Open the CSV in Excel, or import it into Google Sheets and choose comma-separated values. Save your working copy in a controlled location. The CSV contains the rows below and space for your notes; it has no macros, formulas or live account connection. The separate Excel workbook contains editable example inputs and formulas that update the forecast.
How to use the template
Map the funnel first
Take last week's link clicks and landing page views from Meta Ads Manager, and add to cart, checkout started and purchases from your Meta events or GA4. The Funnel tab shows which step keeps the smallest share of visitors and how many purchases one improved step would add, so you start the audit where the money leaks.
Run the 25 two-minute tests
Open your best-spending ad and its landing page on a real phone. Work through message match, speed, offer clarity, trust, mobile layout, checkout and tracking. Mark each check Pass, Partial, Fail or N/A. Use PageSpeed Insights field data for the Core Web Vitals and Meta Ads Data Advisor plus Events Manager test events for tracking.
Rank fixes by impact and effort
Score each failed or partial check for impact on sales and effort to fix, both from 1 to 5. The workbook ranks them by impact x (6 - effort), with partial passes at half weight, and lists your top five fixes on the Scorecard tab with the owner and status.
Fix, re-test, compare
Fix tracking first so you can measure the rest, then the quick wins. Re-run the same tests, save a dated copy of the workbook, and compare the funnel a week later with the ads unchanged so you measure the page, not a new campaign.
Preview the worksheet
Every row shown here is included in the download. Scroll the table horizontally on a small screen.
| # | Group | Check |
|---|---|---|
| 1 | Message match | The headline repeats the ad's main promise |
| 2 | Message match | The offer, price and code from the ad are visible without scrolling |
| 3 | Message match | The product or person in the ad also appears on the page |
| 4 | Message match | Each ad sends people to the most specific page |
| 5 | Speed | LCP (main content shown) is 2.5 seconds or less on mobile |
| 6 | Speed | INP (response to taps) is 200 milliseconds or less |
| 7 | Speed | CLS (layout jumping) is 0.1 or less |
| 8 | Speed | The ad link loads the page directly, with no redirect chain |
| 9 | Offer clarity | In 5 seconds a stranger can say what it is, who it's for and why now |
| 10 | Offer clarity | The total price, including shipping, is clear before checkout |
| 11 | Offer clarity | There is one clear main action, and its button says what happens |
| 12 | Offer clarity | Delivery time and returns are stated near the buy button |
| 13 | Trust and proof | Reviews show a star rating and a count, near the buy button |
| 14 | Trust and proof | Real photos or videos show the product in use |
| 15 | Trust and proof | Guarantee, returns policy and contact details are easy to find |
| 16 | Trust and proof | Checkout looks secure and familiar |
| 17 | Mobile layout | The buy button is easy to reach on a phone |
| 18 | Mobile layout | Text is readable and buttons are easy to tap, with no sideways scroll |
| 19 | Mobile layout | No pop-up covers the page in the first seconds |
| 20 | Checkout friction | Guest checkout is available |
| 21 | Checkout friction | Express wallets and the payment methods your buyers expect are offered |
| 22 | Checkout friction | Forms are short, use autofill and show clear errors |
| 23 | Tracking | The purchase event fires once per order, with the right value and currency |
| 24 | Tracking | Click IDs and UTM parameters survive redirects and checkout |
| 25 | Tracking | Every funnel step is tracked: view, add to cart, checkout, purchase |
Worked review example
Fictional shop: 10,000 link clicks became 7,600 landing page views, 4,100 engaged visitors, 520 adds to cart, 260 checkouts and 150 purchases (1.5% of clicks). The add-to-cart step kept only 12.7% of engaged visitors, the biggest leak.
The audit found 11 failed checks and 3 partial passes, a weighted score of 49%. The top fixes by impact x effort were matching the headline to the ad, showing the total price including shipping, turning on guest checkout and making the purchase event fire once per order.
What this template does and does not establish
A checklist score is not a conversion forecast, and the published studies cited in the guide describe other businesses. Default weights, impact and effort scores are starting points to change. The workbook has no connection to your site, analytics or ad account; example results and funnel counts are fictional.
Primary references
- web.dev: Web Vitals
- web.dev: Core Web Vitals thresholds
- web.dev: Vodafone LCP case study
- web.dev: Milliseconds make millions
- Baymard Institute: Cart abandonment rate
- Google: About PageSpeed Insights
- Meta: Deduplicate Pixel and server events
