Federated Audience Creation Exercise
Create a Federated Audience Composition
In this exercise, we will build an audience to qualify cruisers of the highest loyaly tiers with an upcoming cruise booking that does not include any add-on purchases. This is an upsell opportunity to promote on-board exercusions or activities.
Top Tier Customers Booked Trip Without Add-ons w Email Consent
In the Customer > Audiences portal, click the Federated compositions tab.
Click Create composition.
Label your composition Top Tier Customers Booked Trip Without Add-ons + your initials. Click Create.
Click the + button in the canvas and select Build audience. The right-hand rail should appear.
Click Select a schema and select the TANDH_CRM schema then click Confirm
Click Continue. In the query builder window, click the + button and then Custom Condition. Create the following condition
CUSTOMERTIER = GOLD or CUSTOMERTIER == PLATINUM
AND
ACTIVITIESBOOKED == FALSE and EXCURSIONBOOKED == FALSE
Using the crm_to_consent link, add the following condition
CONSENTSMARKETINGEMAILVAL = TRUE
Your query should now look as follows
Click the next + button then click Save audience.
Label this step Top Tier Customers Booked Trip Without Add-ons w Email Consent + your initials. Use the same value as the audience label.
Add the following audience mappings:
Source Audience Field: EMAIL
Select the primary identity and namespace to use for profiles:
Primary identity field: Email
Identity namespace: Email
Click Save and then click Start, to run the query of the composition you just built.