Ad Spend to Revenue Analysis

This dataset provides a detailed, campaign-level view of advertising expenditures and the corresponding revenue generated, segmented by channel, period, and region. It enables robust analysis of marketing ROI, budget allocation, and campaign performance, supporting data-driven optimization of advertising strategies across multiple channels and markets.

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

Analyzing marketing ROI and optimizing advertising budgets

Sample rows

preview · 8 of 50 rows · all 17 columns
ad_spend_idstringregionstringimpressionsintegerproduct_categorystringcampaign_idstringcampaign_namestringchannelstringad_groupstringstart_datedateend_datedatead_spend_amountfloatcurrencystringrevenue_generatedfloatclicksintegerconversionsintegerconversion_typestringnotesstring
AS1001US1500000ElectronicsCAMP001Spring Sale 2024Google AdsGroup A2024-03-012024-03-3112500.5USD32000250001200purchaseMajor boost due to limited-time offers
AS1002US950000StationeryCAMP002Back to SchoolFacebookFB_Set_12024-07-152024-08-155600.75USD17800.314500700purchaseblank
AS1003EMEA510000ApparelCAMP003Winter ClearanceInstagramIG_Main2024-01-102024-01-314200EUR98008600320signupStrong conversion for new signups
AS1004US430000FitnessCAMP004Summer Fitness PromoLinkedInLN-12024-05-012024-05-318200USD205009600330leadblank
AS1005EMEA2500000WatchesCAMP005Luxury Watches LaunchTVblank2024-02-052024-02-1830000GBP900000120purchaseBrand awareness focus
AS1006US320000ToysCAMP006Holiday SpecialsRadioblank2023-12-012023-12-254500USD12000080purchaseblank
AS1007US12000SubscriptionCAMP007Email Re-Engagement Q2EmailSegment B2024-04-102024-04-30800USD25001100120leadblank
AS1008EMEA380000ApparelCAMP008Spring Dress CollectionInstagramIG-Spring2024-03-152024-04-053500EUR78005400180purchaseblank

What the 50 rows show

from the 50-row sample

EMEA region stands out: mean impressions is 1,142,308, against 313,554 for the rest.

  • 330,000median impressions
  • 4currencies
  • 4conversion types
  • 9channels
  • 4,100median ad_spend_amount
  • 10,650median revenue_generated
Mean impressions by region50 rows
01M2M272.4kUS30 rows1.1MEMEA13 rows490kAPAC7 rows
impressions50 rows, in bands of 250k
0102020163311202201.3M2.5Mimpressions →

Median 330,000, from 4,000 to 2,500,000.

product_category50 rows · top 10 of 23 values
  1. Electronics8
  2. Subscription4
  3. Software4
  4. Home Appliances4
  5. Apparel3
  6. Miscellaneous3
  7. Lifestyle3
  8. Toys2
  9. Gifts2
  10. Automotive2
17 columns by typefrom the column list below
  • string 10
  • integer 3
  • float 2
  • date 2

Columns

17 columns in three groups
blueprint · 17 columns
columntypedescriptionexample
Text 10 columns
ad_spend_idstringUnique identifier for each ad spend and revenue recorduniqueAS1001
campaign_idstringIdentifier for the marketing campaign associated with the spendCAMP001
campaign_namestringName of the marketing campaignoptionalSpring Sale 2024
channelstringMarketing channel used (e.g., Google Ads, Facebook, Email, TV)9 valuesGoogle Ads
ad_groupstringAd group or ad set within the campaign, if applicableoptionalGroup A
currencystringCurrency code for spend and revenue values (ISO 4217 format, e.g., USD, EUR)4 currenciesUSD
conversion_typestringType of conversion tracked (e.g., purchase, signup, lead)purchase · signup · lead · other · optionalpurchase
regionstringGeographic region or market for the campaign (e.g., US, EMEA, APAC)3 regions · optionalUS
product_categorystringProduct category promoted by the campaignoptionalElectronics
notesstringAdditional notes or comments about the campaign or dataoptionalBrand awareness focus
Numbers 5 columns
ad_spend_amountfloatTotal advertising spend for the period (in base currency)0 or more12500.5
revenue_generatedfloatTotal revenue attributed to the campaign/channel for the period0 or more32000
impressionsintegerNumber of times the ad was shown during the period0 or more · optional1500000
clicksintegerNumber of clicks on the ad during the period0 or more · optional25000
conversionsintegerNumber of conversions (e.g., purchases, sign-ups) attributed to the campaign/channel0 or more · optional1200
Dates and times 2 columns
start_datedateStart date of the spend/revenue measurement period2024-03-01
end_datedateEnd date of the spend/revenue measurement period2024-03-31

Use it for

  • median impress…330,00050 rowsmean impressions by r…272.4kUS1.1MEMEA490kAPAC

    A marketing dashboard

    Impressions by region and a breakdown of product_category. Excel, Power BI or Tableau.

  • Why do the 13 EMEA rows have a mean impressions of 1,142,308?

    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 ad spends with campaign_id, campaign_name and channel to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 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 dataset50 rows17 columns
Yours1,000 rows17 columnsregion: UK only

blueprint · ad-spend-to-revenue-analysis

Behind this dataset

Same schema. As many rows as you need.

These 50 rows came out of a blueprint — 17 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
  • Pair spend and revenue by campaign
  • Calculate ROI per campaign
  • Exclude campaigns under $100 spend
  • Flag campaigns with negative ROI
  • Summarize monthly performance
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
ad-spend-to-revenue-analysis

More in Marketing

Browse all
Also in MarketingCampaign Conversion AnalyticsOnline Ad Performance MetricsMarketing Campaign Dataset for AnalysisAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.