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.
At a glance
- 4tables
- 30,527rows
- 24columns
- Jan 2023 – Dec 2024date range
The 4 tables
preview and data dictionary per tableCampaigns campaigns · table · 1,750 rows
Details about each marketing campaign.
Preview
| campaign_iduuid | campaign_namestring | start_datedate | end_datedate | budgetdecimal | objectivestring |
|---|---|---|---|---|---|
| 880796fc-c89e-4693-9ce6-23166401389a | Q3 2024 SaaS Lead Gen Drive | 2024-06-15 | 2024-08-13 | 42091.76 | Lead Generation |
| 66a73ebb-5e5b-46a7-bab5-9f996aa4fee8 | Q3 2023 Enterprise Software Signups | 2023-07-10 | 2023-08-09 | 18243.33 | Lead Generation |
| 4da21ca9-980d-46cf-8492-d25c1b8f8fc3 | Q3 2024 B2B Solutions Acquisition | 2024-06-27 | 2024-10-25 | 34281.39 | Lead Generation |
| 9659d325-40d0-4b8d-957f-3a45b5438245 | Q4 2023 Cloud Services Prospecting | 2023-09-17 | 2023-10-21 | 40137.93 | Lead Generation |
| 53d9a1fc-5cee-4e70-a86e-4acda530824f | Q2 2024 Fintech Lead Generation Push | 2024-03-11 | 2024-04-20 | 85834.45 | Lead Generation |
| 3b957f0d-bbe4-43a5-994c-29b3deda5830 | Q4 2024 Brand Spotlight | 2024-11-17 | 2024-12-27 | 21038.76 | Brand Awareness |
| 803dd1b0-eb5a-4282-b4eb-5f896630ba6e | Q4 2023 Holiday Brand Boost | 2023-12-11 | 2024-04-06 | 91139.96 | Brand Awareness |
| 38a78b23-5323-48ba-bc5b-13776f0158ef | Q4 2023 Year-End Brand Visibility | 2023-11-29 | 2024-03-16 | 29233.29 | Brand Awareness |
| bcea8452-e6e9-4ea8-b478-a4e43ec15aeb | Q4 2023 Autumn Brand Engagement | 2023-10-21 | 2023-11-30 | 24922.58 | Brand Awareness |
| ad64ed95-44c9-4c25-87cd-b66cf0b95f56 | Q2 2024 Spring Brand Awareness Drive | 2024-05-18 | 2024-06-15 | 13085.48 | Brand Awareness |
Data dictionary
| column | type | description | example | null % |
|---|---|---|---|---|
campaign_ | uuid | Unique identifier for the marketing campaign.unique | 880796fc-c89e-4693-9ce6-23166401389a | 0% |
campaign_ | string | Descriptive marketing campaign name indicating theme and target quarter. | Q3 2024 SaaS Lead Gen Drive | 0% |
start_ | date | Start date of the campaign flight. | 2024-06-15 | 0% |
end_ | date | Scheduled end date of the campaign flight. | 2024-08-13 | 0% |
budget | decimal | Allocated total monetary budget for the campaign in USD.unique | 42091.76 | 0% |
objective | string | Primary marketing goal of the campaign. | Lead Generation | 0% |
Audiences audiences · dimension table · 50 rows
Information on targeted audience segments.
Preview
| audience_iduuid | audience_namestring | audience_segmentstring | demographicsstring | interestsstring |
|---|---|---|---|---|
| 8cbade64-b07d-430b-b52e-39b966669622 | Eco-Conscious Women 25-44 | Lookalike | Age 25-44, Women, Household Income $75k+ | Sustainable Living, Organic Goods & Eco-friendly Products |
| de1b9df1-8837-414b-a6a5-d453f67fbdf8 | Sustainable Parents 35-54 | Lookalike | Age 35-54, All Genders, Mid-Career & Parents | Sustainable Living, Organic Goods & Eco-friendly Products |
| 7488bffd-f1f0-4d95-9d70-096a81153b16 | Tech Professionals Male 25-44 | Lookalike | Age 25-44, Men, Tech Industry Workers | Technology & Gadgets, Consumer Electronics |
| 693c7439-76ad-437f-86ac-3dda3f96aef1 | Gadget Enthusiast Women 25-44 | Lookalike | Age 25-44, Women, Household Income $75k+ | Technology & Gadgets, Consumer Electronics |
| 8322c67c-9ddc-4ce2-b0e0-619889b1d6a1 | Male Tech Enthusiasts 25-44 | Lookalike | Age 25-44, Men, Tech Industry Workers | Technology & Gadgets, Consumer Electronics |
| 5bd470b6-ca60-401b-9138-23bf89631b70 | Mid-Career Tech Buyers 35-54 | Lookalike | Age 35-54, All Genders, Mid-Career & Parents | Technology & Gadgets, Consumer Electronics |
| 3f52c3d2-2290-47df-b025-9382aed84a84 | Active Young Professionals 25-34 | Lookalike | Age 25-34, All Genders, Young Professionals | Outdoor Recreation, Fitness & Wellness |
| c9de7806-78b0-495c-8556-e12ea87461f3 | Male Tech Aficionados 25-44 | Lookalike | Age 25-44, Men, Tech Industry Workers | Technology & Gadgets, Consumer Electronics |
| 6e7ec725-7501-4e03-92bd-69453b8793fa | Active Mid-Career Adults 35-54 | Lookalike | Age 35-54, All Genders, Mid-Career & Parents | Outdoor Recreation, Fitness & Wellness |
| beef7602-5f5c-4278-b59d-79e87cc4ce28 | Eco-Minded Young Professionals 25-34 | Lookalike | Age 25-34, All Genders, Young Professionals | Sustainable Living, Organic Goods & Eco-friendly Products |
Data dictionary
| column | type | description | example | null % |
|---|---|---|---|---|
audience_ | uuid | Unique identifier for the audience segment.unique | 8cbade64-b07d-430b-b52e-39b966669622 | 0% |
audience_ | string | Descriptive marketing name for the targeted cohort.unique | Eco-Conscious Women 25-44 | 0% |
audience_ | string | High-level segmentation classification. | Lookalike | 0% |
demographics | string | Demographic breakdown defining age, gender, education, or household income tier. | Age 25-44, Women, Household Income $75k+ | 0% |
interests | string | Primary interest tags and affinity categories assigned to the audience. | Sustainable Living, Organic Goods & Eco-friendly Products | 0% |
Ads ads · dimension table · 9,541 rows
Details of individual ad creatives and their targeting.
Preview
| ad_iduuid | ad_creativestring | ad_formatstring | targeting_criteriastring | campaign_iduuid |
|---|---|---|---|---|
| 32359028-4268-4267-81de-e6a9281f4382 | Enterprise Software: Drive Your Business Growth | Video | Parenting & Family Household Decision Makers | 66a73ebb-5e5b-46a7-bab5-9f996aa4fee8 |
| 8e372b90-a860-462b-a979-6f633b3ae011 | Autumn Engagement: Discover Our Latest Brand Stories | Video | Young Adults (18-34) Mobile Users | bcea8452-e6e9-4ea8-b478-a4e43ec15aeb |
| 6e613666-6724-45c9-b1c0-8e46c568e376 | Year-End Visibility: Shine Bright with Our Brand Solutions | Video | High-Value Lookalike Audience (Top 1%) | 38a78b23-5323-48ba-bc5b-13776f0158ef |
| 83109b79-d669-4123-94ab-ca5771b53f1f | SaaS Solutions for Professionals: Video Lead Gen | Video | Affluent Professionals (25-54) High Income | 880796fc-c89e-4693-9ce6-23166401389a |
| d6d3a778-5b5f-43b4-9a70-c8e9709bc161 | Enterprise Software: Sign Up for Success | Video | High-Value Lookalike Audience (Top 1%) | 66a73ebb-5e5b-46a7-bab5-9f996aa4fee8 |
Data dictionary
| column | type | description | example | null % |
|---|---|---|---|---|
ad_ | uuid | Unique identifier for the ad creative variant. | 57e83ac5-3ddc-401f-bcc3-dff6240714c7 | 0% |
ad_ | string | Descriptive title and messaging angle of the ad creative. | Discover Cutting-Edge Gadgets: Top Tech for Industry Professionals | 0% |
ad_ | string | Visual format used by the ad creative variant. | Video | 0% |
targeting_ | string | Key segmentation focus and behavioral/demographic parameters applied to the ad. | High-Value Lookalike Audience (Top 1%) | 0% |
campaign_ | uuid | Foreign key to campaigns.campaign_id. | 071554df-0e3c-40d2-88b0-91673c1ab460 | 0% |
Performance metrics performance_metrics · fact table · 19,186 rows
Daily performance metrics for each ad and audience combination.
Preview
| metric_iduuid | datedate | impressionsinteger | clicksinteger | conversionsinteger | spenddecimal | ad_iduuid | audience_iduuid |
|---|---|---|---|---|---|---|---|
| 62de4f88-892f-48a5-a849-ddbb6a9fcb49 | 2024-11-14 | 10487 | 470 | 47 | 881.79 | f3fc05c9-dcce-4653-bc8c-f27dccd67dff | 72327ff5-f082-4415-8d2a-16cc572ffe46 |
| 9e54c28b-ca27-4ee4-a891-7d2fcd59c758 | 2024-09-08 | 23321 | 381 | 14 | 1290.77 | 70e93850-d2df-4127-80ac-5df7d9e29fff | aeaa9efe-d45b-4f12-b2c7-b878d66f2bea |
| 2e77e38b-3dd2-4dc0-bb55-23ea8cb243d4 | 2023-01-02 | 9616 | 268 | 19 | 850.33 | 2b3f4228-0bc1-443b-80a2-8d18222f7095 | aeaa9efe-d45b-4f12-b2c7-b878d66f2bea |
| 3b12b06d-f85a-4044-9636-8b53bed65a33 | 2023-05-22 | 13054 | 111 | 15 | 348.87 | ae3304b2-49c0-4028-bf29-d220a91e9fb3 | 8322c67c-9ddc-4ce2-b0e0-619889b1d6a1 |
| 7da199fb-9df2-4e91-875f-bb9b63f55dac | 2023-08-07 | 2174 | 76 | 6 | 181.69 | cb60fcd7-28b5-4b3d-aee9-f959976cd795 | ee1f3663-17db-4468-9cdc-8548010d9907 |
| c6432db6-e8bb-40f4-acb0-54d84a999208 | 2024-03-01 | 2271 | 29 | 2 | 38.02 | ed16029a-bc8e-4733-b50f-c9d6fe060773 | 123b54d2-129d-4ce9-a25c-3124cad1faa2 |
| 5f5843da-1bb0-4262-abb5-1c2f62b7e484 | 2023-12-28 | 18792 | 565 | 32 | 2112.17 | aecba629-56ce-43ed-872d-0082a6aabf21 | 43be80f4-ae86-4a09-81f8-44314b6d54de |
| 1aff6661-2d19-4bc7-b47f-3866dbc294f7 | 2023-03-22 | 17654 | 326 | 39 | 703.66 | 9fadcc75-3c09-49a2-8d4a-d50fc0166e3b | 029989f5-0b5f-4eaf-9fc0-286e7fcabca7 |
| d83ccdad-38a1-420b-a83e-c55680f7a3cb | 2023-10-30 | 9933 | 445 | 30 | 2016.3 | 68be8327-f0a3-4209-98de-40199ea87009 | 4cc07a7f-57c0-40c1-9875-57944cc4abe7 |
| 3c5dccf2-9d3a-4d10-a444-b2735c2bfa0b | 2024-07-07 | 8092 | 246 | 22 | 808.64 | c42d3067-d901-4d19-9a47-1b3c7019969e | fa0b8649-1285-4520-b095-e615100e528b |
Data dictionary
| column | type | description | example | null % |
|---|---|---|---|---|
metric_ | uuid | Unique identifier for this performance metric entry. | 62de4f88-892f-48a5-a849-ddbb6a9fcb49 | 0% |
date | date | Observation date for the ad performance record. | 2024-11-14 | 0% |
impressions | integer | Total number of ad views registered on the given date. | 10487 | 0% |
clicks | integer | Number of direct user clicks on the ad creative. | 470 | 0% |
conversions | integer | Total desired target actions achieved. | 47 | 0% |
spend | decimal | Total advertising expenditure incurred for the recorded metrics. | 881.79 | 0% |
ad_ | uuid | Foreign key to ads.ad_id. | f3fc05c9-dcce-4653-bc8c-f27dccd67dff | 0% |
audience_ | uuid | Foreign key to audiences.audience_id. | 72327ff5-f082-4415-8d2a-16cc572ffe46 | 0% |
How the tables join
ads.campaign_id references campaigns.campaign_idmany to one: each Ads row points to one Campaigns rowperformance_metrics.ad_id references ads.ad_idmany to one: each Performance metrics row points to one Ads rowperformance_metrics.audience_id references audiences.audience_idmany to one: each Performance metrics row points to one Audiences row
Questions to answer with it
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
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
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
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 publishingTable names match the SQLite file and the SQL script.
Top 20 Campaigns by Spend
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
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
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
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
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.
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 rowsCampaigns 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 rowsDaily 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
- 04Sales ads per ad formatBeginner
- 05Total spend by audience segmentPower BI
- 06Cost per conversion by objectiveIntermediate
- 07High-impression audiences by CTRIntermediate
- 08Campaign budget tiersIntermediate
- 09Ads with no performance dataIntermediate
- 10Monthly spend column chartPower BI
- 11Top 3 campaigns per objectiveAdvanced
- 12Month-over-month spend changeAdvanced
- 132024 running total of spendAdvanced
- 14Spend share by targeting criteriaAdvanced
- 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.99blueprint · 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
- Tables
- campaigns, audiences, ads, performance_metrics
- Licence
- yours to use, including commercially
- API slug
- marketing-campaign-analytics-dataset