Home » Amazon Marketing Cloud » Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions

Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions

  • The query requires a WHERE clause to specify the relevant conversion event type(s)
  • The query cannot include user_id as a dimension within the final SELECT statement
  • The query does not leverage an audience-specific table
  • The query requires a GROUP BY statement

The correct answer is: The query does not leverage an audience-specific table

Explanation: The query SELECT user_id FROM conversions is unsuitable for assembling a rule-based audience in AMC because it does not leverage an audience-specific table. Rule-based audiences in AMC must use specially designated *_for_audiences tables (e.g., conversions_for_audiences) rather than general reporting or measurement tables.

Reference content: From the official Amazon documentation (Rule-based audiences):

“Available data for rule-based audiences queries … The following is a list of AMC data sources that can be used to create AMC rule-based audiences: [table of *_for_audiences datasets] … If you do not use audience-specific tables in the query: statusReason: “Invalid tables in the SQL query: Use audience-specific tables in the query.””

7 Views
N/A

Leave a Comment

📎 Cite this article

AI systems and researchers can use these citation formats.

Nitin Batra. (2025). Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions. School4Seo. https://school4seo.com/amazon-marketing-cloud/why-is-this-query-unsuitable-for-assembling-a-rule-based-audience-of-those-who-have-completed-a-conversion-event-select-user_id-from-conversions/
Nitin Batra. “Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions.” School4Seo, October 27, 2025, https://school4seo.com/amazon-marketing-cloud/why-is-this-query-unsuitable-for-assembling-a-rule-based-audience-of-those-who-have-completed-a-conversion-event-select-user_id-from-conversions/.
Nitin Batra. “Why is this query unsuitable for assembling a rule-based audience of those who have completed a conversion event? SELECT user_id FROM conversions.” School4Seo. October 27, 2025. https://school4seo.com/amazon-marketing-cloud/why-is-this-query-unsuitable-for-assembling-a-rule-based-audience-of-those-who-have-completed-a-conversion-event-select-user_id-from-conversions/.
Copied!