Campaign Monitor Data Connector User Guide

Campaign Monitor Data Connector User Guide

Info
This guide will walk you through the process of setting up and using Campaign Monitor as a data source in Power My Analytics. Campaign Monitor is a powerful email marketing platform, and integrating it with PMA allows you to automate your data collection and create comprehensive reports. By following this guide, you'll be able to connect your Campaign Monitor account, set up reports in Data Studio, and understand the key metrics and considerations for this data source.



Prerequisites

Before you begin, ensure you have:
  1. An active Campaign Monitor account with the following permissions: Campaigns, Automation, Transactional, and Lists & Subscribers

Adding Campaign Monitor as a Data Source

  1. Log in to your Power My Analytics hub.
  2. Navigate to Sources from the main menu.
  3. Click + Add new source.
  4. Select Campaign Monitor from the gallery.
  5. Follow the instructions in How to Connect to Campaign Monitor to connect using your account or API keys.

Creating a Data Studio Report

Follow these steps to create a Data Studio report using your Campaign Monitor data:
  1. In the PMA hub, go to Reports > Data Studio
  2. Select Campaign Monitor under Create Data Studio Report (this will open the official Data Studio application in a new window)
  3. Google Data Studio Configuration:
    1. Step 1:
      1. Name your data source (e.g., "Campaign Monitor - Organization Name")
      2. Choose your Power My Analytics hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select your Campaign Monitor account for real data or "Sample Account" for sample data
      2. Click Next
    3. Step 3:
      1. Choose "Clients" for reports
      2. Optional: Allow "Clients" modification in reports
      3. Click Connect (top right)
    4. Step 4:
      1. Click Create Report (top right)
      2. Include “today” in your report’s date range to begin historical data storage when you first create a report
For a quick start, use our pre-built Campaign Monitor demo template.

Key Reports and Fields

Campaign Monitor data in Power My Analytics offers a wide range of metrics and dimensions. Here are some popular metrics you can use in your reports:
  • Key Performance Metrics: Campaigns Sent, Emails Sent, Active Journeys, Emails Sent (automations), Campaign Delivered, Delivery Rate, Campaign Bounced, Bounce Rate, Automation Arrived, Delivery Rate, Automation Bounced, Bounce Rate, Campaign Opened, Open Rate, Campaign Clicks, Click Rate, Automation Opened, Open Rate, Automation Clicks, Click Rate, Campaign Unsubscribed, Unsubscribed Rate, Campaign Spam, Spam Rate, Automation Unsubscribed, Unsubscribe Rate, Automation Not Opened, CTOR
  • Campaign Metrics: Emails Delivered, Open Rate, Click Rate, CTOR
  • Automation Metrics: Emails Delivered, Open Rate, Click Rate, CTOR
  • List Metrics: Subscribers
For a complete list of available Campaign Monitor fields, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Cached Data Requests with Unique Metrics and Date Dimension: When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For more information, please see Understanding Cached and Live Data Requests.
  2. Backfilling: Data cannot be backfilled. Daily collection of lifetime data by PMA begins from the day a report is created. 
  3. Lifetime data only: All metrics are reported as lifetime values.

Unavailable Data

  1. Daily data is not available, as all metrics are lifetime
  2. Email body text
  3. Live data
  4. URL click breakdown
  5. Segments (such as user demographics)
  6. Realtime data
  7. Custom fields

Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the Campaign Monitor connector.