Use the New To Brand Gateway ASIN query in AMC to find top ASINs bringing in the most new-to-brand customers for your brand.
New To Brand Gateway ASIN
By understanding which ASINs attract NTB customers, you can optimize your advertising strategies to focus on promoting these products more effectively. This query returns data on the tracked ASIN, the number of customers who purchased, the number of NTB customers who purchased, the percentage of NTB customers, and the ranking of the ASIN based on the number of NTB customers for each advertiser.
For example, these query results show that 1A00SDKDM4 and 1A3DQNZSTK are the best performing ASINs in terms of bringing in NTB customers while 1A4DKG4SZ6 is the top-performing ASIN in terms of NTB Users % share. This insight can help you prioritize these ASINs in future campaigns to maximize their impact in acquiring new customers.
The query analyzes purchase events from the amazon_attributed_events_by_conversion_time
table. For each ASIN, it calculates:
-
Total number of ad-attributed purchases
-
Number of new-to-brand (NTB) purchases
-
NTB percentage (NTB ÷ total purchases)
-
ASIN rank based on NTB user volume
The data is scoped to your brand’s attributed sales, with a 12-month lookback window to determine NTB status. This helps identify products that are true entry points for new customers.
How it works
-
Navigate to Intentwise Explore
-
Go to Queries > Query Library
-
Search for and add "NTB Gateway ASIN" to your saved queries
-
Fill in the required parameters and run the query (see this article for detailed settings)
-
Once executed, access the results under the Insights section for product-level metrics and visualizations.
To use this query effectively, your brand must have promoted ASINs that resulted in ad-attributed purchases on Amazon. The query analyzes data from the amazon_attributed_events_by_conversion_time table, which includes conversion types such as detail page views, add to cart, and purchases. It's important to note that the 14-day attribution window should be considered when running this query to capture all conversions accurately.
For more information, refer to our data model.
Key Use Cases
-
Product prioritization
Uncover ASINs that are strong acquisition levers, even if they’re not your bestsellers. -
Audience targeting refinement
Guide your non-brand targeting or upper-funnel Sponsored Brands campaigns using top NTB ASINs. -
Creative testing and messaging
Emphasize high NTB ASINs in new customer-focused creatives or landing pages. -
Lifecycle marketing
Identify products that should lead your prospecting campaigns vs. those better suited for retention.
Field Definitions
Field Name | Description |
---|---|
asin |
The ASIN promoted in the ad campaign |
total_purchases |
Total ad-attributed purchases for the ASIN |
ntb_purchases |
Number of purchases made by new-to-brand customers |
ntb_percentage |
% of total purchases that were from NTB customers |
ntb_rank |
ASIN ranking based on NTB customer count |
Recommendations
-
Scale up high NTB ASINs
These are your strongest acquisition drivers. Increase their visibility through non-brand or competitor keyword targeting. -
Use NTB % to spot efficient converters
Even low-volume ASINs with high NTB share can be powerful when used strategically in top-of-funnel campaigns. -
Refine lifecycle strategy
Segment your campaigns by NTB strength—run prospecting for high NTB ASINs and remarketing for low NTB ones.
Real-world Impact (Case Studies)
Peter Pauper
-
Identified 11 ASINs with high NTB performance
-
Increased ad spend on those ASINs by 150%
-
Saw a 323% increase in NTB customers
-
Achieved 341% growth in NTB sales YoY
Motif Digital
-
Shifted budget to ASINs that drove the highest NTB customer count
-
NTB rate improved by 15%
-
Average order value rose by 58%
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.