Narrator Docs

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-min meeting with our data team

Updated about a month ago



Spend Transformations


A special type of enrichment transformation that creates a spend table to record historical marketing data.

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.