Digital Ad Campaign Reach Metrics
This dataset provides detailed, channel-segmented metrics for digital advertising campaigns, including reach, impressions, clicks, conversions, and spend. It enables marketers and analysts to optimize campaigns, track ROI, and gain granular insights into performance across multiple platforms and target audiences. The dataset is ideal for campaign optimization, cross-channel analysis, and marketing ROI reporting.
Sample rows
preview · 8 of 95 rows · all 20 columns| campaign_idstring | currencystring | spendfloat | channelstring | campaign_namestring | ad_group_idstring | ad_group_namestring | start_datedate | end_datedate | impressionsinteger | reachinteger | clicksinteger | conversionsinteger | cost_per_clickfloat | cost_per_millefloat | cost_per_conversionfloat | roifloat | target_audiencestring | created_atdatetime | updated_atdatetime |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CMP-10001 | USD | 3280.45 | Spring Sale 2024 | AG-20101 | FB-Millennial-Group | 2024-03-01 | 2024-03-31 | 210450 | 115300 | 3890 | 312 | 0.84 | 15.59 | 10.51 | 124.3 | 18-34, US, interests: fashion | 2024-02-25T09:15:20 | 2024-03-31T22:17:10 | |
| CMP-10002 | USD | 5120.95 | Tech Gadget Launch | AG-20102 | Google-Search-Tech | 2024-02-10 | 2024-03-10 | 298000 | 145000 | 5900 | 410 | 0.87 | 17.18 | 12.49 | 117.7 | 25-44, CA, interests: electronics | 2024-02-09T14:10:12 | 2024-03-10T18:22:45 | |
| CMP-10003 | USD | 2602.12 | Fitness Promo Q1 | AG-20103 | IG-Influencer | 2024-01-20 | 2024-02-20 | 168500 | 92000 | 2750 | 238 | 0.95 | 15.44 | 10.93 | 109.6 | 18-29, UK, interests: fitness | 2024-01-15T08:20:01 | 2024-02-20T19:03:19 | |
| CMP-10004 | USD | 1340.5 | Holiday Email Blast | blank | blank | 2024-12-01 | 2024-12-31 | 91000 | 78500 | 1420 | 97 | 0.94 | 14.73 | 13.82 | 108.2 | 30-50, AU, interests: travel, holidays | 2024-11-25T11:10:14 | 2024-12-31T21:39:11 | |
| CMP-10005 | USD | 1822 | B2B SaaS Webinar | AG-20104 | LI-Prospects | 2024-04-05 | 2024-04-19 | 12800 | 9600 | 340 | 44 | 5.36 | 142.34 | 41.41 | 95.2 | 35-55, US, B2B SaaS decision-makers | 2024-03-29T10:40:00 | 2024-04-19T14:08:26 | |
| CMP-10006 | USD | 1988.45 | Display | Display Network Awareness | AG-20105 | Display-Retargeting | 2024-05-10 | 2024-05-24 | 155500 | 112000 | 1800 | 97 | 1.1 | 12.79 | 20.5 | 102.3 | 22-45, DE, interests: online shopping | 2024-05-02T13:11:43 | 2024-05-24T20:06:34 |
| CMP-10007 | USD | 1135.75 | YouTube | YouTube Product Demo | AG-20106 | YT-Video-Ad | 2024-06-01 | 2024-06-30 | 87500 | 61300 | 1525 | 92 | 0.75 | 12.98 | 12.34 | 112.8 | 18-34, US, interests: gadgets | 2024-05-25T10:19:26 | 2024-06-30T16:43:00 |
| CMP-10008 | USD | 980 | Twitter Brand Awareness | AG-20107 | TW-Awareness | 2024-04-15 | 2024-05-15 | 49000 | 36000 | 880 | 50 | 1.11 | 20 | 19.6 | 90.1 | 20-40, UK, interests: finance, startups | 2024-04-10T16:44:12 | 2024-05-15T13:18:31 | |
| CMP-10009 | USD | 1690.7 | Instagram Stories GenZ | AG-20108 | IG-GenZ-Stories | 2024-02-12 | 2024-03-12 | 136000 | 61000 | 2200 | 182 | 0.77 | 12.44 | 9.29 | 130.4 | 16-25, US, interests: music, fashion | 2024-02-11T11:08:16 | 2024-03-12T23:02:17 | |
| CMP-10010 | USD | 3872.5 | Google Shopping Summer | AG-20109 | Google-Shopping | 2024-06-05 | 2024-07-05 | 215000 | 107000 | 4375 | 291 | 0.89 | 18.02 | 13.3 | 116.4 | 21-40, CA, interests: shopping, deals | 2024-05-29T12:03:10 | 2024-07-05T10:20:34 | |
| CMP-10011 | USD | 1344.8 | LinkedIn Enterprise | AG-20110 | LI-Enterprise | 2024-08-15 | 2024-08-29 | 10200 | 7500 | 220 | 37 | 6.11 | 131.84 | 36.35 | 91.3 | 40-60, US, enterprise buyers | 2024-08-10T13:12:09 | 2024-08-29T15:45:21 | |
| CMP-10012 | USD | 1334.4 | Display | Display Banner Summer | AG-20111 | Display-Summer-Banner | 2024-06-10 | 2024-06-30 | 101300 | 74000 | 1420 | 88 | 0.94 | 13.17 | 15.17 | 107.5 | 25-44, US, interests: summer, travel | 2024-06-01T07:21:08 | 2024-06-30T21:44:12 |
| CMP-10013 | USD | 1577.5 | Facebook Back to School | AG-20112 | FB-Parents | 2024-08-01 | 2024-08-21 | 140500 | 85000 | 2100 | 150 | 0.75 | 11.24 | 10.52 | 120.9 | 28-44, US, parents, students | 2024-07-25T18:08:21 | 2024-08-21T20:15:47 | |
| CMP-10014 | USD | 789 | YouTube | YouTube Shorts Teens | AG-20113 | YT-Shorts-Teens | 2024-07-12 | 2024-07-27 | 61200 | 43000 | 1050 | 84 | 0.75 | 12.89 | 9.39 | 126.5 | 13-19, US, interests: music, video | 2024-07-08T19:52:18 | 2024-07-27T17:20:10 |
| CMP-10015 | USD | 480.2 | Twitter Summer Deals | AG-20114 | TW-Deals | 2024-06-20 | 2024-07-04 | 32700 | 24000 | 670 | 34 | 0.72 | 14.69 | 14.12 | 98.1 | 21-35, CA, interests: shopping | 2024-06-12T11:22:41 | 2024-07-04T09:09:15 | |
| CMP-10016 | USD | 2250 | Google App Install | AG-20115 | Google-AppInstall | 2024-03-05 | 2024-03-25 | 94000 | 52200 | 2600 | 330 | 0.87 | 23.94 | 6.82 | 145.6 | 18-29, IN, interests: apps, gaming | 2024-02-28T14:10:10 | 2024-03-25T12:00:00 | |
| CMP-10017 | USD | 1836 | Email Product Launch | blank | blank | 2024-05-01 | 2024-05-15 | 67200 | 62000 | 1830 | 119 | 1 | 27.32 | 15.42 | 104.4 | 35-60, AU, interests: tech, gadgets | 2024-04-28T07:15:00 | 2024-05-15T08:23:45 | |
| CMP-10018 | USD | 1050 | Display | Display Retargeting | AG-20116 | Display-Retarget-2 | 2024-01-15 | 2024-02-10 | 80000 | 54000 | 1300 | 88 | 0.81 | 13.13 | 11.93 | 109.5 | 25-45, UK, interests: ecommerce | 2024-01-10T15:12:09 | 2024-02-10T19:14:19 |
| CMP-10019 | USD | 1980 | LinkedIn HR Solutions | AG-20117 | LI-HR | 2024-10-01 | 2024-10-15 | 16500 | 13400 | 380 | 54 | 5.21 | 120 | 36.67 | 91.8 | 30-60, US, HR managers | 2024-09-20T09:32:01 | 2024-10-15T10:24:00 | |
| CMP-10020 | USD | 306.9 | Twitter Brand Boost | AG-20118 | TW-Brand | 2024-05-20 | 2024-06-05 | 28900 | 21500 | 570 | 27 | 0.54 | 10.62 | 11.37 | 110.4 | 22-38, US, interests: tech, finance | 2024-05-15T14:10:09 | 2024-06-05T11:00:00 |
What the 95 rows show
from the 95-row sample- 1,150median spend
- 76,000median impressions
- 52,200median reach
- 1,800median clicks
- 103median conversions
- 0.71median cost_
per_ click
Median 1,150, from 92.0 to 9,201.
- string 7
- integer 4
- float 5
- date 2
- datetime 2
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 7 columns | |||
campaign_id | string | Unique identifier for the advertising campaignunique | CMP-10001 |
campaign_name | string | Descriptive name of the advertising campaign | Spring Sale 2024 |
channel | string | Marketing channel where the campaign is run (e.g., Facebook, Google, Instagram, Email, Display)9 values | |
ad_group_id | string | Identifier for the ad group within the campaign (if applicable)optional | AG-20101 |
ad_group_name | string | Name of the ad group within the campaign (if applicable)optional | FB-Millennial-Group |
currency | string | Currency code for spend and cost fields (e.g., USD, EUR)7 currencies | USD |
target_audience | string | Brief description of the campaign's target audience (e.g., '18-24, US, interests: sports')optional | 30-60, US, HR managers |
| Numbers 9 columns | |||
impressions | integer | Total number of times the ad was displayed0 or more | 210450 |
reach | integer | Number of unique users who saw the ad0 or more | 115300 |
clicks | integer | Number of times the ad was clicked0 or more | 3890 |
conversions | integer | Number of desired actions (e.g., purchases, sign-ups) resulting from the ad0 or more · optional | 312 |
spend | float | Total amount spent on the campaign or ad group (in USD)0 or more | 3280.45 |
cost_per_click | float | Average cost per click (CPC) for the campaign or ad group0 or more · optional | 0.84 |
cost_per_mille | float | Average cost per thousand impressions (CPM) for the campaign or ad group0 or more · optional | 15.59 |
cost_per_conversion | float | Average cost per conversion for the campaign or ad group0 or more · optional | 10.51 |
roi | float | Return on investment for the campaign or ad group (expressed as a percentage, e.g., 120.5 for 120.5%)optional | 124.3 |
| Dates and times 4 columns | |||
start_date | date | Date when the campaign or ad group started | 2024-03-01 |
end_date | date | Date when the campaign or ad group endedoptional | 2024-03-31 |
created_at | datetime | Timestamp when the campaign record was created in the system | 2024-02-25T09:15:20 |
updated_at | datetime | Timestamp when the campaign record was last updatedoptional | 2024-03-31T22:17:10 |
Use it for
A marketing dashboard
Spend by currency and a breakdown of channel. Excel, Power BI or Tableau.
What pattern can you find in 95 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 95 rows.
- Campaigns95CMP-100013280.45USDCMP-100025120.95USDCMP-100032602.12USD
A software demo
Believable campaigns with campaign_
name, channel and ad_ group_ id to fill a screen in front of a buyer.
blueprint · digital-ad-campaign-reach-metrics
Behind this dataset
Same schema. As many rows as you need.
These 95 rows came out of a blueprint — 20 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.
- Each campaign has a unique identifier
- Aggregate impressions and clicks per day
- Calculate click-through rate per channel
- Flag campaigns underperforming vs target benchmarks
- Campaigns must have active start/end dates
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
- digital-ad-campaign-reach-metrics