hreflang Audit: Failed Checks per URL, Status Rules, Failures per Check and the Pass Rate
Lessons in this course
- Market Demand, Demand Share and Capture Rate: Sizing the International SEO OpportunityFree
- Market Prioritisation Scorecard: Weights, SUMPRODUCT Scores, RANK.EQ and Launch Waves Locked
- Language vs Country Targeting: SUMIFS Language Totals, Demand Shares and Version Rules Locked
- Language and Country Coverage: a Localised-Page Matrix, Coverage Rates and the Weakest Page Group Locked
- Translation Cost Estimate: Words, Rates per Language with XLOOKUP, Fees and Cost per Page Locked
- Traffic Potential per Keyword: Expected CTR by Position, Potential Visits and Orders Locked
- Cost vs Traffic: Monthly Gross Profit, Payback Months, Go/Hold Rule and Rank Locked
- Local Keyword Demand: Literal Translation vs Local Term, Ratios, Best Term and Missed Demand Locked
- Keyword Cluster Grid: Cluster and Market Totals, Mixed-Reference Shares and the Strongest Market Locked
- Market Visibility Index: Expected Clicks, CTR Lookup with IFERROR, Weighted Position and Page-One Share Locked
- Market-Level Conversion: Conversion Rate, Revenue per Session, an Index vs the Site and Assessments Locked
- The Cost of the Wrong Language: Local vs Fallback Conversion, Orders Lost and Revenue Lost Locked
- hreflang Audit: Failed Checks per URL, Status Rules, Failures per Check and the Pass Rate Locked
- Rollout Plan within a Budget: ROI, Cumulative Cost, Funding Rule and Funded Profit Locked
- Ramp-Up Forecast: Slope, Intercept, FORECAST.LINEAR and the Month a Target Is Reached Locked
- What-If Grid: Net Profit by CTR and Conversion with Mixed References and Break-Even Conversion Locked
- Testing Human Edit vs Machine Translation: Pooled Rate, z-Test and p-Value Locked
- Translation Quality Sampling: Weighted Error Points, Pass Rule, AVERAGEIFS by Language and Rework Cost Locked
- Net Revenue in Euros: Removing VAT, Currency Rates with XLOOKUP and Market Shares Locked
- Final Project: International SEO Scorecard with Conversion, Profit after Cost, ROI, Rank, Chart and Flags Locked