Is there a way to query a look a like audience ? | Community
Skip to main content
J
JuanOrozco_96
April 8, 2025
Question

Is there a way to query a look a like audience ?

  • April 8, 2025
  • 3 replies
  • 337 views

Hello community, currently I'm trying to query a look a like audience in experience platform but when I use the condition  

 

"array_contains(map_keys(segmentMembership['ups']), 'audienceID')"

 

there is no information displayed. Is there a way to commit this query or is not possible at moment ?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

S
supratim320
Level 5
April 15, 2025

Is it possible to share the whole query?

S
supratim320
Level 5
April 15, 2025

I gave it another try, it works for me. If it is not working for you, then can you ensure that your audience contain some profiles?

 

Sample query that run successfully for me:

SELECT * FROM (SELECT array_contains(map_keys(segmentMembership['ups']), 'audienceId') as TEST_COL, workEmail.address FROM profile_snapshot_export_abc) WHERE TEST_COL = True
    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    July 2, 2025

    @juanorozco_96 Just checking in — were you able to resolve your issue?
    We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...