In a latest weblog submit, I demonstrated how you can 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 method you need. You may as well reap the benefits 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 have got the information 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:

Notice 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 have 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 underneath 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 note your knowledge plotted on a Google Map:

Inside Google Maps, you can also make edits, equivalent 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 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 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: