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 DATETIME_ADD(ldate, INTERVAL, 12 HOUR)
Related Articles
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 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 ...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 ...