Northern Trails Outfitters wants to use complex criteria to identify subscribers for a special promotional email. Specifically, they want to target subscribers who opened or engaged with an email within the last 30 days and live within 10 miles of one of their stores.
What should be used to create its audience?
To create an audience based on subscribers who opened or engaged with an email within the last 30 days and live within 10 miles of a store, a SQL Query should be used. This involves multiple conditions and criteria that can be complex. SQL Queries excel in handling such situations as they allow for advanced logic, multiple joins, and subqueries to combine engagement data with geographic data effectively. This level of complexity is beyond what can be achieved with Measures or Data Filters.
A. SQL Query Here's why: Complex Criteria: The requirement involves multiple conditions that need to be evaluated together, including engagement with emails and geographic proximity. This type of criteria is typically too complex to handle with basic tools like Measures or Data Filters. Advanced Logic: SQL queries allow for the implementation of advanced logic and can handle multiple joins, subqueries, and specific conditions that are necessary to combine engagement data with geographic data. Flexibility and Precision: SQL provides the flexibility and precision needed to accurately filter and identify the target audience based on specific and combined conditions.
A is correct.
Requirement: - target subscribers who - opened or engaged with an email - within the last 30 days and - live within 10 miles of one of their stores. Distance to the stores is for sure not calculated at runtime. Even a SQL query would be a hell of a job. Instead the distance is typically kept in a CRM field, toghether with a relation to the store. Therefore any information is available as flat data. Therefore a data filter fullfill the requirement. The answer from 3ad3374 is correct but the solution is to complicated for this case.