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.

ColumnDescription
enriched_activity_idUnique id for each record in the table
enriched_tsTimestamp in UTC of the data date
ad_sourceName of the ad source generating the data (ie. 'adwords'). The ad source values should match the ad source feature in your started session activity.
impressionsNumber of impressions
clicksNumber of clicks
spendAmount spent
additional_columnsThese 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