Blushift Mailing Data (blueshift_mailing_events)

Overview: This is an incremental batch feed of Blueshift mailing event data.

Frequency: Every 4 hours

Data Source: Blueshift

Delivery Method: Bulk API

LQL Advice: Create last action dates using the 'action' field. Create set fields using 'campaign_name' or 'campaign_segment name', based on the action seen, to identify users who received, opened, or clicked particular mailings.

Field Name	Description	Sample Value
action	Action from the email event record	delivered sent open click bounce unsubscribe soft_bounce spam_report
Affiliate	Affiliate who sent the mailing	International Living
bsft_link_id	Blueshift identifier for a link in an email	18
campaign_name	Campaign name from Blueshift	2021-02-05 ILP Paid Dedicated
campaign_segment_name	Segment name from Blueshift	ILVDED File Advanced Segment - NO LTS, PLC, RND, Weekly
campaign_uuid	Blueshift identifier for a campaign	771e23fc-2cfc-4ddf-855b-6ed79718154a
email	Email address the mailing was sent to	test@example.com
execution_key	Westech generated key to tie an email to when it was sent from Blueshift	2021-02-04T19:01:09Z
experiment_email_subject	Subject line of the email sent	Easy Earning With Stock Photography
experiment_uuid	Blueshift identifier for an experiment	41878b3c-1dcc-b3a0-6008-d07832f71e9e
list_code	Advantage list code used by the mailing	ILPOSTCA
message_uuid	Blueshift identifier for a message	7229a23b-436f-494a-8e74-f6dec44aa9e6
Owning_Organization	Code indicating who owns the list	120
trigger_friendly_from	Friendly name used as the sender of the email	International Living Platinum Circle
trigger_timestamp	Timestamp of the event	2021-02-23 23:24:15.0000000
url	Url of the link	https://signup.realestatetrendalert.com/1729118?customerNumber=000009930454&amp&campaignId=994e0d90-ee72-4852-8b32-2cd4c3d80671&r=eml&experimentId=d0c4ee17-f129-e2ee-5f36-b0fd2ab2df09&vid=ZcOEvG&customerId=000009930454-000000065163&bs_gclid=&utm_campaign=2021-02-12-ilp-paid-dedicated-rrei-listbuild&utm_source=blueshift&utm_medium=email&utm_content=2021-02-12-ilp-paid-dedicated-rrei-listbuild%29&bsft_clkid=75433cbf-a2a2-43da-832f-e4ee46f91b41&bsft_uid=f1b0700f-6bde-4984-97ee-b8d557f3590c&bsft_mid=1fd85866-b4c9-4573-8e49-37f62b3445e9&bsft_eid=d0c4ee17-f129-e2ee-5f36-b0fd2ab2df09&bsft_utid=f1b0700f-6bde-4984-97ee-b8d557f3590c-ILPPAID&bsft_link_id=24&bsft_mime_type=text&bsft_ek=2021-02-12T23%3A31%3A07Z&bsft_aaid=aa8cd6a3-e6e8-49de-9a51-21220a4fdce6&bsft_lx=1&bsft_tv=2
user_uuid	Blueshift identifier for a user	01295c5a-3da7-467a-95dc-0b3b8ca5fddb

Data & Analytics Support

Blushift Mailing Data (blueshift_mailing_events)

Analytics

Overview: This is an incremental batch feed of Blueshift mailing event data.

Frequency: Every 4 hours

Data Source: Blueshift

Delivery Method: Bulk API

LQL Advice: Create last action dates using the 'action' field. Create set fields using 'campaign_name' or 'campaign_segment name', based on the action seen, to identify users who received, opened, or clicked particular mailings.

Related content