# Mailchimp: Campaign Activities

## Description

* Each record represents an activity taken in relation to a campaign email, enriched with data about when the campaign was sent and the lag between send and the activity.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/mailchimp/resources/mailchimp.svg" alt="" data-size="line"> Mailchimp

## Columns

| Type     | Name                       | Description                                                                                    |
| -------- | -------------------------- | ---------------------------------------------------------------------------------------------- |
| STRING   | action\_type               | One of the following actions: 'open', 'click', or 'bounce'                                     |
| STRING   | campaign\_id               | The unique ID for the sent campaign.                                                           |
| STRING   | member\_id                 | The ID of the member the activity relates to.                                                  |
| STRING   | list\_id                   | The ID of the list the email was sent to.                                                      |
| DATETIME | activity\_timestamp        | The timestamp when the activity occurred.                                                      |
| STRING   | ip\_address                | The IP address recorded for the action.                                                        |
| STRING   | url                        | If the action is a 'click', the URL on which the member clicked.                               |
| INTEGER  | bounce\_type               | If the action is a 'bounce', the type of bounce received: 'hard', 'soft'.                      |
| INTEGER  | combination\_id            | The ID of the combination the member was part of for a campaign.                               |
| STRING   | activity\_id               | The ID of the activity/event.                                                                  |
| STRING   | email\_id                  | The ID of the email sent. Surrogate key generated in dbt from 'campaign\_id' and 'member\_id'. |
| DATETIME | send\_timestamp            | The time the campaign was sent.                                                                |
| INTEGER  | time\_since\_send\_minutes | The time from send to activity in minutes.                                                     |
| INTEGER  | time\_since\_send\_hours   | The time from send to activity in hours.                                                       |
| INTEGER  | time\_since\_send\_days    | The time from send to activity in days.                                                        |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/mailchimp-campaign-activities.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.