CleverReach Data Connector User Guide
Get valuable insights into your email marketing and newsletter campaign performance by connecting your CleverReach account to Power My Analytics. This guide will walk you through setup, reporting capabilities, and important considerations for the CleverReach data source.
Prerequisites
Before connecting CleverReach to Power My Analytics, ensure you have:
- An active CleverReach account (free or paid plan). No special permissions or API keys are required; authentication is handled via OAuth.
- Your CleverReach account email and password. CleverReach uses OAuth for authentication, so you will log in directly on the CleverReach authorization page during setup.
Adding CleverReach as a Data Source
- Log in to your Power My Analytics hub.
- Navigate to Sources from the main menu.
- Click + Add new source.
- Search for "CleverReach" and click the CleverReach tile from the gallery.
- You will be redirected to CleverReach's OAuth authorization page. Click "Log in with my existing CleverReach account and connect".
- Enter your CleverReach email and password to authorize the connection.
- Once authorized, you will be redirected back to the PMA hub and your CleverReach account will appear in Sources.
Creating a Looker Studio Report
Follow these steps to create a Looker Studio report using your CleverReach data:
- In the PMA hub, navigate to Reports > Looker Studio.
- Select CleverReach under Create Looker Studio Report (this will open the official Looker Studio application in a new window).
- Google Looker Studio Configuration:
- Step 1:
- Name your data source (e.g., rename "Untitled Data Source" to "CleverReach - Organization Name").
- Power My Analytics Hub: Choose your PMA hub from the dropdown.
- Optional: Leave "Use report template for new reports" checked to use the PMA demo template.
- Click Next.
- Step 2:
- User Account: Select your CleverReach account (for real data) or "Sample Account" (for sample data).
- Click Next.
- Step 3:
- Click Connect (top right) to complete the data source configuration.
- Step 4:
- Click Create Report (top right).
For a quick start, use our pre-built CleverReach demo template.
Key Reports and Fields
The CleverReach connector provides access to a variety of email campaign performance data, including:
- Mails Insights: Opened Rate, Click Rate, Bounced, Delivered, Unsubscribed, Spam Rate
For a full list of available CleverReach fields in Power My Analytics, visit the Schema Explorer.
Limitations and Important Considerations
- 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 this reason, only cached data will appear in a report or chart that pairs a unique field with the date dimension.
- Backfilling: 24 months of historical data will be backfilled when you first connect your CleverReach account as a data source.
Troubleshooting
See our article Basic Troubleshooting for information on issues that may affect the CleverReach connector.
If you need further assistance, please submit a ticket.
Related Articles
How to Connect to CleverReach
This guide will walk you through connecting your CleverReach account as a data source in Power My Analytics. By integrating CleverReach with our platform, you'll be able to automate your email marketing and newsletter data collection, create ...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 ...PayPal Data Connector User Guide
PayPal is a widely used payment processing platform, and integrating its data into your analytics workflow can provide valuable insights into your business performance. This guide will walk you through the process of setting up PayPal as a data ...Stripe Data Connector User Guide
Stripe is a powerful payment processing platform that enables businesses to accept online payments, manage subscriptions, and handle invoicing. This guide will walk you through the process of connecting Stripe to Power My Analytics, creating reports, ...BigCommerce Data Connector User Guide
Are you looking to streamline your BigCommerce data analysis and reporting? Power My Analytics' BigCommerce connector automates the collection and integration of your e-commerce data, saving you time and providing deeper insights into your online ...