Sigma for Marketing Analytics

Maximize every marketing dollar spent with a complete view of your campaign data.

Get the most from your marketing budget — explore our campaign spend attribution interactive demo below

Use case study

Campaign spend attribution

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

Sigma is a team sport.

Invite your TEAM

Marketing analytics in Sigma means more
ROI,customer insights,collaboration

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.”