Skip to main content

Overview

The Paid Search Performance Report is broken down by date, country, platform, campaign type, campaign, and ad group - enabling you to analyse performance from high-level platform strategy down to individual ad group targeting and keywords. Campaign types are automatically classified (Brand, Performance Max, Demand Gen, YouTube, Shopping, Generic) based on naming conventions to help you quickly segment and compare different campaign strategies. Use this report to compare Google Ads vs. Bing Ads performance, analyse brand vs. non-brand efficiency, optimise budget allocation across campaign types, track new customer acquisition vs. repeat purchases, and calculate true profitability including COGS and fees.

Data Dictionary

Fields and their respective definitions available within this report.

Identifiers & Dimensions

NameDescription
IDA surrogate key created from date, country_code, platform, campaign, and ad_group.
DateThe date of the paid search performance metrics.
Country CodeISO country code for the ad performance location.
PlatformThe paid search platform (e.g., ‘Google Ads’, ‘Bing Ads’).
Campaign TypeCampaign classification (e.g., ‘Brand’, ‘Performance Max’, ‘Demand Gen’, ‘YouTube’, ‘Shopping’, ‘Generic’, ‘Other’).
CampaignThe paid search campaign name.
Ad GroupThe ad group name within the campaign.

Platform Metrics

NameDescription
ImpressionsTotal number of times ads were displayed.
Video ViewsTotal number of video views for video campaigns.
ClicksTotal number of clicks on the ads.
InteractionsTotal number of interactions with the ads.
SpendTotal advertising spend.
ConversionsTotal conversions reported by the platform.
Conversion ValueTotal conversion value reported by the platform.
CPMCost per thousand impressions (spend / impressions * 1000).
CPCCost per click (spend / clicks).
CTRClick-through rate (clicks / impressions * 100).

Session Metrics (GA4 Attributed)

NameDescription
Total SessionsTotal number of sessions attributed to the ads.
New SessionsNumber of sessions from new users attributed to the ads.
Repeat SessionsNumber of sessions from returning users attributed to the ads.
Total UsersTotal number of users attributed to the ads.
New UsersNumber of new users attributed to the ads.
Repeat UsersNumber of returning users attributed to the ads.
New User %Percentage of total users who are new users.
CPUCost per user (spend / total users).
CPNUCost per new user (spend / new users).

Order Metrics

NameDescription
Total OrdersTotal number of orders attributed to the ads.
One Off OrdersNumber of one-off (non-subscription) orders attributed to the ads.
Subscription OrdersNumber of subscription orders attributed to the ads.
New OrdersNumber of orders from new customers attributed to the ads.
New Oneoff OrdersNumber of one-off orders from new customers attributed to the ads.
New Subscription OrdersNumber of subscription orders from new customers attributed to the ads.
CRConversion rate (total orders / total sessions * 100).
NC CRNew customer conversion rate (new orders / total sessions * 100).
CACCustomer acquisition cost (spend / new orders).
AOVAverage order value (total net revenue / total orders).
FOVFirst order value (new customer net revenue / new orders).

Financial Metrics

NameDescription
Total Gross RevenueTotal gross revenue before discounts and tax attributed to the ads.
Total Net Revenue Excl RefundsTotal net revenue after discounts, excluding tax and refunds, attributed to the ads.
Total Discount Amount Before TaxTotal discount amount before tax attributed to the ads.
Total Refund AmountTotal refund amount attributed to the ads.
MERMarketing efficiency ratio (total net revenue / spend).
ROASReturn on ad spend (total net revenue / spend).

Cost Metrics

NameDescription
Total COGSTotal cost of goods sold attributed to the ads.
Total Payment Processing FeesTotal payment processing fees attributed to the ads.

Contribution Margin Metrics

NameDescription
CM1 £Level 1 contribution margin (net revenue after COGS).
CM1 %Level 1 contribution margin as a percentage of net revenue.
CM2 £Level 2 contribution margin (CM1 minus payment processing fees).
CM2 %Level 2 contribution margin as a percentage of net revenue.
CM3 £Level 3 contribution margin (CM2 minus ad spend).
CM3 %Level 3 contribution margin as a percentage of net revenue.

Questions This Report Answers

Compare platform metrics, CAC, ROAS, and profitability between Google Ads and Bing Ads to understand which platform delivers better efficiency. Analyse whether you should increase or decrease budget allocation between platforms based on true profitability metrics.
Segment by campaign type to compare Brand campaigns against Generic, Shopping, and other non-brand campaign types. Analyse CAC, conversion rates, and ROAS to understand the role each plays in your acquisition funnel and optimise budget allocation accordingly.
Compare Performance Max, Demand Gen, Shopping, Brand, Generic, and YouTube campaigns across new customer acquisition metrics. Identify which campaign types drive the lowest CAC and highest-quality new customers for scaling opportunities.
Analyse subscription order acquisition by campaign type to identify which strategies drive subscription adoption vs. one-time purchases. Compare the long-term value potential of customers acquired through different campaign types.
Calculate CM1, CM2, and CM3 at the ad group level to understand profitability after COGS, payment processing fees, and ad spend. Identify which ad groups drive profitable growth vs. which are spending inefficiently despite appearing to have good ROAS.
Segment by country code to understand geographic performance differences. Compare CAC, conversion rates, AOV, and profitability across markets to optimise geo-targeted campaigns and budget allocation by region.
Drill down from campaign to ad group level to identify top-performing targeting, keywords, or audience segments. Compare ad group CAC, conversion rates, and ROAS to reallocate budget within campaigns for better efficiency.
Compare platform-reported ‘Conversions’ and ‘Conversion Value’ metrics with GA4-attributed orders and revenue to understand discrepancies in conversion tracking. Identify campaigns with larger attribution gaps to improve measurement and optimisation decisions.
Analyse video views alongside conversion metrics for YouTube campaigns to understand video engagement effectiveness. Compare CPU, CPNU, and conversion rates for video campaigns vs. other campaign types.
Compare spend distribution across Brand, Generic, Shopping, Performance Max, and other campaign types against their respective CAC, ROAS, and contribution margins. Identify opportunities to reallocate budget from low-performing to high-performing campaign types for better overall account efficiency.