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.
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.
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.
Step 4: Create your map
Click ‘create’ at the bottom of the menu
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.
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.
The pins are instantly placed on the locations specified in the spreadsheet. Clicking on a pin will display more detail:
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.