NEW features in BDS Source queries
{{BD_SEG_LIMIT}}: this new static variable its value come from the segment limit input, it is important to connect the limit UI to the SQL
{{ select * from pii | BASEQUERY }}: we can focus deduplication logic to a specific piece of SQL, by encapsulating the thing we want to duplicate between brackets and adding the flag ‘BASEQUERY’
Configurations for deduplication:
- BD Select Sources
- Have {{BD_SEG_LIMIT}} and {{WHERE}} configured in the SQL
- We need to be sure we are selecting all the DedupKeys we are going to select in Audience side, (SELECT * …) is recommended
- For exports, we can deduplicate with any SQL
- For counts, to make deduplication work, is mandatory to have BASEQUERY
- Audience
- We need to enable deduplication, by switching the toggle button that is in the kebab menu next to the export button
- Below toggle, you can click to open de DedupKey selection modal, is mandatory to have at least one dedup key selected, if you create some default keys, they will be selected by default (Be sure this dedup keys are being selected from BDS source query)
- You can configure limits on each segment, if leave it blank, no limit is append it
- You can run exports and counts to validate deduplication