Activity Transformations
What is an activity transformation?
An activity transformation is the SQL query that transforms your source data to define your activity. The activity transformation must meet two requirements:
- Each record corresponds to a customer completing the activity
- It follows a defined structure (11 columns) so that it is compatible with, and can be added to, the Activity Stream
Narrator uses the activity transformation to add activities to the Activity Stream. The activity transformation becomes the definition that will be used to define a customer concept (activity) across your company. Once you create a transformation, everyone at your company will be able to use the same shared definition for this activity.
How To: Create an Activity Transformation
Watch this step-by-step tutorial to add your first activity transformation
Columns in an Activity Transformation
The SQL query transforms the source data to generate the following 10 columns:
| Column | Description |
|---|---|
activity_id | Unique ID for the activity record |
ts | Timestamp in UTC for when the activity occurred |
anonymous_customer_id | (for identity resolution) The anonymous customer id that is generated by the source system of this activity |
customer | Unique identifier for the customer that is used to identify them across all company touchpoints (typically an email address) |
activity | Name of the activity (ex. 'completed_order') |
feature_* | Activity specific feature with feature_ appended in front of the name. |
revenue_impact | Revenue or cost associated with the activity (this must be tracked in the same currency for all activities*) |
link | URL link associated with the activity (ex. link to the Shopify Order) |
*The revenue_impact currency formatting can be set within company settings
Examples
Explore the transformation library for examples by data source.
FAQ
- Can I use multiple transformations to define an activity?
- When should I use
anonymous_customer_id? - What is the re-sync checkbox?
Still have questions?
Our data team is here to help! Here are a couple ways to get in touch...
š¬ Chat us from within Narrator
š Email us at [email protected]
š Or schedule a 15 minute meeting with our data team
Updated over 1 year ago
Watch this step-by-step tutorial to create your first activity transformation