How to export journey user data
  • 13 Dec 2023
  • 3 Minutes to read

    How to export journey user data


      Article Summary

      You can export user activities or user information related to a specific journey. For example, you can export the profile IDs or email addresses of the users who entered a specific journey, or the profile IDs of the users who received email or web push messages from a specific journey. You can use two different methods to export the data:

      Export Raw User Data API

      This API helps you get a download link to export the requested user filters, attributes, and event details. Read more on Export Raw User Data API.

      Using User Profiles

      You can filter users on User Profiles with the desired Journey-related events. Then, you can export those users with up to 20 attributes.

      Journey Enter and Exit Activities

      1. Navigate to Audience > User Profiles.

      2. Click Filter Contacts button on the listing page.3. Select the Events box under the Standard segments.4. Select the "journey_enter" or "journey_exit" based on your needs.

      Your title goes here
      The journey enter event is automatically generated when the user enters the journey. The journey exit event is automatically generated when the user exits/completes/drops from the journey.

      5. Define the Times, Time Range, and Unit values.

      6. Specify the journey you want to export user data from. 

      Your title goes here
      You can see your journey ID if you hover on the journey name on the Architect listing page or via the journey URL.

      You can also use other event parameters such as Journey Exit Reason, Journey Enter Reason, Journey Name or Event Code of the element user exited from.

      7. Click the Apply button to apply the filters.

      8. You can see the number of users who fit in this segment next to the Filter button together with the number of filters applied.

      9. Click the Export button to download your user data.

      10. You can include the user attributes in your export file.

      11. You will receive an email to download your CSV file in your inbox.

      User's Channel Activities

      A journey includes different messaging channels and users can receive messages from them. You can export the user activities on a specified channel(s).

      You can use the Channel Interactions box under Predefined Segments in the filtering section. 

      If you select Architect from the Product dropdown, you can also select Journey Name and Channel Name.

      The Journey specific Channel activities under the users' Events tab

      Architect generates Journey Product Action event for all the messaging channels Architect has. The action (user activity) and the channel are defined with event parameters. 

      Action Code event parameter describes the activity such as click, view, reply.

      Your title goes here
      Sent means the system attempts to send a message or show the campaign. In other words, it does not necessarily mean that the user received a message or viewed the campaign.
      Your title goes here
      Email Open is the same as Email View, which has the action code 4.
      Action CodeMeaningApplicable Channels
      1SentWeb Push, App Push, Email, SMS, WhatsApp, On-Site, In-App, Call an API
      2ClickWeb Push, App Push, Email, SMS, WhatsApp, On-Site, In-App
      3CloseWeb Push
      4View/DeliveredView: SMS, WhatsApp, On-Site, In-App, Email
      Delivered: Web Push, App Push
      5ConversionWeb Push, App Push, Email, SMS, WhatsApp, On-Site, In-App
      15Not seenOn-Site
      16ReplyWhatsApp
      17OpenWhatsApp
      18FrequencyWeb Push, App Push, Email, SMS, WhatsApp
      19Successful RequestCall an API
      20Failed RequestCall an API
      Your title goes here
      The campaign ID event parameter describes the channel.

      Campaign ID has a unique value. This way, you can consider each channel separately. For example, you can have 10 web push channels in the same journey but you can specifically export one of the web push activities.

      Your title goes here
      The journey ID event parameter describes the journey.

      You can use the journey ID event parameter to select a specific journey. The journey_product_action event considers only the messages that are sent from a journey. For example, the user activities on a bulk web push message are not included in the journey_product_action event.

      Channel Code event parameter describes the type of the channel. You can use this to understand from which channel this event is performed.

      Channel CodeChannel Name
      EMEmail
      WPWeb Push
      SMSSMS
      WABWhatsApp
      APPApp Push
      IAInApp
      WCOn-Site
      ACCall an API
      GCMGoogle Ads Customer Match
      FBFacebook Custom Audiences

      Was this article helpful?


      ESC

      Eddy, a super-smart generative AI, opening up ways to have tailored queries and responses