Tabellab

Traffic Potential per Keyword: Expected CTR by Position, Potential Visits and Orders

Lesson 6 of 20 Lab 🔒 Locked

Lessons in this course

  1. Market Demand, Demand Share and Capture Rate: Sizing the International SEO OpportunityLabFree
  2. Market Prioritisation Scorecard: Weights, SUMPRODUCT Scores, RANK.EQ and Launch WavesLab Locked
  3. Language vs Country Targeting: SUMIFS Language Totals, Demand Shares and Version RulesLab Locked
  4. Language and Country Coverage: a Localised-Page Matrix, Coverage Rates and the Weakest Page GroupLab Locked
  5. Translation Cost Estimate: Words, Rates per Language with XLOOKUP, Fees and Cost per PageLab Locked
  6. Traffic Potential per Keyword: Expected CTR by Position, Potential Visits and OrdersLab Locked
  7. Cost vs Traffic: Monthly Gross Profit, Payback Months, Go/Hold Rule and RankLab Locked
  8. Local Keyword Demand: Literal Translation vs Local Term, Ratios, Best Term and Missed DemandLab Locked
  9. Keyword Cluster Grid: Cluster and Market Totals, Mixed-Reference Shares and the Strongest MarketLab Locked
  10. Market Visibility Index: Expected Clicks, CTR Lookup with IFERROR, Weighted Position and Page-One ShareLab Locked
  11. Market-Level Conversion: Conversion Rate, Revenue per Session, an Index vs the Site and AssessmentsLab Locked
  12. The Cost of the Wrong Language: Local vs Fallback Conversion, Orders Lost and Revenue LostLab Locked
  13. hreflang Audit: Failed Checks per URL, Status Rules, Failures per Check and the Pass RateLab Locked
  14. Rollout Plan within a Budget: ROI, Cumulative Cost, Funding Rule and Funded ProfitLab Locked
  15. Ramp-Up Forecast: Slope, Intercept, FORECAST.LINEAR and the Month a Target Is ReachedLab Locked
  16. What-If Grid: Net Profit by CTR and Conversion with Mixed References and Break-Even ConversionLab Locked
  17. Testing Human Edit vs Machine Translation: Pooled Rate, z-Test and p-ValueLab Locked
  18. Translation Quality Sampling: Weighted Error Points, Pass Rule, AVERAGEIFS by Language and Rework CostLab Locked
  19. Net Revenue in Euros: Removing VAT, Currency Rates with XLOOKUP and Market SharesLab Locked
  20. Final Project: International SEO Scorecard with Conversion, Profit after Cost, ROI, Rank, Chart and FlagsLab Locked