ActiveCampaign: Managing large datasets with parameters
If you have see this error "You are trying to retrieve more than 30000 data at one data source which will exceed Google quota",
it means you have exceeded the Google quota for a script runtime.
We recommend adding as many parameters as possible to reduce the amount of data that will be loaded.
For example
If you are trying to show the number of contacts created/added each day, when you are building your data source you will need to set a parameter. For this it will be 'created after' as late (e.g. 20210101 if you only care about this quarter) as possible.
Alternatively, If you still need to load a large set of data, for instance >30000 rows, try breaking it down into several data sources using the parameter offset and max amount of data.
On each data source, the offset is set incrementally and max is fixed.
The example below demos how to load 3000 rows of data on three data sources.
The first data source loads rows 0-1000
The second loads rows 1000- 2000
The 3rd data source loads rows 2000- 3000
Related Articles
ActiveCampaign: Creating your first Looker Studio data source to build your custom Dashboard
Build Your Report Adding and authorising Find My Insight ActiveCampaign Connector in Google Data Studio. This guide shows you how to use a Find My Insight Connector for Data Studio, It's pretty simple, just add and then authorize the connector. This ...Looker Studio: Speed up your dashboards
Have you been in meeting or presentation and wanted to be able to share insight on Looker Studio but were hesitant because you never know how long you will be waiting your dashboard to render? If the answer to to that question is yes. Have you tried ...ActiveCampaign: Optimising your Contact lists data source
When building dashboards we don't always need all of the data available to answer a particular question. In the example below we only want to know how many contacts have subscribed to list 81 since 22 November 2021. If you have a large number of ...ActiveCampaign: Using resource "Campaign Report Open List"
When you create a data source using the resource 'Campaign Report Open List' you will need to use the date dimensions 'tstamp' and 'tstamp_iso'. It also required the use of a parameter for the 'campaign id' there are several ways to obtain a campaign ...Meta Ads: Creating your first Looker Studio data source to build your custom Dashboard
Build Your Report Adding and authorising Find My Insight Meta Ads Connector in Google Data Studio. This guide shows you how to use a Find My Insight Connector for Data Studio, It's pretty simple, just add and then authorize the connector. This will ...