> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hologrow.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Schema

> Browse Hologrow's governed commerce, advertising, and analytics data domains.

<div className="holo-hub-page holo-doc-page holo-catalog-page">
  <section className="holo-hero holo-hero-compact">
    <p className="holo-eyebrow">DATA SCHEMA</p>
    <h1>Every connected source. One governed data layer.</h1>
    <p className="holo-lead">Hologrow organizes commerce, advertising, and analytics data into traceable tables with a documented grain, source, history window, and refresh cadence.</p>

    <div className="holo-actions">
      <a className="holo-button holo-button-primary" href="/hologrow-basics/integrations">Connect a source →</a>
      <a className="holo-button holo-button-secondary" href="/hologrow-data/data-fetch-periods">Understand refresh timing</a>
    </div>

    <div className="holo-stat-grid">
      <div className="holo-stat"><strong>Governed</strong><span>Source-aware tables</span></div>
      <div className="holo-stat"><strong>Documented</strong><span>Grain + business keys</span></div>
      <div className="holo-stat"><strong>Incremental</strong><span>Scheduled refreshes</span></div>
      <div className="holo-stat"><strong>Read-only</strong><span>Upstream stays unchanged</span></div>
    </div>
  </section>

  <section className="holo-section" id="access">
    <div className="holo-section-heading"><div><p className="holo-eyebrow">ACCESS CHANNELS</p><h2>Use the same data in the workflow that fits.</h2><p>Each channel reads from the governed Hologrow layer; connection and table health stay visible in one place.</p></div></div>

    <div className="holo-access-grid">
      <a className="holo-access-card" href="/hologrow-basics/ai-platforms"><span className="holo-icon-tile">OA</span><h3>OAuth-connected AI</h3><p>Use the native sign-in flow where a supported AI client offers it—no endpoint or key to paste.</p><span className="holo-card-link">Choose an AI platform →</span></a>
      <a className="holo-access-card" href="/mcp/mcp"><span className="holo-icon-tile">MC</span><h3>Hologrow MCP</h3><p>Connect Codex, Claude, ChatGPT, Cursor, Gemini CLI, Hermes Agent, or another compatible client.</p><span className="holo-card-link">Open MCP setup →</span></a>
      <a className="holo-access-card" href="/hologrow-basics/data-explorer"><span className="holo-icon-tile">DX</span><h3>Data Explorer</h3><p>Inspect connection state, freshness, historical coverage, and whether a source needs attention.</p><span className="holo-card-link">Check data health →</span></a>
      <a className="holo-access-card" href="/ai-agents-and-skills"><span className="holo-icon-tile">SK</span><h3>AI Agents & Skills</h3><p>Run reusable, read-only workflows against the same connected tables from your preferred AI client.</p><span className="holo-card-link">Browse workflow families →</span></a>
    </div>
  </section>

  <section className="holo-section holo-governance-panel">
    <div><div className="holo-governance-kicker"><span className="holo-governance-mark">READ-ONLY ACCESS</span><p className="holo-eyebrow">GOVERNED ACCESS</p></div><h2>Designed for safe, read-only analysis.</h2><p>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.</p></div>
    <a className="holo-button holo-button-secondary" href="/trust-safety/privacy-policy">Review privacy controls</a>
  </section>

  <section className="holo-section holo-band" id="catalog">
    <div className="holo-section-heading"><div><p className="holo-eyebrow">BROWSE THE CATALOG</p><h2>Schema explorer</h2><p>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.</p></div></div>

    <div className="holo-anchor-nav" role="navigation" aria-label="Data schema categories">
      <a href="#commerce">Commerce</a><a href="#advertising">Advertising</a><a href="#analytics">Analytics</a><a href="#schema-legend">How to read this</a>
    </div>

    <div className="holo-schema-group" id="commerce">
      <div className="holo-schema-group-heading"><div><p className="holo-eyebrow">COMMERCE</p><h2>Stores, marketplaces, inventory, and finance</h2></div><span className="holo-chip">Amazon · Shopify · Shoplazza</span></div>

      <div className="holo-schema-list">
        <div className="holo-schema-card">
          <div className="holo-schema-summary"><div><h3>Sales & traffic by product and date</h3><p>Daily commerce performance aligned to product, marketplace, and reporting date.</p></div><div className="holo-meta-row"><span>SYNCED</span><span>DAILY</span><span>STANDARD</span></div></div>
          <div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>Product × marketplace × date</dd></div><div><dt>Business keys</dt><dd><code>date</code>, <code>asin</code> or <code>product\_id</code>, <code>marketplace\_id</code></dd></div><div><dt>Common measures</dt><dd>Sales, units, sessions, page views, conversion</dd></div></dl></div>
        </div>

        <div className="holo-schema-card">
          <div className="holo-schema-summary"><div><h3>Orders & order items</h3><p>Order-level and line-item facts for supported commerce sources.</p></div><div className="holo-meta-row"><span>SYNCED</span><span>HISTORY + DAILY</span><span>READ-ONLY</span></div></div>
          <div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>Order or order line item</dd></div><div><dt>Business keys</dt><dd><code>order\_id</code>, <code>line\_item\_id</code>, <code>sku</code></dd></div><div><dt>Common measures</dt><dd>Quantity, item amount, tax, discount, status</dd></div></dl></div>
        </div>

        <div className="holo-schema-card">
          <div className="holo-schema-summary"><div><h3>Inventory & logistics</h3><p>Inventory availability, FBA or warehouse health, shipments, and returns where supported.</p></div><div className="holo-meta-row"><span>SYNCED</span><span>DAILY</span><span>SOURCE-SPECIFIC</span></div></div>
          <div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>SKU × location × snapshot date</dd></div><div><dt>Business keys</dt><dd><code>sku</code>, <code>asin</code>, <code>location\_id</code>, <code>date</code></dd></div><div><dt>Common measures</dt><dd>Available, reserved, inbound, aged, returned units</dd></div></dl></div>
        </div>

        <div className="holo-schema-card">
          <div className="holo-schema-summary"><div><h3>Settlements & finance</h3><p>Settlement, fee, reimbursement, and related money movement from supported Amazon Seller flows.</p></div><div className="holo-meta-row"><span>SYNCED</span><span>DAILY</span><span>FINANCE</span></div></div>
          <div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>Settlement component or transaction</dd></div><div><dt>Business keys</dt><dd><code>settlement\_id</code>, <code>transaction\_id</code>, <code>order\_id</code></dd></div><div><dt>Common measures</dt><dd>Principal, fees, tax, refunds, reimbursements</dd></div></dl></div>
        </div>

        <div className="holo-schema-card">
          <div className="holo-schema-summary"><div><h3>Listings & catalog</h3><p>Products, attributes, listing state, and marketplace context.</p></div><div className="holo-meta-row"><span>SYNCED</span><span>PERIODIC</span><span>CATALOG</span></div></div>
          <div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>SKU or product × marketplace</dd></div><div><dt>Business keys</dt><dd><code>sku</code>, <code>asin</code>, <code>product\_id</code></dd></div><div><dt>Common fields</dt><dd>Title, brand, category, status, attributes</dd></div></dl></div>
        </div>

        <div className="holo-schema-card">
          <div className="holo-schema-summary"><div><h3>Amazon Vendor operations</h3><p>Purchase orders, shipments, direct fulfillment, demand, margin, and forecasting reports.</p></div><div className="holo-meta-row"><span>SYNCED</span><span>REPORT CADENCE</span><span>VENDOR</span></div></div>
          <div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>Vendor × ASIN × reporting period</dd></div><div><dt>Business keys</dt><dd><code>vendor\_code</code>, <code>asin</code>, <code>purchase\_order\_id</code></dd></div><div><dt>Common measures</dt><dd>Ordered, shipped, received, inventory, demand</dd></div></dl></div>
        </div>
      </div>
    </div>

    <div className="holo-schema-group" id="advertising">
      <div className="holo-schema-group-heading"><div><p className="holo-eyebrow">ADVERTISING</p><h2>Campaign structure and daily performance</h2></div><span className="holo-chip">Amazon Ads · Google Ads · Meta</span></div>

      <div className="holo-schema-list">
        <div className="holo-schema-card"><div className="holo-schema-summary"><div><h3>Amazon Ads performance</h3><p>Sponsored Products, Brands, and Display entities with daily delivery and conversion measures.</p></div><div className="holo-meta-row"><span>SYNCED</span><span>DAILY</span><span>ADS</span></div></div><div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>Campaign, ad group, target, or advertised product × date</dd></div><div><dt>Business keys</dt><dd><code>profile\_id</code>, <code>campaign\_id</code>, <code>date</code></dd></div><div><dt>Common measures</dt><dd>Spend, impressions, clicks, orders, sales, ACoS</dd></div></dl></div></div>
        <div className="holo-schema-card"><div className="holo-schema-summary"><div><h3>Google Ads performance</h3><p>Customers, campaigns, ad groups, ads, keywords, and search terms where available.</p></div><div className="holo-meta-row"><span>SYNCED</span><span>DAILY</span><span>ADS</span></div></div><div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>Customer, campaign, ad group, ad, or keyword × date</dd></div><div><dt>Business keys</dt><dd><code>customer\_id</code>, <code>campaign\_id</code>, <code>date</code></dd></div><div><dt>Common measures</dt><dd>Cost, impressions, clicks, conversions, value</dd></div></dl></div></div>
        <div className="holo-schema-card"><div className="holo-schema-summary"><div><h3>Meta Ads coverage</h3><p>Paid-social delivery and conversion context for accounts where table coverage is enabled.</p></div><div className="holo-meta-row"><span>EXPANDING</span><span>AVAILABILITY VARIES</span><span>ADS</span></div></div><div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>Account, campaign, ad set, or ad × date</dd></div><div><dt>Business keys</dt><dd><code>account\_id</code>, <code>campaign\_id</code>, <code>date</code></dd></div><div><dt>Verify in</dt><dd>Integrations and Data Explorer for your workspace</dd></div></dl></div></div>
      </div>
    </div>

    <div className="holo-schema-group" id="analytics">
      <div className="holo-schema-group-heading"><div><p className="holo-eyebrow">ANALYTICS</p><h2>Web behavior and organic search</h2></div><span className="holo-chip">GA4 · Search Console</span></div>

      <div className="holo-schema-list">
        <div className="holo-schema-card"><div className="holo-schema-summary"><div><h3>Google Analytics 4</h3><p>Properties, streams, and daily traffic, page, event, and conversion-oriented metrics.</p></div><div className="holo-meta-row"><span>SYNCED</span><span>DAILY</span><span>WEB</span></div></div><div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>Property × dimension set × date</dd></div><div><dt>Business keys</dt><dd><code>property\_id</code>, <code>date</code>, selected dimensions</dd></div><div><dt>Common measures</dt><dd>Users, sessions, events, conversions, engagement</dd></div></dl></div></div>
        <div className="holo-schema-card"><div className="holo-schema-summary"><div><h3>Google Search Console</h3><p>Sites and search analytics for query, page, device, country, and date dimensions.</p></div><div className="holo-meta-row"><span>SYNCED</span><span>DAILY</span><span>SEARCH</span></div></div><div className="holo-schema-details"><dl><div><dt>Typical grain</dt><dd>Site × selected dimensions × date</dd></div><div><dt>Business keys</dt><dd><code>site\_url</code>, <code>date</code>, <code>query</code> or <code>page</code></dd></div><div><dt>Common measures</dt><dd>Impressions, clicks, CTR, average position</dd></div></dl></div></div>
      </div>
    </div>
  </section>

  <section className="holo-section" id="schema-legend">
    <div className="holo-section-heading"><div><p className="holo-eyebrow">SCHEMA LEGEND</p><h2>How to read the catalog</h2></div></div>

    <div className="holo-grid-3">
      <div className="holo-info-card"><h3>Grain</h3><p>The business entity represented by one row. Check it before aggregating or joining a table.</p></div>
      <div className="holo-info-card"><h3>Business keys</h3><p>Stable identifiers used to align related entities across tables, accounts, sources, or time.</p></div>
      <div className="holo-info-card"><h3>Cadence</h3><p>How often Hologrow requests and processes new source data. Availability may lag while a platform prepares reports.</p></div>
    </div>
  </section>

  <section className="holo-final-cta">
    <div><p className="holo-eyebrow">YOUR WORKSPACE</p><h2>See the exact tables available to your connected accounts.</h2><p>Connect a source, then use Data Explorer to verify freshness and account-specific coverage.</p></div>
    <a className="holo-button holo-button-primary" href="/hologrow-basics/data-explorer">Open Data Explorer →</a>
  </section>
</div>