Is there a way to query a look a like audience ? | Community
Skip to main content
J
JuanOrozco_96
New Participant
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 ?

3 replies

kautuk_sahni
kautuk_sahni
Employee
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
S
supratim320
New Participant
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
    S
    supratim320
    New Participant
    April 15, 2025

    Is it possible to share the whole query?

    Terms & ConditionsAccessibility statement

    Loading footer...