Viewing your promotional campaigns in Google Maps

We all look at data and arrange it differently in our minds on order to best understand it. Some of us may squeal at spreadsheets whilst others prefer flowcharts, and yet the ‘visual learner’ group  wants things presented as an image. It’s why there are so many organisational apps out there – what works for one person, one team, or one company may be totally irrelevant to the workflow of another.

Watu also provides various ways to view jobs, for example in the job schedule page or downloaded to CSV for those spreadsheet nerds, but what about the visual group?

Here’s a solution for you guys: creating a promotional campaigns map in Google Maps

How does it work?

Within Google Maps, once logged in, you can choose to create and save a map based on your data. This data can, of course, be imported, meaning you can either whip together a spreadsheet of what you want to visualise, or you can choose to download straight from Watu. The map then saves pins on your locations with all the columnised data stored within each pin.

If you’re going ‘huh..?’ – don’t worry, this blog piece is for visual learners. So let’s make it so.

Step 1: Create the document

Once you’ve built your job in Watu, click ‘Download Job Schedule’

Alternatively, you can choose at this point to build your own spreadsheet in Google Drive or another document. If doing so, just place the column headers in the first row so that Maps can read the titles correctly.

Creating a google map of a promotional campaign

Step 2: Filter your document

Filter to what you need by selecting repetitive columns and deleting them.

In this case, I’ve chosen to narrow down the rows to just one line per location, rather than having a pinpoint for each time the location appears.

Creating a google map of a promotional campaign

Step 3: Go to Google maps

Create your map by going to Google Maps then clicking on the menu and selecting ‘My Maps’. Note that you’ll have to be logged into Google in order to create your own map.

Creating a google map of a promotional campaign

Step 4: Create your map

Click ‘create’ at the bottom of the menu

Creating a map of promotional campaigns

Step 5: Import your data

Import your map by selecting the layer and clicking ‘import’. Select your document and then click ‘location’ (or however you named the address column) to have the pins reflect the addresses of your campaign.

Creating a map of promotional campaigns

Your customised promotional campaign map:

There you have it, your final results. In this case, a basic map with just a few job points, but with the potential for many more.

Creating a map of promotional campaigns

The pins are instantly placed on the locations specified in the spreadsheet. Clicking on a pin will display more detail:

Creating a map of promotional campaigns

Once you’re at this point, the map is yours to explore and add to like, for example, adding additional layers if you have other campaigns you’d like to add in.

Happy mapping!

Photo by Nicolas Raymond

Leave a Reply

Your email address will not be published. Required fields are marked *