Tips & tricks
Data Studio Gotchas
As a free tool, we love Data Studio. However, it does have system limitations that you need to be mindful of when you are working with large data sets. Queries will time out after 6 minutes. Data is stored in the cache for 12 hours (you can check ...
ActiveCampaign: Using the Ecomm Integration resources for Shopify
The ActiveCampaign data connector includes three ecommerce resources that you are able to connect to. (For a full description of the resources you can refer to the resource document from page 14 onwards) These are ecomCustomers ecomOrderProducts ...
Data blending Join Properties: Importance of same data type for match key fields
When creating data blends with Looker Studio the match key fields have to be the same data type. (also known as the join fields) In the example below, you would need to change the data type of customFieldId (Deal Custom Field Values) from Number to ...
ActiveCampaign: Create click rate percentage calculations
The ActiveCampaign Resources don't come with any percentage based metrics. This means that you will have to create them yourself. This success article shows you how easy it is to create percentage calculations for your charts and dashboards. Select ...
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' ( For a full list of errors please refer to ActiveCampaign API document here as the last ...
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 ...
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 ...
ActiveCampaign: Converting timestamps to your local timezone
In your ActiveCampaign account you will typically have it set to your local time zone. This allows you to set campaigns to run at at time you are familiar with. Equally this could apply to deals, tasks, automations. Any feature that you are using. In ...
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 ...