Blushift Mailing Data (blueshift_mailing_events)
- Chris Laun
Owned by Chris Laun
Feb 28, 2023
Loading data...
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 |
| 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 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&&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 |
com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html-macro' is unknown.