Adobe Campaign

I need to now the unique elements of the column: DESCORREOAF from Recipients table. I used this query:SELECT COUNT(DISTINCT DESCORREOAF) AS DESCORREOAF FROM NmsRecipients;But is giving error: 27/09/2023 17:28:54 PGS-220000 PostgreSQL error: ERROR: relation "nmsrecipients" does not exist LINE 1: ...T COUNT(DISTINCT DESCORREOAF) AS DESCORREOAF FROM NmsRecipie... ^ .The column I need to query is this in XML: <attribute name="DESCORREOAF" type="string"/>  

Hello, Is it possible to use conditional HTML formatting in a Transactional Email Template based off of an RT event value? I've been testing with something basic like this: <% if ( <%= rtEvent.ctx.email.@type %> == 'Order' ) { %>Your Order is en route<% } %><% else { %>Your Order is delayed<% } %> I'm testing based on proofs with a seed address that has the following two CTX values: <ctx><email location="somewhere" type="Order"/></ctx>  When I analyze a proof to send, it shows an error around htmlContent -- so I'm wondering if this is just not available functionality in message center. But maybe (hopefully), I'm just doing something wrong. What do you think? Thanks!

In my nms:Recipients, the Adobe Campaign Out Of the Box table,  we have a field called:  manager, that we want to use as BCC. So everytime a client recieves an email, their manager also recieves it.How to do this?  In delivery template I see "Email BCC" , in the delivery tab, but where do I configure the actual BCC email to be used? 

Team,By Mistake, if a workflow or delivery (executed) get deleted, is there any way to recover that deleted workflow or delivery?Is there any recycle table or anything? Thanks!

Hi All,I am recently facing an issue like if I am creating a custom schema with dataSource="nms:extAccount:ffda"  it is not replicating in the xxl schema and I have also started the replication workflow. Could you please help me with this?

Hi there, We started using AEP and the RT-CDP feature. In AEP, there is a HTTP API Destination connector that allows AEP to POST profile data to an API. I am wondering if ACS has some kind of API endpoint that AEP can POST the data to initiate an outbound communication? I looked into the External API function, but it seems to be able to perform GET function (fetch something from an API), as opposed to receiving data from a POST function. Wondering if anyone has a solution for this? Thanks.

We are not able to access List data in adobe campaign, we can see the list name....IN ADOBE campaign upon checking in database we cant find this 'grp table' : any idea why this list data is not access these tables is there any workflow which is deleting the tables?///          

For optimizing analytics, we're looking for a way to configure a brand so the UTM parameters passed will depend on the Campaign Standard e-mail being sent. We assume this must be possible, and that the way to do it is to use applicability conditions in the brand configuration that uses an e-mail's Campaign ID (i.e. DMxxxx), e.g.Parameter name: utm_campaign - Parameter value: 'Mailing X' - applicability condition: "when E-Mail has ID DMxxxx"  We think the answer will be as simple "<function> == 'DMxxxx'", but we can't figure out the right function. Are we even on the right track? UPDATE:Original question has been answered correctly for typical scenarios. Unfortunately, as mentioned in my reply below, I'm looking at a specific scenario where I can't address mailings via DM#, and presumably would need to pass utm_campaign based on a WKF#. Is that even possible?

Hello, I am trying to build a workflow where I extract dynamically the answers from surveys, the answers are stored in the temp schema temp:webAppLogRcpData. To access the temp schema I need to use the activity "Survey Responses", if there is any other way please let me know. I am trying to introduce the WebApp via JS in teh advanced tab:activity.survey.internalName = "YYYY"But this is not working. I have also tried to introduce:activity.survey_cs = "XXXX (YYYYY)"activity.extension.schema[0].element.sysFilter.condition.expr= "[webAppLogRcp/webApp/@internalName] = 'YYYYY"activity.survey.internalName = "YYYYY"; But it is also not working. The activity runs but extracts the information from the Webapp I have selected in the General tab. Can anyone help me with this? 

Hi, I want to add a custom web form for unsubscription link. 2 questions:1) Where do I configure my custom Unsubscription URL2) How will I associate the Unsubscription URL to the web application in Adobe Campaign Thanks,Saurabh

External account says, Integration Successful, as seen below in the Screenshot. "Sending of indicators and campaign attributes" OOB Technical Workflow is getting errored out, attached the Screenshot for reference.  Error in the WF:  Note: whenever this Workflow is running, the 'camapign Id' and 'Broadlog ID' reference is getting reset from the external account. tried adding multiple times in the configure tab, still it is getting reset. Steps taken as of now to fix it:Adobe has increased javascript maxMB from 512 to 1024.we tried recreating the external account as well.below is the setup in the Analytics: Could you please help on this, what could be the reason?

Hello, ca you please help me to change access from other operator group, to Admin in adobe campaign. I have changed to Admin but typology access Management.  Thanks in Advance.

Hi All, I am currently working in Adobe V8. I have created a schema using autopk and also gave there a pk sequence. But when I am trying to insert data into that schema using xtk.session.Write unable to find key values of elements .  I am attaching code and error syntax .    

Hi, text in proof is diferent from HTML, what could be the cause? Proof: Delivery in Campaign:  

Make no mistake – email is still a primary channel marketers rely on to engage with their customers. Research shows that 41% say it’s very critical—up nearly 30% since 2020. And consumers are just as reliant on email, where they prefer brands to communicate with them via email over other channels. Therefore, it is as important as ever to marketers for emails to make it to the inbox and drive engagement. But this can be a challenge, as 1 in 6 legitimate, permission-based marketing emails aren’t delivered (Validity, State of Email, 2023). To succeed with email marketing, email marketers must address challenges related to planning, infrastructure, and data. To support overcoming these, and other challenges, we are excited to announce the availability of deliverability offerings, Essentials, Enhanced, and Plus. These offerings are designed to give you the ultimate flexibility in choosing which package is the best for you and replace all legacy deliverability packages for Campaign

Hi guys, when i create a Direct Mail Delivery from a campaign, it appears in the dashboard before sending.But when it is sent it stops appearing in the previous campaign, and it gets linked to a campaign that didn't exist before sending the delivery.How can i fix this?@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni

 please let me know when these tables are created wkDlv_447220343 We can see there are are so many tables exist in pour db which starts with namespace......"wkDlv And the count of these tables in our db is close to 3000 and it is now affecting db performance can u please tell us when those tables are created, can we delete them from db manaully

Hi All,I have observedwkDlv_815003218:observed tables like starts with wkDlv_81500321 in adobe database is 1lac in counts, can someone lwt me know when these tables are craeted , can we delete them?

We have this formula, it tries to contact Recipients between 8 am and 8 pm,  in this case it is set to 9 am.I'd like to make it directly, like: send this delivery the next day at 9 am. Or even better that the user the possibility to insert directly the date: 28/09/23 at 9 am. Iif( Hour(GetDate())<=8 , AddHours(ToDate(GetDate()),8) , AddHours(AddDays(ToDate(GetDate()),1),9) )

Hi All, I came across this best practice v7 document noting that 'regular data imports must be done in delta mode' to import only modified or new data sets to ACC instead of the entire table. Would anyone know if there is an additional document or guide to importing data in delta mode or can anyone explain how to do this? CheersFrankie 

Hello, is there any way to save a calculated field by expr in database?  When I create a calcualted attribute, it's only saved as XML and not as a database record. I want to keep them after being calculated, so I can make an index. Is there any way?  

Hi All we are facing this error in wkf very frequnetly:09/19/2023 6:05:04 AM enrich223 ODB-240000 ODBC error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is insufficient system memory in resource pool 'default' to run this query. SQLState: 37000if anyone faced same issueplease help to undertand the rootcause and fix of this issue further

Hi there,I'm working on the version upgrade and there are several errors to resolve. This is the first time I'm working with this type of error.One of the errors is "The document with identifier 'nms:delivery' and type 'xtk:form' is in conflict with the new version."How do I solve this problem?Regards

Hi there!I'm working on the version upgrade and there are several errors to resolve. This is the first time I'm working with this type of error.One of the errors is "SOP-330006 The method 'SaveMarketingBuildNumber' is not defined in SOAP service 'xtk:session'. (iRc=-53)"How do I solve this problem?Regards

Hello, I'm Super Beginner. How to store CSV data of Data loding (file) in Javascript variable?Or can read the CSV file directly with JavaScript? Thank you.