Adobe Experience Platform

Data in legacy dataset is source from Adobe Analytics (lots of columns)I need to modify one column in the dataset and write out the record to a new datasetI do not want to list 1,000+ columns in my select or insert queriesI known I can use "with (schema=<schema>)" when creating the output datasetWhat I want is the select query to also reference the schema  create table with (schema=<schema1>) as select <something here to get all columns from the dataset>, <somefunction>(offending column) as original columnFrom <dataset>

Hello All,  We have a few streaming audiences setup with Default merge policies and the data is streamed into AEP. We came across this note this adobe doc and  this post. My understanding is that, if we are streaming the data then the default merge policy would work. But I'm confused because of these two statements here -  Note from Adobe documentation - In order to use streaming segmentation, you must use a merge policy that is “Active on Edge”.  Note from the community response - When it comes to defining segments, you can choose which merge policy is used by the segment definition. The segment builder defaults to whichever merge policy is selected as your default merge policy. If you had multiple merge policies defined, you could change the one used by the segment by selecting the gear icon and then using the dropdown. An important thing to keep in mind with merge policies is that only one merge policy can be sele

Hi all,I've run into issues with mapping inside the data prep tool, specifically within productListItems. The solution would need to be able to iterate through an array.I am experiencing a dataset error where the Quantity is coming back as a string and not a number. I updated the code in my launch script so it would stop happening but am still getting this error about once a day. I tried using the following code within Data Prep Tool using a calculated field but it is still not working. My target field would productListItems[*].quantity but I cannot use that notation inside a calculated field because it does not accept [*].Mapping Triedto_integer(quantity). to_integer(productListItems.quantity)Error message in datasets: #/productListItems/0/quantity: expected type: Number, found: String.Sample Array:[{"sku": "HGYU_89","name": "Wireless Mouse","pricetotal": 29.99,"quantity": 2},{"sku": "ABC_01","name": "Mechanical Keyboard","pricetotal": 89.95,"quantity": 1},{"sku": "XYZ_02","

I have an existing destination setup in Adobe Experience Platform where audience data is being exported. I would like to update the existing field mapping (e.g., map a new schema attribute or modify the transformation logic) using the API, without recreating the destination or dataflow.

Hello All, We have field eventType in AJO Push Tracking Experience Event Dataset to get values like application.opened, decisioning.propositionInteract etc.However, Can some one please help me understand which value from this field provides data related to  clicks. Thank you,Shivani 

Is there any way to find out what records failed after partial batch ingestion in adobe experience platform UI? I don't have access to API. There is one record failed when ingested 100K record and want to find out what is the issue with failed record? 

Hello, Has anyone tried to bring in the Azure DevOps data into AEP through any connector or storage? I am trying to get my product releases and we use Azure DevOps to track all releases. Having this data would be helpful. Please let me know if anyone has done something similar or has any suggestion on this engineering work. Thanks, Gautham

I can override the on-page Tags script environment on one page of the site frontier.com/shop however when I move to other pages, the Dev environment override jumps out and I'm reverted back to Prod environent. I believe this issue is because on that single page frontier.com/shop the Tags script url is coded fully "https://..." and on other pages it's coded without the protocol (leading slashes only), so the debugger seems unable to handle this use case scenario. Thanks for reviewing! Community Discussion Ref:Re: Adobe Experience Platform Debugger jumps envir... - Adobe Experience League Community - 765618

Does the profile needs to be removed separately from Profile Store and Identity Graph?

Hi Community ,I am facing issue with event dataset activity, where I am not able to see existing profile fragment count on batch ingestion. Issue is discussed in below url. https://experienceleaguecommunities.adobe.com/t5/adobe-experience-platform/ct-p/adobe-experience-platform-communityI could not the resolution of this issue.Regards,

Hi everyone,Has anyone run into this issue when trying to run queries in Adobe Experience Platform?I'm getting this error in the Query Service console:I’ve already tried:Refreshing the pageLogging out and back inSwitching browsersStill seeing the same issue. Is this usually tied to backend instability or a permission/session timeout? Would appreciate any advice.Thanks!

Hello, I have an error in query service within AEP when I use set auto_to_json=true; and them run the select * from adobe analytics data; Error:  Cannot read properties of undefined (reading 'map')I have just use the dataset that is created from adobe source connector. I have 3k+ fields within this that is in JSON format. How does one query this within the query service to get all columns auto populated. ? 

Adobe Experience Cloud certification renewal is better than ever, thanks to a newly streamlined process. Now that the process has launched, we’re reaching out to the Adobe Experience Cloud community—including evangelists, advisors, product teams, and subject matter experts—for your input on the content of renewal modules. We invite you to recommend the most relevant and impactful articles, tutorials, or blog posts that would help certification holders keep their skills fresh. Our team will consider submissions for use as part of renewal modules. Submissions must be publicly available and hosted on Adobe-managed platforms such as Adobe Experience League, Adobe Developer, Marketo Nation, or Adobe Corporate websites. Your recommendations will help ensure that certified individuals engage with high-value, up-to-date content that reflects the evolving Adobe DX ecosystem. Thank you for helping us elevate the renewal experience for the entire Adobe community. Submit a content recommendation &

Hi - there are 2 Consent Value fields available to use in Audiences, but they are mapped to different paths. One is:  XDM Individual Profile> Consents and Preferences> Id Specific >Marketing Preferences >Receive email >Choice ValueThe other is:  XDM Individual Profile> Consents and Preferences> Marketing Preferences >Receive email >Choice Value We want to create an audience of ALL email opt outs, regardless of ID (we have multiple). Should we be using the second path above where it does NOT reference Id Specific?  Thanks.

Hi all,I’m working in AEP and noticed that the total profile count is not showing on the Home dashboard or the Profiles > Overview page, even though:I’ve ingested data into a Profile-enabled schema and datasetIdentity fields are mapped properly and populatedBoth schema and dataset have the Profile toggle enabledThe dataset ingestion shows success with no errorsHas anyone run into this before where the dashboard doesn’t reflect the profile count even after successful ingestion? Any steps I should take to verify or refresh the count?Thanks in advance!(Attaching screenshots of Home and Profile Overview for context.) 

I recently gave an internal enablement session on the AI Assistant.  It was straight forward and didn’t go into too much depth.  Out of it came a lot of asks for any kind of rules or methodology I was following. My approach is simple; just use it to do my job.  As I think of any question, I quickly frame the question and ask the AI.  Nothing fancy, not trying to trick it, not doing large verbose prompts or persona, just straight forward Q&A. Break down more complex questions to simpler prompts and then tie these answers together myself for more critical thinking. Basic prompts: Do you know any documentation about Edge API? What are segment guardrails? What is the difference between rbac and obac? Can I do an upsert? At some point I started taking questions that others were posting in an email to me or more broadly to a group. Then have the AI Assistant answer them as is without changing anything. Questions people were asking: How are profiles qualified into a

Hi Adobe Community,   So my company uses RTCDP and CJA. So for some datasets, we bring them in as events so that they can be used in CJA. However, for audience building purposes, we don't really need the data as events. I have an instance where I just want to most recent record of data for every customer number that qualifies for my audience. I am wondering if there is a way to set the timestamp or somethign so that it's just giving me the most up to date record for each customer. I don't want to set the criteria and have it include a customer that used to qualify but does not qualify anymore.   Thanks, Nick

Hi Community,I have implement Data Usage Labels to Fields Groups using descriptors endpoint API,but to delete the labels using descriptors endpoint if not working ,To delete Dule Labels we should have descriptors ID and I hit GET request to get descriptors ID.but in response we have so many IDs i can't find out the descriptors ID which is belong to a particular field group.This is API request to create Data usage labels using API: Please give insights to delete lables using Descriptors endpoint API.

Hi Team, I want to get the tracking data of sms journey . As per my understanding, below three system datasets are present with delivery and tracking data in AEP. Could some one please help me understand in which dataset and field I'll get tracking information of SMS? (like sms open, click etc.) Email tracking: tracks data of emails (Interaction type is its field and opens/ clicks/ unsubscribe etc tracking of email data is captured here)Push tracking : tracking data of push journeys (eventtype field captures data of open, clicks. descision.propositioninteract value is capturing the clicks as per below screenshot)Message feedback: takes care of delivery data of all three push/email/sms (feedback status is its field which provides update like sent/exluded/bounced etc.)

Here's an image for reference: 

We recently implemented Web SDK. We have Analytics, Target and AAM. We will be implementing RTCDP soon. We also recently got OneTrust. We did a OneTrust scan of our website and came up with a list of cookies. In OT, cookies are categorized as Essential, Functional, Targeting, etc. Visitor preferences for each category are stored in a data layer variable. Therefore, we can inspect the variable to see that was opted in and out for each visitor; e.g. Essential opted in, Functional opted in, Targeting opted out, etc. We can have a script that either allows cookies to be created or not based on the category preferences (opted in or out). In Launch, we have a Page View rule. Based on my research, Web SDK creates multiple cookies such as-kndctr_<ORG_ID>_identity - Functional cookiekndctr_<ORG_ID>_consent - Targeting cookiekndctr_<ORG_ID>_cluster - Functional cookiembox - Targeting cookiemboxEdgeCluster - Targeting cookieAMCV_###@AdobeOrg - Targeting cookie OT

Hello we're trying to build reporting on AEP RT-CDP destinations (Customer Data Type).... preferably connecting CJA to analyze Anyone had this experience or how-tos? thanks

SELECT *FROM INFORMATION_SCHEMA.COLUMNSWHERE table_name = 'table_name';Above query only gives dataType at root level. but how do we find dataType of each attribute in the dataSet ?

My customer has hybrid mobile app: web view (in mobile app) + native app (kotlin etc) I suppose that some web view needs to use web sdk and native app has to use mobile sdk?Did anybody do something like that recently? How to share the ECID? What might be the risks?