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. Once I ran digital analytics groups, there have been occasions once I wished 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 in case you use Google Sheets, you’ll be able to export Amplitude knowledge to Google Drive and Google Sheets utilizing this add-on.
Let’s take a look at an instance to see how the Amplitude Google Sheet add-on can be utilized. Suppose I need to see how typically 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 instances the place the 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 note the add-on seem on the suitable aspect, and you’ll have to conform to the phrases of service, authenticate your Amplitude account, and approve the permissions:
Subsequent, you will note 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 note an inventory of studies. 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 is able to insert the information into the Google Sheet (be aware 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 getting the information in Google Sheets, you’ll be able to reference it as some other knowledge set. Subsequently, you’ll be able to create new tables, charts, graphs, and so on. primarily based upon your Amplitude knowledge:
If you wish to see a brief video of me strolling by the steps above, see the video beneath.
