Activity transformations are getting simpler!
anonymous_customer_id is replacing the
source_id columns in the activity transformation
- Simplified Logic
source_idhave caused a lot of confusion for users. The single
anonymous_customer_idis much more clear and straightforward to use.
- Performance Improvements
When using datasets or the customer journey, the
source_idwould need to be concatenated to create a unique identifier. This additional processing step creates unnecessary strain on the warehouse. Now, the unique identifier will be defined once, alleviating the need for more processing.
Example Activity Transformation:
SELECT s.id as activity_id, s.timestamp as ts, s.anonymous_id as anonymous_customer_id, -- new column! s.email as customer, 'logged_in' as activity, NULL as feature_1, NULL as feature_2, NULL as feature_3, NULL as revenue_impact, s.url as link FROM table.schema as s
Do I need to migrate my transformations that use
No, existing transformations will still work, but all new transformations should use
It's used for identity resolution in the data processing. Learn more about Identity Resolution in Narrator.
What if two different data sources use the same ID for two different people?
anonymous_customer_idshould be unique for that user across all activities in the activity stream. An easy way to ensure this is to concatenate a string before the ID for each data source. For example, if two different systems uses a numeric ID 1 to 10,000, you could define the anonymous_id as
('system_1 -' || id)to create a unique ID for that system that won't be confused with system 2's id.
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