Solved

I am struggling with building a report based on an evar as I dont fully comprehend the nunances of evar.On my website, we have product pages. On those product pages, we use and evar to capture the product brand (evar10).The configurations of that evar are:merchandising : conversion variablebinding events: purchase event (order, revenue, units) checkout, cart additions, remove from cart, add to wishlist, remove from wishlist, product view, cart view, and cart open.allocation most recent : lastreset: do not resetexpire after: purchaseenable merchandising: enabled. Now, i want to know conversion rate for evar10 = brand_ASpecifically, I want to know 2 things :QUESTION 1. of all visits to products page where evar10='brand_A', what percentage of those visits purchased 'brand_A' products?QUESTION 2. of all visits to products page where evar10='brand_A', what percentage of those visits purchased a product (of any brand, does not have to be a brand_A product).I created a segment based on H

Is it populated automatically?Do the Application Close (Background) and Application Launch (Foreground) events are added automatically? 

Due to Marketo database limits, we need to purge inactive people in Marketo (we will not purge in Salesforce). Because Marketo deletions do not sync to Salesforce, after a purge when the same person re-enters Marketo and is recreated—the native sync creates a new Salesforce Lead instead of linking to the existing record. This is causing a lot of duplicates in SFDC. Does Marketo have the capability to correlate to an existing Salesforce record and only create a new Lead if one doesn’t already exist? Is this a common issue other companies face, and how do you handle it?

Hi All, Need help with a few clarifications. I have an AEM 6.5.21 on prem instance running on RHEL VM. TarMK is being used as the node store and File System Data Store for datastore. The datastore size currently is ~ 260GB.Under Operations dashboard I can see:Under Daily Maintenance Task (Runs from 02:00 – 05:00): I have Lucene Binaries Cleanup and Revision Clean Up. Both Tasks currently have a green checkmark displayed next to it with a message succeeded, which makes me believe they successfully ran.Under Weekly maintenance task (Runs every Saturday from 01:00 – 02:00):I can see Data Store Garbage collection has successfully run previous Saturday and is scheduled to run upcoming Saturday at 01:00:00 . When I open the configuration for DataStoreGarbageCollectionTask, I can see the checkbox for  granite.maintenance.mandatory is not selected.The Workflow Purge is successful and AuditLog Maintence (Failed) tasks are also present.Under the  SegmentNodeStoreService confi

Hi, I have a report with 3 level of OR statements. Example below.Field1_Mod=isnullname=Task 1name_Mod=cicontainsOR:1:Field1_Mod=isnullOR:1:name=Task 2OR:1:name_Mod=cicontainsOR:2:Field1_Mod=isnullOR:2:name=Task 3OR:2:name_Mod=cicontains But on Field 1, I want to do an additional check to exclude the task if FIeld 1 contains 0 in it.  So I modified the code as below:Field1_Mod=isnullAND:1:Field1_Mod=cinotcontainsAND:1:Field 1_=0name=Task 1name_Mod=cicontainsOR:1:Field1_Mod=isnullOR:1:name=Task 2OR:1:name_Mod=cicontainsOR:2:Field1_Mod=isnullOR:2:name=Task 3OR:2:name_Mod=cicontains The code works find for Task 1, but I want to apply the same logic for Task 2 and Task 3.  I am not sure how to write the same AND:1: code but for OR:1 and OR:2. Is that even possible? 

Is it possible to utilize the replication agents or a similar mechanism from an author instance to distribute content to an S3 bucket?  I don't intend to use S3 for the entire instance's datastore, I only need certain content directories.  My desire is to have a push mechanism in place rather than a side loaded script that will export data from my AEM instance and then push to downstream to S3.   Apologies for the vague nature of my query as I can only provide so much information due to the sensitive nature of the project.   Additional info : 6.5 SP18 On premise installation on RHEL

Hello,I have a test workflow written in aem where i need to get the Assetwhere the java test case is written as:  import javax.jcr.RepositoryException;import org.apache.sling.api.resource.Resource;import org.junit.jupiter.api.BeforeEach;import org.junit.jupiter.api.Test;import org.junit.jupiter.api.extension.ExtendWith;import org.mockito.Mock;import org.mockito.junit.jupiter.MockitoExtension; //import com.day.cq.dam.api.Asset;  //if i am using this import then its working fineimport com.adobe.granite.asset.api.Asset;  //but i want for this importimport com.adobe.granite.workflow.WorkflowException;import io.wcm.testing.mock.aem.junit5.*;@ExtendWith({ AemContextExtension.class, MockitoExtension.class })class ExampleTest{    AemContext aemContext = new AemContext();    @Mock    Resource resource;    @BeforeEach    void setup() throws Exception    {        aemContext.load().json("com/ex

Hi All, We are on AEM as Cloud Service and we are using CIF to connect to commerce.While authoring the products/categories, AEM is making an "IntrospectionQuery" call to commerce. This call gets the response but AEM is not making any more subsequent calls to fetch the products/category. Because of which, we are unable to author the products. Can you please help in what can be the possibility of this. NOTE: When we connect to different commerce instance, AEM is able to proceed further to product/category selection. On comparing, there are few field difference. Does the response of "IntrospectionQuery" need to have any specific field defined to proceed further or is there any limit on the response size.

Hi Team,We’re currently implementing a strict Content Security Policy (CSP) in our web application, and we’ve encountered an issue where Adobe Analytics scripts are being blocked unless we add 'unsafe-eval' to the script-src directive.However, our security guidelines specifically aim to avoid 'unsafe-eval', so this is not a viable option for us.at.js 2.11.6

I have created test profiles in AJO but was unable to use them in my audience set configuration. what could be the reason for this? Though i am using correct field names while configuring the audience set.   

Hi Team, I want to upload a lot of folders with many images into AEM DAM. Thanks,Syed Peer Vali Shaik.a

// Variablesvar FILE_PREFIX = "Mecca_Games_hashed_emails_";var FILE_EXTENSION = ".csv";var FILE_DIRECTORY = "C:\\Rank Sharing Folder\\MSAds\\";// var SERVER_UPLOAD_URL = "https://duprdcpmgtstdstor01.blob.core.windows.net/msadsfiletransfer/"; // Replace with actual endpoint// Generate timestamp and filenamevar now = new Date();var isoTimestamp = now.toISOString().replace(/:/g, "-");var filenamePart = FILE_PREFIX + isoTimestamp + FILE_EXTENSION;var filename = FILE_DIRECTORY + filenamePart;// Query extracted datavar url = 'C:\\Rank Sharing Folder\\MSAds\\'; // Replace with your actual endpointvar params = {schema: vars.targetSchema,operation: 'select',select: ['@email']};fetch(url, {method: 'POST',headers: {'Content-Type': 'application/json'},body: JSON.stringify(params)}).then(function(response) { return response.json(); }).then(function(data) {// handle your data hereconsole.log(data);}).catch(function(error) {console.error('Error:', error);});var records = query.ExecuteQuery();// Build

Basically I'm trying to cache historical data since it's not going to chance anymore. 2 questions please1. how do I configure the dispatcher so it caches query parameter? 2. How can I cache these pages for X days (considering they are historical and not going to change anymore. It'll only be used for reporting. ----------- So I have the following in my dispatcher config. reading various references it seems it should work but I cannot test it locally./ignoreUrlParams { /0001 { /glob "*" /type "deny" } /4441 { /glob "year=2024" /type "allow" } /4442 { /glob "year=2023" /type "allow" } /4443 { /glob "year=2022" /type "allow" } /4444 { /glob "year=2021" /type "allow" } /4445 { /glob "year=2020" /type "allow" } /4446 { /glob "year=2019" /type "allow" } /4447 { /glob "year=2018" /type "allow" } /4448 { /glob "year=2017" /type "allow" } /4449 { /glob "year=2016" /type "allow" } /44

I have a use case where I have two PDFs. 1- Static PDF  2- Dynamic PDF, generated using AEM Form Communication API (https://developer.adobe.com/experience-manager-forms-cloud-service-developer-reference/api/output-sync/).   Ask - I would like to insert static PDF pages after page 2 of Dynamic PDF(generated using communication API) using Document manipulation APIs (https://developer.adobe.com/experience-manager-forms-cloud-service-developer-reference/api/assembler-sync/#section/Introduction).   Any sample code or DDX file, if this can be done?

 We are migrating from one Marketo instance to another.  At this point, we have migrated all of our marketing activities plus assets, lists and reports into our new instance sandbox.  We have also synced Salesforce QA to our Marketo sandbox.  Our next step is to test everything in our Marketo sandbox environment. Does anyone have best practices for loading data into our Marketo sandbox or salesforce QA environment prior to testing all of our activities? Thanks in advance!

Hi,  On my user profile schema, I have an object array that stores information of the accounts the user has access too. Something like[{"accountName": "A","balance": 10}, {"accountName":"B","balance": 9}]. In the web channel personalization I was able to display plain text or any attributes that's not in an array. However whenever I tried using an attribute that's an array, it would return blank. Even when I have wrap it in an array function like {%= head(profile._xxx.accountName) %}. In the websdk response, it would show it like the screenshot Want to understand if this is a web channel limitation or if I am missing something.  

Hello, I've built a Document Version report that provides me with the version # a proof was on once it reached 'Approved' status. I want to add one more column in my Details tab that tells me what Proof Workflow Template was used. I was in the API explorer and saw workflowTemplate was a field available, but curious to know how this can be implemented as an object in my report. Thank you for your insight! Best,Isaac

I'm currently exporting the audit log and noticed that the date and time format in the exported file differs from how it's displayed within the instance. I've attached a screenshot showing the comparison between the two formats. I've tried a couple of times in excel using Text to Date and custom formatting, but it's still not showing correctly. Not sure what I'm doing wrong.Is there a way to adjust the exported data so the date and time appear consistent with the instance view? I’d appreciate any guidance you can share.Thanks so much!   

Hello, I am trying to create a AEM Maven archetype project named aem-magazine. When I run the build using IntelliJ it shows the below error. Can anyone help me with this ?? [ERROR] Failed to execute goal com.github.eirslett:frontend-maven-plugin:1.7.6:npm (npm install) on project aem-magazine.ui.frontend: Failed to run task: 'npm install' failed. org.apache.commons.exec.ExecuteException: Process exited with an error: 1 (Exit value: 1) -> [Help 1] I have also included my frontend pom.xml here<?xml version="1.0" encoding="UTF-8"?><!-- | Copyright 2015 Adobe Systems Incorporated | | Licensed under the Apache License, Version 2.0 (the "License"); | you may not use this file except in compliance with the License. | You may obtain a copy of the License at | | http://www.apache.org/licenses/LICENSE-2.0 | | Unless required by applicable law or agreed to in writing, software | distributed under the License is distributed on an "AS IS" BASIS, | WITHOUT WARR

Hi team,While working with the Transactional Messaging API (/ajo/im/executions/unitary), I noticed that the recipients array supports both "type": "aep" and "type": "external".From my understanding:"aep" is used when the recipient exists in the Real-Time Customer Profile (RTCP) and the system can resolve the namespace (like Email or ECID)."external" seems to be for sending messages to users not stored in AEP, but I couldn’t find clear documentation on what data is honored in this case (e.g., profile attributes, channelData, or context).Could someone please clarify the following?What is the exact use case for "recipient.type": "external"?Does the transactional API honor the "channelData.emailAddress" when "type": "external" is used, or does it still rely on any profile lookup?Can dynamic headers like From Name and From Email be populated from the request payload for external recipients?Are there any limitations or prerequisites (e.g., specific channel presets or message configurations)

Hi, Can anyone help me with trying to get the document approval date to show in this field please? I've added {currentVersion}.{approvalDate} but it does nothing. I'm in a project report. displayname=Quote Approval Datelistdelimiter=<p>listmethod=nested(documents).liststype=iteratevalueexpression=IF(!ISBLANK({currentVersion}.{proofID}),IF(CONTAINS("Quote",{currentVersion}.{fileName}),{currentVersion}.{approvalDate},""),"")valueformat=HTMLwidth=200 ThanksMatt

How to allow access to native reports, especially the "deliveryStatistics" and "trackingStatistics" reports, to users who do not have the right to do anything else? 

Hi all, I need to be able to pull the first and second proof dates into a report. So far I have this which pulls in the current version, but I can't make it only look at the earlier versions displayname=1st Proof Datelistdelimiter=<p>listmethod=nested(documents).liststype=iteratevalueexpression=IF(!ISBLANK({currentVersion}.{proofID}),IF(!CONTAINS("Quote",{currentVersion}.{fileName}),{entryDate}),"")valueformat=HTMLwidth=200 ThanksMatt

1. I create DT and FG as templates.2. I add them to the Schema3. If I change DT or FG in template then does the schema from point 2 inherit new changes?

Hi all,  Has anyone tried setting up Technical Account Id to run scheduled query in query services AEP? This a recommended approach by Adobe rather than owning queries by individual users. In case where an user's role changes or account is deactivated, the scheduled query would fail to run.  There is documentation but it doesn't appear very clear to me. Any help/recommendation will be greatly appreciated. Thanks, Sambit