Login
Start Trial
Request Demo

Mailchimp

Knowi connects to Mailchimp to pull campaign performance data, email reports, and engagement metrics into a unified analytics platform.

Track open rates, click rates, bounce rates, and campaign ROI alongside data from your CRM, databases, and other marketing tools.

Overview

Connect to Mailchimp using your API key. Knowi supports campaign listings and detailed performance reports with Cloud9QL transformations.

Connecting

  1. Log in to Knowi and select "Queries" from the left sidebar.

  2. Click on the "New Datasource +" button and select Mailchimp from the list of datasources.

  3. Configure the following:

    a. Datasource Name: Enter a name (e.g., "Marketing Mailchimp")

    b. Data Center: Enter your Mailchimp data center prefix (e.g., us14). This is the suffix in your Mailchimp API key after the dash (e.g., if your key is abc123-us14, the data center is us14).

    c. API Key: Enter your Mailchimp API key. Generate one in Mailchimp under Account > Extras > API keys.

  4. Click "Save" to finish setup.

Collections

Reports

Retrieves detailed campaign performance reports including open rates, click rates, bounce statistics, forward counts, and e-commerce revenue data.

Required Parameters: * Fields - Comma-separated list of report fields to return. The default includes: id, campaign_title, type, list_id, list_name, subject_line, emails_sent, abuse_reports, unsubscribed, send_time, bounces, forwards, ecommerce, delivery_status, and more. * Start - Only return campaigns sent after this date. ISO 8601 format: 2024-01-01T00:00:00+00:00.

Default Cloud9QL:

select expand(reports);
select expand(opens);
select expand(clicks);

Campaigns

Retrieves campaign listings with metadata, settings, tracking configuration, and summary statistics.

Required Parameters: * Fields - Fields to return. * Filter by status - Campaign status filter. Default: save,paused,schedule,sending,sent. * Start - Only return campaigns sent after this date.

Default Cloud9QL:

select expand(campaigns);

Common Use Cases

Campaign Open Rate Analysis

select expand(reports);
select campaign_title, emails_sent, opens.opens_total as opens,
       round(opens.open_rate * 100, 1) as open_rate_pct,
       send_time
order by send_time desc;

Click Performance

select expand(reports);
select campaign_title, clicks.clicks_total as clicks,
       round(clicks.unique_clicks / emails_sent * 100, 1) as click_rate_pct
order by clicks desc;

Bounce Analysis

select expand(reports);
select campaign_title, bounces.hard_bounces, bounces.soft_bounces,
       bounces.syntax_errors, emails_sent
where bounces.hard_bounces > 0
order by bounces.hard_bounces desc;

Scheduling

Schedule queries to run automatically to track campaign performance over time. Use Knowi date tokens in the Start parameter for rolling windows.

Notes