Instructional Queries
      Back to home
      1. Knowledge Base
      2. Intentwise Explore (AMC)
      3. Instructional Queries

      ASIN Purchase Overlap Upsell

      Discover upsell and cross-sell opportunities with the ASIN Purchase Overlap Upsell dashboard, analyzing product combinations buyers frequently purchase together.

      ASIN Purchase Overlap Upsell

      The ASIN Purchase Overlap Upsell dashboard helps you identify which products are frequently purchased together. By analyzing overlap patterns between ASINs, you can uncover upsell and cross-sell opportunities, optimize bundles, and enhance remarketing strategies.   

      Top 5 ASIN Combinations With High Overlap Purchasers

      Key Metrics

      • Lead ASIN: The primary product purchased.

      • Overlap ASIN: Secondary product purchased alongside the lead ASIN.

      • Purchasers: Number of customers who purchased both ASINs.

      • Overlap Ratio: Percentage of lead ASIN buyers who also purchased the overlap ASIN.

      Highlights the five most common product combinations. For example:

      • Wiser Drones Foldable Arms FA510 often overlaps with Wiser Drones Calibration Mat CM020 at a 10.4% ratio.

      • Anti-Collision Lights ACL810 overlap strongly with Sun Hood SH030 at a 16.4% ratio.

      This helps you quickly see which add-ons or accessories resonate with buyers.

      ASIN Purchase Top 5 Overlap Network

      A network visualization of overlap patterns for a selected ASIN.

      This view makes it easy to spot clusters of complementary products that can be bundled or promoted together.

      ASIN Purchases Overlap Table

      A detailed table with metrics for each ASIN pair, including purchasers, overlap ratio, and lead ASIN orders.
      For instance:

      • FA510 Foldable Arms → WD130 Wind Deflector: 3.7% overlap.

      • RC910 Remote Controller → WC820 Waterproof Case: 3.9% overlap.

      This provides granular insights for data-driven upsell strategies.

      How it works

      1. Navigate to Intentwise Explore

      2. Go to Queries > Query Library

      3. Search for and add "ASIN Purchase Overlap Upsell" to your saved queries

      4. Fill in the required parameters and run the query (see this article for detailed settings)

      5. Once executed, access the results under the Insights section for product-level metrics and visualizations.

      For more information, refer to our data model.

      Use Cases

      • Upsell & Cross-Sell Campaigns: Identify accessories that pair well with core products and feature them in ads or email sequences.

      • Product Bundling: Build bundles based on frequently purchased combinations to increase average order value (AOV).

      • Inventory Planning: Forecast demand for accessories tied to best-selling ASINs.

      • Personalized Remarketing: Retarget buyers of one product with ads for complementary products.

      Recommendations

      • Leverage high-overlap pairs in Sponsored Products or DSP remarketing campaigns.

      • Test bundles of lead ASINs with top 2–3 overlap ASINs to drive higher cart sizes.

      • Use the overlap ratio to prioritize which ASIN pairs deserve promotional investment.

      • Review network visualization to find hidden clusters that can inform new product development or marketing campaigns.

      Frequently Asked Questions (FAQs)

      What are instructional queries?

      Amazon Marketing Cloud's (AMC) instructional queries provide pre-written SQL code that AMC users can use as is or modify for common measurement and analytics tasks.