# MailChimp

### Snapshot

| Features                        | Details                                           |
| ------------------------------- | ------------------------------------------------- |
| Release Status                  | Released                                          |
| Source API Version              | v3.0                                              |
| Table Selection                 | Yes                                               |
| Column Selection                | Yes                                               |
| Edit Integration                | Yes                                               |
| Replication Type Selection      | No                                                |
| Authentication Parameters       | <p>Mailchimp API Key<br>Mailchimp data centre</p> |
| Replication Type                | Key Based Replication                             |
| Replication Key                 | Date-Time                                         |
| Suggested Replication Frequency | 24 hrs                                            |

| Tables/APIs Supported     |                                   |
| ------------------------- | --------------------------------- |
| Campaigns                 | Connected Sites                   |
| Ecommerce Stores          | Cart                              |
| Customers                 | Products                          |
| Product variants          | Promo Rules                       |
| Promo Codes               | Orders                            |
| Facebook Ads              | Lists                             |
| Abuse Reports             | Activity                          |
| Clients                   | Growth History                    |
| Interest Categories       | Locations                         |
| Merge Fields              | Segments                          |
| Landing Pages             | Campaign Reports                  |
| Campaign Abuse            | Campaign Open Reports             |
| Campaign Clicks           | Campaign Email Domain Performance |
| Campaign Product Activity | Campaign Email Activity           |
| Campaign Locations        | Campaign Sent To                  |
| Campaign Sub Reports      | Campaign Unsubscribes             |
| Campaign Advice reports   |                                   |

### Integrate Mailchimp with Daton

1. Sign-in to Daton .
2. Select Mailchimp from Integrations page.
3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later.
4. Provide Mailchimp API Key and Data Centre.
5. Post successful authentication, you will be prompted to choose from the list of available tables. Select the required tables from the list.
6. Then select all required fields for each table.
7. Submit the integration

### Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
2. Users would be able to edit/pause/re-activate/delete integration anytime
3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

### Mailchimp Data

### **Campaigns**

Purpose: Get all campaigns in an account. Campaigns are how you send emails to your Mailchimp list. Use the Campaigns API calls to manage campaigns in your Mailchimp account

Source API Documentation  <https://developer.mailchimp.com/documentation/mailchimp/reference/campaigns/>

Replication: Incremental

Replication Key: send\_time

**Fields**

<table data-header-hidden><thead><tr><th>Name</th><th>Target Datatype</th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>Name</td><td>Target Datatype</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>id</td><td>STRING</td><td>id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>web_id</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>create_time</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>archive_url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>long_archive_url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>status</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>emails_sent</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>send_time</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>content_type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>needs_block_refresh</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>resendable</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>recipients</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>settings</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>tracking</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>report_summary</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>delivery_status</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### **ConnectedSites**

Purpose: Get all connected sites in an account

Source API Documentation  [https://developer.mailchimp.com/documentation/mailchimp/reference/connected-sites/# ](https://developer.mailchimp.com/documentation/mailchimp/reference/connected-sites/)

Replication: Full Load

**Fields**

<table data-header-hidden><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>Name</td><td>Target Datatype</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>foreign_id</td><td>STRING</td><td>foreign_id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>store_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>platform</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>domain</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>site_script</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>created_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>updated_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### Ecommerce Stores

Purpose: Get a list of all Ecommerce Stores

Source API Documentation  <https://mailchimp.com/developer/marketing/api/ecommerce-stores/>

Replication: Full Load

**Fields**

<table data-header-hidden><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>Name</td><td>Target Datatype</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>id</td><td>STRING</td><td>id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>platform</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>domain</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>is_syncing</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>email_address</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>currency_code</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>money_format</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>primary_locale</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>timezone</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>phone</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>address</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>connected_site</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>automations</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_is_active</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>created_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>updated_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### Cart

Purpose: Get information about all carts in a store

Source API Documentation  <https://mailchimp.com/developer/marketing/api/ecommerce-carts/>

Replication: Full Load

**Fields**

<table data-header-hidden><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>Name</td><td>Target Datatype</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>store_id</td><td>STRING</td><td>store_id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>customer</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>campaign_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>checkout_url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>currency_code</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>order_total</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>tax_total</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>lines</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>created_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>updated_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### Customers

Source API Documentation  <https://mailchimp.com/developer/marketing/api/ecommerce-customers/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>Name</td><td>Target Datatype</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>store_id</td><td>STRING</td><td>store_id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>email_address</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>opt_in_status</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>company</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>first_name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>last_name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>orders_count</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>total_spent</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>address</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>created_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>updated_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### Products

Source API Documentation  <https://mailchimp.com/developer/marketing/api/ecommerce-products/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>Name</td><td>Target Datatype</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>store_id</td><td>STRING</td><td>store_id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>currency_code</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>title</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>handle</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>description</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>vendor</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>image_url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>published_at_foreign</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>variants</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>published_at_foreign_st</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### Product variants

Source API Documentation  <https://mailchimp.com/developer/marketing/api/ecommerce-product-variants/>

Replication: Full Load

**Fields**

<table data-header-hidden><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>Name</td><td>Target Datatype</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>store_id</td><td>STRING</td><td>store_id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>product_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>title</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>sku</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>price</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>inventory_quantity</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>image_url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>backorders</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>visibility</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>created_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>updated_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### Pro**mo Rules**

Source API Documentation  <https://mailchimp.com/developer/marketing/api/ecommerce-promo-rules/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>store_id</td><td>STRING</td><td>store_id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>title</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>description</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>starts_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>ends_at</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>amount</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>target</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>enabled</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>created_at_foreign</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>updated_at_foreign</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### Pro**mo Codes**

Source API Documentation  <https://mailchimp.com/developer/marketing/api/ecommerce-promo-codes/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>promo_rules_id</td><td>STRING</td><td>promo_rules_id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>store_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>code</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>redemption_url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>usage_count</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>enabled</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>created_at_foreign</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>updated_at_foreign</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### Orders

Source API Documentation  <https://mailchimp.com/developer/marketing/api/ecommerce-orders/>

Replication: Full Load

**Fields**

<table data-header-hidden><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>id</td><td>STRING</td><td>id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>customer</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>store_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>campaign_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>landing_site</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>financial_status</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>fulfillment_status</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>currency_code</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>order_total</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>order_url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>discount_total</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>tax_total</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>shipping_total</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>tracking_code</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>processed_at_foreign</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>cancelled_at_foreign</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>updated_at_foreign</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>shipping_address</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>billing_address</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>lines</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>tracking_number</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>tracking_carrier</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>tracking_url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td><td></td><td>REQUIRED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td><td></td><td>REQUIRED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td><td></td><td>REQUIRED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>promos</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>outreach</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### **F**acebook Ads

Source API Documentation  <https://mailchimp.com/developer/marketing/api/facebook-ads/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>id</td><td>STRING</td><td>id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>web_id</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>status</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>show_report</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>create_time</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>start_time</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>updated_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>canceled_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>published_time</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>has_segment</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>report_summary</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>recipients</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>thumbnail</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>email_source_name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>paused_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>end_time</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>needs_attention</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>was_canceled_by_facebook</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>is_connected</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>has_audience</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>has_content</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>channel</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>feedback</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>site</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>audience</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>budget</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>content</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### **Lists**

Purpose: Your Mailchimp list, also known as your audience, is where you store and manage all of your contacts.

Source API Documentation  <https://mailchimp.com/developer/marketing/api/lists/>

Replication: Incremental

Replication Key: campaign\_last\_sent

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>id</td><td>STRING</td><td>id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>web_id</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>contact</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>permission_reminder</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>use_archive_bar</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>campaign_defaults</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>notify_on_subscribe</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>notify_on_unsubscribe</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>date_created</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_rating</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>email_type_option</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>subscribe_url_short</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>subscribe_url_long</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>beamer_address</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>visibility</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>double_optin</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>has_welcome</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>marketing_permissions</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>stats</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### **Landing Pages**

Source API Documentation <https://mailchimp.com/developer/marketing/api/landing-pages/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>id</td><td>STRING</td><td>id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>title</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>description</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>template_id</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>status</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>store_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>web_id</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>created_by_source</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>created_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>published_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>unpublished_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>updated_at</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>tracking</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### **Campaign Reports**

Source API Documentation <https://mailchimp.com/developer/marketing/api/reports/>

Replication: Incremental

Replication Key: send\_time

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>id</td><td>STRING</td><td>id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>campaign_title</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>type</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_is_active</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_name</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>subject_line</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>preview_text</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>emails_sent</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>abuse_reports</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>unsubscribed</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>send_time</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>bounces</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>forwards</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>opens</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>clicks</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>facebook_likes</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>industry_stats</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_stats</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>timeseries</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>ecommerce</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>delivery_status</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### **Campaign Abuse**

Source API Documentation <https://mailchimp.com/developer/marketing/api/campaign-abuse/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td><td>id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>campaign_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_is_active</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>email_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>email_address</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>merge_fields</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>vip</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>date</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### **Campaign Open Reports**

Source API Documentation <https://mailchimp.com/developer/marketing/api/open-reports/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>campaign_id</td><td>STRING</td><td>campaign_id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>list_is_active</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>contact_status</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>email_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>email_address</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>merge_fields</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>vip</td><td>BOOLEAN</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>opens_count</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>opens</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### **Campaign Clicks**

Source API Documentation <https://mailchimp.com/developer/marketing/api/click-reports/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>id</td><td>STRING</td><td>id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>total_clicks</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>click_percentage</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>unique_clicks</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>unique_click_percentage</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>last_click</td><td>TIMESTAMP</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>campaign_id</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>_links</td><td>RECORD</td><td></td><td>REPEATED</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### **Campaign Email Domain Performance**

Source API Documentation <https://mailchimp.com/developer/marketing/api/domain-performance-reports/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>campaign_id</td><td>STRING</td><td>campaign_id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>domain</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>emails_sent</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>bounces</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>opens</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>clicks</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>unsubs</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>delivered</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>emails_pct</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>bounces_pct</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>opens_pct</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>clicks_pct</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>unsubs_pct</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

### **Campaign Product Activity**

Source API Documentation <https://mailchimp.com/developer/marketing/api/domain-performance-reports/>

Replication: Full Load

**Fields**

<table><thead><tr><th></th><th></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td>campaign_id</td><td>STRING</td><td>campaign_id</td><td></td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>title</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>sku</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>image_url</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>total_revenue</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>total_purchased</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>currency_code</td><td>STRING</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>recommendation_total</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr><tr><td>recommendation_purchased</td><td>NUMERIC</td><td></td><td>NULLABLE</td><td></td><td></td><td></td><td></td><td></td></tr></tbody></table>

\\
