1Understanding Metric Categories
Primary vs. Diagnostic Metrics
Primary Metrics
Primary metrics directly measure business outcomes:
- How much is being spent
- How many conversions are generated
- What return is achieved on that spend
Diagnostic Metrics
Diagnostic metrics help identify problems and opportunities:
- Why is performance good or bad
- Where are inefficiencies occurring
- What needs attention
Key Principle: Primary metrics guide strategic decisions; diagnostic metrics guide tactical optimizations.
2The Essential Column Setup
Core Campaign Information
| Column | Purpose |
|---|---|
| Campaign | Campaign name (locked by default) |
| Budget | Daily budget setting |
| Status | Campaign health indicators |
| Bid Strategy Type | Current bidding approach |
Status Indicators to Watch:
- Eligible: Healthy
- Limited by budget: Potential growth opportunity
- Bid strategy limited: Needs adjustment
- Learning: Insufficient data
Traffic Metrics
| Metric | What It Shows | Use Case |
|---|---|---|
| Clicks | Total clicks received | Volume indicator |
| Impressions | Times ads shown | Reach indicator |
| CTR (Click-Through Rate) | Clicks ÷ Impressions | Ad relevance indicator |
| Avg. CPC | Average cost per click | Auction competitiveness |
| Cost | Total spend | Budget consumption |
Conversion Metrics (E-Commerce)
| Metric | What It Shows | Use Case |
|---|---|---|
| Conversions | Number of conversion actions | Volume outcome |
| Cost/Conv. | Cost ÷ Conversions | Efficiency metric |
| Conv. Rate | Conversions ÷ Clicks | Landing page effectiveness |
| Conv. Value | Total revenue generated | Revenue outcome |
| Conv. Value/Cost | ROAS | Primary efficiency metric |
| Value/Conv. | Average order value | Revenue per conversion |
Conversion Metrics (Lead Generation)
| Metric | What It Shows | Use Case |
|---|---|---|
| Conversions | Number of leads | Volume outcome |
| Cost/Conv. | Cost per lead | Primary efficiency metric |
| Conv. Rate | Leads ÷ Clicks | Landing page effectiveness |
3Understanding "By Time" Metrics
The Attribution Timing Problem
Standard conversion metrics attribute conversions to the click date, not the conversion date.
Example:
- User clicks ad on Day 1
- User converts on Day 7
- Standard metrics: Conversion counted on Day 1
- By Time metrics: Conversion counted on Day 7
When to Use By Time Metrics
| Timeframe Analyzed | Recommended Approach |
|---|---|
| Last 7 days | Use By Time metrics |
| Last 14 days | Use By Time metrics |
| Last 30 days | Use By Time metrics |
| 90+ days | Standard metrics acceptable |
Why By Time Matters
When analyzing recent performance, standard metrics underreport because conversions from recent clicks haven't occurred yet. By Time metrics show what actually converted in that period.
Essential By Time Columns:
- Conversions by conversion time
- Conversion value by conversion time
- Value/Conv. by conversion time
Want to see how your account stacks up?
Get a complete Google Ads audit in under 3 minutes.
4Creating Custom Columns
The Problem
Google Ads doesn't provide "Cost per Conversion by Time" or "ROAS by Time" as preset columns. These must be created manually.
How to Create Custom Columns
- Navigate to Columns → Modify Columns
- Scroll to "Custom Columns"
- Click "Create Custom Column"
ROAS by Time Formula
- Column Name: Conv. Value/Cost by Time (or ROAS by Time)
- Formula:
Conversion value by conversion time ÷ Cost
CPA by Time Formula
- Column Name: Cost/Conv. by Time (or CPA by Time)
- Formula:
Cost ÷ Conversions by conversion time
6Using Metrics for Diagnosis
CTR Diagnostic Thresholds
| Campaign Type | Healthy CTR | Warning Zone | Red Flag |
|---|---|---|---|
| Search (Branded) | 8%+ | 4-8% | Below 4% |
| Search (Non-brand) | 3%+ | 2-3% | Below 2% |
| Shopping | 1%+ | 0.5-1% | Below 0.5% |
Low CTR Indicates:
- Ad copy not resonating with searchers
- Keywords too broad or irrelevant
- Ad position issues
- Asset/extension problems
Conversion Rate Diagnostic
Low Conversion Rate + High CTR:
- Landing page issues
- Price/offer misalignment
- Site experience problems
- Audience mismatch
Low Conversion Rate + Low CTR:
- Fundamental targeting issues
- Keyword relevance problems
- Complete campaign restructure may be needed
CPC Diagnostic
Rising CPC Over Time:
- Increased competition
- Quality Score decline
- Bid strategy aggression
CPC Higher Than Industry Average:
- Quality Score issues
- Poor ad relevance
- Suboptimal bidding strategy
Want to see how your account stacks up?
Get a complete Google Ads audit in under 3 minutes.
7Decision Framework Based on Metrics
When ROAS is Below Target
Check in order:
- Conversion rate (landing page issues?)
- CPC (bidding too aggressively?)
- CTR (ad relevance issues?)
- Search terms (targeting issues?)
When Limited by Budget
If ROAS is Strong:
- Increase budget
- Reallocate from underperforming campaigns
If ROAS is Weak:
- Optimize before adding budget
- Identify what's driving poor performance
When Impression Share is Low
If Profitable:
- Budget increase opportunity
- Bid strategy adjustment
If Unprofitable:
- Focus on efficiency before growth
- Fix fundamentals first
Complete Recommended Column Order
- Campaign (locked)
- Budget (locked)
- Status (locked)
- Bid Strategy Type
- Clicks
- Impressions
- CTR
- Avg. CPC
- Cost
- Conversions
- Cost/Conv.
- Conv. Rate
- Conv. Value (e-commerce)
- Conv. Value/Cost (e-commerce)
- Conv. by Time
- Cost/Conv. by Time (custom)
- Search Impr. Share
- Search Lost IS (Budget)