Addin for Excel — GSC Warehouse — Exporter GA4 — Exporter GSC

Analytics Edge GSC Warehouse

Power of a data warehouse. Privacy of a desktop app. 

Sync your Google Search Console data into a lightning-fast, local database for interactive exploration. See page+query+country+device metrics instantly. Click-to-filter or use the advanced filter wizard. Build your own custom query with the conversational AI query assistant, or connect to your desktop AI client via the built-in MCP server. 

Own your data. Own your data analysis.

Combining Analytics Edge connector technology with the latest in desktop databases, the GSC Warehouse creates a local repository for your search data. Packed with features like scheduled refresh, automatic backup, simple team sharing, and a report library, the GSC Warehouse removes the restrictions to accessing your data. 

Plug-and-Play Data Engineering

  • It is a local desktop application that includes a high-performance DuckDB database engine
  • It can download GSC data from the API or from BigQuery
  • Choose Google logins or service accounts, and bring your own AI API keys
  • It cleans the URL and Query fields to improve data quality; raw versions also available
  • GSC metrics include clicks, impressions, ctr, position, # queries and # pages
  • Dimensions include date, raw_url, url, page, server, folder, raw_query, query, country, device, search type and search appearance

Enterprise Power, Desktop Package

  • It organizes data sources into ‘client’ databases for consolidated reporting
    • e.g. GSC data from multiple subdomains or related domains
  • It can update/refresh the data automatically overnight or on demand
  • The database files are local to the computer for data integrity
    • automatic backups can be put on a shared drive for team member access
  • The exploration page has the familiar metric tiles + time-series chart + detailed table with selectable date ranges
  • The user can select metrics and dimensions with simple selections
  • Use a preset date range or a custom range, with compare to previous period, or previous year, or a custom date range
  • Clicking on a value in the table interactively filters by that value, or open the advanced filter panel
  • The data from the chart and table can be copied (tsv) / exported (csv) any time
  • The user can save the current selections as a ‘report’ for that client or as a template for any client

Designed for AI

  • Includes an AI-assisted Query Generator — an integrated AI chat to query the database
    • the AI cannot see the data, only the database schema
    • the AI Assistant uses an AI API key supplied by the user for Anthropic, Gemini or OpenAI
  • Queries can be saved for the specific client or as a template
  • Includes a library of preset queries like a cannibalization report or a content decay report
    • preset queries can be modified and saved as your own template
  • An integrated MCP server can be used to connect their own AI desktop client (like Claude Desktop)
    • the AI would have read-only access to your data in this scenario

Total Data Ownership, Limitless Exploration

  • There are no account or usage limits in the product
    • subject to API limits which should not be a problem with daily refreshes
  • There is no limit to the number of client databases
  • There is no limit to the number of rows that can be copied or exported
  • The database files are open and can be queried from other tools
  • Privacy-first design: the app uses direct connections to the APIs and there is no usage tracking
    • your data doesn’t pass through an intermediate server
    • your account credentials are stored in your database, not on a third-party server
  • The application is available with a perpetual software license and one year of software maintenance
    • it is yours to use, forever
    • after the first year, there is optional software maintenance
    • software maintenance entitles you to upgrades and license transfer