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

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	email	11036_braze-026c3e+1002@inbox.mailtrap.io_11036	braze-026c3e+1002@inbox.mailtrap.io

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.

Sample_Send_Event_Source_To_FL_Conversion.dlp