Spend Transformations
A special type of enrichment transformation that creates a spend table to record historical marketing data.
What is a spend table?
A spend table maintains all of the details about your company's marketing spend, campaign details, and utm parameters.
Every marketing dollar cannot be associated to a specific customer, so the spend data is aggregated before it is joined to the data in the activity stream. This ensures that all marketing spend details are used when evaluating marketing performance.
How is it used?
The spend table can be joined to any grouped dataset to enrich it with marketing details like total spend, clicks, impressions, etc. The data in the spend table is aggregated before it is joined to the grouped dataset.
See How To: Add Spend Data to your Dataset to see how it's used.
Columns in an Spend Transformation
A spend transformation generates a dataset with six required columns and any number of additional columns related to marketing (campaign, utm parameters, etc). Spend transformations are a specific implementation of an enrichment transformation.
| Column | Description |
|---|---|
enriched_activity_id | Unique id for each record in the table |
enriched_ts | Timestamp in UTC of the data date |
ad_source | Name of the ad source generating the data (ie. 'adwords'). The ad source values should match the ad source feature in your started session activity. |
impressions | Number of impressions |
clicks | Number of clicks |
spend | Amount spent |
| additional_columns | These columns are the additional features related to the marketing spend (ie. campaign, creative, etc). The names should be descriptive of the data they represent (as opposed to the generic feature_1, feature_2, feature_3 naming used for activities). |
How To: Create a Spend Table
Watch this step-by-step tutorial to learn how to add a spend table.
Examples
Explore the transformation library for examples by data source.
FAQ
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