Hi again, You can ignore my previous message, I don't know why but now I see my audience in my list of my profile selected.Thanks a lot for your help ! Really appreciate Have a nice evening. BR, Maily

ah that's fine, I found the right query for my audience :select * from profile_snapshot_export_7209966b_2d62_40c1_b711_170682a0daed where segmentmembership['ups']['b9a4756a-662e-4de2-b50a-27af26008a90'].status IN ('realized', 'existing','exited') BUT when I take a profile and I check his audience, I...

ok, thanks, I found audience id, that's ok for this part but when I do my query :select * from customer_main where segmentmembership['ups']['b9a4756a-662e-4de2-b50a-27af26008a90'].status IN ('realized', 'existing','exited')I get this message :ErrorCode: 42703 queryId: 8d42ae88-ac36-4aea-a605-a976af3...

Hello,Thanks but where do you find your audience id ?When I click on code view of my audience I have this code : _belfius.customerCloudId.isNotNull() and (select _Customer_Product_Eligibility_Details1 from _belfius.productEligibilityDetails where _Customer_Product_Eligibility_Details1.eligibilityID....

Hello, Thanks for your reply, ok I'll try with a query but when I click on "code view" :_belfius.customerCloudId.isNotNull() and (select _Customer_Product_Eligibility_Details1 from _belfius.productEligibilityDetails where _Customer_Product_Eligibility_Details1.eligibilityID.equals("IsAsXx01", false)...

Hello, I would like to get all data from my audience but I only have sample of 9 records. How is it possible to have more than 9 records as sample ?As I have 5.96k normally I would like for example have 100 records of that.

Ah yes, that was also a solution, I tried it after posting my question, thanks a lot for your answer

Thanks a lot for your answer.

Hello,I would like to create an audience and select people with product id = L00122 and who subscribed to this product exactly one year ago.I don't want to select people in the last year but those who subscribed for example if we are today 04/12/2023, I would like to select those who subscribed 04/1...