Google Search Ads Campaigns: Keywords & Match Types, Quality Score & Ad Rank, Search Terms, Negatives, Impression Share & Account Structure
Learn how a Google Search campaign works by rebuilding its numbers in a spreadsheet. You will read a keyword report with CTR, average CPC, conversion rate and cost per conversion, compare broad, phrase and exact match, rebuild a Quality Score from its three components, calculate Ad Rank and the actual CPC of a simplified auction, sort a search terms report, test negative keywords with wildcards and turn impression share into lost impressions. Then you measure ad assets, roll keywords up to ad groups and campaigns, derive bids from a target CPA, pace a monthly budget, price a better Quality Score in a what-if grid, segment by device and time of day, compare responsive search ads, forecast what more budget would buy, check landing pages, project a click trend, separate brand from non-brand, audit the account and finish with a quarterly scorecard. 20 hands-on labs, fictional bike shop Tarnwick Cycles, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This beginner course teaches Google Search Ads campaigns through the numbers behind them. In 20 interactive spreadsheet labs you work on the account of Tarnwick Cycles, a fictional online bike shop: you calculate CTR, average CPC, conversion rate and cost per conversion for a keyword report, compare broad, phrase and exact match keywords, rebuild a Quality Score from expected CTR, ad relevance and landing page experience, and work out Ad Rank and the actual click price in a simplified auction. You sort a search terms report, test negative keywords before adding them, convert impression share into impressions lost to budget and to rank, measure ad assets, organise keywords into ad groups and campaigns, set bids from a target CPA, pace a budget and build a quarterly scorecard with a chart. Every formula is checked instantly, and each function is explained when it first appears. All companies, keywords and figures are fictional, and platform numbers are illustrative.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- Reading a Search Campaign Report: CTR, Average CPC, Conversion Rate and Cost per Conversion per KeywordFree
- Keyword Match Types: Broad, Phrase and Exact Compared by Clicks, Cost, Cost per Conversion and Share of Spend Locked
- Quality Score: Expected CTR, Ad Relevance and Landing Page Experience, a Points Model and an Impression-Weighted Average Locked
- Ad Rank and the Auction: Bid × Quality Score, the Actual CPC You Pay and the Bid Needed to Move Up Locked
- The Search Terms Report: Keywords versus Real Queries, Cost without Conversions and a Rule for Exclusions Locked
- Negative Keywords: Finding Candidate Words with Wildcards, the Cost They Save and the Conversions They Would Block Locked
- Search Impression Share: Eligible Impressions, Share Lost to Budget, Share Lost to Rank and the Account Total Locked
- Ad Assets (Extensions): CTR by Asset Type, Uplift against Ads without Assets, Ranking and Cost per Conversion Locked
- Account Structure: Campaigns, Ad Groups and Keywords, Cost per Ad Group and a Check for Overloaded Ad Groups Locked
- Bids from a Target CPA: Conversion Rate per Keyword, the Maximum Affordable CPC and Raise, Hold or Lower Locked
- Budget Pacing: Cumulative Cost, Planned Spend to Date with EOMONTH, Pacing Percentage and a Month-End Projection Locked
- What a Better Quality Score Is Worth: a Two-Way CPC Grid with Mixed References, a Heat Map and the Monthly Saving Locked
- Segments: Cost per Conversion by Device and Time of Day, Two-Condition SUMIFS and Bid Adjustments Locked
- Comparing Responsive Search Ads: CTR, Conversions per 1,000 Impressions, a Minimum-Data Rule and the Winner per Ad Group Locked
- What More Budget Would Buy: Extra Impressions, Clicks, Cost and Conversions from Impression Share Lost to Budget Locked
- Landing Page Check: Conversion Rate per Page, Slow and High-Bounce Pages, and What Slow Pages Cost in Conversions Locked
- Trend and Forecast: Weekly Clicks with SLOPE and FORECAST.LINEAR, and the Cost of the Next Four Weeks Locked
- Brand, Non-Brand and Competitor Campaigns: Cost per Conversion, ROAS by Type and What the Blended Number Hides Locked
- Account Audit: Duplicate Keywords, Keywords without Impressions, Costly Non-Converters and Spend on Low Quality Scores Locked
- Final Project: Quarterly Search Scorecard with Conversions, Cost per Conversion, Impression Share, Target Status and a Combo Chart Locked
Learner reviews
Be the first to review this course.