Our RedShift integration creates a mirror dataset of all events your account has in our system, inside of a RedShift instance.
Each field in our system becomes a column and each row represents an event.
All events have values for the following columns:
|eventId||String - Used as internal identifier in Rebel's platform|
|campaignId||String - Used as internal identifier in Rebel's platform|
|to||String - Set by the user to identify email recipient|
|type||String - One of
Do not have any values in additional columns.
Populate an additional value in the
|variant||String - One of
Populate additional values in the
interaction string contains a pipe delimited string describing the full interaction. E.G.
gallery||0||thumbnail||1 would represent a click on the first gallery's second thumbnail.
|interaction||String - Represents the full interaction|
Populate additional value in the
|submitPayload||Object - Varies depending on the submitted values|
duration columns are deprecated, but are kept in the integration to support legacy events.