Universal Analytics will stop recording new hits on 1st July 2023. After approximately 6 months it will stop working altogether.
We'll work with you to set you up a data warehouse and back-up your GA data so you'll have all of it forever. All the gritty details below. Price from £150+ pm.Get in touch
Our pricing for Google Analytics data warehousing goes from £150+ a month. The bottom pricing is aimed at individual medium/small websites.
1. At the start we'll run a short consulting session. We'll work out your data requirements and talk you through what is possible. Analytics is complicated and we'll walk you through it.
2. We'll get you set-up with a data warehouse (if you haven't got one).
3. We'll back-up all your data into it. Your new UA data will be downloaded and stored every day until UA sunsets.
4. Finally we'll set you up with our query platform so you get the benefits of the data warehouse as well as just using it for backup (details below)!
Yes! We've got plenty of customers who have been storing GA data before they needed to backup. Primarily for the following reasons:
The data models aren't identical so you won't be able to get perfect session to session numbers.
But we will be able to help you tie together the data sources.
We are also building reporting templates to offer to people, which should be available by the end of April at latest, but hopefully sooner.
When any data is in a data warehouse, you need to use SQL to work with it.
Piped Out provides a query builder with pre-built queries that just allows you to fill in a form to generate what you need. (Handy gif below shows basic SEO metrics (i.e. landing pages report).)
You can use this for ad-hoc analysis, or to plug straight into a reporting tool like Data Studio, Tableau etc.
As far back as you've got. However keep in mind that GA has a default retention period of 26 months, so unless you've changed it any data before that becomes unuseable.
Yes. All the back-ups from GA make use of the API and this gives some limitations, doesn't matter if you're using a third part tool or us. Everyone will bump into these limitations.
The primary one is each report is limited to 7 dimensions and 10 metrics. This means you can't get literally everything at once (Unless you've already done some custom work to store a unique session level ID.).
Instead you have to broadly think about it in terms of reports you want to generate, we can help you work through this.
We primarily work with BigQuery at the moment. We do work with other data warehouses, there additional costs for working with them.
Specifically for the scenario where you have been using UA and you're going to move to GA 4, we'd highly recommend using BigQuery because GA 4 has a built in BigQuery export.
By having both of these in the same place, it sets it up for tying the two sources together.
If you just want an analytics platform with your GA data, then this probably isn't the best option.
Pretty much every other small analytics provider at this point will be pushing out a GA import feature as fast as possible (maybe not Adobe for example, but certainly people like Fathom, Matomo already has one etc.).
Wait until the platform of your choice has and they'll almost certainly let you import as part of their sign-up process.
But if in the long term you want to be able to tie together all your different sources more easily then putting it all into a data warehouse is a great idea and we can help!