Can I send event data from AEP to a SFTP location? If yes, how can I send timestamp of that event.

[Pareek1]

I have a use-case, where I want to send the timestamp of the "message.tracking" event where the user unsubscribed from the email communications to a SFTP location.
I have created an audience, and it is wrking fine, except that, I do not know if we can send an event to a destination along with the timestamp of this unsub event.

[ccg1706]

Hi @Pareek1 ,

In RT-CDP, you can send the timestamp of the "message.tracking" event , such as an unsubscribe action, to an SFTP location using Dataflows

Here's a summary of the process:

1. Capture the Unsubscribe Event in AEP:

- Event Streaming: AEP is able to ingest of ingest and process real-time events, including "message.tracking" events like an unsubscribe action. Ensure that your Adobe Experience Platform is set up to capture these events from your email marketing tool (ex: Adobe Campaign).
-Schema Definition: Make sure the event data is correctly mapped to a schema within AEP, including fields like the unsubscribe_timestamp, user_id, and email.
2. Create a Dataset for the Unsubscribe Events
-Dataset Creation: Create a dataset within AEP to store the unsubscribe events. This dataset should include all relevant fields such as the timestamp of the unsubscribe, the user ID, and the email address.
-Data Mapping: Ensure that the event data is properly mapped to this dataset so that each unsubscribe event is recorded with the correct timestamp.
3. Set Up a Dataflow to Transfer Data to SFTP
-Data Export Workflow: Use the Dataflow functionality in AEP to create an export job. This will allow you to automate the process of transferring the unsubscribe data to an external destination, such as an SFTP server.
-Connector Configuration: Configure an SFTP connector within the Dataflow settings. Provide the necessary SFTP credentials, specify the target directory on the SFTP server, and choose the appropriate file format (e.g., CSV, JSON) for the export.
-Scheduling: You can schedule the Dataflow to run at specified intervals (e.g., daily, hourly) or trigger it based on certain conditions.
4. Transform Data (if needed)
-Data Preparation: If necessary, use Adobe Experience Platform Query Service or Data Prep functions to transform the data before exporting it. For instance, you may need to format the timestamp or filter specific unsubscribe events.
5. Monitor and Validate the Dataflow
-Monitoring: After setting up the Dataflow, monitor it regularly to ensure that the data is being transferred successfully. You can use the monitoring tools within AEP to check the status of the Dataflow and troubleshoot any errors.
-Validation: Validate the exported files on the SFTP server to ensure they contain the correct data, including accurate timestamps for the unsubscribe events.

Additionally I share with some useful documentation links:

This doc covers how to ingest different types of data, including real time events, into AEP.

This part explains how to define and manage schemas in AEP, crucial for structuring your event data like unsubscribe events.

This guide provides specific instructions on configuring and using SFTP as a destination for exporting data from AEP.

This section offers guidance on using the Query Service to prepare and transform your data before exporting it.

This link explains how to monitor your Dataflows and set up alerts for tracking the success of your data transfers.

This section provides you and overall view of dataflows and its creation.

¡Hope this is helpful!

Regards, 

Celia

@jpetermarias 

[Pareek1]

Hi Celia,

The events are coming from AJO and I have made an audience that includes the unsub profiles, and I am activating this to a SFTP location, is there any way, I can make this setup send the timestamp of the unsub event?

[ccg1706]

Hi @Pareek1,

You can include it following the next steps:

-Data Extension Modification: Ensure that your data extension (or the audience list) includes a field for the unsubscribe event timestamp. This could be a field like UnsubscribeDate or EventTimestamp, which captures the exact time when the unsubscribe event occurred.

-Event Data Configuration: In Adobe Journey Optimiser (AJO), when capturing the unsubscribe event, ensure that the timestamp of the event is being recorded. This might already be happening automatically, but verify that this data is being stored in the relevant data extension.

-Audience Segmentation: When you create your audience that includes the unsubscribed profiles, ensure that the timestamp field is part of the selected attributes. This means when you pull the audience, the unsubscribe timestamp is included in the audience data.

-File Export Configuration: In the setup for exporting your audience to the SFTP location, make sure to map the unsubscribe timestamp field in the export configuration. This will secure you  that the timestamp is included in the file that is sent to the SFTP server.

-Format the Output: When exporting, you can format the timestamp in the desired way. This will be helpful for downstream processes that consume the file.

By following the previous steps, your SFTP export will include the unsubscribe timestamp, allowing you to track when each user opted out.

Regards, 

Celia 

@jpetermarias 

[_Manoj_Kumar_ · Accepted solution]

Hello @Pareek1  If you are creating an audience then you won't have access to events data in output.

What you can do is to get the data via query service and then create a dataset in the format you want to export. 
Here is an example of how to get data from email tracking dataset:

https://experienceleague.adobe.com/en/docs/journey-optimizer/using/data-management/datasets/datasets...

once the dataset is ready then you can export it with timestamp to an SFTP location