Analytics keywords report

Connect Search Console to GA4

GA4 -> Admin -> Product links -> Search Console links -> Link. Pick your Search Console property and the GA4 web stream. This enables the Search Console reports inside GA4 - Queries and Google organic search traffic. Without this link, GA4 has no keyword data at all (GA4 sees sessions; Search Console sees queries; the link bridges them).

Publish the Search Console reports inside GA4

Once linked, the reports exist but aren't published by default. GA4 -> Library -> Search Console collection -> Publish. Now Queries and Google organic search traffic appear in your Reports navigation. This is the GA4-native view; it's limited but free.

Set up the GA4 conversion mapping per landing page

The bridge between keyword and revenue is the landing page. Search Console knows query -> landing page. GA4 knows landing page -> session -> conversion. Join on landing page. In GA4, build a custom exploration: Dimensions = Landing page; Metrics = Sessions, Conversions, Total revenue. Filter to Session source = google / medium = organic.

Export Search Console data via the API for richer joins

GA4's UI caps at 1,000 rows. For real analysis, pull Search Console data via its API (or the Looker Studio connector). Endpoint: searchanalytics.query. Pull dimensions [query, page, country, device] - lets you slice by branded vs non-branded, by device, by market. Export to Google Sheets or BigQuery for the join.

// Search Console API - Node
const { google } = require('googleapis');
const sc = google.searchconsole({ version: 'v1', auth });
const res = await sc.searchanalytics.query({
  siteUrl: 'sc-domain:shuttergen.com',
  requestBody: {
    startDate: '2026-04-21',
    endDate: '2026-05-20',
    dimensions: ['query', 'page', 'device'],
    rowLimit: 25000,
    dataState: 'final'
  }
});

Pull matching GA4 conversion data via Data API

GA4 Data API returns conversions, revenue, sessions per landing page. Pull the same date range. Dimensions = pagePath; Metrics = sessions, conversions, totalRevenue, engagementRate. Filter sessionDefaultChannelGroup = 'Organic Search'. Join to Search Console output on page = pagePath.

// GA4 Data API - Node
const response = await analyticsDataClient.runReport({
  property: 'properties/123456789',
  dateRanges: [{ startDate: '2026-04-21', endDate: '2026-05-20' }],
  dimensions: [{ name: 'landingPage' }],
  metrics: [
    { name: 'sessions' },
    { name: 'conversions' },
    { name: 'totalRevenue' }
  ],
  dimensionFilter: {
    filter: {
      fieldName: 'sessionDefaultChannelGroup',
      stringFilter: { value: 'Organic Search' }
    }
  }
});

Join the two datasets on landing page

In your spreadsheet or BI tool, join Search Console rows to GA4 rows on page URL. The resulting table: query | page | clicks | impressions | position | sessions | conversions | revenue. This is the analytics keywords report. Every keyword now has revenue attached, not just clicks.

Visualize in Looker Studio for ongoing access

Looker Studio has native connectors for both Search Console and GA4. Build the joined report once; refresh automatically. Standard sections: top revenue-driving queries, query-level CTR by position bucket, branded vs non-branded split, device split, week-over-week deltas. Share with the team via link; auto-updates daily.

Build the weekly review cadence

A report no one reads is dead. Block 15 minutes weekly: scan top 20 revenue queries for week-over-week drops, scan top 20 by impressions for new query opportunities, flag landing pages with high impressions + low CTR (under-optimized titles), flag queries with high clicks + low conversion (intent mismatch). Document 2-3 actions per week.