Export campaign activity data

Blueshift can export a campaign activity each time your customer interacts with a marketing message. Notifications can be sent to Segment.com, mParticle, Mixpanel or a Custom webhook URL. Blueshift sends a notification when the customer opens, clicks, or unsubscribes to marketing messages, or if marketing messages bounce or get delivered. You can use this to update analytics or route the data to other partners you may be using.

In order to export campaign activity, go to the Campaign Activity Export tab in Account Settings and set up the required configurations.

Export campaign status notifications

You can export execution details for event triggered campaigns to a webhook by completing the following settings.

Export selected campaign activity data

Export selected campaign activities by completing the following settings and selecting the events to export.

Ensure that you Save your settings.

This is how the notification content looks if the payload of the webhook callback is batched.

{
"batch": [
    {  
    "action":"open",
    "bucket_uuid":"e211ea94-8da6-43a5-b95b-c21ccfe4568c",
    "campaign_exec_term":"on_going",
    "campaign_id":"0835fbbb-4059-4172-bebc-6aafdaa7b44f",
    "campaign_name":"Abandoned cart",
    "campaign_uuid":"0845bbbb-4059-4172-bebc-6aafdaa7b44f",
    "creative_uuid":"a533de05-1a32-4312-80da-7c5893fbd5a5",
    "customer_id":"12345",
    "email":"username@domain.com",
    "event":"open",
    "experiment_uuid":"ac09f565-9bd9-4f72-b5ea-6a143516f1f4",
    "ip":"198.234.218.145",
    "message_uuid":"3543b535-29ad-4144-a749-2340a5c694f0",
    "trigger_timestamp":"2016-11-22T06:50:14+00:00",
    "trigger_type":"EmailTrigger",
    "trigger_uuid":"577a52f6-0678-4aa2-80f9-f819395aba07",
    "user_agent":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:49.0) Gecko/20100101 Firefox/49.0",
    "user_uuid":"9a4df219-e42c-4913-a3d9-917e9fb4dd6d",
    "utm_campaign":"abandoned_cart",
    "utm_content":"product-banner",
    "utm_medium":"email",
    "utm_source":"blueshift",
    "utm_term":null
    },
    ...
    ]
}

Export all campaign actions

Blueshift also exports all the raw campaign actions (sent, delivered, opened, and so on) from your campaigns in the form of campaign activity reports which give you lots of valuable information to track and measure the performance of your campaigns. These reports are exported to Amazon S3. You can also export these reports to your Snowflake account.

Data in campaign activity reports

The following attributes and extended attributes are exported in the campaign activity reports to S3 and Snowflake.

Note: Blueshift can add new columns in the future, but any new columns will be added at the end.

Attributes

Extended attributes

The extended attributes field in a report includes metadata of a campaign activity.

• A campaign activity can be a message that is sent, a message that bounces, spam reports etc. You can use this additional information in your attribution models.
• In addition, extended attributes also include:
  • Additional parameters that you specify in your campaign
  • Certain attributes specific to an adapter or a channel such as IP addresses for Sparkpost and Sendgrid
• Each campaign type has its own attributes that are added in the extended attributes field of the report.
• The rendered attributes are available only for ‘send’ events. The raw values are available for all events.

The following table provides the extended attributes for the following types of campaigns:

• One Time
• Recurring
• Segment triggered
• Event triggered
• API triggered

¹Note: The user_agent attribute in an email open event provides information regarding the email client that was used to open the email and is used to determine if the email was opened by a user, was a prefetch open, or was opened by a proxy server. The User-Agent request header is a characteristic string that is used by servers and network peers to identify the application, operating system, vendor, and/or version of the requesting user agent.

• For a user open, the full user-agent attribute is returned. For example: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:35.0) Gecko/20100101 Firefox/35.0
• For a prefetch open, only the User Agent information is returned. For example: Mozilla/5.0
• For a proxy open, no user_agent information is returned.