Skip to the tool
ViewCSV
Files stay on your device

Google Ads CSV performance report

google-ads-mapping-sample.csv· SAMPLE DATA3 rows · 7 columns

Select the report type and map its columns before calculating. Remove summary rows and overlapping segments first. Amounts use account currency units, never micros. Choose a decimal mark; thousands separators and currency symbols are rejected.

Map campaign or keyword exports and calculate cost, CTR, CPC, CPA and ROAS by currency.

Report type

Select the report type and map its columns before calculating. Remove summary rows and overlapping segments first. Amounts use account currency units, never micros. Choose a decimal mark; thousands separators and currency symbols are rejected.

Group by column

cost / clicks / impressions / conversions
conversion_value → ROAS
CTR = clicks / impressions × 100
CPC = cost / clicks
CPA = cost / conversions
ROAS = conversion_value / cost

Result

Sums are exact; ratios are truncated to 6 decimal places. Zero denominators stay blank. Invalid rows and repeated selected keys are excluded and listed. Currencies remain separate; row counts are not order counts.

Only accepted records enter this summary. Review exclusions and the calculation rules below.

Standards and references