ActiveCampaign | Converting timestamps to your local timezone

ActiveCampaign: Converting timestamps to your local timezone

In your ActiveCampaign account you will typically have it set to your local time zone. This allows you to set campaigns to run at at time you are familiar with. Equally this could apply to deals, tasks, automations. Any feature that you are using.

In the background however, ActiveCampaign will record the events at a different time. We have seen both UTC (which is universal coordinated time) and also Chicago time (which is where ActiveCampaign are headquartered) in the connector resources.

What this means for you, is that you may want to convert these timestamps to your local timezone (especially since Looker Studio Date Range Control is in the local timezone).

To do this you will need to convert them with a formula.

We are in New Zealand which is (UTC+12) so would create a dimension using DATETIME_ADD(ldate, INTERVAL, 12 HOUR) as we are 12 hours ahead of UTC. 


    • Related Articles

    • ActiveCampaign: Create click rate percentage calculations

      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 easy it is to create percentage calculations for your charts and dashboards. Select ...
    • Looker Studio: Creating a date dimension from a datetimestamp

      Often when building a dashboard you will want to group activities (metrics) by a datetime dimension. This could be day, week, month, year etc. Looker studio lets you select any of those attributes once you have dragged this into the chart. However, ...
    • 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 ...
    • 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: 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' ( For a full list of errors please refer to ActiveCampaign API document here as the last ...