Campaign Activity Reports

Blueshift allows you to track all the raw campaign actions (Ex: sent, delivered, opened etc ) from your campaigns and see exactly what actions were taken. The campaign activity reports give you lots of valuable information to track and measure the performance of your campaigns. You can review your individual campaign activity reports by each day to track the performance of your campaigns. Blueshift captures and archives all this campaign activity (sends, clicks, opens, delivered etc) to your S3 bucket. The data is batched and written to the folder every 5 mins.

You can find the campaign activity reports at the following location on your s3 bucket

bucket: bsft-customers
path: <site_name>/campaign_activity/<year>/<month>/<day>
Ex: demosite.com/campaign_activity/2018/06/21/

 

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

 

Sample Data:

Here's some sample data:

trigger_timestamp trigger_type experiment_uuid user_uuid retailer_customer_id email action event extended_attributes trigger_uuid campaign_uuid merged_from_user_uuid creative_uuid uuid execution_key message_uuid
2018-06-21T07:08:18+00:00 EmailTrigger 153811c3-16b5-4ca9-9ba5-6a0e50a606b2 69d56862-049f-405d-b162-ea457fd11ea8 C12345 test@test.com sent   "{""campaign_exec_term"":""transactional"",""execution_key"":""20180621070805"",""message_uuid"":""8e5b8e0f-9a7a-48ea-9e49-8913ffe20334"",""transaction_uuid"":""3c8eb39f-f0c2-406b-9fdd-2cba76de3fbc"",""utm_campaign"":""my_campaign""}" 1244a2ad-f23d-4422-85b3-be2954eb11b6 a20a33f7-8e05-4742-bc75-60ffe6da7d2c   c8b47d68-db9b-4d71-b198-9e9f6fa94f98 1e5b8e0f-9a7a-48ea-9e49-8913ffe20334 2018-06-21T07:00:00Z   8e5b8e0f-9a7a-48ea-9e49-8913ffe20334
2018-06-21T07:08:52+00:00 EmailTrigger 153811c3-16b5-4ca9-9ba5-6a0e50a606b2 69d56862-049f-405d-b162-ea457fd11ea8 C12345 test@test.com delivered   "{""message_uuid"":""8e5b8e0f-9a7a-48ea-9e49-8913ffe20334"", ""transaction_uuid"":""3c8eb39f-f0c2-406b-9fdd-2cba76de3fbc"",""sg_message_id"":""wa8jzQcqSnWUMFlHLKavWA.filter0611p1iad2-11282-5B2B4EE2-9.0"",""utm_campaign"":""my_campaign""}" 1244a2ad-f23d-4422-85b3-be2954eb11b6 a20a33f7-8e05-4742-bc75-60ffe6da7d2c   c8b47d68-db9b-4d71-b198-9e9f6fa94f98 4293e8a4-d167-47e0-a4cc-883c176824d8  2018-06-21T07:00:00Z 8e5b8e0f-9a7a-48ea-9e49-8913ffe20334 

 

Attributes: 

name description type
trigger_timestamp Time of the action in iso8601 UTC timestamp
trigger_type

Type of the trigger

EmailTrigger: Email channel

PushTrigger: Push channel

SmsTrigger: SMS channel

OnsiteTrigger: Live website channel

WebhookTrigger: Cloud App channel

 String
experiment_uuid Unique identifier of experiment.
Even if there is a single template on a trigger, it will generate a unique experiment_uuid.
Engagement statistics are aggregated against experiment_uuid for reporting.		 String
user_uuid unique Blueshift generated user uuid for the user. String
retailer_customer_id customer_id of the customer as passed into Blueshift via API or CRM upload. String
email email identifier of the customer String
action

User campaign activity action. The action is set to attribution when a goal events gets attributed to a campaign. Possible values:

  • sent: Message sent to user
  • open: User opened/viewed message
  • click: User clicked on the link
  • holdout: The user was held out from getting a message from the campaign since the user was a member of the control group.
    Also look for the is_global extended attribute for more information.
  • bounce: Hard bounce from ISP
  • soft_bounce: Temporary soft bounce from ISP
  • delivered: Delivery notification from ESP sendgrid/sparkpost
  • attribution: Downstream conversion such as purchase or custom goal based on attribution model configured
  • unsubscribed: User clicked unsubscribed
  • spam_report: User reported email as Spam
  • visit: User session/visit attributed to campaign
 String
event

The event name for event triggered campaigns or attribution:

  • If the action is sent and was triggered as a part of event triggered campaign or 
  • If action is attribution, the event which got attributed

String
extended_attributes JSON encoded Metadata for the message - includes  "message_uuid" which uniquely tracks all the user actions to a send.
You can also white list custom attributes from your event to be included here.
It also includes all the utm parameters, such as utm_campaign, that specifies the campaign name.
For more information, see Campaign Tracking Parameters. 		 String
trigger_uuid UUID of the Trigger step in the journey (example: Send an email).
Each step in a journey has a unique trigger_uuid.
The trigger uuid is shown in the Advanced settings at the bottom of the trigger in the campaign creation page.		 String
campaign_uuid UUID of the Campaign.
This corresponds to the UUID of the campaign from the URL.

Example: if the campaign url is https://app.getblueshift.com/dashboard#/campaigns/2df5aa31-3261-4354-8395-53c76a4cec9c/details,
Its corresponding uuid will be 2df5aa31-3261-4354-8395-53c76a4cec9c		 String
merged_from_user_uuid Old user uuid, if the user was merged to another user String
creative_uuid Template UUID.
This corresponds to the UUID of the template from the URL.
Example: if the template url is https://app.getblueshift.com/dashboard#/app/email_template_studio/4290936f-9223-40d2-8bcf-60ffa7e8d1d7/edit/info.
Its corresponding uuid will be 4290936f-9223-40d2-8bcf-60ffa7e8d1d7		 String
uuid UUID for this action String
execution_key Campaign execution time timestamp
message_uuid UUID of the message sent String

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 table below provides the extended attributes of the following campaign types:

  • One Time
  • Recurring
  • Segment triggered
  • Event triggered
  • API triggered
Parameter Email SMS Push In-app Cloud-app
account_algorithm_uuid
(Unique identifier of the recommendation algorithm that is used to generate product recommendations in a template.)		 ✓  ✓  ✓  ✓  ✓ 

campaign_exec_term (The term that indicates the campaign type and behavior. For example, one-time or recurring.)

  ✓ ✓  ✓   ✓  ✓

message_uuid

(Unique identifier of the message that is sent to your customers)

 ✓  ✓ ✓   ✓  ✓

transaction_uuid
(Unique identifier of the transaction if a message sent as a part of a campaign is also a part of a transaction.)

 ✓  ✓ ✓     

product_uuid
(Unique identifier of the product that is sent in a campaign)

 ✓        

bsft_click_uuid 

 ✓  ✓       

user_agent
(Information on the device type where your customer views the message. For example, information such as Mozilla, Chrome in this field indicates that the user viewed the message on a browser.)

 ✓  ✓  ✓    

mime_type
(Indicates the type non-ASCII components of a message.)

 ✓        

url
(URL of the product from your site that includes parameters for analytics on our platform.)

 ✓ ✓       
utm_source (The source of traffic to your service. For example, Blueshift.) ✓     ✓  
utm_campaign (Your campaign's name.) ✓ ✓ ✓ ✓ ✓
utm_medium (The channel on which a message was sent to your customer. For example, email.) ✓ ✓ ✓ ✓ ✓
utm_content (Optional parameter to include information such as details on an A/B test.) ✓ ✓ ✓ ✓ ✓ 
utm_term (Optional parameter to include keywords that optimize search based ads.) ✓  ✓  ✓  ✓  ✓ 
sending_ip (The IP address that your email service provider uses to send messages.) ✓ ✓      
ip_pool (The pool of IP addresses from which your email address provider picks an IP address to send emails.) ✓        
sending_domain (The domain that your email service provider uses to send emails.) ✓        
adapter_uuid (The unique identifier of the adapter that you use to send messages to your customers. An adapter represents an integration with Blueshift to send messages.) ✓        
subaccount_id (ID of the account you create for Blueshift in Sparkpost or Sendgrid to send emails.) ✓        
friendly_from (The email address that we use to send emails to your customers.) ✓        
execution_key
(The date and time of the execution of a step in a campaign.)		  ✓     ✓  ✓
product_ids
(Unique identifiers of the products sent in a message)		 ✓        
products
(Products sent in a message)		 ✓         
bsft_link_url  ✓ ✓      
cloud_app
(Content type of the message sent through a cloud app. For example, custom JSON.)		         ✓
template
(Template used for a message.)		       ✓  ✓
Recommendations
(Unique identifier of the product recommendations used in a message. It is available for 'send' events only.)		 ✓ ✓ ✓ ✓ ✓

clk_elmt

(Identifier of the clicked element on an in-app modal)

       ✓  

is_global

(true indicates that the user is a member of the global control group.

false indicates that the user is a member of the campaign control group.)

 

 ✓ ✓ ✓ ✓ ✓

clk_url

(Identifier of the action or the URL of a page in the app that is launched when a customer clicks on it in an in-app modal)

       ✓  

preheader_text
(The pre-header text of the email.)

 ✓        

subject

(The subject line of the email.)

 ✓        

price_per_message

(The cost of sending an SMS if you use Infobip as your SMS adapter with Blueshift.)

   ✓      

currency

(The currency of the cost of sending an SMS if you use Infobip as your SMS adapter with Blueshift.)

   ✓      
bsft_template_version

(The version of the template used in the email.)		 ✓        
bsft_link_index

(Identifies the instance of the URL when the same URL is used in multiple locations in the template.)		 ✓        

Note

For event triggered campaigns, the extended attributes can also show the whitelisted event attributes. Reach us on support@blueshift.com to enable this feature.

 

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.