Universal Analytics data is disappearing in 3 days, on July 1, 2024. The only way to access this data in the future will be if it’s been exported to another 3rd party service or CSV files. Once I started thinking about exporting Universal Analytics data, it took me only a short time to decide to use Looker Studio. It makes much more sense than manually exporting reports inside Universal Analytics, and it doesn’t cost anything. Here are some of the main benefits of this approach:
- Universal Analytics only allows you to export 5,000 rows at a time. Looker Studio doesn’t have that limitation. Using this approach, I’ve exported up to 250,000 rows of Universal Analytics data from Looker Studio.
- I can create pivot tables showing one dimension (examples: traffic source/medium, page, countries) and all the daily values for the entire account history. Doing this with medium, for example, allows you to see how many organic visitors there were every day.