ActiveCampaign: Create click rate percentage calculation

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

  1. Select the resource 'Campaigns',
  2. click 'add a field' as in first screenshot
  3. Create formula calculation as per the second screenshot for click rate
  4.  Repeat for open rate, unsubscribe rate or any other metric you want to create as percentage 
  5. You should see these numbers on your report as per the third screenshot. You will need to change the metrics type to 'Percent'.

18137706_1616440090C4Dimage.png


    • Related Articles

    • 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: 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: create multi account subscription

      If you want to build dashboards for 2 or more ActiveCampaign accounts it's very easy. Sign up on our member portal and start a subscription with 2 (or more) Connectors as per the first screenshotn the My Connectors page, click Add Connector button ...
    • 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 ...