INTERNATIONAL KEYWORD TRAFFIC SCENARIO WORKSHEET — FIELD GUIDE Published after site-owner G03 factual review on 2026-11-16. Purpose One row = one country × language × reviewed search task × forecast horizon. Output is possible monthly Google organic clicks for the *modeled basket*. It is not measured traffic, sessions, leads, sales, market size, or a promise of rank. All rates are editable planning assumptions. Open scenario-worksheet.csv in a spreadsheet. Keep the example SIM-01 as a teaching row, then delete it before a real subtotal. All its numbers and query/page descriptions are invented. Columns A task_id: stable identifier, separate for each market task. B country: target country code, not global. C language: language of the candidate query/page. D page_task: the searcher's reviewed job and proposed page type. E horizon: e.g., third full month after publication; compare only matching horizons. F demand_monthly: documented estimate for this task in this country. Leave empty if unknown; zero only when a provider actually returned zero and the row notes that source. G provider_and_settings: provider, database/network, country, date window and source/export reference. Do not silently mix providers. H checked_on: metric retrieval date. I overlap_rule: state which related strings were excluded, used as representative or treated as independent; point to raw evidence. J low_rate; K base_rate; L stretch_rate: assumed proportion of task demand that may become clicks to your site, as decimal fractions (0.01 = 1%). Explain each rate in column P. Do not also multiply by a ranking/CTR factor already embedded in these rates. M low_clicks; N base_clicks; O stretch_clicks: formula result; empty input remains empty output. The sheet rounds to whole clicks solely for readability. P scenario_reason: why visibility, page fit, result layout and timing support the range; record comparable site evidence or explicitly say none. Q evidence_status: reviewed, held or simulated; no simulated or held row belongs in a real decision subtotal. R observed_period: fill after publication, using a consistent Search Console period. S observed_clicks: Google Search Console country/page/query slice. Preserve the report reference and understand that anonymized queries may be absent from query rows. T decision_and_owner: continue, revise, pause or stop plus decision owner and date. Formula rules For each row r: low_clicks = ROUND(F_r × J_r, 0), base_clicks = ROUND(F_r × K_r, 0), stretch_clicks = ROUND(F_r × L_r, 0). The CSV cells use IF guards so missing demand or rates return blank. Check 0 ≤ low ≤ base ≤ stretch ≤ 1. A blank is not zero. If any rate is missing, that scenario is unmodeled. Aggregation rule Filter to evidence_status=reviewed, one country and one horizon. Inspect overlap_rule and provider settings before summing each click column. Show count of held/unknown rows next to totals. Do not sum across overlapping tasks or present a basket subtotal as all organic traffic. Worked teaching row SIM-01, US/en, fictional comparison task, fictional 600 monthly searches, fictional rates 1% / 3% / 6%, resulting 6 / 18 / 36 possible clicks. This is arithmetic only, not US demand research or a recommended CTR benchmark. Remove this row from live planning. Reviewer checklist Confirm the demand source and scope; verify exact-string and close-variant handling; check task/page fit and local-language review where relevant; challenge each rate; check the horizon and formulas; keep real observations separate; approve the article and worksheet together before any release.