Sample Marketing CSV File — Free Download
Multi-channel campaign performance across seven channels with impressions, clicks, spend, conversions and revenue — everything you need to compute CTR, CPC, CPA and ROAS.
Download the sample file
CSV · 260 rows · 15.2 KB · synthetic data, free for any use
Download CSV samplePreview
| date | channel | campaign | impressions | clicks | spend | conversions | revenue |
|---|---|---|---|---|---|---|---|
| 2026-02-24 | Organic | Brand-9 | 24549 | 1392 | 1698.24 | 45 | 4632.75 |
| 2026-01-23 | Organic | Brand-1 | 49123 | 2235 | 4559.40 | 40 | 3373.60 |
| 2026-03-02 | Spring-4 | 83777 | 1215 | 1518.75 | 105 | 12655.65 | |
| 2026-01-08 | Organic | Retargeting-6 | 9714 | 445 | 1388.40 | 30 | 3683.40 |
| 2026-02-21 | Brand-6 | 45743 | 2594 | 5473.34 | 154 | 32731.16 | |
| 2026-03-01 | Meta Ads | Brand-4 | 60750 | 2163 | 5147.94 | 66 | 6913.50 |
Showing the first 6 of 260 rows.
Columns
| Column | Type | Description |
|---|---|---|
date | date (YYYY-MM-DD) | Reporting date over ~120 days |
channel | string | Google Ads, Meta Ads, LinkedIn, Email, Organic, Affiliate, TikTok |
campaign | string | Campaign name |
impressions | integer | Ad impressions |
clicks | integer | Clicks (derived from a plausible CTR) |
spend | decimal | Media spend, USD |
conversions | integer | Conversions from clicks |
revenue | decimal | Attributed revenue, USD |
What makes this file useful
- clicks, conversions and revenue are derived from impressions through realistic funnel rates, so ratio metrics land in believable ranges.
- Every channel appears on many dates, so a channel breakdown is always based on a real sample.
- Organic rows have spend > 0 too (content cost proxy) — decide whether to exclude them when computing paid ROAS.
Use cases
- Calculate CTR (clicks / impressions), CPC (spend / clicks) and CPA (spend / conversions)
- Compute ROAS as revenue / spend by channel
- Build a channel-mix pivot table or stacked bar chart
- Practise time-series aggregation by week or month
Open it in a tool
Load this sample — or your own file — into a real tool. Everything runs client-side.
Related guides
More sample datasets
Frequently asked questions
Is this real ad data?
No. It is generated from a funnel model. It is realistic in shape but not tied to any real account or platform export.
Does it match the Google Ads export format?
Not column-for-column, but it is close enough to practise the clean-and-reshape step before loading real exports.
Can I use it in a course or template?
Yes, it is free for any use.
Turn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.
Follow HowToCSV on Google
Add us as a preferred source on Google Search so our latest CSV guides and tutorials surface more often in your Top stories.