Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.