Campaign Conversion Analytics
This dataset provides detailed analytics on digital marketing campaigns, capturing key performance indicators such as impressions, clicks, conversions, costs, and ROI. It enables marketing teams to evaluate campaign effectiveness, optimize spending, and make data-driven decisions to improve future campaign outcomes. The dataset is ideal for campaign performance analysis, ROI tracking, and marketing strategy optimization.
Sample rows
preview · 8 of 90 rows · all 18 columns| campaign_idstring | campaign_typestring | roifloat | channelstring | campaign_namestring | start_datedate | end_datedate | budgetfloat | impressionsinteger | clicksinteger | conversionsinteger | conversion_ratefloat | cost_per_clickfloat | cost_per_conversionfloat | revenuefloat | target_audiencestring | created_atdatetime | updated_atdatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CMPN1001 | 171.43 | Email Newsletter | Spring Sale 2023 | 2023-03-01 | 2023-03-20 | 3500 | 56000 | 4200 | 710 | 16.9 | 0.83 | 4.93 | 9500 | Existing Customers, US | 2023-02-25T10:45:23 | 2023-03-21T09:11:02 | |
| CMPN1002 | social | 112.5 | Back to School Push | 2023-07-15 | 2023-08-15 | 12000 | 185000 | 9800 | 1350 | 13.78 | 1.22 | 8.89 | 25500 | Parents, K-12, CA | 2023-07-10T14:12:12 | 2023-08-18T11:44:59 | |
| CMPN1003 | search | 125 | Google Ads | Product Launch Alpha | 2023-01-10 | 2023-02-05 | 8000 | 145000 | 3500 | 480 | 13.71 | 2.29 | 16.67 | 18000 | Tech Early Adopters | 2023-01-09T09:00:00 | 2023-02-06T16:10:11 |
| CMPN1004 | display | 146.67 | Display Network | Holiday Deals 2022 | 2022-11-25 | 2022-12-26 | 15000 | 350000 | 15700 | 2150 | 13.69 | 0.96 | 6.98 | 37000 | All Visitors, Global | 2022-11-23T13:15:32 | 2022-12-28T15:24:21 |
| CMPN1005 | affiliate | 140 | Influencer Collaboration Q1 | 2023-02-05 | 2023-03-05 | 5000 | 112000 | 4700 | 800 | 17.02 | 1.06 | 6.25 | 12000 | Gen Z, Europe | 2023-02-01T17:30:00 | 2023-03-06T11:05:44 | |
| CMPN1006 | 188.89 | Email Blast | Flash Sale Weekend | 2023-11-10 | 2023-11-12 | 1800 | 33500 | 2100 | 290 | 13.81 | 0.86 | 6.21 | 5200 | All Subscribers | 2023-11-09T08:17:45 | 2023-11-13T10:35:12 | |
| CMPN1007 | video | 5.26 | YouTube | Brand Awareness Drive | 2023-04-01 | 2023-04-30 | 9500 | 390000 | 8700 | 600 | 6.9 | 1.09 | 15.83 | 10000 | 18-35, Global | 2023-03-28T10:10:10 | 2023-05-01T10:10:10 |
| CMPN1008 | search | 85.71 | Apple Search Ads | Mobile App Install Drive | 2023-06-01 | 2023-06-30 | 4200 | 70000 | 3700 | 1300 | 35.14 | 1.14 | 3.23 | 7800 | iOS Users, US | 2023-05-29T13:47:18 | 2023-07-01T11:22:10 |
| CMPN1009 | display | 125.58 | Google Display Network | Retargeting Spring | 2023-03-10 | 2023-03-27 | 4300 | 88000 | 5400 | 670 | 12.41 | 0.8 | 6.42 | 9700 | Returning Website Users | 2023-03-09T08:00:00 | 2023-03-28T11:22:03 |
| CMPN1010 | social | 134.21 | Cyber Monday Boost | 2022-11-28 | 2022-12-02 | 3800 | 52000 | 3200 | 440 | 13.75 | 1.19 | 8.64 | 8900 | Tech Enthusiasts | 2022-11-26T10:22:33 | 2022-12-03T09:31:47 | |
| CMPN1011 | display | 102.94 | Programmatic Display | Winter Clearance Event | 2023-01-15 | 2023-01-31 | 6800 | 121000 | 6500 | 920 | 14.15 | 1.05 | 7.39 | 13800 | All Website Visitors | 2023-01-10T16:10:00 | 2023-02-01T12:30:30 |
| CMPN1012 | 144 | Email Campaign | New Arrivals Promo | 2023-09-05 | 2023-09-17 | 2500 | 41000 | 2200 | 330 | 15 | 1.14 | 7.58 | 6100 | Female Shoppers, UK | 2023-09-01T13:00:00 | 2023-09-18T09:09:09 | |
| CMPN1013 | affiliate | 100 | Coupon Partners | Early Bird Discount | 2023-02-20 | 2023-02-25 | 1200 | 21000 | 1200 | 230 | 19.17 | 1 | 5.22 | 2400 | Deal Seekers, NA | 2023-02-18T15:50:16 | 2023-02-26T10:15:00 |
| CMPN1014 | search | 275 | Google Search | Luxury Watch Launch | 2023-10-01 | 2023-10-25 | 20000 | 95000 | 1900 | 260 | 13.68 | 10.53 | 76.92 | 75000 | Affluent Men, Asia | 2023-09-28T08:00:00 | 2023-10-26T18:25:00 |
| CMPN1015 | social | 119.51 | TikTok | Gadget Giveaway | 2023-06-12 | 2023-06-30 | 4100 | 67000 | 4900 | 920 | 18.78 | 0.84 | 4.46 | 9000 | Gen Z, US | 2023-06-10T12:00:00 | 2023-07-01T09:12:12 |
| CMPN1016 | 93.75 | Email Blast | Easter Weekend Push | 2023-04-06 | 2023-04-10 | 1600 | 22000 | 900 | 150 | 16.67 | 1.78 | 10.67 | 3100 | Families, UK | 2023-04-03T08:15:00 | 2023-04-11T10:15:45 | |
| CMPN1017 | video | 98.63 | YouTube Shorts | Fitness Challenge | 2023-05-01 | 2023-05-31 | 7300 | 156000 | 6900 | 950 | 13.77 | 1.06 | 7.68 | 14500 | Fitness Enthusiasts | 2023-04-30T17:00:00 | 2023-06-01T12:30:00 |
| CMPN1018 | social | 127.78 | Festival Season Buzz | 2023-09-01 | 2023-09-14 | 5400 | 91000 | 4100 | 830 | 20.24 | 1.32 | 6.51 | 12300 | Millennials, India | 2023-08-28T09:15:15 | 2023-09-15T14:22:10 | |
| CMPN1019 | display | 109.52 | Google Display Network | Gift Card Promo | 2023-12-10 | 2023-12-24 | 2100 | 36000 | 2100 | 340 | 16.19 | 1 | 6.18 | 4400 | Holiday Shoppers, NA | 2023-12-07T13:35:50 | 2023-12-25T08:21:10 |
| CMPN1020 | search | 151.72 | Bing Search | End of Season Clearance | 2023-08-21 | 2023-09-03 | 2900 | 49000 | 1700 | 280 | 16.47 | 1.71 | 10.36 | 7300 | Budget Shoppers | 2023-08-18T11:00:00 | 2023-09-04T12:00:00 |
What the 90 rows show
from the 90-row sampleVideo (campaign type) stands out: mean roi is 71.7, against 105.2 for the rest.
- 99.3median roi
- 5,150median budget
- 85,500median impressions
- 2,700median clicks
- 311median conversions
- 8.0median conversion_
rate
Median 99.3, from 5.3 to 275.0.
- string 5
- integer 3
- float 6
- date 2
- datetime 2
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 5 columns | |||
campaign_id | string | Unique identifier for the marketing campaignunique | CMPN1001 |
campaign_name | string | Descriptive name of the campaign | Spring Sale 2023 |
campaign_type | string | Type of campaign (e.g., email, social, search, display)7 values | |
channel | string | Marketing channel used for the campaign (e.g., Facebook, Google Ads, Email Newsletter) | Email Newsletter |
target_audience | string | Description of the target audience for the campaignoptional | Existing Customers, US |
| Numbers 9 columns | |||
budget | float | Total budget allocated to the campaign (in USD)0 or more | 3500 |
impressions | integer | Number of times the campaign was displayed to users0 or more | 56000 |
clicks | integer | Number of times users clicked on the campaign0 or more | 4200 |
conversions | integer | Number of successful conversions attributed to the campaign0 or more | 710 |
conversion_rate | float | Percentage of clicks that resulted in a conversion (conversions/clicks * 100)0 to 100 | 16.9 |
cost_per_click | float | Average cost per click for the campaign (budget/clicks)0 or more | 0.83 |
cost_per_conversion | float | Average cost per conversion for the campaign (budget/conversions)0 or more | 4.93 |
revenue | float | Total revenue generated from the campaign (in USD)0 or more · optional | 9500 |
roi | float | Return on investment for the campaign ((revenue - budget)/budget * 100)optional | 171.43 |
| Dates and times 4 columns | |||
start_date | date | Date when the campaign started | 2023-03-01 |
end_date | date | Date when the campaign ended | 2023-03-20 |
created_at | datetime | Timestamp when the campaign record was created in the system | 2023-02-25T10:45:23 |
updated_at | datetime | Timestamp when the campaign record was last updated | 2023-03-21T09:11:02 |
Use it for
A marketing dashboard
Roi by campaign_
type and a breakdown of channel. Excel, Power BI or Tableau. Why do the 10 video rows have a mean roi of 71.7?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Campaigns90CMPN1001171.43emailCMPN1002112.5socialCMPN1003125search
A software demo
Believable campaigns with campaign_
name, campaign_ type and start_ date to fill a screen in front of a buyer.
This dataset90 rows18 columns
Yours10,000 rows18 columns
blueprint · campaign-conversion-analytics
Behind this dataset
Same schema. As many rows as you need.
These 90 rows came out of a blueprint — 18 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
- Each campaign must have a defined budget
- Campaigns with < 1% conversion flagged for review
- Conversion events must be timestamped
- Duplicate click records are removed
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- campaign-conversion-analytics