G02 CROSS-MARKET KEYWORD RECONCILIATION WORKSHEET Status: Published after site-owner review on 2026-11-13; the practice case remains entirely simulated. Version: 2026-11-13 Purpose Relate country discovery runs that began from one source seed without turning different exact queries or search tasks into one global keyword row. This is an editorial decision worksheet, not a Google-prescribed data format or a source of measured keyword demand. Before use Keep every raw export unchanged. Record its provider or source, target country, query language, retrieval date, settings and file/report reference. A source seed is an input hypothesis, not evidence that a local phrase is used. IDENTIFIERS source_seed_id: the input prompt used to start discovery; may relate to several concepts. concept_id: a shared business/problem concept for comparison across markets; never a page or intent decision. market_query_id: one exact query string in one country-language pair; do not reuse across countries. task_id: one provisional or validated search task within one market; may contain multiple market_query_id values only after review. evidence_ref: dated source or SERP/language-review record supporting a decision; retain raw file/location details. BLANK DECISION ROW — copy once per market-specific exact query source_seed_id: concept_id: market_query_id: country_code: language_code: query_exact: raw_source_ref: provider_intent_label_if_any: task_hypothesis: target_page_type_hypothesis: serp_evidence_ref_and_location_method: language_reviewer_ref: related_query_id_if_any: relation_to_related_query: exact_repeat / possible_variant / same_task / different_task / unresolved task_id_if_validated: decision: reuse_query_id / keep_separate / group_for_one_market_task / hold / reject_for_this_task reason: next_check_and_owner: decision_reviewer_and_date: DECISION GATES 1. Compare country, language and exact query. An exact repeat inside one market reuses the same market_query_id but adds a new raw source/evidence reference. Identical text in another market gets another market_query_id. 2. Similar spelling, translation, normalized text or shared concept only proposes a relation. Preserve both original strings and both source references. 3. Write the user task and plausible page type separately for each market. A provider intent tag or shared source seed is a clue, not a merge instruction. 4. Review a documented target-market SERP sample and destination pages for each exact query. Record date, device, region/location method, visible location, URLs, page types, and important limits. An incognito window alone is not a target-country setting. Obtain a competent language review before using a phrase as customer-facing local copy. 5. Group two queries under one market task_id only when their task, page type, business offer and reviewed evidence support one page job. If the sample is mixed or incomplete, hold and name the missing check. Never group two countries under a single task_id for URL planning. 6. Only after a market task is validated, hand it to the separate keyword-to-URL mapping workflow. This worksheet does not assign canonical or hreflang tags. SIMULATED PRACTICE CASE — NOT OBSERVED SERP OR LOCAL-LANGUAGE ADVICE Every query, result pattern, evidence reference, reviewer and decision below is invented solely to demonstrate how the fields link. Do not import these rows as market evidence or reuse the words as recommended US/GB keywords. Source seed S-01: "team planning tools"; concept C-01: software and resources for coordinating a team. This concept label carries no search-intent verdict. Q-US-01 | US | en | "team planning software" | S-01 / C-01 SIMULATED raw source: SIM-EXPORT-US-01. SIMULATED sample SIM-SERP-US-01 shows software comparison pages under an assumed US setup. Hypothetical task: compare software options. Provisional task T-US-SOFTWARE. Decision: HOLD until an actual US SERP capture, source settings and accountable review exist. Q-GB-01 | GB | en | "team planning software" | S-01 / C-01 Same exact spelling as Q-US-01 but a distinct market_query_id. SIMULATED sample SIM-SERP-GB-01 is mixed between software and templates. Decision: HOLD and do not assign T-US-SOFTWARE to GB. Next check: inspect actual GB results and resolve whether one or more page tasks appear. Q-GB-02 | GB | en | "team planning template" | S-01 / C-01 Different exact string from Q-GB-01, so it remains a separate query record. SIMULATED sample SIM-SERP-GB-02 shows template pages. Hypothetical task: obtain a planning template; provisional task T-GB-TEMPLATE. Decision: HOLD until real GB SERP and language review. If real evidence later confirms the task, keep it separate from a software-comparison task even though both relate to C-01. SIMULATED second export SIM-EXPORT-US-02 repeats Q-US-01. Reuse Q-US-01 and append the second source reference. Do not count it as a new query, and do not silently replace the first source or change its task decision. QUALITY CHECK BEFORE HANDOFF - Can every market_query_id resolve to one country, one language and one exact string? - Are all raw sources and dated evidence references still retrievable? - Did an exact repeat only add evidence, while another country got a new query ID? - Is every same-task grouping supported by a stated task, page type, business fit, documented target-country result sample and reviewer? - Are conflicting or mixed-intent samples on hold with a named next check? - Does each validated task_id belong to one market only? - Are provisional source-seed, AI, translation and provider labels visibly separated from reviewed local-language and SERP conclusions? References checked 2026-11-13 - Google Search Console dimensions: https://support.google.com/webmasters/answer/17011259?hl=en - Google localized page versions: https://developers.google.com/search/docs/specialty/international/localized-versions - Ahrefs intent label limitations: https://help.ahrefs.com/en/articles/9973393-how-to-filter-keywords-based-on-search-intent-and-other-useful-attributes - Ahrefs clustering interpretation: https://ahrefs.com/blog/keyword-clustering/