Product Communities

In this post, we’ll explore how to manage dynamic SQL audience in Data Distiller by using the INSERT OVERWRITE INTO command. This capability enables you to fully refresh the contents of an audience with the results of a new SQL query, making it ideal for use cases that require recurring or complete audience updates, such as monthly re-qualification or based on customer behavioral pattern. What is INSERT OVERWRITE INTO?Unlike the standard INSERT INTO command, which adds new profiles to an existing audience, INSERT OVERWRITE INTO removes all current audience members and replaces them with only the profiles returned by your SQL query. This ensures precision and control when updating SQL audience definitions at scale. Audience Behavior in Real-Time Customer ProfileWhen an overwrite occurs, Real-Time Customer Profile applies the following logic:New profiles in the batch → marked as enteredRemoved profiles (not in the new batch) → marked as exitedUnchanged profiles → no action take

I haven’t been able to locate any documentation regarding SPA integration. I came across the following link through a Google search, but it doesn’t redirect to the correct page:https://experienceleague.adobe.com/docs/analytics-learn/tutorials/implementation/spa-pages/using-best-practices-when-tracking-spa.html?lang=en#running-s-t-or-s-tl-in-the-launch-ruleDoes anyone know the correct URL? Additionally, I’m trying to determine whether I should use a direct call or create a custom event when working with Adobe Launch.

Right now we have a manual Analytics implementation and really want to update to using Data Collection.  Outside of a couple of videos, I'm having a devil of a time finding documentation to implement Data Collection for the first time and then add Analytics.  Would anyone know where this documentation is? We aren't interested in Web SDK at all at this time.  I realize Adobe is really trying to push everyone towards it, but we aren't ready for that.  

Hi all!I just built a Proof Approvals report that lists every potential proof decision within a few specific programs (groupings are Approver Role > Approver Name > Document Version Decision). I noticed that under one approver's name, there was a pending approval for a proof he had been removed from a few months ago... I've had similar issues on another report as well.Is there a way to fully remove an approver so they don't show up in reporting?Thanks in advance!

Looking for some insight. We were recently hitting customer inboxes at 100% in Gmail, there's been a sudden nosedive to 50% of our emails hitting inboxes. We send from a dedicated IP that is DMARC Compliant, and we are on no Block Lists. We are one-click unsubscribe compliant as well, and all of our sends are from monitored inboxes (no noreply). What could be the cause for the sudden drop? We aren't hitting inboxes for Outlook either - but that has been an ongoing issue that we're trying to resolve with them.

In our previous system, each "campaign" had a unique number assigned to it.  The numbers grow by 1 with each campaign created.  In Workfront, the Programs have IDs, but they are alphanumeric and very long.  Ideally we need to create an auto-generated number that can be used to help search and track the Program.  Something along the lines of a 5-digit number that can grow as our number of Programs increases.  Is there a way to create a calculated field that will produce this or use Fusion to assist?  Thank you for any assistance!

Objective: I am trying to find the number of people - per week - who visit BOTH our "Offers" and "Rewards" pages. And I need to trend this audience over time.  What did I try?: I created two filters - one for Persons visiting the "Offers" path, and another for the "Rewards" path. I then created a Freeform table, with Week as the table index, and People as the metric. Lastly, I stacked both filters on the People metric, with the intention of filtering people who visited BOTH "Offers" and "Rewards" pages by week.  Result: When the global project date range filter is restricted to a specific week, the result is as expected - I get around 560K people. However, when this date range is expanded, the result balloons to over 2.3M, which is obviously incorrect, since the max cannot exceed the minimum size of these two audiences, which is around 820K.  Ask: How do I get the freeform table to only apply the Filter criteria for the individual weeks

Watch now Join Adobe CJA champions and Experience Maker award winners Katie Klein and Lokesh Alluri as they dive deep into customer journey analytics (CJA) and explore its transformative potential for your business.What you'll learn:Understanding CJA: Learn what CJA is and how it differs from AA.Strategic framework: Discover the steps for data ingestion, enablement, and adoption to maximize ROI.Web SDK insights: Find out if Web SDK is necessary for CJA and explore alternatives.CJA vs. AA: Understand the relationship between CJA and AA, and explore options for integration.Profile data importance: Learn about the significance of profile data and how to overcome related challenges.Implementation best practices: Get tips on use case-driven approaches, scalable data ingestion, and establishing governance practices.Examples of CJA capabilities: See real-world examples of what CJA can achieve.What if I don’t have CJA? No worries! Whether you're interested in what CJA implementation looks

Hello - is there a way to run a report that shows you all the calendars and who the owners are? Since Workfront considers it a kind of report I thought it might come up in a report about report owners but they didn't. I appreciate any insight. Thanks.

Hi Community,I see frequent Adobe status messages relating to "Workfront Application(Redrock)" but what is Redrock? Am I missing issues?ThanksMatt

One of our teams uses a custom form which request descriptions which can be rather long.I have built a report to summarise information submitted on the custom form which contains the description fields. I have included a screenshot to illustrate an example of the length.Is there a way to limit the amount of detail shown in the report details tab without removing this column? A way so only, for example, half of the content is shown?

Hey, is there a way to adjust work week in balancer for each employee separately, e.g. if I need one person to work only Thu-Fri and the other one on Mon-Wed? If I enter their schedule it gets distributed throughout the full week and I need 8h daily but only on 2 or 3 days for part timers, the rest of days should be greyed out the same way weekend is, thanks in advance!

Greetings! We recently made a UTM generator form that's 1:1 - meaning it builds all the UTMs necessary per channel for one singular URL. However, we haven't figured out how to do this when multiple URLs are involved for a campaign. Do any of you have suggestions?Would you use Fusion? Or, is it possible to generate without Fusion? TY

Hi All , recently i created a custom target mapping on acc v8 lets say named as “ABC” out of which 3 schemas for delivery, exclusion, tracking where created but now i want to delete it as requirement changes , but while deleting its giving “delivery linked” error i too check that no delivery is linked as it is new instance , secondly tried renaming and tried to create new target mapping on same schema but not able to save it it giving error and finally not able to create any new target mapping on schema used un ABC while i can create target mapping with other schema , how to resolve it . 

Hi,  I am working on creating a new template in the new Marketo email builder and am struggling to find resources about using background colors.  I have created a 2:1 structure and filled this with text and a button. I would like to make the background color different from the email viewport and cannot determine the best way to do this. If I use a container then fill it with content the container is not responsive. Has anyone been able to solve for this?

Depuis la console administration Adobe (https://adminconsole.adobe.com/), j'ai ajouté les droits à un utilisateur sur AEM.Depuis AEM je recherche l'utilisateur mais il n'apparait pas.J'ai essayé en créant l'utilisateur par le suite directement dans AEM mais cela ne fonctionne pas, l'utilisateur ne peut pas se connecter. L'utilisateur créé dans la console d'administration est bien répliqué dans AEM ? il ne faut pas le recréer ?

Hi, What is the difference between the below terms: 1. Quarantined addresses vs Denylisted addresses vs Blacklisted addresses 2. Blacklisted profile vs Denylisted profile

Hi,is there a way to limit the creation or publish or both at user/role permission level in AEP?i d like to have an approval process for audience creation and publish but i cannot find anything about this in the Permission section

Hi, if an user marks an email as spam or unsubscribes from an email, will the profile be denylisted for that particular channel but continue to receive communications for other channels? Do the terms blacklist and denylist mean the same thing here?

Hi, If an user has marked an email as spam and if the user is asked to "unspam" the email, then will the user be removed from the Quarantine list after that?

If I prolong my visitor profile lifetime from 14 to 90 days how it may affect my license costs? What to be cautious about?

Hi, I need help with Dynamic Media Video Thumbnail configuration.So far what I've done:Established connection on the cloud services -> Dynamic Media Configuration.I saw a video where it stated that Dynamic Media should be enabled on CRX at this location /etc/dam/dynamicmediaconfig which I have already set the value to true.Still after I upload my video in a folder, I can't click the thumbnail button and it seems like Dynamic Media is not generating the thumbnails at all. Can someone help or point out what else am I missing. Thank you in advance!

in creating audiences what are the uses cases for choosing compose audience vs segment builder? thanks