Adobe Journey Optimizer

Hi there,    I need help to get the data from a JSON object using SQL in AJO.  { "consent": { "idSpecific": { "Phone": { "75708": { "marketing": { "sms": { "val": "y", "time": "2023-12-06T17:22:46.118Z" } } } } } } } I tried the following code but it's not returning the value (I'm able to parse identityMap tho) select a.identityMap['clientID'][0].ID AS cardUnmasked, TIMESTAMP, b.consents.marketing.sms.val, explode(b.consents.idSpecific), to_json(b.consents.idSpecific) from ajo_message_feedback_event_dataset a inner join profile_snapshot_export_987e0af1_adb6_45b0_9a58_4565707ef05d b on a.identityMap['clientID'][0].ID = b._client.identities.cardUnmasked where a._experience.customerJourneyManagement.messageExecution.journeyVersionID IN ('1ffd0d80-d2e7-4d75-a097-e5e5e54f19a6') and b._riteaid.identities.cardUnmasked = '95087080686'     Thanks, D

I need to fetch Journey Status, Journey Creation Date, Journey Published Date, Created by,  attributes. Can you let us know where to find them and fetch via a query ? or any other possible way

Experience League LIVE: Use Case Playbooks, self-serve templates to deploy use cases in a few clicks   Recording URL: https://experienceleague.adobe.com/docs/events/experience-league-live-recordings/episodes/exl-live-episode-02-08-24.html?lang=en  Event Details: Introducing Use Case Playbooks – an actionable catalog of industry-specific use case playbooks in Real-Time CDP and Journey Optimizer. In this webinar you'll learn about Use Case Playbooks and how they translate your marketing goals into implementation objects. We’ll show you how to jump-start your organization towards building and deploying commonly known use cases for accelerated business impact and collaboration. Event Schedule: Thursday, February 8th, 2024 | 9:00 AM PST Adobe Presenters: Host, Daniel Wright, Sr. Technical Marketing Engineer  Josée Monette-Healey, Sr. Product Marketing Manager, Adobe Real-Time CDPRohit Basuri, Senior Product Manager, Adobe Experience Platform

The client is migrating from Marketo to AJO, brand has various sub-brands, and the sender email address is unique for each sub-brand. However, the client is resisting the idea of following subdomain delegation for each sub-brand. The sub-brands do not have a technical team that can support this process, and they don't mind if the corporate or marketing mail delivery domain is the same. Has anyone encountered a similar scenario? is it possible to set up Email channel surface without subdomain delegation? 

Hi everyone, I read the documentation about Capping and Throttling, because we want to create customActions in AJO with conecctions to APIs with limits in the events sent per seconds, but we don't understand If the limits apply to the customAction and all of the journeys that they use it or we have to applied the limits to each journey manually. Thanks for your attention!Regards,Diego P. 

Does anyone know if we can use offer decisions within the in-app channel that’s part of a journey? When I look at the in-app message interface within a journey, it’s not showing offer decisions, rather it’s only showing profile attributes.

Hi, How do we exactly fetch the journey status (i.e., whether it is live, stopped, draft, etc) through the query service in AJO? What is the field name which should be called for fetching the status? I am trying to fetch all the live journeys but not able to find the field name through which I can filter out the ones which are live or draft or stopped.

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.

Hi Journey Optimizer Community, Here’s the 5th edition of the Adobe Journey Optimizer Community Lens! Adobe Journey Optimizer Community Lens is your community newsletter that highlights the latest updates from the Adobe Journey Optimizer Community in one place.In this edition, we are sharing highlights from October to December 2023, including, Journey Optimizer product releases, nomination opportunity for Community Advisor Program, best practices from Adobe experts, the most viewed Adobe Journey Optimizer content on Experience League, and a lot more!   Adobe Journey Optimizer Community Lens 🚀LATEST RELEASES🚀 Learn about all the new capabilities, upgrades, improvements, and fixes that were included in the latest release for Adobe Journey Optimizer: [Release Update] Personalize journeys with behavioral data using Computed Attributes [Release Update] Adobe Journey Optimizer October 2023 Release   EVENTS AND OPPORTUNITIES Register now for the upcoming Adobe Jou

Hi, Does AJO take hashed emails for executions or does it have to be in plain text? Please let us know. Thanks

I have records in Journey Orchestration journeys that I would like to jump to a different Journey Optimizer journey depending on specific criteria in the JO journey. Is this possible using the 'Jump' action?

Hi, I'm a little bit lost about how manage the third party unsubscription. I have my external landing page for unsuscbribe profiles (info.myexternalunsub.com/Email-Preference-Center.html?&optout=true). So, I will create the message template in a journey and add "External opt out" type in Unsubscribe link Then I can't understand the Subscription API Call, where and when the API call will be triggered? As the final unsubscription landing page (info.myexternalunsub.com/Email-Preference-Center.html?&optout=true) is hosted in an external tool I can't change anything there, neither the green unsubscribe button or the checkbox. Here info.myexternalunsub.com/Email-Preference-Center.html?&optout=true templateHere I can see profile need to add its email so maybe third party tool will make all the work, matching email with opt out behavior but not sure about it. So please if you can guide me step by step the API part and where that endpoint goes and so on as I can'

Hi Team,We have a third party hosted Landing page with which we want to configure unsubscribe.To implement this we have implemented Subscription API call through Developer Console to update the preference of indivdual profile. To achieve this we have used the following document:Email opt-out management | Adobe Journey Optimizer There is a requirement to pass two encrypted parameters in the URL1. params( which will contain encrypted payload data) and2. Pid (Profile ID) The challenge here is how to encrypt these values in runtime in AJO/AEP and pass it to individual user while sending email.   

Can you tell me what is the reson of "INTERNAL" and "messageExecutionFailed" in Journey Report and wer are facing the issue 7 profile entered in the journey and it is showing that 9 Exited from Journey and 9 get failed 

Is it possible to download the metadata of all the journeys existing in the AJO as a csv file. Something like the journey overview database ? Not like what we can get from the reports accessible from the individual journeys which has detailed overview of each individual journey, but like a consolidated table containing all journeys and their related KPIs

Hello All, I am trying to put a "Add to Calendar" button to an email in the campaign section of AJO. We have previously used Marketo which had a feature within the tokens that would allow us to do this. Is there any work arounds or similar tools within AJO?

Hello All, I have a journey which will send SMS to users based on some conditions. As part of my audience evaluation, I need to know whether the user has received SMS from this same journey within last 2 months. If yes, we need to exclude such users from the audience segment,  else the SMS should be triggered to the users. SMS is implemented using custom action. Is there any possible way to implement this ?

We have an urgent ask, so any quick replies will be appreciated.  We have a journey that starts with segment qualification and has a profile cap. Audience that are in the range of the cap receive an email and the rest exit the journey.  The journey evaluates on a daily basis and we'd like to understand how to exclude the profiles from receiving an email if they've already received the same email before.  Thanks!

Can we Use AMP Script in AJO emial template ?Is It possible that we can call a excel data inside AJO template via AMP script ? 

Hi Team, I have a usecase where I need to select a specific field from the profile schema for reading out the email for campaign. However if this field is empty then I want AJO to select some other field for reading the email. Currently we can only select one field using the execution field option in AJO. Is there some other way to handle it? I am aware that in journey its possible to override it , not sure how it can be handled in AJO campaigns. Thanks,Arpan  

Hello,  I have a question about the suppression list feature in AJO. As far as I comprehend, this feature allows us to add users whom we do not wish to contact. I included my personal email address in this list and scheduled a campaign to send me an email. However, I am still receiving emails from AJO, and I am uncertain whether this functionality is functioning correctly. Thanks,Arpan

Hi there,  I have a question when using the external data source in AJO.  Here is our use case: We would like to send emails to users who did a travel search, and in the email, we would like to use the destination name the user searched. But after a user searches for a travel, AEP will only receive an event with eVars with the destination code (not the destination name). And there is an API endpoint whose response can map the destination code to the destination name.  Now I have added the API as our external data source and also created an audience that users did a travel search. But when I setup the journey, I didn't find any out-of-box action in AJO to enrich the data. Did I do things correctly? Or is there a better solution or use case I can refer to? Thanks very much!

Hi All, want to confirm that if the email is marked as spam and added to the spam list, this can be extracted for the purpose of sending the back to another system. Thanks,

Hi All, We are sending the emails via AJO journey, I want to know if end user is marking my emails spam how I would know about this, is this a oob furcation which automatically mark that as hard bouncy and added it to the suppress list or we need to reach out to ESP like google and get that spam list and manual upload that in AJO suppression list?