Analytics Marts
The channel decision model. These marts answer mejorseguroonline.com's core question: for each keyword cluster, should the next euro go to SEO, Ads, or GEO (AI-visibility) content? — Keyword Visibility (organic signal per keyword), Channel Allocation (the recommendation itself: per-cluster organic/paid/geo scores), and GEO Visibility (the LLM mention index those geo scores are built from). Rebuilt daily by dbt.
Data freshness: GEO visibility mart covers 2026-06-15 (farming start) to yesterday. Keyword Visibility and Channel Allocation are all-time mart snapshots (no date dimension) — the date selector below only filters the GEO Visibility section.
Keyword Visibility (all-time mart)
Aggregated GSC keyword performance per keyword × landing page, over the mart's full history. All clicks are currently 0 in the source data, so CTR renders 0.0% — data provenance, not a display bug.Keywords
Impressions
Clicks
CTR
Avg Position
Channel Allocation (all-time mart)
Per keyword cluster: scores for organic vs paid vs GEO investment and the recommended channel. `insufficient_data` clusters lack enough signal to score.Total Clusters
Organic
Paid
GEO
Insufficient Data
GEO Visibility
Daily LLM mention tracking per actor — filtered by the date range below.Total Mentions
Avg Visibility
Avg Sentiment