Technical Reference
Technical entry point for DataHawk source systems, schemas, tables, grains, joins, and SQL references.
Use Technical Reference when you need implementation details: source systems, table families, grain, joins, SQL patterns, or the source-of-truth column reference. If you need the business meaning first, start with the Data & Metrics Guide. The complete live list of schemas, tables, columns, and data types lives in the Exhaustive Column Referential; these docs help you understand how to navigate it and which reference page to open next.
Start here
Find Tables and Columns
Learn how to use the source-of-truth schema reference to find tables, columns, grains, and field definitions.
Source Systems & Freshness
Map DataHawk data types to source APIs, schemas, account requirements, and refresh fields.
Product Data Reference
Identifiers, product joins, listing quality, competitors, pricing, and offers.
SEO & Keyword Data
Keyword research, search volume, organic rank, and sponsored rank tables.
Sales Estimates Data
V7 sales estimate tables, deprecated aliases, key columns, grain, and refresh behavior.
Daily Exchange Rate Dataset
Exchange-rate table source, schema, columns, and currency conversion behavior.
Schema families at a glance
DataHawk organizes data into schema families. Use this as orientation only; use the Exhaustive Column Referential for the current table and column list.
| Schema | What's in it | When to look here |
|---|---|---|
ADVERTISING | Amazon and Walmart advertising performance | Campaign, keyword, product, account, and placement metrics |
FINANCE | Seller orders, profit, P&L, fees, taxes | Revenue, margin, cost-of-goods, financial events |
PRODUCT | Product catalog, listing quality, offers, competitors, estimates | Product tracking, Buy Box, pricing, LQS, competitor analysis |
MARKET | Top-100 category data and market-level estimates | Category sizing and competitive landscape work |
SELLING_PARTNER | Seller/Vendor Central source reports | Inventory, returns, replenishment, Brand Analytics, Vendor data |
SEO | Keyword ranks and search volume | Organic rank, sponsored rank, keyword demand |
REPORTS | Curated business-ready tables | Dashboard-style queries without rebuilding joins |
REFERENTIAL | Reference data | Marketplaces, accounts, tracked entities, tags, currency rates |
RAW_INVENTORY | Raw FBA inventory snapshots and ledger events | Low-level inventory analysis |
USAGE | Snowflake usage and credit tracking | Query history and credit consumption |
Common data flows
These simplified flows help you choose the right family before opening the Sheet.
Profit and finance
FINANCE_EVENTS
FINANCE_PROFIT_LEDGER
FINANCE_PROFIT / FINANCE_PROFIT_LOSS
FINANCE_PRODUCT_PROFIT_LOSSFor profit-specific fields, event timing, and use-case queries, see Amazon Seller Profit Data.
Inventory
SELLER_INVENTORY_LEDGER_DETAIL
SELLER_INVENTORY_LEDGER_SUMMARY
SELLER_INVENTORY_FBA_HISTORY_DAILY
SELLER_INVENTORY_FBA_PLANNINGFor inventory examples and operational query patterns, see Amazon Inventory Data.
Advertising
ADVERTISING_ACCOUNT_METRICS
ADVERTISING_CAMPAIGN_METRICS
ADVERTISING_KEYWORD_METRICS_V2
ADVERTISING_PRODUCT_METRICSFor Walmart-specific advertising tables, see Walmart Advertising Data.
Sales estimates
PRODUCT.PRODUCT_SALES_ESTIMATES
MARKET.PRODUCT_SALES_ESTIMATES
REPORTS.REPORT_MARKET_BEST_SELLER_RANK_AND_ESTIMATESFor V7 tables, aliases, key columns, grain, and FAQ, see Sales Estimates Data.
Specialized references
Amazon Advertising Data
Amazon Ads API, DSP, Brand Store, account, campaign, keyword, and product table families.
Walmart Advertising Data
Walmart Connect ad-group, item, keyword, placement, and platform tables.
Amazon Brand Analytics Data
Search Query Performance, Search Terms, Market Basket, and Repeat Purchases.
Amazon DataHawk Reports
Curated report tables designed for analytics and executive reporting.
Amazon Returns Data
FBA and FBM return tables, order joins, and reason-code mappings.
Amazon Replenishment Data
Subscribe & Save table names, grain, fields, joins, and deprecated source tables.