Free Data Tools for Marketing Analysts: Clean, Merge and Report Campaign Data
Marketing data lives in many places: ad platforms, email tools, web analytics, a CRM. Each exports a slightly different CSV, and the weekly report means stitching them together. This guide shows how a marketing analyst can clean, merge and measure campaign data for free in the browser, and where a connector-based reporting tool becomes worth paying for.
1. Clean each export
Platform exports bring currency symbols in number columns, inconsistent date formats, trailing spaces in campaign names and messy UTM values. Fix them with the data transformation tool. The walkthrough is in clean marketing campaign data in CSV. Profile the result with the data profiler.
2. Put channels in one table
Rename columns to common names (`date`, `channel`, `campaign`, `spend`, `clicks`, `conversions`), then stack the files with SQL in SQL on your files:
select 'google' as channel, date, campaign, spend, clicks, conversions from google_ads
union all
select 'meta', date, campaign, spend, clicks, conversions from meta_ads;3. Calculate the metrics
select channel,
sum(spend) as spend,
sum(clicks) * 1.0 / nullif(sum(impressions), 0) as ctr,
sum(spend) / nullif(sum(conversions), 0) as cpa
from all_channels group by channel;Always compute ratios from sums, not by averaging row-level rates; averaging rates overweights small campaigns.
4. Practice or demo with sample data
Building a report template? Use sample marketing campaign data with ads, clicks and spend.
5. Share lead lists safely
Before sending a lead or customer list to an agency, hide the personal columns with data masking.
Caveats that affect the numbers
- Platforms adjust conversions retroactively inside the attribution window, so numbers exported on different days will differ.
- Each platform counts conversions its own way. Do not treat the sum as a deduplicated total.
- This is manual. If you report weekly across many accounts, a connector-based tool will save time.
Related tool pages
- Query a Large CSV with SQL: Run SQL on a CSV of 500 MB or more without a database. Filter, group and export the result. Runs in your browser.
- Query a CSV File with SQL: Query a CSV file with SQL online. Filter, group, sort and join with DuckDB in your browser. No database, no install and no upload.
- Run SQL on an Excel File: Run SQL queries on an Excel file without importing it into a database. Join sheets from different files and download the result.
- Query Parquet Files Online: Open and query Parquet files with SQL in your browser. Preview, filter, aggregate and export to CSV without installing anything.
- Join CSV Files with SQL: Join two or more CSV files with SQL JOIN: inner, left, right or full. Runs in your browser with DuckDB and nothing is uploaded.
- DuckDB in Your Browser: Use DuckDB in your browser with no setup. Drop in CSV, Excel, JSON or Parquet files and run analytical SQL on your own computer.
Also try
- Free data profiling tool for data analysts
- Free data tools for business analysts
- Free data tools for product analysts
- Clean marketing campaign data
How to use the SQL on Your Files: step by step
- Export each platform as CSV.
- Clean and rename columns.
- Stack channels and calculate metrics with SQL.
- Mask lead lists before sharing.
When to use the SQL on Your Files
- Merging Google, Meta and email exports
- Calculating CTR, CPA and ROAS
- Cleaning UTM and campaign names
- Masking lead lists for agencies
Example
Input: sales.csv + customers.xlsx
Output: SQL query result
Frequently asked questions
How do I combine Google Ads and Meta Ads CSV exports?
Rename columns to common names and stack the files with a SQL UNION ALL, adding a channel column. Then calculate metrics from the sums.
How do I calculate ROAS or CPA in SQL?
Divide total revenue or spend by total conversions or spend, using sums across rows, and guard against division by zero.
Why do my ad numbers change after I export?
Platforms revise conversions retroactively within the attribution window, so exports taken on different dates can differ.
Is lead data uploaded?
No. Files are processed in your browser and not uploaded to our servers.
Tip: Export on a fixed day each week and put the date in the file name, so you can later see how platform numbers were revised.