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.

  • opened 20 times
  • last updated 21 Jul 2025
  • by GoMask
The brief that made it

Optimizing digital ad campaigns for improved ROI

Sample rows

preview · 8 of 95 rows · all 20 columns
campaign_idstringcurrencystringspendfloatchannelstringcampaign_namestringad_group_idstringad_group_namestringstart_datedateend_datedateimpressionsintegerreachintegerclicksintegerconversionsintegercost_per_clickfloatcost_per_millefloatcost_per_conversionfloatroifloattarget_audiencestringcreated_atdatetimeupdated_atdatetime
CMP-10001USD3280.45FacebookSpring Sale 2024AG-20101FB-Millennial-Group2024-03-012024-03-3121045011530038903120.8415.5910.51124.318-34, US, interests: fashion2024-02-25T09:15:202024-03-31T22:17:10
CMP-10002USD5120.95GoogleTech Gadget LaunchAG-20102Google-Search-Tech2024-02-102024-03-1029800014500059004100.8717.1812.49117.725-44, CA, interests: electronics2024-02-09T14:10:122024-03-10T18:22:45
CMP-10003USD2602.12InstagramFitness Promo Q1AG-20103IG-Influencer2024-01-202024-02-201685009200027502380.9515.4410.93109.618-29, UK, interests: fitness2024-01-15T08:20:012024-02-20T19:03:19
CMP-10004USD1340.5EmailHoliday Email Blastblankblank2024-12-012024-12-3191000785001420970.9414.7313.82108.230-50, AU, interests: travel, holidays2024-11-25T11:10:142024-12-31T21:39:11
CMP-10005USD1822LinkedInB2B SaaS WebinarAG-20104LI-Prospects2024-04-052024-04-19128009600340445.36142.3441.4195.235-55, US, B2B SaaS decision-makers2024-03-29T10:40:002024-04-19T14:08:26
CMP-10006USD1988.45DisplayDisplay Network AwarenessAG-20105Display-Retargeting2024-05-102024-05-241555001120001800971.112.7920.5102.322-45, DE, interests: online shopping2024-05-02T13:11:432024-05-24T20:06:34
CMP-10007USD1135.75YouTubeYouTube Product DemoAG-20106YT-Video-Ad2024-06-012024-06-3087500613001525920.7512.9812.34112.818-34, US, interests: gadgets2024-05-25T10:19:262024-06-30T16:43:00
CMP-10008USD980TwitterTwitter Brand AwarenessAG-20107TW-Awareness2024-04-152024-05-154900036000880501.112019.690.120-40, UK, interests: finance, startups2024-04-10T16:44:122024-05-15T13:18:31

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
currency95 rows by value
0459082USD86%5EUR5%3GBP3%2SGD2%1CHF1%1INR1%1CAD1%
spend95 rows, in bands of 1,000
0204038387432110105,00010kspend →

Median 1,150, from 92.0 to 9,201.

channel95 rows · 9 values
  1. Facebook15
  2. Google13
  3. Display13
  4. Instagram12
  5. LinkedIn11
  6. YouTube11
  7. Email10
  8. Twitter8
  9. Other2
20 columns by typefrom the column list below
  • string 7
  • integer 4
  • float 5
  • date 2
  • datetime 2

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 7 columns
campaign_idstringUnique identifier for the advertising campaignuniqueCMP-10001
campaign_namestringDescriptive name of the advertising campaignSpring Sale 2024
channelstringMarketing channel where the campaign is run (e.g., Facebook, Google, Instagram, Email, Display)9 valuesFacebook
ad_group_idstringIdentifier for the ad group within the campaign (if applicable)optionalAG-20101
ad_group_namestringName of the ad group within the campaign (if applicable)optionalFB-Millennial-Group
currencystringCurrency code for spend and cost fields (e.g., USD, EUR)7 currenciesUSD
target_audiencestringBrief description of the campaign's target audience (e.g., '18-24, US, interests: sports')optional30-60, US, HR managers
Numbers 9 columns
impressionsintegerTotal number of times the ad was displayed0 or more210450
reachintegerNumber of unique users who saw the ad0 or more115300
clicksintegerNumber of times the ad was clicked0 or more3890
conversionsintegerNumber of desired actions (e.g., purchases, sign-ups) resulting from the ad0 or more · optional312
spendfloatTotal amount spent on the campaign or ad group (in USD)0 or more3280.45
cost_per_clickfloatAverage cost per click (CPC) for the campaign or ad group0 or more · optional0.84
cost_per_millefloatAverage cost per thousand impressions (CPM) for the campaign or ad group0 or more · optional15.59
cost_per_conversionfloatAverage cost per conversion for the campaign or ad group0 or more · optional10.51
roifloatReturn on investment for the campaign or ad group (expressed as a percentage, e.g., 120.5 for 120.5%)optional124.3
Dates and times 4 columns
start_datedateDate when the campaign or ad group started2024-03-01
end_datedateDate when the campaign or ad group endedoptional2024-03-31
created_atdatetimeTimestamp when the campaign record was created in the system2024-02-25T09:15:20
updated_atdatetimeTimestamp when the campaign record was last updatedoptional2024-03-31T22:17:10

Use it for

  • median spend1,15095 rowsmean spend by currency1.6kUSD730.0EUR2.8kGBP1.9kSGD

    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.

  • A software demo

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

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset95 rows20 columns
Yours10,000 rows20 columns

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.

Rules it was built with
  • 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
Rows
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
digital-ad-campaign-reach-metrics

What should your data show?

Preview 20 rows free
No signup. No card.