Deduplicating Joins Across Citation, Referral, and CRM Data
Website owners comparing citation reports with referrals and customer relationship management (CRM) outcomes need to keep the three record types separate. A…
In international SEO, country and language describe different things. Google Search Console reports the country where a search originated, but its standard performance reports do not report language. To compare results by language, label your site’s URLs with their intended language and region, then analyze their search data alongside country data.
A French-language page can serve people in several countries, and people in one country can search in more than one language. Compare similar pages, queries, and time periods. Assess each metric on its own: clicks, impressions, click-through rate, and average position. Do not combine them into one score.
Keep a list of the URLs you want to compare. For each URL, record its intended language, target region if it has one, page type, and topic or search-intent group. For example, put a French product page for France and a French product page for Canada in separate regional groups, even though both use French.
Search Console lets you view performance by country and query. It also breaks results down by page, device, date, and search type. Use these views to examine performance, and use your URL map to add language and locale labels. A locale combines a language and region, such as French for Canada. Google notes that search results do not always match the language selected for the search interface. That setting does not reliably show the language of a query or page. See Google’s explanation of multilingual searches.
Use judgment when labeling query language. Group queries by the need they express, based on local wording and meaning rather than translating keywords word for word. Mark unclear queries as uncertain instead of assigning them to a language with confidence. Search Console also omits some queries for privacy, so the query list you see does not include every search.
Decide what you want to learn before building a report. For example, ask whether localized product pages appear in their intended markets, whether similar informational pages attract clicks, or whether a market’s visibility changed after a localization update.
Compare pages and searches that serve similar purposes. Match pages by purpose and type, and group queries with similar intent in each language. Keep branded and nonbranded searches separate when brand awareness could skew the results. Use matching date ranges, and account for device and search type when they matter. Search Console lets you compare and filter these dimensions, but you must decide which pages and queries are truly comparable. Its Performance report provides the country and page data.
Do not rank countries by total clicks or impressions alone. A higher total can reflect greater visibility. It can also reflect more pages on your site or a different mix of searches. It does not show that pages perform better for equivalent searches. Search Console does not provide a complete estimate of market demand, so impressions are not a count of the people searching in a country.
Impressions show how often a result from your site appeared under Google’s counting rules. Clicks count visits from Google Search result links. Click-through rate (CTR) is clicks divided by impressions, so it shows the share of impressions that led to clicks. Average position summarizes the topmost position of your property or page when it appeared; it is not a fixed rank for a keyword in every location.
Read these metrics together. If a localized page gets impressions but few clicks, inspect the queries and how the search result looks in that market. The title and snippet might not match local wording or expectations, but the metric alone does not identify the cause. If impressions are low, check whether Google has indexed the page and which queries it appears for before concluding that demand is low. If clicks are strong but business results are weak, examine the landing page and conversion data separately.
To combine CTRs across countries, divide the group’s total clicks by its total impressions. Do not average the countries’ CTRs directly. That would give a country with few impressions the same weight as one with many. Read average position with care too. Search Console averages positions across impressions, and the types of results can differ between markets. Google recommends reading position alongside clicks and impressions in its guidance on Performance report interpretation.
Search Console can count results differently in property-level and page-level views when several URLs from your site appear for one query. These differences can change the reported CTR and position. Compare the same type of view across markets. Google explains the distinction in its Performance data documentation.
A weak result in one market does not by itself show that the content is the problem. First check whether Google can find and use the localized page intended for that market.
Give each language or regional version its own URL that search crawlers can access, and make sure its main visible content uses the intended language. Google determines a page’s language from its visible content, not from its URL or the HTML lang attribute. Its multi-regional site guidance warns that routing visitors by IP address can make some versions harder for crawlers to reach. Test sample URLs from outside the target country. Check that they do not automatically send visitors or crawlers to another locale.
Use URL Inspection in Search Console to check whether Google has indexed a sample URL and which canonical URL it selected. A canonical URL is the one Google chooses to represent a page when it finds similar or duplicate URLs. If Google selects a URL for another locale, the performance data might not appear under the page you expect.
For localized versions, check hreflang, markup that tells search engines which URLs are related language or regional alternatives. Each version should identify itself and the relevant alternatives with supported language and region codes. Google says hreflang helps it understand how localized URLs relate to one another. It does not replace accurate page content, crawler access, or canonical selection. See Google’s localized-version documentation.
Country targeting has a trade-off. A country-specific signal can help Google associate a site with that country, but it can also narrow the site’s relevance elsewhere. Use country targeting when the business serves separate markets and the pages offer useful local information. Do not create country-specific pages just to add rows to a report.
Search Console measures when your site appears in Google Search and when people click its results. Web analytics measures what visitors do after they reach your site, based on the analytics property’s data collection and attribution settings. Use Search Console to study search visibility and clicks. Use analytics to study what visitors do on the site.
Google Analytics can combine organic-search landing-page data with Search Console metrics in its Google organic search traffic report. The linked properties need to cover the same pages. It provides up to 16 months of Search Console history, and Search Console data appears in Analytics after a delay.
Search Console clicks and Analytics sessions will not necessarily match. The tools use different rules for collecting and processing data, covering pages, and setting time zones. Search Console dates use Pacific Time. Analytics uses the time zone set for its property. Check the date range and pages covered before treating a mismatch as lost traffic or a tracking failure. Google explains these Search Console data limitations.
Search Console does not show every query. Privacy protections hide some queries, and its reports limit the number of rows displayed. The Search Analytics API lets you export more rows, but it does not remove privacy omissions or other reporting limits. A query missing from a table might still have been searched.
Google documents a dedicated generative AI performance report for AI Overviews and AI Mode. The report shows impressions and lets you break them down by country, page, date, and device. Google does not document a language breakdown, so use the same URL-to-language map to analyze language. The report’s impressions show visibility in these features. They do not show conversions attributed to AI or provide a complete comparison of clicks by language and country. Google says links in AI Overviews and AI Mode count as clicks in Search Console. The dedicated impressions report still does not show all outcomes.
If an AI-search trend changes sharply, check for known reporting anomalies before linking the change to a market or SEO update. Google maintains a Search Console data anomalies log.
Give Vroni a GitHub issue, bug report, spec, or rough idea. It reads the repo, plans the change, writes code, runs checks, and works toward a review-ready pull request.
Take a look at vroni.com