P4: Analytics Hub Pricing + Access Controls

{
  "cost": {
    "input_tokens": 221,
    "estimated_usd": 0.004538,
    "output_tokens": 1476
  },
  "model": "gemini-3-flash-preview",
  "status": "success",
  "transport": "gemini_api",
  "latency_ms": 14151,
  "response_text": "This configuration establishes the multi-tier data monetization framework for the **c8_commerce_intelligence_v2** exchange.\n\n### Part 1: Pricing Model Documentation\n\n| Tier | Price (Monthly) | Data Included | Access Policy |\n| :--- | :--- | :--- | :--- |\n| **Trade Reference** | $0 (Free) | Public domain government data, basic registration info. | Public Listing / Auto-approve |\n| **Trade Intelligence** | $500 | Derived IP, aggregated trade volumes, growth scores. | Private Listing / Manual Approval |\n| **Full Intelligence** | $2,000 | Patterns, TINN (Trade ID Network), Vendor relationships. | Private Listing / Manual Approval |\n| **Enterprise** | $5,000 | Custom views, SLA, full historical depth, raw patterns. | Private Listing / Manual Approval |\n\n---\n\n### Part 2: SQL Implementation\nTarget File: `sql/analytics_hub_tiers.sql`\n\n```sql\n/*\n  ANALYTICS HUB TIERED ACCESS VIEWS\n  Stream #22: Data Subscription Revenue\n  \n  Note: These views act as 'Authorized Views'. \n  The Analytics Hub Dataset will contain these views, while the underlying \n  raw tables remain in restricted datasets.\n*/\n\n-- 1. TRADE REFERENCE (Free Tier)\n-- Focus: Publicly available gov/customs data only.\nCREATE OR REPLACE VIEW `c8_analytics_hub.v_tier_trade_reference` AS\nSELECT \n    entity_id,\n    registration_country,\n    industry_category,\n    public_filing_date,\n    import_export_status,\n    -- No derived IP or StoreLeads data\nFROM `c8_derived.unified_trade_master`\nWHERE is_public_record = TRUE;\n\n\n-- 2. TRADE INTELLIGENCE ($500/mo)\n-- Focus: Derived IP and Growth Metrics.\nCREATE OR REPLACE VIEW `c8_analytics_hub.v_tier_trade_intelligence` AS\nSELECT \n    t.entity_id,\n    t.registration_country,\n    t.industry_category,\n    i.growth_score_percentile,\n    i.estimated_annual_volume_tier,\n    i.market_share_index,\n    i.last_activity_date\nFROM `c8_derived.unified_trade_master` t\nJOIN `c8_derived.intelligence_scores` i ON t.entity_id = i.entity_id\n-- Exclude high-sensitivity TINN and Raw StoreLeads\nWHERE i.confidence_score > 0.7;\n\n\n-- 3. FULL INTELLIGENCE ($2,000/mo)\n-- Focus: Patterns, TINN, and Vendor Relationships.\nCREATE OR REPLACE VIEW `c8_analytics_hub.v_tier_full_intelligence` AS\nSELECT \n    t.entity_id,\n    t.registration_country,\n    i.growth_score_percentile,\n    p.trade_pattern_type, -- Proprietary Pattern Logic\n    p.tinn_id,            -- Trade Identification Number Network\n    p.primary_vendor_id,\n    p.supply_chain_stability_index,\n    -- Explicitly excluding raw StoreLeads columns (e.g., contact emails/phones)\n    -- Only sharing the derived 'Technographic' summary\n    s.technographic_stack_summary \nFROM `c8_derived.unified_trade_master` t\nLEFT JOIN `c8_derived.intelligence_scores` i ON t.entity_id = i.entity_id\nLEFT JOIN `c8_derived.trade_patterns` p ON t.entity_id = p.entity_id\nLEFT JOIN `c8_derived.store_summary_derived` s ON t.entity_id = s.entity_id;\n\n\n-- 4. ENTERPRISE ($5,000/mo)\n-- Focus: Custom views + Full Data Depth (No raw StoreLeads).\nCREATE OR REPLACE VIEW `c8_analytics_hub.v_tier_enterprise` AS\nSELECT \n    t.*,\n    i.* EXCEPT(entity_id),\n    p.* EXCEPT(entity_id),\n    s.technographic_stack_summary,\n    s.estimated_revenue_bracket,\n    CURRENT_TIMESTAMP() as data_freshness_timestamp\nFROM `c8_derived.unified_trade_master` t\nLEFT JOIN `c8_derived.intelligence_scores` i ON t.entity_id = i.entity_id\nLEFT JOIN `c8_derived.trade_patterns` p ON t.entity_id = p.entity_id\nLEFT JOIN `c8_derived.store_summary_derived` s ON t.entity_id = s.entity_id;\n```\n\n---\n\n### Part 3: Access Control & Workflow Configuration\n\n#### 1. Security Configuration (Authorized Views)\nTo ensure subscribers can see the view but not the source data:\n1.  Go to the **Restricted Source Dataset** (`c8_derived`).\n2.  Click **Sharing** > **Authorize Views**.\n3.  Add the four views created above. This allows the views to query the source data even if the subscriber doesn't have access to the raw tables.\n\n#### 2. Analytics Hub Listing Setup\n*   **Listing Type:** Shared Dataset.\n*   **Dataset:** `c8_analytics_hub`.\n*   **Approval Workflow:** \n    *   Navigate to Analytics Hub > `c8_commerce_intelligence_v2` exchange.\n    *   For the **Trade Intelligence** and higher listings, toggle **\"Require lead request\"** to **ON**.\n    *   This forces a manual approval step where the sales team verifies the subscription payment before granting access.\n\n#### 3. Data Masking Policy (StoreLeads)\n*   **Rule:** No raw StoreLeads data (emails, personal phone numbers, or raw CSV exports) is included in any `c8_analytics_hub` view.\n*   **Enforcement:** The `v_tier_enterprise` view uses `EXCEPT` and explicit column selection to ensure only `technographic_stack_summary` and `estimated_revenue_bracket` are exposed from the StoreLeads-derived table.\n\n#### 4. Subscriber Provisioning\n*   **Step 1:** Subscriber requests access via Analytics Hub.\n*   **Step 2:** Admin receives email notification.\n*   **Step 3:** Admin verifies Stripe/Invoice payment for the specific tier.\n*   **Step 4:** Admin approves request, which automatically creates a linked dataset in the subscriber's project."
}