This script sets a dimension to help you identify those keywords that are most likely to generate new-to-brand conversions.

What can I do with this?

With this script, you can easily identify those customers that haven't ever shopped with your brand on Amazon and target these customers with the greatest potential CLTV uplift. 

How it works

• The Python script aims to populate the "NTB Uplift" dimension in a data source based on whether a keyword has a potential to generate new-to-brand sales. 
• The keywords that are determined to be most likely to generate a NTB uplift are:
  • If the keyword belongs to the "Sponsored Brand Test - PRODUCT A" strategy and meets certain conditions (revenue > 0.00, ROAS > 11, % Orders New To Brand (14 Day) > 0.5), then the "NTB Uplift" is set to a calculated value.
  • If the keyword belongs to the "Sponsored Brand Test - PRODUCT B" strategy and meets certain conditions (revenue > 0.00, ROAS > 14, % Orders New To Brand (14 Day) > 0.5), then the "NTB Uplift" is set to a calculated value.

Customization

• Products that the NTB test campaigns
• Target ROAS lift

Requirements

• You must have Sponsored Brand Test strategies to run keywords head-to-head
• You must have a report with the following columns: 
  • Account, Campaign, Group, Keyword, Match Type, NTB Uplift