• Marketing
  • 4 tables
  • 30,527 rows
  • 7 formats
  • synthetic data

Marketing Campaign Dataset for Analysis

Analyze marketing campaign performance with this ready-made dataset. It contains 30,527 rows of synthetic data spanning from 2023-01-01 to 2024-12-31. A free sample is available, with full downloads costing credits.

  • last updated 19 Oct 2026
  • version 2
  • by GoMask
  • Dataset includes 4 tables: campaigns, audiences, ads, and performance_metrics.
  • Contains 30,527 rows and 24 columns of synthetic marketing data.
  • Covers a date range from 2023-01-01 to 2024-12-31.
  • Data is available in CSV, Excel, SQL, and Parquet formats.
  • Free sample available for preview.

At a glance

  • 4tables
  • 30,527rows
  • 24columns
  • Jan 2023 – Dec 2024date range

The 4 tables

preview and data dictionary per table

Campaigns campaigns · table · 1,750 rows

Details about each marketing campaign.

Preview

First 10 of 1,750 rows of the Campaigns table
campaign_iduuidcampaign_namestringstart_datedateend_datedatebudgetdecimalobjectivestring
880796fc-c89e-4693-9ce6-23166401389aQ3 2024 SaaS Lead Gen Drive2024-06-152024-08-1342091.76Lead Generation
66a73ebb-5e5b-46a7-bab5-9f996aa4fee8Q3 2023 Enterprise Software Signups2023-07-102023-08-0918243.33Lead Generation
4da21ca9-980d-46cf-8492-d25c1b8f8fc3Q3 2024 B2B Solutions Acquisition2024-06-272024-10-2534281.39Lead Generation
9659d325-40d0-4b8d-957f-3a45b5438245Q4 2023 Cloud Services Prospecting2023-09-172023-10-2140137.93Lead Generation
53d9a1fc-5cee-4e70-a86e-4acda530824fQ2 2024 Fintech Lead Generation Push2024-03-112024-04-2085834.45Lead Generation
3b957f0d-bbe4-43a5-994c-29b3deda5830Q4 2024 Brand Spotlight2024-11-172024-12-2721038.76Brand Awareness
803dd1b0-eb5a-4282-b4eb-5f896630ba6eQ4 2023 Holiday Brand Boost2023-12-112024-04-0691139.96Brand Awareness
38a78b23-5323-48ba-bc5b-13776f0158efQ4 2023 Year-End Brand Visibility2023-11-292024-03-1629233.29Brand Awareness
bcea8452-e6e9-4ea8-b478-a4e43ec15aebQ4 2023 Autumn Brand Engagement2023-10-212023-11-3024922.58Brand Awareness
ad64ed95-44c9-4c25-87cd-b66cf0b95f56Q2 2024 Spring Brand Awareness Drive2024-05-182024-06-1513085.48Brand Awareness
10 of 1,750 rows · 6 columns

Data dictionary

Data dictionary for the Campaigns table
columntypedescriptionexamplenull %
campaign_iduuidUnique identifier for the marketing campaign.unique880796fc-c89e-4693-9ce6-23166401389a0%
campaign_namestringDescriptive marketing campaign name indicating theme and target quarter.Q3 2024 SaaS Lead Gen Drive0%
start_datedateStart date of the campaign flight.2024-06-150%
end_datedateScheduled end date of the campaign flight.2024-08-130%
budgetdecimalAllocated total monetary budget for the campaign in USD.unique42091.760%
objectivestringPrimary marketing goal of the campaign.Lead Generation0%

Audiences audiences · dimension table · 50 rows

Information on targeted audience segments.

Preview

First 10 of 50 rows of the Audiences table
audience_iduuidaudience_namestringaudience_segmentstringdemographicsstringinterestsstring
8cbade64-b07d-430b-b52e-39b966669622Eco-Conscious Women 25-44LookalikeAge 25-44, Women, Household Income $75k+Sustainable Living, Organic Goods & Eco-friendly Products
de1b9df1-8837-414b-a6a5-d453f67fbdf8Sustainable Parents 35-54LookalikeAge 35-54, All Genders, Mid-Career & ParentsSustainable Living, Organic Goods & Eco-friendly Products
7488bffd-f1f0-4d95-9d70-096a81153b16Tech Professionals Male 25-44LookalikeAge 25-44, Men, Tech Industry WorkersTechnology & Gadgets, Consumer Electronics
693c7439-76ad-437f-86ac-3dda3f96aef1Gadget Enthusiast Women 25-44LookalikeAge 25-44, Women, Household Income $75k+Technology & Gadgets, Consumer Electronics
8322c67c-9ddc-4ce2-b0e0-619889b1d6a1Male Tech Enthusiasts 25-44LookalikeAge 25-44, Men, Tech Industry WorkersTechnology & Gadgets, Consumer Electronics
5bd470b6-ca60-401b-9138-23bf89631b70Mid-Career Tech Buyers 35-54LookalikeAge 35-54, All Genders, Mid-Career & ParentsTechnology & Gadgets, Consumer Electronics
3f52c3d2-2290-47df-b025-9382aed84a84Active Young Professionals 25-34LookalikeAge 25-34, All Genders, Young ProfessionalsOutdoor Recreation, Fitness & Wellness
c9de7806-78b0-495c-8556-e12ea87461f3Male Tech Aficionados 25-44LookalikeAge 25-44, Men, Tech Industry WorkersTechnology & Gadgets, Consumer Electronics
6e7ec725-7501-4e03-92bd-69453b8793faActive Mid-Career Adults 35-54LookalikeAge 35-54, All Genders, Mid-Career & ParentsOutdoor Recreation, Fitness & Wellness
beef7602-5f5c-4278-b59d-79e87cc4ce28Eco-Minded Young Professionals 25-34LookalikeAge 25-34, All Genders, Young ProfessionalsSustainable Living, Organic Goods & Eco-friendly Products
10 of 50 rows · 5 columns

Data dictionary

Data dictionary for the Audiences table
columntypedescriptionexamplenull %
audience_iduuidUnique identifier for the audience segment.unique8cbade64-b07d-430b-b52e-39b9666696220%
audience_namestringDescriptive marketing name for the targeted cohort.uniqueEco-Conscious Women 25-440%
audience_segmentstringHigh-level segmentation classification.Lookalike0%
demographicsstringDemographic breakdown defining age, gender, education, or household income tier.Age 25-44, Women, Household Income $75k+0%
interestsstringPrimary interest tags and affinity categories assigned to the audience.Sustainable Living, Organic Goods & Eco-friendly Products0%

Ads ads · dimension table · 9,541 rows

Details of individual ad creatives and their targeting.

Preview

First 5 of 9,541 rows of the Ads table
ad_iduuidad_creativestringad_formatstringtargeting_criteriastringcampaign_iduuid
32359028-4268-4267-81de-e6a9281f4382Enterprise Software: Drive Your Business GrowthVideoParenting & Family Household Decision Makers66a73ebb-5e5b-46a7-bab5-9f996aa4fee8
8e372b90-a860-462b-a979-6f633b3ae011Autumn Engagement: Discover Our Latest Brand StoriesVideoYoung Adults (18-34) Mobile Usersbcea8452-e6e9-4ea8-b478-a4e43ec15aeb
6e613666-6724-45c9-b1c0-8e46c568e376Year-End Visibility: Shine Bright with Our Brand SolutionsVideoHigh-Value Lookalike Audience (Top 1%)38a78b23-5323-48ba-bc5b-13776f0158ef
83109b79-d669-4123-94ab-ca5771b53f1fSaaS Solutions for Professionals: Video Lead GenVideoAffluent Professionals (25-54) High Income880796fc-c89e-4693-9ce6-23166401389a
d6d3a778-5b5f-43b4-9a70-c8e9709bc161Enterprise Software: Sign Up for SuccessVideoHigh-Value Lookalike Audience (Top 1%)66a73ebb-5e5b-46a7-bab5-9f996aa4fee8
5 of 9,541 rows · 5 columns

Data dictionary

Data dictionary for the Ads table
columntypedescriptionexamplenull %
ad_iduuidUnique identifier for the ad creative variant.57e83ac5-3ddc-401f-bcc3-dff6240714c70%
ad_creativestringDescriptive title and messaging angle of the ad creative.Discover Cutting-Edge Gadgets: Top Tech for Industry Professionals0%
ad_formatstringVisual format used by the ad creative variant.Video0%
targeting_criteriastringKey segmentation focus and behavioral/demographic parameters applied to the ad.High-Value Lookalike Audience (Top 1%)0%
campaign_iduuidForeign key to campaigns.campaign_id.071554df-0e3c-40d2-88b0-91673c1ab4600%

Performance metrics performance_metrics · fact table · 19,186 rows

Daily performance metrics for each ad and audience combination.

Preview

First 10 of 19,186 rows of the Performance metrics table
metric_iduuiddatedateimpressionsintegerclicksintegerconversionsintegerspenddecimalad_iduuidaudience_iduuid
62de4f88-892f-48a5-a849-ddbb6a9fcb492024-11-141048747047881.79f3fc05c9-dcce-4653-bc8c-f27dccd67dff72327ff5-f082-4415-8d2a-16cc572ffe46
9e54c28b-ca27-4ee4-a891-7d2fcd59c7582024-09-0823321381141290.7770e93850-d2df-4127-80ac-5df7d9e29fffaeaa9efe-d45b-4f12-b2c7-b878d66f2bea
2e77e38b-3dd2-4dc0-bb55-23ea8cb243d42023-01-02961626819850.332b3f4228-0bc1-443b-80a2-8d18222f7095aeaa9efe-d45b-4f12-b2c7-b878d66f2bea
3b12b06d-f85a-4044-9636-8b53bed65a332023-05-221305411115348.87ae3304b2-49c0-4028-bf29-d220a91e9fb38322c67c-9ddc-4ce2-b0e0-619889b1d6a1
7da199fb-9df2-4e91-875f-bb9b63f55dac2023-08-072174766181.69cb60fcd7-28b5-4b3d-aee9-f959976cd795ee1f3663-17db-4468-9cdc-8548010d9907
c6432db6-e8bb-40f4-acb0-54d84a9992082024-03-01227129238.02ed16029a-bc8e-4733-b50f-c9d6fe060773123b54d2-129d-4ce9-a25c-3124cad1faa2
5f5843da-1bb0-4262-abb5-1c2f62b7e4842023-12-2818792565322112.17aecba629-56ce-43ed-872d-0082a6aabf2143be80f4-ae86-4a09-81f8-44314b6d54de
1aff6661-2d19-4bc7-b47f-3866dbc294f72023-03-221765432639703.669fadcc75-3c09-49a2-8d4a-d50fc0166e3b029989f5-0b5f-4eaf-9fc0-286e7fcabca7
d83ccdad-38a1-420b-a83e-c55680f7a3cb2023-10-309933445302016.368be8327-f0a3-4209-98de-40199ea870094cc07a7f-57c0-40c1-9875-57944cc4abe7
3c5dccf2-9d3a-4d10-a444-b2735c2bfa0b2024-07-07809224622808.64c42d3067-d901-4d19-9a47-1b3c7019969efa0b8649-1285-4520-b095-e615100e528b
10 of 19,186 rows · 8 columns

Data dictionary

Data dictionary for the Performance metrics table
columntypedescriptionexamplenull %
metric_iduuidUnique identifier for this performance metric entry.62de4f88-892f-48a5-a849-ddbb6a9fcb490%
datedateObservation date for the ad performance record.2024-11-140%
impressionsintegerTotal number of ad views registered on the given date.104870%
clicksintegerNumber of direct user clicks on the ad creative.4700%
conversionsintegerTotal desired target actions achieved.470%
spenddecimalTotal advertising expenditure incurred for the recorded metrics.881.790%
ad_iduuidForeign key to ads.ad_id.f3fc05c9-dcce-4653-bc8c-f27dccd67dff0%
audience_iduuidForeign key to audiences.audience_id.72327ff5-f082-4415-8d2a-16cc572ffe460%

How the tables join

  • ads.campaign_id references campaigns.campaign_idmany to one: each Ads row points to one Campaigns row
  • performance_metrics.ad_id references ads.ad_idmany to one: each Performance metrics row points to one Ads row
  • performance_metrics.audience_id references audiences.audience_idmany to one: each Performance metrics row points to one Audiences row

Questions to answer with it

  1. Which marketing campaigns generated the highest ROI? Calculate ROI as (SUM(spend) / SUM(conversions)) for each campaign.

    Join campaigns, ads, and performance_metrics. Group by campaign and calculate ROI.

    tables: campaigns, ads, performance_metrics

  2. What is the click-through rate (CTR) for different ad formats? Calculate CTR as (SUM(clicks) / SUM(impressions)) * 100 for each ad_format.

    Join ads and performance_metrics. Group by ad_format and calculate CTR.

    tables: ads, performance_metrics

  3. How do different audience segments respond to various campaign objectives? Analyze average conversions and spend by audience_segment and objective.

    Join all three tables. Group by audience_segment and objective to find average conversions and spend.

    tables: campaigns, audiences, performance_metrics

  4. Create a dashboard showing campaign performance over time, including impressions, clicks, conversions, and spend. Use line charts for trends and bar charts for daily totals.

    Aggregate performance_metrics by date and campaign. Visualize trends and daily totals.

    tables: campaigns, performance_metrics

Starter SQL

run against this data before publishing

Table names match the SQLite file and the SQL script.

Top 20 Campaigns by Spend

sql
SELECT c.campaign_name, SUM(pm.spend) AS total_spend
FROM campaigns c
JOIN ads a ON c.campaign_id = a.campaign_id
JOIN performance_metrics pm ON a.ad_id = pm.ad_id
GROUP BY c.campaign_name
ORDER BY total_spend DESC
LIMIT 20;

Average Conversions per Ad Format

sql
SELECT a.ad_format, AVG(pm.conversions) AS average_conversions
FROM ads a
JOIN performance_metrics pm ON a.ad_id = pm.ad_id
GROUP BY a.ad_format
LIMIT 20;

Campaign Performance Trends Over Time

sql
SELECT
    pm.date,
    c.campaign_name,
    SUM(pm.impressions) AS total_impressions,
    SUM(pm.clicks) AS total_clicks,
    SUM(pm.conversions) AS total_conversions,
    SUM(pm.spend) AS total_spend
FROM performance_metrics pm
JOIN ads a ON pm.ad_id = a.ad_id
JOIN campaigns c ON a.campaign_id = c.campaign_id
WHERE pm.date BETWEEN '2024-01-01' AND '2024-12-31'
GROUP BY pm.date, c.campaign_name
ORDER BY pm.date, c.campaign_name
LIMIT 20;

Audience Segment Performance

sql
SELECT
    aud.audience_segment,
    SUM(pm.conversions) AS total_conversions,
    SUM(pm.spend) AS total_spend
FROM audiences aud
JOIN performance_metrics pm ON aud.audience_id = pm.audience_id
GROUP BY aud.audience_segment
ORDER BY total_conversions DESC
LIMIT 20;

Load it with pandas

python
import pandas as pd

# Unzip the CSV download first: one file per table
campaigns = pd.read_csv("campaigns.csv")
audiences = pd.read_csv("audiences.csv")
ads = pd.read_csv("ads.csv")
performance_metrics = pd.read_csv("performance_metrics.csv")

# Join ads to campaigns
df = ads.merge(campaigns, left_on="campaign_id", right_on="campaign_id", how="left", suffixes=("", "_campaigns"))
print(df.groupby("objective").size().sort_values(ascending=False))

Using it in your tool

Excel
Load each table into a separate sheet. Use Power Query to join tables based on their keys (e.g., campaign_id, ad_id). Create a PivotTable on the joined data to analyze campaign performance by objective or audience segment.
Power BI
Create a star schema with 'performance_metrics' as the fact table and 'campaigns', 'ads', and 'audiences' as dimension tables. Establish relationships: 'ads' to 'campaigns' on campaign_id, 'performance_metrics' to 'ads' on ad_id, and 'performance_metrics' to 'audiences' on audience_id. DAX measures could include Total Spend (SUM(performance_metrics[spend])) and Conversion Rate (DIVIDE(SUM(performance_metrics[conversions]), SUM(performance_metrics[clicks]))).
SQL
Load the SQLite or SQL relational download. Use foreign keys to join tables: campaigns to ads on campaign_id, ads to performance_metrics on ad_id, and performance_metrics to audiences on audience_id. Example join path: campaigns -> ads -> performance_metrics.

Formats available

  • CSV (zip)One CSV file per table, zipped
  • Excel workbookOne worksheet per table
  • SQLite databaseA ready-to-query database file with every table
  • Parquet (zip)One Parquet file per table, zipped
  • SQL scriptCREATE TABLE with primary and foreign keys, then INSERTs
  • CSVA single CSV file
  • JSONA single JSON file

How this data was generated

Synthetic data. Every row was generated: no real people, customers or companies are in this dataset.

Synthetic data generated by GoMask DataFactory from a relational blueprint: keys, links and rules are enforced in code, text columns are filled by a language model. No real people, companies or transactions.

  • Data was generated using GoMask DataFactory.
  • Synthetic data mimics common marketing campaign structures and metrics.
  • Includes relationships between campaigns, ads, audiences, and performance metrics.
  • Checked by an automated quality gate: unique keys, no orphan foreign keys, required columns filled, declared rules and date ranges (realism score 100).

Limitations

  • The dataset is synthetic and does not represent real-world individuals or events.
  • Performance metrics are simplified and may not capture all nuances of advertising platforms.
  • Distributions and correlations are modelled, not measured from real records.

15 SQL practice questions for the Marketing Campaign Dataset for Analysis

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · ORDER BY · LIMIT

    Top 10 campaigns by budget

    From the campaigns table, return campaign_id, campaign_name and budget for the 10 campaigns with the highest budget. Order the rows by budget from highest to lowest, using campaign_id ascending to break ties.

    Tables: campaigns · your result: 3 columns, 10 rows
  2. 02BeginnerFreeGROUP BY · COUNT

    Campaigns per objective

    Count the campaigns for each objective. Return objective and campaign_count, ordered by campaign_count from highest to lowest, then by objective alphabetically.

    Tables: campaigns · your result: 2 columns, 4 rows
  3. 03BeginnerFreeWHERE · ORDER BY

    Daily rows with 1,000+ conversions

    From performance_metrics, return metric_id, date, clicks and conversions for every row with at least 1000 conversions. Order by conversions from highest to lowest, then by metric_id ascending.

    Tables: performance_metrics · your result: 4 columns, 42 rows
  1. 04Sales ads per ad formatBeginner
  2. 05Total spend by audience segmentPower BI
  3. 06Cost per conversion by objectiveIntermediate
  4. 07High-impression audiences by CTRIntermediate
  5. 08Campaign budget tiersIntermediate
  6. 09Ads with no performance dataIntermediate
  7. 10Monthly spend column chartPower BI
  8. 11Top 3 campaigns per objectiveAdvanced
  9. 12Month-over-month spend changeAdvanced
  10. 132024 running total of spendAdvanced
  11. 14Spend share by targeting criteriaAdvanced
  12. 15Audience average spend flagPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

blueprint · marketing-campaign-analytics-dataset

Scale this dataset

Same tables. As many rows as you need.

Open the blueprint behind these 4 tables in Data Factory: keep the relationships, change a column, and generate it at the size you need.

  • 200,000 rows
  • 1,000,000 rows
Scale this dataset in Data Factory
Tables
campaigns, audiences, ads, performance_metrics
Licence
yours to use, including commercially
API slug
marketing-campaign-analytics-dataset

What should your data show?

Preview 20 rows free
No signup. No card.