In a latest weblog put up, I demonstrated methods to 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 possibly can manipulate it any manner you need. You may also reap the benefits of different options and Google Sheet add-ons. On this put up, 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 info. In my earlier put up, I confirmed a report of my weblog put up views by metropolis:
Subsequent, I embedded this report right into a Google Sheet:
After you could have the information in Google Sheets, you may make a brand new tab and reference this information. On this case, I need to sum all weblog put up views by metropolis, so I take advantage of formulation to do that in a brand new tab:
Be aware that for Google Maps to work, the information you need to map must be within the first tab of the Google Sheet, so at this level, you want to make the tab above the primary tab within the sheet.
Subsequent, you possibly can 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 underneath the primary map layer and choose the proper Google Sheet:
After you choose the proper Google Sheet, Google Maps will ask you to establish the column representing the demographic info (e.g., metropolis, state, nation). You’ll have to do that twice:
After you click on the end button, you will note your information plotted on a Google Map:
Inside Google Maps, you may make edits, similar to altering the markers, the kind of map, or displaying the precise numbers. These settings are situated underneath the information layer (on this case, the hyperlink labeled “Uniform Model”). You might also see instances the place Google Maps didn’t acknowledge town, however these needs 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 information for various date ranges, you possibly can label every import with the date. You possibly can see the title and information label right here:
If you wish to see a brief video of me strolling by way of the steps above, see beneath.
