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.

Open the SQL on Your Files

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.

Open the SQL on Your Files

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

How to use the SQL on Your Files: step by step

  1. Export each platform as CSV.
  2. Clean and rename columns.
  3. Stack channels and calculate metrics with SQL.
  4. 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.