Google-sheets – Google Analytics Cohort analysis CSV, TSV and Google Sheets Download

google analyticsgoogle sheets

When I perform a simple cohort analysis using the built in tools I am able to generate a table that looks like this:

However – When I try to download the table using the download button in the top right hand side:

and try to download in TSV, CSV or Google sheets – I get a useless output that looks like this:

What am I doing wrong here?

Is it a bug with Google Analytics?
I can't seem to find a solution online?

I wish to get the table produced in CSV or Google Sheets format.

Best Answer

Related Solutions

Google-sheets – No force-reload tip on Google Sheets

i would suspect that setting the expire-time for the .csv file could help. that would be something for the server to deliver.

OR you can trick the webbrowser by appending something random at the end of the url you are using to fetching the data (see my comment on your question):

http://example.com/myfile.csv?_invalidate_cache_of_browser_XYZ

and then you have to put some random XYZ into the url, maybe by usuing the rand() function.

Google-sheets – Downloading charts from Google Sheets in high resolution

Just use the standard print dialog in Chrome (File -> Print / do not use the shortcut cmd+p, as this opens up a Google sheet specific print pop-up) and chose "save as PDF" (tried on a Mac/OSX). This exports the charts in a vector format. There is no need for a Chromium add-on.

Best Answer

Related Solutions

Google-sheets – No force-reload tip on Google Sheets

Google-sheets – Downloading charts from Google Sheets in high resolution

Related Topic