# Sample Marketing Campaign Dataset: Ads, Clicks, Spend and Conversions

> Free sample marketing dataset: ad campaigns with impressions, clicks, CTR, spend and conversions that add up. Download CSV or Excel for dashboards and practice.

Page: https://datautility.in/blog/sample-marketing-campaign-dataset-ads-clicks-spend
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

Published 2026-11-16 · Create · marketing dataset csv, ad campaign sample data, sample google ads data, marketing analytics practice data, campaign performance dataset

To build a marketing dashboard or practise campaign analysis you need rows that look like ad reports and whose numbers agree. Generate a campaign performance dataset in your browser, free.

Open the tool: [Data Generator](https://datautility.in/mock-data-generator)

## What is in the dataset

Open the [Data Generator](https://datautility.in/mock-data-generator), choose Marketing and pick Ad campaign performance. Each row is a day for a campaign and has the date, campaign name, channel (Paid search, Paid social, Display, Video, Email or Affiliate), impressions, clicks, click-through rate, spend and conversions. Download CSV, Excel, JSON or Parquet and choose from 100 up to 500,000 rows.

## The numbers agree with each other

Real ad reports follow rules, and so does this data. Clicks never exceed impressions, conversions never exceed clicks, the click-through rate is clicks divided by impressions, and spend is clicks times a cost per click between about 0.10 and 6. Because of that, the metrics you calculate from it behave like real ones instead of giving impossible values such as a 120 percent click rate.

## Metrics to calculate

Add these as calculated columns in Excel, or in [Data Transformation](https://datautility.in/data-transformation): cost per click is spend divided by clicks, cost per conversion is spend divided by conversions, and conversion rate is conversions divided by clicks. Then compare channels. In SQL, SELECT channel, SUM(spend) AS spend, SUM(clicks) AS clicks, ROUND(SUM(spend) / NULLIF(SUM(clicks), 0), 2) AS cpc FROM ad_campaigns GROUP BY channel ORDER BY spend DESC; works in [SQL on Your Files](https://datautility.in/sql-on-your-files).

Sum the spend and clicks first, then divide. Averaging the daily rates gives a different and usually wrong answer, which is a good mistake to learn to avoid.

## What to use it for

Use it to build a Looker Studio, Power BI or Excel dashboard before real data arrives, practise pivot tables by channel and month, test an ad report import, or teach campaign metrics. If you work with real exports from the ad platforms, see [Meta Ads and Google Ads data to Excel](https://datautility.in/blog/meta-ads-google-ads-data-to-excel) and [cleaning marketing campaign data](https://datautility.in/blog/clean-marketing-campaign-data-csv).

## What it is not

The data is random. It is not an industry benchmark, so do not quote its click rates or costs as typical for any channel. There is no revenue column, so return on ad spend cannot be calculated from it.

## How to use the Data Generator: step by step

1. Open the Data Generator and choose Ad campaign performance.
2. Choose the number of rows.
3. Pick CSV, Excel, JSON or Parquet.
4. Download the file and build your report.

## When to use the Data Generator

- Build a marketing dashboard before real data arrives
- Practise pivot tables by channel and month
- Teach CPC, CPA and conversion rate
- Test an ad report import

## Example

Input:

```
Dataset: Customers, 3 rows
```

Output:

```
id,name,email
1,Maya Patel,maya.patel@example.com
2,Leo Fischer,leo.fischer@example.com
```

## Frequently asked questions

### Are the clicks and costs realistic?
They are internally consistent: clicks never exceed impressions and spend equals clicks times a cost per click. They are random, so they are not benchmarks for any real channel.

### Can I calculate return on ad spend from it?
No. The dataset has conversions and spend but no revenue, so you can calculate cost per click, cost per conversion and conversion rate only.

### How many rows can I generate?
Up to 500,000 rows in the Data Generator, in CSV, Excel, JSON or Parquet.

Tip: Set the date range to the months your dashboard covers, so date filters and month-over-month charts have data.

## Related tool pages

- [Fake Data Generator](https://datautility.in/fake-data-generator): Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- [Test Data Generator](https://datautility.in/test-data-generator): Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- [Student Data Generator: Fake Student Records](https://datautility.in/student-data-generator): Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
- [Student Marks Dataset Generator](https://datautility.in/student-marks-dataset-generator): Create a student marks dataset by student, subject and exam for SQL, Excel pivot tables and charts. Free, in your browser.
- [Sample Data for SQL Practice](https://datautility.in/sample-data-for-sql-practice): Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
- [Dummy Data for Excel Practice](https://datautility.in/dummy-data-for-excel-practice): Generate dummy sales, student or employee data and download Excel to practise filters, pivot tables and VLOOKUP. Free.

## Also try

- [Meta Ads and Google Ads data to Excel](https://datautility.in/blog/meta-ads-google-ads-data-to-excel)
- [Clean marketing campaign data](https://datautility.in/blog/clean-marketing-campaign-data-csv)
- [Free practice datasets](https://datautility.in/blog/free-practice-datasets-sql-excel-data-science)
- [SQL on your files](https://datautility.in/sql-on-your-files)
- [Free test data generator: all datasets](https://datautility.in/blog/fake-datasets-by-industry-orders-healthcare-finance-climate)

## More guides

- [Free Mock Data Generator: Realistic Test Data in 1 Minute](https://datautility.in/blog/free-mock-data-generator-test-data)
- [Generate Test Data from a CREATE TABLE (500k Rows)](https://datautility.in/blog/generate-test-data-from-schema)
- [Synthetic Data vs Random Fake Data: What Is the Difference?](https://datautility.in/blog/synthetic-data-vs-fake-data-generator)
