Tips & tricks
ActiveCampaign: Create click rate percentage calculation
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 in easy steps Select the resource 'Campaigns', click 'add a field' as in first ...
ActiveCampaign: Creating a date dimension
Any datetime dimension field can be used for aggregation. We have created a short video on so you can follow along. In this example, we use the createdTimestamp datetime dimension. For more video you can visit our YouTube channel.
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 ...
ActiveCampaign: Using Campaign Report Open List from API v1
When using the resource 'Campaign Report Open List' you will need to use the date dimensions 'tstamp' and 'tstamp_iso'. The parameter 'campaign id' is also required as per the screenshot below. This resource is from the ActiveCampaign API v1, which ...
ActiveCampaign: Create local timezone calculation
All the timestamp fields are in UTC. If you need them in your local timezone (since Date Range Control is in the local timezone), you will need to convert them with a formula. We are in New Zealand (UTC+12) and we would create a dimension using ...
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 ...