Solved

I have extracted the datafeed for a single day and imported it into a single SQL table. I have successfully created SQL queries to calculate Unique Visitors and Visits, as shown below and its exactly matching with workspace data.Unique Visitors: SELECT COUNT(distinct concat(post_visid_high, post_visid_low)) from where visit_page_num!=0 and hit_source not in (5,7,8,9)Visits: SELECT COUNT(distinct CONCAT(post_visid_high, post_visid_low, visit_num, visit_start_time_gmt)) FROMwhere visit_page_num!=0 and hit_source not in (5,7,8,9)  Could someone please share similar SQL queries for calculating the following metrics?1. Page Views2. Bounce3. Bounce Rate4. New User5. Repeated User5. Average time on site6. Average time per page7. Entries8. Exits

I have a situation where I have to concatenate values from a multi-select (where I use the join() function), but if only 1 selection is made my join() returns a null.I need to find a way to determine if this field is coming in as an array or single text field.Ideas?

Hello all,  Does anyone know if is possible to add custom field to the Standard Layout Template' in the place highlighted on the screenshot below:   I tried to search field but this field is not listed.  Thanks, Mariola

Hi, We would like to create the Journey tags in an automated way, as they are managed by an external system, and we have more than 500.  In Adobe AJO API documentation (https://developer.adobe.com/journey-optimizer-apis/) is not explained but I would like to confirm if it's becasue is not possible or because is not being documented as it's quite uncommon.Thanks 

Hi, I have a requirement to dynamic populate few Adaptive form fields. The dynamic values are updated as cookie in the browser, and when the user access the form, certain fields needs to be updated based on the values in the cookie. Can I achieve this using jquery/js? I have not worked with Adaptive Forms Class: GuideBridge before, hence asking if I need to initiate GuideBridge inorder to set values in adaptive form field? any help is appreciated. Thank you. 

On my project I have got only AT. if (User viewed == finance category)then (homepage personalization)Target does not store previous URLs of the session, is it the only workaround?Send through web sdk:alloy("sendEvent", {  "data": {    "__adobe": {      "target": {        "profile.category": "finance"      }}}} AM I able to use that attribute during the same session?

Hi All,on local SDK build is working fine but on adobe cloud pipeline deployment failed due to below error:[ERROR] com.adobe.granite.fact.command.AnalyseCommand - exception occurred : Errors are present in the analyser. Please, check logs.Errors:[api-regions-exportsimports] test.project.core:0.0.1-SNAPSHOT: Bundle test.core:0.0.1-SNAPSHOT is importing package(s) [Package com.fasterxml.jackson.annotation;version=[2.16,3), Package com.fasterxml.jackson.databind;version=[2.16,3)] in start level 20 but no visible bundle is exporting these for that start level in the required version range. (test.project.all:0.0.1-SNAPSHOT)[api-regions-exportsimports] test.project.core:0.0.1-SNAPSHOT: Bundle test.core:0.0.1-SNAPSHOT is importing package(s) [Package com.fasterxml.jackson.annotation;version=[2.16,3), Package com.fasterxml.jackson.databind;version=[2.16,3)] in start level 20 but no visible bundle is exporting these for that start level in the required version range. (test.project.all:0.0.1-SNA

Hi Community, We have implemented an event 1 that fire when user do certain behavior like clicking or scrolling the page. Where it is possible for us to have 1 page view and multiple engagement event 1. Our team want to create an engagement metric for page-level where HIT CONTAINER event 1 exist (Page views) / Page views, but it doesn't work. Could you advise? The goal is to be able to use page URL as dimension and this metric for visualization so we can tell how engagement rate each page are performing. A couple of solutions we have tried is using the visit container:1. VISIT CONTAINER event 1 exist (Page views) / Page views. This rule pulls all page view from that visit not just the page where event 15 fire, so this possibly inflate the engagement number.2. HIT CONTTAINER event 1 exist (visits) / Visits. This rule worked but it's also at the visit level and we are looking to get a page level metric.3. Distinct Count Page URL (event 1 exist) / page views - issues w

Hi Community, Do we know what will happen when classification rule build gets deprecated? our team is looking to get some insights on what we should do to prepare for this as most of our classification is being populated using rule builders. Thank you in advance!

I can't find any installation instructions for Hotfix for GRANITE-61551.  Does it get deployed on both publish and author instances?  Also, no documentation for AEM 6.5 SITES Hotfix on SP23 SITES-33973.  I assume it needs to be deployed as well on a SP23 instance since the GRANITE-61551 hotfix does not appear to include 33973.

Hello,I'm in the process of configuring a feedback webhook in Adobe Journey Optimizer for my API triggered transactional mails and have selected JWT Authentication as the method. However, the documentation does not provide detailed information on the specific requirements for the following components:App ID: What exactly should be included in the App ID for the JWT authentication?API Token: Is an API token required for this authentication method? If so, how should it be generated and included?JWT Payload: What claims and information must be included in the JWT payload to ensure successful authentication?Could someone please provide detailed guidance or examples on how to correctly configure these elements for JWT authentication in the feedback webhook setup? Additionally, is it possible to do authentication using an access token, where a first call is made to obtain the access token, and then this token is included in the main webhook request? If so, how would this flow work in th

I am dealing with unclosed resource resolver warnings and working on solutions to fix this. In the process I came across this article - https://experienceleague.adobe.com/en/docs/experience-cloud-kcs/kbarticles/ka-23761#This article offers the following workaround:The solution seems to close the resource resolver from just one resource instead of "iterating" over the iterator.For eg://workaround: close internal resource resolver(s)Iterator< Resource> resources = result.getResources(); while (resources.hasNext()) { Resource resource = resources.next(); resource.getResourceResolver().close(); }Appreciate your suggestions!!PS: Tried to use the "suggest an edit" option on that page and got a 404.

I'm doing a journey analysis using raw data from Adobe data feeds in my GCP table. I want to filter rows to only page view events. Is there a way to do that?

Adobe launched multi capping functionality, but custom event is not working in real time based on response. Is that real time based on customer response event.   

How would you do such a use-case that user spent more than 10 sec on some specific site?

In our SDR we use adobe events 251,252,253,254 for google search. We want to check whether these events are available in event.tsv file. But our confusion is which number we need to check in tsv for these events. Could you help us?

Hi, Some time back I posted a question here about "ZIP file referencing not showing in metadata reference links"... We did not locate what the cause was for the ZIP files not showing that they are referenced in the webpages. Lately I was auditing thousands of docx and pdf files. I used Renovator to export the lists of files from the folders. Then in the CSV sheet filtered out the files that has no references. I cross checked a few randomly picked files in the DAM to make sure they have have no reference links in the asset properties. However, with the help of a few users we found out that many files that were reported as not referenced in the webpages, were actually referenced. I confirmed the files were added to the webpages correctly using asset pick tool. Tested it myself. The reference links in the asset properties did not show up! The documents in the webpage are added in the Accordion component. Can components influence this behaviour?I am out of ideas what ma

can data distiller delete a record form profile store event-time series dataset if we provide the 1000s of _id values as part of batch every day ?

Hi Team,How can we display gated content (visible only after the user logs in) through the Dispatcher? Example: I want to display a specific course to users after they log in to the website. Thanks in advance, Syed Shaik. 

Hi, I have different credentials for the dev and prod environments. Both push credentials use the same appID, but the dev credentials were configured with the “Apply to all sandboxes” option enabled, which is why they show as “All” in the sandbox field.  Would this configuration affect push deliveries in the prod environment, considering both credentials share the same appID (one for “All” and one for “Prod”)?  

I use basic query to find a profiles which belong to audience (80k users). Why nothing is returned?? No error SELECT *from profile_snapshot_export_745b62c8_332c_4a79_970e_03660f18b752WHERE segmentMembership.DDA['22eb5450-7b52-4d42-a9bc-e5dea5d34955'] IS NOT NULL why on our demo sandbox I need to use segment.membership.ups ??? 

I have seen many articles in EL on accessing Proof from the main menu and/or how to go to setting to configure BUT none of that is available and not sure if the documentation is outdated.   How do I add Proof to the main menu?How do I access the setting in WF?As nothing is in the layout template to add and nothing under settings for Proof? ThanksDavid

Hello, I am trying to implement a functionality on our HTML5 forms, where i provide a Import button through the profile (jsp). This Import would look for a partially prefilled PDF, once imported, it should prefill the opened HTML5 form. In case prefilling an already opened HTML5 form is not an option, i am still fine to reload the HTML5 form with data prefilled. So far, i have tried, importing the PDF, the extracted XML structure from PDF is not complete, its missing some tags or probably when AEM converts an XDP to HTML5, the element names are different from XDP field names (?). But overall thats what i am trying, any better approaches or thoughts will be really helpful. Thanks again,Abhishek

I have a few Marketo forms in place where I collect consent from people to send text messages to them. By default I have set them as blank and not pre-filled. But whenever I view my forms, these check boxes come as pre-filled. I have cleared the cache, checked in incognito mode and everywhere but I am unable to fix this. Has anyone else faced the same issue and how did you fix this?

I'm creating timeline views in Workfront planning and realized there is no option to show events based on singular dates. It always asks for a start and end date. I want to show events based on one date and create a deployment timeline. Does anyone have any suggestions on how we can get around this limitation