ActiveCampaign: Creating a date dimension

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. 


    • Related Articles

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

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