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