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 →AI Agents & Skills
Run reusable, read-only workflows against the same connected tables from your preferred AI client.
Browse workflow families →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.
BROWSE THE CATALOG
Schema explorer
Use the platform anchors to jump between representative governed domains. Availability can vary by account; Data Explorer is the source of truth for your workspace.
COMMERCE
Stores, marketplaces, inventory, and finance
Sales & traffic by product and date
Daily commerce performance aligned to product, marketplace, and reporting date.
- Typical grain
- Product × marketplace × date
- Business keys
date,asinorproduct_id,marketplace_id- Common measures
- Sales, units, sessions, page views, conversion
Orders & order items
Order-level and line-item facts for supported commerce sources.
- Typical grain
- Order or order line item
- Business keys
order_id,line_item_id,sku- Common measures
- Quantity, item amount, tax, discount, status
Inventory & logistics
Inventory availability, FBA or warehouse health, shipments, and returns where supported.
- Typical grain
- SKU × location × snapshot date
- Business keys
sku,asin,location_id,date- Common measures
- Available, reserved, inbound, aged, returned units
Settlements & finance
Settlement, fee, reimbursement, and related money movement from supported Amazon Seller flows.
- Typical grain
- Settlement component or transaction
- Business keys
settlement_id,transaction_id,order_id- Common measures
- Principal, fees, tax, refunds, reimbursements
Listings & catalog
Products, attributes, listing state, and marketplace context.
- Typical grain
- SKU or product × marketplace
- Business keys
sku,asin,product_id- Common fields
- Title, brand, category, status, attributes
Amazon Vendor operations
Purchase orders, shipments, direct fulfillment, demand, margin, and forecasting reports.
- Typical grain
- Vendor × ASIN × reporting period
- Business keys
vendor_code,asin,purchase_order_id- Common measures
- 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.
- Typical grain
- Campaign, ad group, target, or advertised product × date
- Business keys
profile_id,campaign_id,date- Common measures
- Spend, impressions, clicks, orders, sales, ACoS
Google Ads performance
Customers, campaigns, ad groups, ads, keywords, and search terms where available.
- Typical grain
- Customer, campaign, ad group, ad, or keyword × date
- Business keys
customer_id,campaign_id,date- Common measures
- Cost, impressions, clicks, conversions, value
Meta Ads coverage
Paid-social delivery and conversion context for accounts where table coverage is enabled.
- Typical grain
- Account, campaign, ad set, or ad × date
- Business keys
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.
- Typical grain
- Property × dimension set × date
- Business keys
property_id,date, selected dimensions- Common measures
- Users, sessions, events, conversions, engagement
Google Search Console
Sites and search analytics for query, page, device, country, and date dimensions.
- Typical grain
- Site × selected dimensions × date
- Business keys
site_url,date,queryorpage- Common measures
- Impressions, clicks, CTR, average position
SCHEMA LEGEND
How to read the catalog
Grain
The business entity represented by one row. Check it before aggregating or joining a table.
Business keys
Stable identifiers used to align related entities across tables, accounts, sources, or time.
Cadence
How often Hologrow requests and processes new source data. Availability may lag while a platform prepares reports.
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.