Connect Search Console to your Definite lakehouse in minutes.
Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.
Have multiple Search Console accounts? Analytics across multiple Search Console accounts →
Everything Search Console exposes, modeled and queryable.
Extracts Google Search performance metrics (clicks, impressions, CTR, average position) for a specified Search Console property. Data is grouped by date and can be broken down by query, page (URL), country, and device. This enables SEO analysis such as tracking rankings and CTR over time, identifying top queries and pages, monitoring device and country performance, and analyzing trends using both freshest and finalized data.
Tables & streams
Fact table of Google Search metrics (clicks, impressions, CTR, average position) aggregated for a property and broken out by dimensions like date, query, page, country, and device. Enables SEO trend tracking, ranking analysis, CTR optimization, and content performance measurement using both freshest and finalized data.
Represents the site or domain property that scopes all search performance data. Supports cross-property comparisons and rollups for multi-site SEO reporting.
Individual search terms that generated impressions and clicks. Enables keyword-level ranking, CTR, and traffic opportunity analysis.
Landing pages (URLs) on the property that appeared in search results. Supports content performance analysis, page-level ranking trends, and optimization insights.
Device category of the searcher (e.g., desktop, mobile, tablet). Enables device-level comparisons of rankings, CTR, and traffic mix.
Geographic market associated with impressions and clicks. Supports geo-segmentation, localization effectiveness, and international SEO performance.
Uses a Google service account JSON key to authenticate to your Search Console property
Requires a Search Console account to connect.
Operational data, performance metrics, and business insights.
Three steps. One afternoon.
Authenticate Search Console in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.
We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.
SQL, dashboards, or ask Fi in plain English. Your Search Console data lives next to every other source — ready to join.
Build your own with the Definite SDK, or ask us — we add new connectors every week.
