# Free Data Tools for Marketing Analysts: Clean, Merge and Report Campaign Data

> Marketing analysts: clean campaign exports, merge channels with SQL, calculate CTR, CPA and ROAS, and share masked lead lists. Free, in your browser.

Page: https://datautility.in/blog/free-data-tools-for-marketing-analysts
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-19 · Analyze & protect · marketing analyst free tools, marketing data tools free, merge google ads and meta csv, campaign data cleaning, calculate roas in sql, marketing reporting csv, utm data cleanup, marketing analytics without bi tool

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 tool: [SQL on Your Files](https://datautility.in/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](https://datautility.in/data-transformation). The walkthrough is in [clean marketing campaign data in CSV](https://datautility.in/blog/clean-marketing-campaign-data-csv). Profile the result with the [data profiler](https://datautility.in/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](https://datautility.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](https://datautility.in/blog/sample-marketing-campaign-dataset-ads-clicks-spend) 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](https://datautility.in/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.

## 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.

## Related tool pages

- [Query a Large CSV with SQL](https://datautility.in/query-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](https://datautility.in/query-csv-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](https://datautility.in/sql-on-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](https://datautility.in/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](https://datautility.in/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](https://datautility.in/duckdb-in-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](https://datautility.in/blog/free-data-profiling-tool-for-data-analysts)
- [Free data tools for business analysts](https://datautility.in/blog/free-data-tools-for-business-analysts)
- [Free data tools for product analysts](https://datautility.in/blog/free-data-tools-for-product-analysts)
- [Clean marketing campaign data](https://datautility.in/blog/clean-marketing-campaign-data-csv)

## More guides

- [Data Profiler: Check Data Quality Before You Use It](https://datautility.in/blog/data-profiler-check-data-quality)
- [Compare Two CSV or Excel Files: Find Added, Removed and Changed Rows](https://datautility.in/blog/compare-two-csv-files-find-differences)
- [Data Masking: Hide Emails, Phones and Names Before Sharing](https://datautility.in/blog/data-masking-hide-emails-phones-pii)
