Home  › Search › Paid Search
geoflow-excel-visuals

No.10 Most Read Article of 2013: 5 Free Excel Add-Ins to Help Digital Marketers Decipher Big Data

  |  December 25, 2013   |  Comments

As the volume of data grows by the hour, take comfort in knowing "big data" can be sifted through an interface that you're already familiar with - Excel.

This story was originally published on May 2, 2013, and comes in at No. 10 on our countdown of the 10 most popular ClickZ stories of 2013. As ClickZ looks back over the past year, we're celebrating the best of 2013, as determined by you, our readers. Enjoy!

Wherever a marketer turns these days she is confronted by the idea of big data. Mining this storehouse of user activity for actionable intelligence can seem a daunting task to a business without an in-house data analyst. Data captured will do no good if teams can't interpret it quickly and efficiently - it needs to be easily accessible.

Luckily you likely have a powerful analysis tool at your fingertips - Excel.

Excel has become so indispensable that 76 percent of agency media planners rely on it for their media planning, according to Chris O'Hara from NextMark. To turn your raw data into an asset, many powerful add-ins have been built to plug in to Excel.

  • GeoFlow for 3D geographic visualization
  • PowerPivot and Power View for massive data crunching
  • Bing Ads Intelligence for rich PPC data
  • Excellent Analytics pulls in analytics data directly into Excel
  • SeoTools for Excel for robust SEO-specific tasks

All of these can help you harness the power of your data quickly and save time. As marketers, we should have a conversation around getting more from a tool we already know well (but not well enough).

GeoFlow: Big Data + Great Mapping Visualization

The Excel team just released a new free Excel add-in called GeoFlow that displays geographic data using Bing Maps to tell your story in a 3D visualization. The visualizations attract attention, are easily understood, and can even be incorporated into dashboards.

geoflow-excel-visuals
click to enlarge

The example above maps electric power usage from Dallas Utilities from publicly available data. In digital marketing, advertisers can easily map sales and website interaction over time by geography. This sort of visualization for your data can make your reports and presentations pop.

PowerPivot: Pivot Tables on Steroids

Another key tool in Excel is PowerPivot, included with Excel 2010 and 2013. PowerPivot is pivot tables on steroids. PowerPivot can load even the largest data sets from almost any source and process this massive amount of data in seconds. After the initial learning curve, it's surprisingly lightweight.

Many businesses are putting together dashboards created from PowerView, a complement to PowerPivot.

powerview-powerpivot-dashboard
click to enlarge

Now, PowerPivot and GeoFlow are fantastic tools all marketers can use to help sift and visualize big data. But there are a whole set of free tools that bring search marketing or analytics directly into Excel. You don't have to leave Excel, so you can use an interface you're already familiar with.

PPC: Bing Ads Intelligence

Need keyword ideas or bid estimates by position? Bing Ads intelligence, a free add-in from Bing Ads, can give you the number of searches per search term, cost-per-click data, keyword ideas, age/gender data, and even more.

It also offers time-saving keyword research templates, like the "Search Query Insights Dashboard," which is similar in some ways to Google Trends. Nick Kastner from Red Clay Interactive echoes this point: "This awesome extension offers you seven standard keyword research templates to help you get started."

bing-ads-intelligence-features
click to enlarge

Analytics: Excellent Analytics

Spending too much time on reports? Excellent Analytics lets you pull Google Analytics data directly into Excel. There is a free, open-source version that has been downloaded tens of thousands of times by marketers looking to automate reporting. One review in the analytics app gallery highlights the time-savings: "This is a real time saver for me. What used to take me an hour now takes about 2 minutes."

excellent-analytics-excel
click to enlarge

SEO: SeoTools for Excel (Now With Majestic SEO Data)

Last but not least is a free set of SEO tools, fittingly called SeoTools for Excel. This donation-supported toolset adds many SEO-specific tasks to the Excel ribbon. Mitch Monsen from WhiteFireSEO says, "It has one of the most robust feature sets I've seen in an extension, and Nielsen is updating it constantly. It has mind-boggling scraping capabilities (get a proxy if you plan on using them a lot) and a ton of on-page analysis tools."

seotools-excel-add-in

This isn't a complete list by any means. I'd love to hear your favorites in the comments section.

That said, countless late, coffee-filled nights putting together proposals have led me to this conclusion: digital marketing runs on Excel and caffeine. As the volume of data grows by the hour, take comfort in knowing "big data" can be sifted through an interface that you're already familiar with - Excel. And there are plenty of add-ins to help save you time!

ClickZ Live Chicago Join the Industry's Leading eCommerce & Direct Marketing Experts in Chicago
ClickZ Live Chicago (Nov 3-6) will deliver over 50 sessions across 4 days and 10 individual tracks, including Data-Driven Marketing, Social, Mobile, Display, Search and Email. Check out the full agenda and register by Friday, Oct 3 to take advantage of Early Bird Rates!

ABOUT THE AUTHOR

John Gagnon

John Gagnon is a Bing Ads Evangelist (aka “search nerd”) at Microsoft. He has worked for both Bing Ads and Google AdWords, and is a frequent speaker at digital marketing conferences such as SES, SMX, and others. He has advised hundreds of clients ranging from Microsoft teams like Windows and Internet Explorer to small businesses like local garage door repair shops just getting started.

COMMENTSCommenting policy

comments powered by Disqus

Get the ClickZ Search newsletter delivered to you. Subscribe today!

COMMENTS

UPCOMING EVENTS

Featured White Papers

IBM: Social Analytics - The Science Behind Social Media Marketing

IBM Social Analytics: The Science Behind Social Media Marketing
80% of internet users say they prefer to connect with brands via Facebook. 65% of social media users say they use it to learn more about brands, products and services. Learn about how to find more about customers' attitudes, preferences and buying habits from what they say on social media channels.

Marin Software: The Multiplier Effect of Integrating Search & Social Advertising

The Multiplier Effect of Integrating Search & Social Advertising
Latest research reveals 68% higher revenue per conversion for marketers who integrate their search & social advertising. In addition to the research results, this whitepaper also outlines 5 strategies and 15 tactics you can use to better integrate your search and social campaigns.

Resources

Jobs

    • Digital Marketing Analyst
      Digital Marketing Analyst (GovLoop) - Washington D.C.Are you passionate about audience acquisition? Love effective copy and amazingly effective...
    • Product Specialist
      Product Specialist (Agora Inc. ) - BaltimoreDescription: The Product Specialist is hyper-focused on the customer experience and ensures that our...
    • Partnerships Senior Coordinator
      Partnerships Senior Coordinator (Zappos.com, Inc.) - Las VegasZappos IP, Inc. is looking for a Partnerships Senior Coordinator! Why join us? Our...