What Data Is Needed to Integrate Campaign Interaction Data into the ROI Report?
For many clients, the strength of the Platform lies in integrating various first-party data sources with campaign interaction data from multiple marketing channels. Strum Platform is an open-source system that enables clients to seamlessly incorporate campaign interaction data from external sources, provided the data includes an ID for connecting with product-level data and offers interaction-level records. Strum Platform already supports numerous integrations to facilitate this process but can be expanded to include systems not yet integrated. The specifications below outline the data elements required to link external campaign data to your membership records in Strum Platform.
For optimal tracking and reporting, campaign interaction data should be provided at the interaction level, with each row representing a unique interaction or activity. If this level of detail is not available, please inform Strum to determine if a customized project or data flow build is necessary to fully populate the supporting data structure, or if an alternative daily summary-level extract can be used.
*Please note that any data provided to Strum is treated as highly confidential and will not be disclosed to anyone outside of Strum without the expressed, written consent of the client institution.
Campaign Interaction Data Extract Specifications:
| Field | Type | Required | Optional | Details |
| Unique Customer ID | char | x | required if direct matching for attribution is desired. The customer ID needs to be the same as the ID element passed to Strum in the nightly extract for accurate matching. | |
| Campaign ID | char | x | required if interaction data should be grouped by or tied to a specific campaign | |
| Campaign Name | char | x | required if interaction data should be grouped by or tied to a specific campaign | |
| Parent Campaign ID | char | x | example would be if there was a parent campaign like a customer journey or flow | |
| Campaign Category/Group | char | x | ||
| Campaign Audience | char | x | if tracking by audience is desired | |
| First Contact Date | date | x | earliest send for this campaign ID, if campaign ID is included | |
| Last Contact Date | date | x | latest send for this campaign ID, if campaign ID is included | |
| Interaction Type | char | x | Examples (sent, delivered, opened, clicked, failed, bounced, unsubscribed) | |
| Interaction Reason | char | x | if result is failed or bounced (hard, soft, etc…) | |
| Interaction Date | date | x | ||
| Channel | char | x | if tracking channels within the same source is desired | |
| Link/Funnel (URL) | char | x | if tracking link activity is desired | |
| Version | char | x | if tracking versions is desired | |
| A/B Testing Variant | char | x | if tracking A/B variants is desired | |
| Source | char | x |