Campaign event sample: Braze
This page contains an example of a JSON record that is converted to Campaign Event NonRPI Feed Layout.
Redpoint CDP data ingestion does not require that all fields are populated for a given field layout. In this example, only the fields that are populated based on the JSON input are represented in the CSV file.
Example JSON
{
"events": [
{
"event_type": "users.messages.email.Send",
"id": "80500abb-b102-4334-94f5-5e9587b69423",
"time": 1700515504,
"user": {
"user_id": "6532cf544764af00014d1c96",
"external_user_id": "11036"
},
"properties": {
"campaign_id": "f7428cc5-2fc6-424c-9a2c-61e91a30d0ac",
"message_variation_id": "6cda6825-879c-469c-87a0-50cdf6a31d6d",
"dispatch_id": "655bcea34c4185eadd8ab7b07dbc5a9e",
"campaign_name": "RP_CAMPAIGN_20231120_SEND01",
"message_variation_name": "Variant 2",
"email_address": "braze-026c3e+1002@inbox.mailtrap.io",
"ip_pool": "partner_us03_ip_pool",
"message_extras": null
}
}
]
}
Sample CSV record
This is the converted record that can be found in the attached CSV file.
Attached file name: Braze_Campaign_Event_Converted.csv
sor_name | client_campaign_event_id | campaign_event_datetime | campaign_code | campaign_name | cell_code | cell_name | channel_code | audience_id | email_address |
Braze Sample | 80500abb-b102-4334-94f5-5e9587b69423 | 11/20/2023 21:25 | f7428cc5-2fc6-424c-9a2c-61e91a30d0ac | RP_CAMPAIGN_20231120_SEND01 | 6cda6825-879c-469c-87a0-50cdf6a31d6d | Variant 2 | 11036_braze-026c3e+1002@inbox.mailtrap.io_11036 |
Attached file:
Braze_Campaign_Event_Converted.csv
RPDM project to convert JSON to CSV
This is the Redpoint Data Management (RPDM) project used to convert the Braze JSON to the Campaign Event NonRPI Feed Layout CSV file.