DATA SCHEMA
Every connected source. One governed data layer.
Hologrow organizes commerce, advertising, and analytics data into traceable tables with a documented grain, source, history window, and refresh cadence.
ACCESS CHANNELS
Use the same data in the workflow that fits.
Each channel reads from the governed Hologrow layer; connection and table health stay visible in one place.
OAuth-connected AI
Use the native sign-in flow where a supported AI client offers it—no endpoint or key to paste.
Choose an AI platform →Hologrow MCP
Connect Codex, Claude, ChatGPT, Cursor, Gemini CLI, Hermes Agent, or another compatible client.
Open MCP setup →Data Explorer
Inspect connection state, freshness, historical coverage, and whether a source needs attention.
Check data health →GOVERNED ACCESS
Designed for safe, read-only analysis.
Hologrow does not modify campaigns, bids, budgets, listings, orders, or settings in connected platforms. OAuth sessions and MCP keys can be revoked, and disconnecting a source stops future syncs.
DATA CATALOG
What kind of data are you looking for?
Choose commerce, advertising, or analytics, then open the platform you use. You can see which tables it provides and what each table contains.
The data available to each account may be different.
COMMON USES
What questions can this data answer?
These examples can help you decide which kind of data to explore.
COMMERCE
Stores, marketplaces, inventory, and finance
Sales & traffic by product and date
Daily commerce performance aligned to product, marketplace, and reporting date.
- Each record
- One product in one marketplace on one date
- Identifying fields
date,asinorproduct_id,marketplace_id- You can view
- Sales, units, sessions, page views, conversion
Orders & order items
Order-level and line-item facts for supported commerce sources.
- Each record
- One order or one item within an order
- Identifying fields
order_id,line_item_id,sku- You can view
- Quantity, item amount, tax, discount, status
Inventory & logistics
Inventory availability, FBA or warehouse health, shipments, and returns where supported.
- Each record
- One product at one location on one snapshot date
- Identifying fields
sku,asin,location_id,date- You can view
- Available, reserved, inbound, aged, returned units
Settlements & finance
Settlement, fee, reimbursement, and related money movement from supported Amazon Seller flows.
- Each record
- One settlement component or financial transaction
- Identifying fields
settlement_id,transaction_id,order_id- You can view
- Principal, fees, tax, refunds, reimbursements
Listings & catalog
Products, attributes, listing state, and marketplace context.
- Each record
- One SKU or product in one marketplace
- Identifying fields
sku,asin,product_id- Included data
- Title, brand, category, status, attributes
Amazon Vendor operations
Purchase orders, shipments, direct fulfillment, demand, margin, and forecasting reports.
- Each record
- One ASIN for one vendor in one reporting period
- Identifying fields
vendor_code,asin,purchase_order_id- You can view
- Ordered, shipped, received, inventory, demand
ADVERTISING
Campaign structure and daily performance
Amazon Ads performance
Sponsored Products, Brands, and Display entities with daily delivery and conversion measures.
- Each record
- One campaign, ad group, target, or advertised product on one date
- Identifying fields
profile_id,campaign_id,date- You can view
- Spend, impressions, clicks, orders, sales, ACoS
Google Ads performance
Customers, campaigns, ad groups, ads, keywords, and search terms where available.
- Each record
- One customer, campaign, ad group, ad, or keyword on one date
- Identifying fields
customer_id,campaign_id,date- You can view
- Cost, impressions, clicks, conversions, value
Meta Ads coverage
Paid-social delivery and conversion context for accounts where table coverage is enabled.
- Each record
- One account, campaign, ad set, or ad on one date
- Identifying fields
account_id,campaign_id,date- Verify in
- Integrations and Data Explorer for your workspace
ANALYTICS
Web behavior and organic search
Google Analytics 4
Properties, streams, and daily traffic, page, event, and conversion-oriented metrics.
- Each record
- One property with one set of dimensions on one date
- Identifying fields
property_id,date, selected dimensions- You can view
- Users, sessions, events, conversions, engagement
Google Search Console
Sites and search analytics for query, page, device, country, and date dimensions.
- Each record
- One site with selected search dimensions on one date
- Identifying fields
site_url,date,queryorpage- You can view
- Impressions, clicks, CTR, average position
YOUR WORKSPACE
See the exact tables available to your connected accounts.
Connect a source, then use Data Explorer to verify freshness and account-specific coverage.