Home  › Search › Paid Search

PowerMap: Excel Charting Plus Bing Maps on Steroids

  |  September 19, 2013   |  Comments

Data visualization tool, PowerMap, lets users leap from big data to invaluable insight shockingly fast.

Digital marketers often wrestle with the myths and truths of "big data", and what to do with it. But data is just numbers until used to answer questions. Then it becomes insight. Luckily there are many new, yet familiar tools to help. One of the newest, PowerMap, lets you leap from data to insight shockingly fast.

Mapping data geographically can paint a stunning picture that actually tells you what you need to do to market smarter. PowerMap is likely the most beautiful insight tool you've seen yet, and can unlock insights to drive campaign performance. It has to be seen to be believed.

Powermap Visualizations
click to enlarge

Excel Charting plus Bing Maps on Steroids

Think of PowerMap as Excel charting plus Bing Maps on steroids. Before PowerMap was PowerMap, it was GeoFlow Preview for Excel 2013 created from a Microsoft Research project. It can chart data with 3D columns overlaid on a map over time. And as of early September new features make PowerMap even stronger:

    • Smart Start-Up. PowerMap can identify geographical data for the data type it is, and then automatically maps it. Zip codes, for example, are identified as zip codes - without telling PowerMap that they're zip codes. Countries, states, cities, counties and even latitude and longitude - PowerMap knows what to do with your data.
    • Region Shading For Visualization. During an election, political analysts love to highlight voting by county. These election maps highlight each state or county, then color them red or blue. PowerMap puts this type of map at your fingertips, but instead of votes, use any data you'd like. This is in addition to the existing visualization options bubbles, Heatmaps, and columns.
    • Flat Map. PowerMap was born as a 3D visualization which was highly engaging and interactive. Now data scientists and analysts can also switch to a 2D map for a broader geographical view.
    • Create A Video. Share your PowerMap data with people who don't have the PowerMap plug-in. String together several PowerMap scenes to create a story, and PowerMap takes care of the smooth transitions. Files are exported as MP4.

Applying Insights to Advertising Campaigns

Here's an example to illustrate the value of PowerMap. Did you know that different parts of the country (and the world, of course) have different start-dates for school? This year, all of Hawaii's public K-12 students went back to school August 5, while New York went back September 9.

If you're targeting the back-to-school audience, you'd want to know precisely when school starts at different places across the country. This information is publicly available. Since there are over 15,000 school districts, it's easier to work with a third party data provider, in this case MCH Strategic Data. A distinct geographic targeting strategy emerges when you combine the first day of school data with PowerMap, something even MCH Strategic Data hadn't seen before.

We're working with two data points: Date and geography. It looks like this:

Back-to-School Powermap
click to enlarge

Visualizing the data on a map and over time drives home many insights. One key insight: A nationally targeted campaign won't allow you to differentiate your ad copy to cities or states which are already in school. If Los Angeles' 640,000 students go back to school on August 13, you'd have to have the same ad messaging and bids until New York City's 1.1 million students go back on September 9. So switching from a nationally targeted campaign to a region-specific campaign makes more sense.

Data is just numbers. Tools like PowerMap unlock insights by visualizing lots of data in an intuitive manner. You can then focus on understand how everything fits together, plus where and when you should take action. This is a new tool, and right now it's only available for Office 365 Pro Plus on a PC. It's a free download for those users, hopefully coming to more users soon!

What's the first thing you'd want to plot using PowerMap? What are the questions this tool can answer for you?

ClickZ Live New York Want to learn more?
Attend ClickZ Live New York March 30 - April 1. With over 15 years' experience delivering industry-leading events, ClickZ Live brings together over 60 expert speakers to offer an action-packed, educationally-focused agenda covering all aspects of digital marketing. Register today!


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!




Featured White Papers

A Buyer's Guide to Affiliate Management Software

A Buyer's Guide to Affiliate Management Software
Manage your performance marketing with the right solution. Choose a platform that will mutually empower advertisers and media partners!

Google My Business Listings Demystified

Google My Business Listings Demystified
To help brands control how they appear online, Google has developed a new offering: Google My Business Locations. This whitepaper helps marketers understand how to use this powerful new tool.


    • Website Optimizer - SEO, CRO, Analytics
      Website Optimizer - SEO, CRO, Analytics (Marcel Digital) - ChicagoMarcel Digital, an award winning interactive marketing agency established in 2003...
    • Director of Marketing
      Director of Marketing (Patron Technology) - New YorkDirector of Marketing We are seeking a Director of Marketing to manage and build our marketing...
    • Senior Interactive Producer
      Senior Interactive Producer (Ready Set Rocket) - New YorkWhat You'll Do As a member of our team, the Senior Producer reports directly to our...