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 alternative. After I ran digital analytics groups, there have been occasions once I needed to export knowledge to a spreadsheet and manipulate it there.
In Amplitude, you’ll be able to export virtually any knowledge 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 knowledge 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 wish to see how usually individuals view weblog posts I’ve written and consider this by metropolis. In Amplitude, I might 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 the town is unknown. Subsequent, you’d 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 proper 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 throughout the add-on window the place you’ll be able to select your group:
After you choose your Amplitude group, you will notice a listing 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 (notice that the add-on will make a brand new tab):
After embedding knowledge 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 knowledge set. Subsequently, you’ll be able to create new tables, charts, graphs, and many others. based mostly upon your Amplitude knowledge:
If you wish to see a brief video of me strolling by means of the steps above, see the video under.
