Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Reading a Search Campaign Report: CTR, Average CPC, Conversion Rate and Cost per Conversion per KeywordLabFree
  2. Keyword Match Types: Broad, Phrase and Exact Compared by Clicks, Cost, Cost per Conversion and Share of SpendLab Locked
  3. Quality Score: Expected CTR, Ad Relevance and Landing Page Experience, a Points Model and an Impression-Weighted AverageLab Locked
  4. Ad Rank and the Auction: Bid × Quality Score, the Actual CPC You Pay and the Bid Needed to Move UpLab Locked
  5. The Search Terms Report: Keywords versus Real Queries, Cost without Conversions and a Rule for ExclusionsLab Locked
  6. Negative Keywords: Finding Candidate Words with Wildcards, the Cost They Save and the Conversions They Would BlockLab Locked
  7. Search Impression Share: Eligible Impressions, Share Lost to Budget, Share Lost to Rank and the Account TotalLab Locked
  8. Ad Assets (Extensions): CTR by Asset Type, Uplift against Ads without Assets, Ranking and Cost per ConversionLab Locked
  9. Account Structure: Campaigns, Ad Groups and Keywords, Cost per Ad Group and a Check for Overloaded Ad GroupsLab Locked
  10. Bids from a Target CPA: Conversion Rate per Keyword, the Maximum Affordable CPC and Raise, Hold or LowerLab Locked
  11. Budget Pacing: Cumulative Cost, Planned Spend to Date with EOMONTH, Pacing Percentage and a Month-End ProjectionLab Locked
  12. What a Better Quality Score Is Worth: a Two-Way CPC Grid with Mixed References, a Heat Map and the Monthly SavingLab Locked
  13. Segments: Cost per Conversion by Device and Time of Day, Two-Condition SUMIFS and Bid AdjustmentsLab Locked
  14. Comparing Responsive Search Ads: CTR, Conversions per 1,000 Impressions, a Minimum-Data Rule and the Winner per Ad GroupLab Locked
  15. What More Budget Would Buy: Extra Impressions, Clicks, Cost and Conversions from Impression Share Lost to BudgetLab Locked
  16. Landing Page Check: Conversion Rate per Page, Slow and High-Bounce Pages, and What Slow Pages Cost in ConversionsLab Locked
  17. Trend and Forecast: Weekly Clicks with SLOPE and FORECAST.LINEAR, and the Cost of the Next Four WeeksLab Locked
  18. Brand, Non-Brand and Competitor Campaigns: Cost per Conversion, ROAS by Type and What the Blended Number HidesLab Locked
  19. Account Audit: Duplicate Keywords, Keywords without Impressions, Costly Non-Converters and Spend on Low Quality ScoresLab Locked
  20. Final Project: Quarterly Search Scorecard with Conversions, Cost per Conversion, Impression Share, Target Status and a Combo ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy