Get the most from your marketing budget — explore our campaign spend attribution interactive demo below
Identify your ads and platforms
First, you’ll need a list of your ads and the platforms on which they ran. Each row should represent an ad/platform combination. If an ad ran on multiple platforms, the ad will populate multiple rows (one for each associated platform).
Identify money spent per ad
Next, you’ll need a column displaying how much money was spent for each ad/platform pair. In the example above, this is represented as the [Money Spent (USD)] column. Your column names don’t have to match this example.
Select a conversion metric
Finally, you’ll need a conversion metric. In this example, we’ll look at sales leads. However, you may choose from a variety of other data points (e.g. products sold, account signups, initial conversion steps, website click-throughs, revenue from deals closed, or inboard sales contacts).
Group your data by platform
Data is easier to digest when it’s grouped into distinct categories. If multiple rows of data share a common value in a given column, you can group these rows based on that value. In this example, rows are grouped based on their value in the [Platform] column.
Calculate spend and ROI
Entering a single formula automatically calculates data across every row in a table. In this example, [Money Spent] / [Sales Leads] calculates the cost per lead of each individual ad on a platform.
Visualize ad performance
Bar charts are great for displaying campaign spend attribution.
Add your ads and their calculated costs per lead to a bar chart to see a side-by-side comparison of your data.
Add color to distinguish ads by platform
Just like the rows in your table, each bar in your visualization represents an ad/platform combination. Color-code your visualization based on each ad’s associated platform to see which bars are associated with each platform.
Identify your best-performing ads
Now all you have to do is sort your data! Sort your ads by their cost per lead, and your visualization will represent their ROI accordingly.
Ready to Get Started?
For your security, Sigma never holds onto your data. Start a free trial to connect to your data cloud and get up and running.
- Upload CSVs and import data easily
- Connect to company data in the cloud
- Invite colleagues to explore and collaborate
Come back on your desktop for the full experience
Sigma is Believing.
Start your 14-day free trial now to see the game-changing ways Sigma allows teams to unleash the full power of their data.
- Combine data from all your sources
- Use familiar spreadsheet formulas
- Showcase your data story
Marketing analytics in Sigma means more
Form & function
Pivot, lookup, filter, and drill into any level of detail in an unconstrained spreadsheet environment.
Scale & speed
Explore and sort through billions of rows of data at unlimited scale — the only limit is your curiosity.
Collaboration & iteration
Share, iterate, and collaborate on workbooks to drive initiatives and keep teams on the same page.
Security & governance
Give your IT team peace of mind with a full suite of security and governance provisions.
“We now make decisions based on data we see in Sigma. We can finally tie together the complete buyer journey from the first impression with our brand to the time they buy and then even through customer lifecycle marketing.”