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 id, the easiest is to login to your ActiveCampaign account and grab the 'campaign id' from the URL as per the screen shot below.
This resource is from the ActiveCampaign API v1, which is an older version. (There are no plans to sunset the API v1 and any removal would be notified by ActiveCampaign)
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 ...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 ...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: 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 ...