we want to export our control groups that we have saved in several audiences in a file and drop them on our server via an automated workflow.
The file we are looking to extract should have the following columns for each record:
- customer id (from profile schema)
- the audience label (audience schema)
- audience creation data (audience schema)
For the follow up of this we want to know which user was in which control group.
However - when we export the file, we are able to only export customer ids from the profile schema but none of the data from the audience schema.
We have tried to enrich and reconcile the schemas within the workflow but were not successful.
Anyone here that has had a similar issue or an idea on how to create such file?