In a latest weblog submit, I demonstrated how one can set up and use the Amplitude Google Sheets add-on to embed information right into a Google Sheet. After you embed information right into a Google Sheet, you’ll be able to manipulate it any manner you need. You may as well benefit from 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 information 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 might have the information in Google Sheets, you may make a brand new tab and reference this information. 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 information you wish to map must be within the first tab of the Google Sheet, so at this level, you might want to make the tab above the primary tab within the sheet.
Subsequent, you’ll be able to open Google Maps (which requires a Google Account) and click on the button to create a brand new map:
Then you will notice a clean map, and you’ll click on on the Import hyperlink beneath the primary map layer and choose the right Google Sheet:
After you choose the right Google Sheet, Google Maps will ask you to establish 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 notice your information plotted on a Google Map:
Inside Google Maps, you may make edits, corresponding to altering the markers, the kind of map, or displaying the precise numbers. These settings are positioned beneath the information layer (on this case, the hyperlink labeled “Uniform Model”). You might also see instances the place Google Maps didn’t acknowledge the town, however these ought to be uncommon.
I counsel including a title to the Google Map. You may as well import a number of map layers, so if you wish to see the identical information for various date ranges, you’ll be able to label every import with the date. You’ll be able to see the title and information label right here:
If you wish to see a brief video of me strolling by means of the steps above, see under.
