ActiveCampaign: Managing large datasets

ActiveCampaign: Managing large datasets

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 (script runtime).

We recommend adding as many parameters as possible to reduce the amount of data that will be loaded.

For example, if you need the number of contacts created each day, set the parameter 'created after' as late (e.g. 20210101 if you only care about this quarter) as possible. See 

If you still need to load a large set of data, for instance >30000, try breaking it down to several data sources with 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.

Hope this helps!


22964421_1633030364Zfjimage.png




    • Related Articles

    • ActiveCampaign: Creating custom Contact lists

      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: error code 403

      When you receive the error code 403 'The request could not be authenticated or the authenticated user is not authorized to access the requested resource' (refer to ActiveCampaign API doc as the last screenshot). Please check that you've set the ...
    • ActiveCampaign: Resource Documentation

      For a detailed description of all the ActiveCampaign resources and tips for using the ActiveCampaign connector for Data Studio you can download the document here  It lists all resources and contains a description of each dimension or metric in each ...
    • ActiveCampaign: Creating a Connector Membership

      Become a Member and purchase your  Data Studio Connectors Thanks for Choosing a Find My insight Connector. First things first, you will need to sign up to our portal and become a member. Membership is free. Our privacy Policy can be found here and ...
    • ActiveCampaign: Creating your first data source

      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 ...