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

• 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.