We recently added the ability to connect a "View" to Google Data Studio, to enable you to restrict the number of fields and filter the data available in Data Studio.
It is now also possible to create an "extract" of the View. This means that we create an extract of the data that would be in the View and store it separately. Any Data Studio requests you make to the View now go to the extract instead of to the live Funnel database containing all your data.
As the amount of data in the extract is much less than in your account in total, and all dimensions and metrics are pre-calculated when the extract is created, a View extract will normally have much better performance than querying the Funnel database. If you currently get frequent rate limit messages, you will not with an extract, as rate limits do not apply when using View extracts.
The extract is refreshed every 6 hours, so this feature is not for you if you need your data to be as up-to-date as possible. Also be aware that changes to the fields will not be reflected in Data Studio until the extract is refreshed.
Why might I want this?
View extracts might make sense for you if:
- You are happy with your reporting data being up to 6 hours old
- You have performance or rate limiting issues with Data Studio
- You have a stable set of fields in your reports
How do I use View extracts?
Currently View extracts are an experimental feature. Contact support if you are interested in trying it out.
Once you have the feature you should see the Data extract section in your View.
To enable an extract, click 'Enable extract'.
You will then need to wait for the extract to finish before the data is available in Data Studio.