Submit a request

In this Article

    Constant Contact | Campaign Performance Dataset

    Avatar
    Brendon Reimer
    Updated:
    Follow

    This article details the dataset structure that ChannelMix considers standard for the Campaign Performance dataset from Constant Contact.  This is always considered "lifetime" data and daily aggregated metrics are not available.  Data is pulled daily for the last 3 days with a 0 day lag.

    Field Type Description
    Created At Timestamp The system generated date and time that this email campaign was created.
    Updated At Timestamp The system generated date and time showing when the campaign was last updated.
    Last Sent Date Timestamp The date and time that the email campaign was last sent.
    Campaign ID Text The unique ID used to identify the email campaign (UUID format).
    Campaign Name Text The descriptive name the user provides to identify this campaign. Campaign names must be unique for each account ID.
    Campaign Type Text

    Identifies the type of campaign that you select when creating the campaign. Newsletter and Custom Code email campaigns are the primary types.

    Field values include: [Newsletter, Custom Code Email, Announcement, Product/Service News, Business Letter, Card, Press release, Flyer, Feedback Request, Ratings and Reviews, Event Announcement, Simple Coupon, Sale Promotion, Product Promotion, Membership Drive, Fundraiser]
    Campaign Activity ID Text The unique ID used to identify the campaign activity (UUID).
    Activity Role Text The purpose of the individual campaign activity in the larger email campaign effort. Valid values are:
    • primary_email — The main email marketing campaign that you send to contacts. The primary_email contains the complete email content.
    • permalink — A permanent link to a web accessible version of the primary_email content without any personalized email information. For example, permalinks do not contain any of the contact details that you add to the primary_email email content.
    • resend — An email campaign that you resend to contacts that did not open the email campaign.

    Constant Contact creates a primary_email and a permalink role campaign activity when you create an email campaign.

    Field values include: [primary_email, permalink, resend]
    Current Status Text The current status of the email campaign activity. Valid values are:
    • DRAFT — An email campaign activity that you have created but have not sent to contacts.
    • SCHEDULED — An email campaign activity that you have scheduled for Constant Contact to send to contacts.
    • EXECUTING — An email campaign activity Constant Contact is currently sending to contacts. Email campaign activities are only in this status briefly.
    • DONE — An email campaign activity that you successfully sent to contacts.
    • ERROR — An email campaign activity that encountered an error.
    • REMOVED — An email campaign that a user deleted. Users can view and restore deleted emails through the UI.
    Field values include: [DRAFT, SCHEDULED, EXECUTING, DONE, ERROR, REMOVED]
    From Email Text The email "From Email" field for the email campaign activity. You must use a confirmed Constant Contact account email address.
    From Name Text The email "From Name" field for the email campaign activity.
    Reply To Email Text The email "Reply To Email" field for the email campaign activity. You must use a confirmed Constant Contact account email address.
    Subject Text The email "Subject" field for the email campaign activity.
    Preheader Text The email preheader for the email campaign activity.
    Permalink URL Text The permanent link to a web accessible version of the email campaign content without any personalized email information. The permalink URL becomes accessible after you send an email campaign to contacts.
    Unique Sends Whole Number Number of unique email sends.
    Unique Opens Whole Number Number of unique recipients who opened the email.
    Opens All Whole Number Total number of non-unique email opens.
    Unique Not Opened Whole Number Number of unique recipients who did not open the email. This is calculated as follows: em_not_opened is equal to em_sends - em_opens - em_bounces. This value is reported as zero if the calculation results in a negative value.
    Opens All Tablet Whole Number Number of non-unique email opens on a small tablet type computer (e.g. iPad).
    Opens All Computer Whole Number Number of non-unique email opens on a standard desktop or laptop computer.
    Opens All Mobile Whole Number Number of non-unique email opens on a mobile phone or similar small mobile device (e.g. iPhone).
    Opens All Other Whole Number Number of non-unique email opens on an unknown device (e.g. Game Console or Wearable).
    Opens All None Whole Number Number of non-unique email opens for which the device type was not captured. This will account for any opens prior to when device type was collected and stored.
    Unique Clicks Whole Number Number of unique recipients who clicked any link in the email.
    Clicks All Whole Number Total number of non-unique email clicks.
    Clicks All Tablet Whole Number Number of non-unique email clicks on a small tablet type computer (e.g. iPad).
    Clicks All Computer Whole Number Number of non-unique email clicks on a standard desktop or laptop computer.
    Clicks All Mobile Whole Number Number of non-unique email clicks on a mobile phone or similar small mobile device (e.g. iPhone).
    Clicks All Other Whole Number Number of non-unique email clicks on an unknown device (e.g. Game Console or Wearable).
    Clicks All None Whole Number Number of non-unique email clicks for which the device type was not captured. This will account for any clicks prior to when device type was collected and stored.
    Unique Bounces Whole Number Number of unique email bounces.
    Unique Bounces Blocked Whole Number Unique number bounced because as blocked by the receiving system.
    Unique Bounces Vacation Whole Number Unique number that bounced back with a vacation or out of office autoreply.
    Unique Bounces Undeliverable Whole Number Unique number that bounced as undeliverable.
    Unique Bounces Mailbox Full Whole Number Unique number that bounced back with a mailbox full message.
    Unique Bounces Suspended Whole Number Unique number that bounced as suspended. Email address bounces as suspended when multiple non-existent bounces have been received for the same address.
    Unique Bounces Nonexistent Address Whole Number Unique number that bounced as a non-existent address.
    Unique Bounces Other Whole Number Unique number that bounced without an identifiable cause.
    Unique Forwards Whole Number Number of unique recipients who forwarded the email using the forward to a friend feature (not available for all types of emails).
    Unique Optouts Whole Number Number of unique recipients who unsubscribed due to this email.
    Abuse Whole Number Number of abuse (spam) complaints received.
    Contact List IDs Text List of unique contact list IDs associated to the campaign.
    Segment IDs Text List of unique segment IDs associated to the campaign.
    Stats Last Refreshed By Constant Contact Timestamp The time at which the campaign activity stats were last refreshed by Constant Contact in ISO 8601 format (e.g. '2015-08-25T22:00:09.908Z').
    Insert Date Timestamp ChannelMix Field: when the row was inserted into the dataset.
    ChannelMix Profile Text ChannelMix Field: the ChannelMix Profile associated with the data.
    Was this article helpful?
    0 out of 0 found this helpful
    Have product questions? Visit our Community!
    Have more questions? Submit a request