How to Leverage New-to-Brand Data Using Amazon Marketing Cloud?

WITH dsp_campaigns (campaign_id) AS (
  VALUES
    -- Optional update: To apply display campaign filter to the query, add campaign IDs below and uncomment lines in the impressions cte and the final select statement. Ignore the section to skip filters.
    (1111111111111),
    (2222222222222)
),
sa_campaigns (campaign) AS (
  VALUES
    -- Optional update: To apply sponsored ads campaign filter to the query, add campaign names below and uncomment lines in the impressions cte and in the final select statement. Ignore section to skip filters.
    ('SP Campaign 1'),
    ('SP Campaign 2'),
    ('SD Campaign 1'),
    ('SD Campaign 2'),
    ('SB Campaign 1'),
    ('SB Campaign 2')
)
SELECT
  advertiser_id,
  advertiser,
  campaign_id,
  campaign,
  SUM(new_to_brand_total_purchases) AS new_to_brand_purchases,
  SUM(total_purchases) - SUM(new_to_brand_total_purchases) AS non_new_to_brand_purchases,
  (
    SUM(new_to_brand_total_purchases) / SUM(total_purchases)
  ) * 100 AS new_to_brand_purchases_percentage,
  SUM(new_to_brand_total_product_sales) AS new_to_brand_product_sales,
  SUM(total_product_sales) - SUM(new_to_brand_total_product_sales) AS non_new_to_brand_product_sales,
  (
    SUM(new_to_brand_total_product_sales) / SUM(total_product_sales)
  ) * 100 AS new_to_brand_product_sales_percentage
FROM
  amazon_attributed_events_by_conversion_time
WHERE
  purchases > 0
  AND user_id IS NOT NULL -- Optional update: uncomment this line to enable DSP & SA filters. Leave the line commented to skip filters
  /*AND (campaign_id IN (SELECT campaign_id FROM dsp_campaigns) OR campaign IN (SELECT campaign FROM sa_campaigns)).*/
GROUP BY
  advertiser_id,
  advertiser,
  campaign_id,
  campaign