As a former analyst, I’m used to spending time in spreadsheets. I was a wiz at MS Excel, however these days, most individuals use Google Sheets as their spreadsheet of selection. After I ran digital analytics groups, there have been occasions after I wished to export information to a spreadsheet and manipulate it there.
In Amplitude, you’ll be able to export nearly any information set to CSV after which import it into MS Excel or Google Sheets, however if you happen to use Google Sheets, you’ll be able to export Amplitude information to Google Drive and Google Sheets utilizing this add-on.
Let’s have a look at an instance to see how the Amplitude Google Sheet add-on can be utilized. Suppose I need to see how typically folks view weblog posts I’ve written and look at this by metropolis. In Amplitude, I’d create a report like this:
On this report, I’m exhibiting Weblog Publish Views the place the writer is “Adam Greco” and Grouping by “Metropolis” however excluding circumstances the place town is unknown. Subsequent, you’ll open a brand new Google Sheet and select Extensions – Amplitude Sync to Drive and Sheets from the menu as proven right here:
After clicking, you will notice the add-on seem on the appropriate facet, and you’ll have to conform to the phrases of service, authenticate your Amplitude account, and approve the permissions:
Subsequent, you will notice your Amplitude Organizations inside the add-on window the place you’ll be able to select your group:
After you choose your Amplitude group, you will notice an inventory of experiences. From right here, you’ll be able to search and discover the report you need:
On this case, I’ll select the Adam Weblog Posts by Metropolis, which can insert the info into the Google Sheet (be aware that the add-on will make a brand new tab):
After embedding information within the Google Sheet, you’ll be able to refresh it anytime utilizing the add-on window:
After you have the info in Google Sheets, you’ll be able to reference it as another information set. Due to this fact, you’ll be able to create new tables, charts, graphs, and many others. based mostly upon your Amplitude information:
If you wish to see a brief video of me strolling by way of the steps above, see the video beneath.