Campaign Channel Conversion Breakdown

This dataset provides a daily breakdown of conversion metrics for active marketing campaigns across multiple channels, including impressions, clicks, conversions, costs, revenue, and ROI. It enables detailed channel performance analysis, supports resource allocation decisions, and facilitates cross-campaign and cross-channel comparisons for data-driven marketing optimization.

  • opened 13 times
  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Comparing channel effectiveness for ongoing campaigns

Sample rows

preview · 8 of 93 rows · all 12 columns
campaign_idstringchannelstringroifloatcampaign_namestringdatedateimpressionsintegerclicksintegerconversionsintegerconversion_ratefloatcostfloatrevenuefloatcurrencystring
CMP-1001Email6.5Spring Sale 20242024-03-015500480600.125120900USD
CMP-1002Social Media3.84Social Buzz Launch2024-03-018000720900.1253101500USD
CMP-1003Display Ads1.35Brand Awareness Q12024-03-0113000420180.04285714285714286170400USD
CMP-1004Affiliate3.12Affiliate Growth 20242024-03-014300210260.1238095238095238185350USD
CMP-1005DirectblankDirect Entry Promo2024-03-0117006090.15090USD
CMP-1001Paid Search4.24Spring Sale 20242024-03-016000490440.089795918367346952101100USD
CMP-1002Organic SearchblankSocial Buzz Launch2024-03-013000160240.150320USD
CMP-1003Other0.54Brand Awareness Q12024-03-0125006070.1166666666666666765100USD

What the 93 rows show

from the 93-row sample

Email channel stands out: mean roi is 3.4, against 1.5 for the rest.

  • 1.6median roi
  • 6,200median impressions
  • 390median clicks
  • 34median conversions
  • 0.10median conversion_rate
  • 120.0median cost
Mean roi by channel70 rows
0243.4Email12 rows1.7Socia…13 rows2.0Paid …14 rows1.1Displ…13 rows1.5Affil…12 rows0.90Other6 rows
roi70 rows, in bands of 1
02040133788301047roi →

Median 1.6, from 0.54 to 6.5.

campaign_id93 rows · top 10 of 32 values
  1. CMP2024044
  2. CMP2024124
  3. CMP2024194
  4. CMP2024054
  5. CMP2024104
  6. CMP2024134
  7. CMP2024144
  8. CMP2024064
  9. CMP2024074
  10. CMP2024084
12 columns by typefrom the column list below
  • string 4
  • integer 3
  • float 4
  • date 1

Columns

12 columns in three groups
blueprint · 12 columns
columntypedescriptionexample
Text 4 columns
campaign_idstringUnique identifier for the marketing campaign.CMP-1001
campaign_namestringDescriptive name of the marketing campaign.Spring Sale 2024
channelstringMarketing channel through which the campaign is run (e.g., Email, Social Media, Paid Search, Organic Search, Display Ads, Affiliate, Direct).8 valuesEmail
currencystringCurrency code (ISO 4217) for cost and revenue fields.USD
Numbers 7 columns
impressionsintegerNumber of times the campaign was displayed in the specified channel on the given date.0 or more5500
clicksintegerNumber of times users clicked on the campaign in the specified channel on the given date.0 or more480
conversionsintegerNumber of successful conversion actions (e.g., purchases, sign-ups) attributed to the campaign and channel on the given date.0 or more60
conversion_ratefloatConversion rate for the campaign and channel on the given date (conversions divided by clicks).0 to 10.125
costfloatTotal cost incurred for the campaign in the specified channel on the given date (in campaign currency).0 or more120
revenuefloatTotal revenue generated from conversions attributed to the campaign and channel on the given date.0 or more · optional900
roifloatReturn on investment for the campaign and channel on the given date ((revenue - cost) / cost).optional6.5
Dates and times 1 column
datedateDate for which the conversion metrics are recorded.2024-03-01

Use it for

  • median roi1.670 rowsmean roi by channel3.4Email1.7Soci…2.0Paid…1.1Disp…

    A marketing dashboard

    Roi by channel and a breakdown of campaign_id. Excel, Power BI or Tableau.

  • Why do the 12 Email rows have a mean roi of 3.4?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable campaigns with campaign_name, channel and date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 12 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset93 rows12 columns
Yours1,000 rows12 columns

blueprint · campaign-channel-conversion-breakdown

Behind this dataset

Same schema. As many rows as you need.

These 93 rows came out of a blueprint — 12 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • At least 3 channels per campaign required
  • Conversions must be traceable to source channel
  • Include clicks, impressions, and conversions
  • Calculate conversion rate per channel
  • Channels with zero conversions flagged
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
campaign-channel-conversion-breakdown

More in Marketing

Browse all
Also in MarketingOnline Ad Performance MetricsMarketing Influencer Campaign ROI DataSocial Media Influencer Impact DatasetAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.