# Ad Performance by ASIN & Date

- BigQuery table name: `amazon_ads_performance_by_child_asin_and_date`
- Available in: Amazon Ads
- Data scheme index: https://api.datadoe.com/api/v1/spec/data-scheme.md

Ads performance by product, ad or campaign, and date for Sponsored Products, Sponsored Display, and Sponsored Brands. Multiple rows can exist for the same ASIN, SKU and date. Products and Display report advertised/promoted-product sales and orders; Display units include all click-attributed purchases. Brands ad_sales and ad_orders are estimated shares of campaign totals, including brand halo; Brands same-SKU columns, clicks and impressions are null. Sponsored Brands spend uses eligible ad-creative ASINs, with same-day ad cost rescaled to campaign cost. Remaining spend uses campaign purchased-product shares. Without purchased-product data, it uses Seller Central sales, orders and sessions, or an even split among known campaign ASINs. Sales and orders allocate campaign totals by purchased-product shares, with the same fallback signals. ASIN spend and sales are split across available SKUs by same-day order-sales shares; orders use order-count shares. A zero total uses an even split for that measure. With no SKU rows, sku is null. Campaigns without any ASIN signal remain account-only. Estimates can lag the campaign report and are revised as inputs arrive. Prefer amazon_ads_performance_by_campaign_by_date for total campaign data. Sponsored Television and Amazon DSP are not included here.

- Source type: `AMAZON_ADS`
- Source ID: `d0017e92fb089c2c8c3fe65f81d08666ecb4fe937ffbce9969ce2fc7d28c805c`
- Requires a date period: yes
- Contains PII: no
- Premium table: no
- User-managed: no
- Default dataset: yes
- Rows count towards billing: yes
- Hub: https://www.datadoe.com/hub/data-scheme?source=AMAZON_ADS&table=d0017e92fb089c2c8c3fe65f81d08666ecb4fe937ffbce9969ce2fc7d28c805c

## Fetch periods

- `INITIAL` (60 days)
- `RECURRING_DAILY` (21 days)
- `RECURRING_MONTHLY` (49 days)

## Data availability

- `INTRADAY` — Intraday updates are available when source data changes during the day. Refresh: 10am, 1pm, 4pm.

## Related actions

- `AMAZON_ADS_ADS_ADD` — writes: writes rows to this table
- `AMAZON_ADS_ADS_UPDATE` — writes: writes rows to this table
- `AMAZON_ADS_ADS_REMOVE` — writes: writes rows to this table
- `AMAZON_ADS_ADS_FIND` — live: reads a fresher live value

## Search aliases

- ppc
- sponsored ads
- asin ads
- same sku

## Columns (31)

- `marketplace_id` (`TEXT`, nullable) — Amazon provided ID that represents a specific country where the Seller or Vendor operates.
- `marketplace_country_code` (`TEXT`, nullable) — ISO country code for the Amazon marketplace.
- `marketplace_country_name` (`TEXT`, nullable) — Human-readable country name for the marketplace (derived from marketplace_id).
- `seller_or_vendor_id` (`TEXT`, nullable) — DataDoe account identifier used by MCP/API calls (sellers_and_vendors_list, exports). Not unique in amazon_sellers_and_vendors_context when one account has multiple connection contexts — join that table on connection_context_id instead.
- `seller_or_vendor_name` (`TEXT`, nullable) — DataDoe connection context display name for the seller or vendor.
- `marketplace_seller_id` (`TEXT`, nullable) — Amazon Seller Central seller ID from the connection (connection_seller_id). Null when the connection has no seller ID.
- `amazon_ads_profile_id` (`TEXT`, nullable) — Amazon Ads profile identifier.
- `child_asin` (`TEXT`, nullable)
- `sku` (`TEXT`, nullable)
- `date` (`DATE`, required) — Single date may repeat.
- `product_name` (`TEXT`, nullable)
- `ad_campaign_type` (`TEXT`, required) — SPONSORED_DISPLAY / SPONSORED_PRODUCTS / SPONSORED_BRANDS
- `ad_portfolio_id` (`TEXT`, nullable) — Portfolio ID for SPONSORED_PRODUCTS campaigns. Null for SPONSORED_DISPLAY and SPONSORED_BRANDS.
- `ad_portfolio_name` (`TEXT`, nullable) — Portfolio name for SPONSORED_PRODUCTS campaigns. Null for SPONSORED_DISPLAY and SPONSORED_BRANDS.
- `ad_sales` (`NUMBER`, nullable) — Products: same-SKU click sales (7d). Display: promoted-product click sales (14d). Brands: estimated share of campaign sales (14d), including brand halo. Use ad_sales_same_sku for the product-only scope. — definition: `amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_PRODUCTS' ? raw_ads_api_report_advertised_products_sp.attributedSalesSameSku7d : amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_DISPLAY' ? raw_ads_api_report_advertised_products_sd.salesPromotedClicks : amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_TELEVISION' ? null : refined_ads_estimated_sb_performance_by_asin.estimatedSales14d`
- `ad_orders` (`NUMBER`, nullable) — Products: same-SKU click orders (7d). Display: promoted-product click orders (14d). Brands: estimated share of campaign orders (14d), including brand halo. Use ad_orders_same_sku for the product-only scope. — definition: `amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_PRODUCTS' ? raw_ads_api_report_advertised_products_sp.purchasesSameSku7d : amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_DISPLAY' ? raw_ads_api_report_advertised_products_sd.purchasesPromotedClicks : amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_TELEVISION' ? null : refined_ads_estimated_sb_performance_by_asin.estimatedOrders14d`
- `ad_sales_same_sku` (`NUMBER`, nullable) — Attributed sales of the advertised SKU only (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS). Excludes brand-halo purchases of other SKUs. Not total ad sales; campaign totals are amazon_ads_performance_by_campaign_by_date.ad_sales. Null for Sponsored Brands. — definition: `amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_PRODUCTS' ? raw_ads_api_report_advertised_products_sp.attributedSalesSameSku7d : amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_DISPLAY' ? raw_ads_api_report_advertised_products_sd.salesPromotedClicks : amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_TELEVISION' ? null : null`
- `ad_clicks` (`NUMBER`, nullable) — Clicks after Amazon removed invalid traffic. Gross clicks, including invalid traffic, are ad_gross_click_throughs. Null for Sponsored Brands.
- `ad_impressions` (`NUMBER`, nullable) — Times the ad was displayed after Amazon removed invalid traffic. Gross impressions, including invalid traffic, are ad_gross_impressions. Null for Sponsored Brands.
- `ad_spend` (`NUMBER`, nullable) — Reported Products and Display spend, or estimated Brands spend allocated to this ASIN and SKU. Sponsored Brands spend uses eligible ad-creative ASINs, with same-day ad cost rescaled to campaign cost. Remaining spend uses campaign purchased-product shares. Without purchased-product data, it uses Seller Central sales, orders and sessions, or an even split among known campaign ASINs. Sales and orders allocate campaign totals by purchased-product shares, with the same fallback signals. ASIN spend and sales are split across available SKUs by same-day order-sales shares; orders use order-count shares. A zero total uses an even split for that measure. With no SKU rows, sku is null. Campaigns without any ASIN signal remain account-only. Attribution windows do not apply to spend.
- `ad_units_sold_same_sku` (`NUMBER`, nullable) — Products: same-SKU click-attributed units (7d), excluding brand halo. Display: total click-attributed units (14d), which can include purchases of other products despite the column name. Null for Brands. — definition: `amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_PRODUCTS' ? raw_ads_api_report_advertised_products_sp.unitsSoldSameSku7d : amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_DISPLAY' ? raw_ads_api_report_advertised_products_sd.unitsSoldClicks : amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_TELEVISION' ? null : null`
- `ad_orders_same_sku` (`NUMBER`, nullable) — Attributed orders of the advertised SKU only (14d for SPONSORED_BRANDS and SPONSORED_DISPLAY, 7d for SPONSORED_PRODUCTS). Excludes brand-halo orders of other SKUs. Null for Sponsored Brands. — definition: `amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_PRODUCTS' ? raw_ads_api_report_advertised_products_sp.purchasesSameSku7d : amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_DISPLAY' ? raw_ads_api_report_advertised_products_sd.purchasesPromotedClicks : amazon_ads_performance_by_child_asin_and_date.ad_campaign_type === 'SPONSORED_TELEVISION' ? null : null`
- `ad_campaign_budget_amount` (`NUMBER`, nullable) — Campaign budget repeated on every row of the campaign. Do not sum it across ASINs, keywords, placements, or dates. ad_campaign_budget_type is DAILY_BUDGET or LIFETIME_BUDGET. Available for Sponsored Products. Null for Sponsored Display and Sponsored Brands.
- `ad_campaign_budget_type` (`TEXT`, nullable) — DAILY_BUDGET / LIFETIME_BUDGET or NULL.
- `ad_campaign_budget_currency` (`TEXT`, nullable) — Currency code for Sponsored Products and Sponsored Display. Null for Sponsored Brands.
- `ad_id` (`TEXT`, nullable) — Ad ID for Sponsored Products and Sponsored Display. Null for Sponsored Brands.
- `ad_group_id` (`TEXT`, nullable) — Ad group ID for Sponsored Products and Sponsored Display. Null for Sponsored Brands.
- `ad_campaign_id` (`TEXT`, nullable) — Campaign ID for SPONSORED_PRODUCTS, SPONSORED_DISPLAY and SPONSORED_BRANDS.
- `ad_campaign_name` (`TEXT`, nullable) — Campaign name for SPONSORED_PRODUCTS, SPONSORED_DISPLAY and SPONSORED_BRANDS.
- `ad_campaign_status` (`TEXT`, nullable) — Campaign status for SPONSORED_PRODUCTS. Null for SPONSORED_DISPLAY and SPONSORED_BRANDS.
- `is_estimated` (`LOGIC`, required) — TRUE for SPONSORED_BRANDS rows, whose ASIN-level metrics are estimated by allocating campaign-level totals down to ASINs (Amazon does not expose true SB ASIN-level data). FALSE for SPONSORED_PRODUCTS / SPONSORED_DISPLAY rows, which are reported directly.

---

Query live via DataDoe MCP `exports_source_get` (connected accounts only), or request rows with `exports_create`.