The marketing analytics team at your organization uses Dynamics 365 Customer Insights – Data. They need to quickly find metrics for marketing stakeholders in order to help stakeholders make decisions that impact digital advertising campaigns.
• Loyalty data is stored in a table named “Loyalty” and has been unified.
• The top tier is “Gold” and the column that holds tier information as string values is “LTier”.
• There are also columns for Street, City, and State address attributes.
The marketing analytics team member receives a question from a stakeholder on Microsoft Teams. The stakeholder asks, “How many top tier loyalty members are there in Seattle, Washington?”
You need to provide guidance on how to get a quick and accurate answer.
What should you recommend?
CILove
6 months, 3 weeks ago