Campaign Monitor Data Connector User Guide

Campaign Monitor Data Connector User Guide

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 Looker 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 + New Data 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 Looker Studio Report

Follow these steps to create a Looker Studio report using your Campaign Monitor data:
  1. In the PMA hub, go to Reports > Looker Studio
  2. Select Campaign Monitor under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
  3. Google Looker 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. Backfilling: Data cannot be backfilled. Daily collection of lifetime data by PMA begins from the day a report is created. 
  2. 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.


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • How to Connect to Campaign Monitor

        This guide will show you how to connect to Campaign Monitor and start creating reports. You can connect using your Campaign Monitor login or using your API keys. Begin in your Power My Analytics Hub. Under Sources, click + New Data Source. ...

      • Mailchimp Data Connector User Guide

        Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...

      • Criteo Data Connector User Guide

        This guide will walk you through the process of connecting your Criteo account to Power My Analytics and creating reports using the data. Criteo is a powerful advertising platform specializing in retargeting, customer acquisition, and personalized ...

      • Taboola Data Connector User Guide

        Taboola is a powerful native advertising platform that helps marketers reach their target audience through sponsored content and product recommendations. This guide will walk you through the process of connecting your Taboola account to Power My ...

      • SharpSpring Data Connector User Guide

        SharpSpring is a powerful marketing automation and customer relationship management platform that helps businesses streamline their marketing efforts and manage leads effectively. This guide will walk you through the process of connecting SharpSpring ...