Amazon’s Advertising platform produces a multitude of facts about the performance of your advertising. Jungle Scout collects this information on your behalf and provides multiple tables to give you a comprehensive view of the state of your advertising performance.

Dimension tables for Product Ads, Ad Groups, Keywords, and Campaigns can all be joined with daily fact tables. Conversion attribution data is at the daily, bi-weekly, and monthly grain.

DSP data is also available with an Advertisers dimension table and order/line item fact tables.

Jungle Scout Report Amazon Report Parameters
ad_group_headline_search_fact SB Ad Group report v2
ad_group_sponsored_display_fact SD Ad Group report v2
ad_group_sponsored_product_fact SP Campaign report v3 Group by: Ad Group
campaign_headline_search_fact SB Campaign report v2
campaign_placement_headline_search_fact SB Placement report v2
campaign_placement_sponsored_product_fact SP Campaign report v3 Group by: Placement
campaign_sponsored_display_fact SD Ad Group report v2
campaign_sponsored_product_fact SP Campaign report v3 Group by: Campaign
campaign_order_line_item_creative_fact DSP Campaign report
keyword_headline_search_fact SB Keyword report v2
keyword_sponsored_product_fact SP Targeting report v3 Filter by: Keyword
keyword_query_sponsored_product_fact SP Search Term report v3 Filter by: Keyword
keyword_query_headline_search_fact SB Search Term report v2
product_ad_sponsored_display_fact SD Product Ad report v2
product_ad_sponsored_product_fact SP Advertised Products report v3
sb_purchased_product_facts SB Purchase Product report v3
target_sponsored_product_fact SP Targeting report v3 Filter by: Target
target_headline_search_fact SB Target report v2
target_query_sponsored_product_fact SP Search Term report v3 Filter by: Target
dsp_line_item /dsp/orders API method
dsp_order /dsp/lineItems API method
inventory_order_line_item_supply_site_fact DSP Inventory report
currency_conversion Fixer API

Click here for table definitions