No csv file export feature in AJO what's alternative way to achieve?

[chrisyan]

Hi,

I’ve encountered a key challenge that I’m facing with the absence of a native CSV export feature in AJO.

In my current process, exporting CSV files is crucial for downstream teams who use those files for deployment. This workflow in ACC heavily depends on exporting data to specific folders.

In AJO, I’ve come up a potential solution to replicate this process by utilizing Adobe Experience Platform (AEP). Here’s the approach I’m considering:

Journey Setup: I have a journey that starts with an audience segment (read audience node). After the audience segment, I use a conditional node to narrow down.
Data Capture: Instead of linking to an email action node, I would connect it to an Update Profile action node, which would update a schema/dataset in AEP with data from the conditional node
and this dataset will be full replacement every time when the scheduled journey gets triggered.
Data Export: From AEP, I can export the data stored in the dataset to a CSV file and post it to an FTP path we set up.
This approach seems like it could replicate the CSV export process I use in Adobe Campaign without disrupting downstream workflows.

My key question is whether this approach is technically feasible within the AJO/AEP ecosystem, as it's critical to the future design of journey in AJO.

Your guidance on whether this would work as expected or if there are any potential challenges I should be aware of would be greatly appreciated.

Thank you for your time in advance!!

[Ivan_Mironchuk]

You're approach above seems feasible. If you are looking at a downstream Direct Mail service, you can use the Direct Mail action inside of AJO Campaigns to export a .txt or .csv file to S3, or FTP path. This action gives you the ability to select an audience and the columns of data along with any data transformations you want exported for direct mail. 

[chrisyan]

Thanks Ivan, I must export it via journey is not campaign as I have tons of mailer to be export in one file. If I use campaign with only one communication, then I have to create like 100 campaigns for each mailer type. is that possible to build in journey?