In a latest weblog submit, I demonstrated learn how to set up and use the Amplitude Google Sheets add-on to embed knowledge right into a Google Sheet. After you embed knowledge right into a Google Sheet, you may manipulate it any manner you need. You may also make the most of different options and Google Sheet add-ons. On this submit, I’ll present how one can mix the Amplitude Google Sheet add-on and Google Maps to visualise Amplitude knowledge on a map.
First, let’s create a report in Amplitude that has geographic data. In my earlier submit, I confirmed a report of my weblog submit views by metropolis:
Subsequent, I embedded this report right into a Google Sheet:
After you could have the info in Google Sheets, you can also make a brand new tab and reference this knowledge. On this case, I wish to sum all weblog submit views by metropolis, so I exploit formulation to do that in a brand new tab:
Be aware that for Google Maps to work, the info you wish to map must be within the first tab of the Google Sheet, so at this level, it’s essential to make the tab above the primary tab within the sheet.
Subsequent, you may open Google Maps (which requires a Google Account) and click on the button to create a brand new map:
Then you will note a clean map, and you’ll click on on the Import hyperlink beneath the primary map layer and choose the proper Google Sheet:
After you choose the proper Google Sheet, Google Maps will ask you to determine the column representing the demographic data (e.g., metropolis, state, nation). You’ll have to do that twice:
After you click on the end button, you will note your knowledge plotted on a Google Map:
Inside Google Maps, you can also make edits, corresponding to altering the markers, the kind of map, or displaying the precise numbers. These settings are positioned beneath the info layer (on this case, the hyperlink labeled “Uniform Model”). You might also see instances the place Google Maps didn’t acknowledge town, however these ought to be uncommon.
I recommend including a title to the Google Map. You may also import a number of map layers, so if you wish to see the identical knowledge for various date ranges, you may label every import with the date. You’ll be able to see the title and knowledge label right here:
If you wish to see a brief video of me strolling by means of the steps above, see under.
The submit Mapping Amplitude Knowledge by way of Google Sheets Add-on appeared first on Amplitude.
