Adobe Campaign

Hello,  Does Adobe have the OOTB feature or capabilities to create a Waterfall report from Workflow activities?  In a previous CRM system, I could easily create a Waterfall that would list all the activities and the quantities associated with them.  Asking because I don't want to go down the route of creating Instance Variables for each activity and writing them out in an Alert.  

Hi all,I'm trying to execute a typology rule based on the variable passed from the workflow. The below is not the exact scenario, but one of the way I'm trying to achieve. Let me know if there are any such usecases you experienced.   

Hi, I am trying to build a workflow which will be used to export data through an API.I have to make multiple joins and also do retrieval of xml fields within clob columns so I have chosen to write sql queries in javascript activities for this.After the javascript retrieval I am populating temporary tables with the data, and then read those tables later in the workflow to build the object being sent to the API. I don't want to send too big requests to the API, therefore I have chosen to loop through the records, until none is left to process. I run this workflow every 30 minutes with a scheduler.This setup works just fine the first time the scheduler is triggered and there are records to process, but not after that first successful run. I have tried inserting to an extension table within the workflow the following code var strSchema = "temp:" + activity.name; var strTable = "wkf" + instance.id + "_" + vars.selectCount + "_" + Date.now(); vars.targetSchema = strSchema

Hi All,I’ve been working on setting up the Control Group using the Advanced Campaign Parameters in Adobe Campaign Classic (ACC) by uploading a predefined list. However, after conducting a test dispatch with two audience members, their tracking data is still visible in the Audit Dashboard.My goal is to analyze campaign performance in the dashboard excluding tracking data for both the seed addresses and the control group.To achieve this, I would appreciate guidance on:Proper configuration of the Control Group in ACC: I want to include all audience members from the uploaded list without using random sampling.Steps to ensure the Control Group and seed list are excluded from performance tracking in the dashboard.If someone could explain the correct setup or point me in the right direction, it would be a great help. Looking forward for a quick response team!!! Thanks in Advance!   

I have a client that for internal seeding of emails that go external in production, there are two profiles per a few individuals. This was caused do to uploading a CSV where the name was in Caps while the profile that already existed had the names in lower case.  If I want to blend the profiles so only the Caps version remains, what is the best way to do that? I probably have 10 profiles like this.  And how do I prevent this from happening again? Is there a way to load profiles or create profiles so capitalization of names does matter?  Thank you, Andrew 

Hello! We would like to request help with this question: Are pressure rules applied considering a week starting on Sunday or Monday? For example: we did send three emails for a country during a week and another email for this same country will be sent on Sunday; will this email be considered the fourth, or is it considered the first of a new week? Thank you in advance,Thais

Hi Team,We have hosted system with Marketing and MTA server separately.We are sending WhatsApp campaign every hour to our Customers, for few deliveries processed and Success indicator remains 0 even after delivery in finished state, but if I manually recompute the delivery all indicator get updated.  It looks like some cache issue to me, delivery 'RecomputeStats' is not able to fetch the details to marketing server from our MTA.Could you please let me know how can we fix this issue.Also I guess we can recompute the indicator using workflow as well using method 'RecomputeStats' on delivery schema.E.g. nms.delivery.RecomputeStats(DeliveryID,Delivery_Status);But daily I have issue with 12-14 delivery for 1 campaign, how can I pass all delivery ID in one method at once. ( If I planned to run this re compute workflow daily at midnight to get correct count in morning reports)Thanks,Saransh Sharma

Hello everyone, I am trying to use "is included in" in the Query activity of a Report where the values are coming from a Textbox of a report through a variable. EX: Country is included in $([vars/Country]) Ex of values: X,Y,Z  Instead of considering it as separate value the condition is considering it as a single string and returning no value.  There is already a similar post but is for the query activity of a Workflow. Solved: Calling instance variable in Query’s ‘Is included ... - Adobe Experience League Community - 641694 Where the accepted answer to modify the query in Advance section of the Query activity But In my case For Report, Query activity doesn't have Advance Tab. Please provide your valuable suggestions.

I've found other thread with the same question, but answer was not clear enough for me. I need to link "nms:recipients" (or our extended abc:recipients table) and abc:agents.  Both have the column codinterno. It is a PK in both schemas.So in my abc:recipients (extension schema), accorind to docs, I should add Database mapping | Adobe Campaign:<element integrity="own" label="Extension" name="extension" revCardinality="single" revLink="recipient" target="cus:extension" type="link"/>So, my "1 to 1 link" should be:<element integrity="own" label="Agents" name="Agents" revCardinality="single" revLink="recipient" target="abc:agents" type="link"/>Right?1.- So how can I specify the relationship is done based on codinterno that is a PK on both schemas?2.- You only modify the recipients schema in this case, or should I add something to the abc:agents schema?

Hello, I'm trying to use the enumeration label in a delivery instead of the internal value in an email delivery. I would like to know how to do it.I've already tried with exportFormat/analyze="true", but I think it only works for deliveries that generate a file.How should I do this for the email delivery?Thank you in advance.  

Hi All,There is one piece of code which encrypts the URL and that is in JS. Basically want to include that in PB and ultimately include that PB in HTML so that it creates encrypted link for all the HTML templates. How we can achieve this.

Hi, Does anyone know which soft bounce types will probably end up in a hard bounce? In my case it could take several months before the maximum of 4 soft bounces is reached. I would like to act on these soft bounces beforehand if there is a large chance that it will turn into a hard bounce eventually. Hopefully there is anyone with experience on this subject. Kind regards,Lara Vlasblom

Can we add 2 or more schedulers in single workflow , such that one scheduler runs at one time and other scheduler runs at another time, as both the schedulers run at different times does the workflow throw any error or cause any issue? Please through some light on this !  

Hello, I use the generic query editor to view and aggregate data and sometimes i have to use the same query in different days. I would like to save the query as a template to use it another time by importing the template.

Hi,I have an import workflow that I would like to execute later in the day on Saturday compared to the weekdays. Is it possible to use two schedulers to start the workflow (one for Saturday and one for weekdays) or should I manage it in another way?/Filip 

Hello everyone, In the "Profile" resource we have created the extended resource and created new fields. We are also creating profiles through API calling this endpoint https://mc.adobe.io/company/campaign/profileAndServicesExt/profile/. This is working correctly but we have added a new field to the profile extended resource and we have added the same field to the API and we are getting the following error 'NewField' property is not valid for the 'profile' resource. It looks like it is not identifying the new field in the API schema? Does anything else have to be done apart from creating it in the resource? Thanks

Is it possible to send JSON format API calls to the Message Center in Adobe Campaign Classic v8?In this documentation for an older version of Campaign Standard, JSON format API calls to the Transactional Message Center are possible: Documentation .However, in Adobe Campaign v8, I have not found any documentation indicating that JSON format API calls to the Message Center are possible - only XML. I have tried sending JSON format calls with the proper 'content-type' header and received an "invalid document structure" error.

Hello All, I am stuck in a requirement where I have to do Join of schemas with condition in adobe campaign classic like this:Do I need to use calculated filed to achieve thisIF iBrandId = 0 then iBranchId=999999else JOINcustomers.iBranchId =orders.iEntityId Please suggest how can we do Join of schemas with condition or Calculated fields in adobe campaign classic like thisplease provide some examples

Dear community! Around 80000 targeted audience are coming from downstream transition but I dont want to target all these in the single execution. it should be create in the single workflow.Example: 80,000 targeted audiencesFrom Sept 11 to sept15 (5 Days) - want to send each day 7000from Sept 18 to 21 (4days) - want to send each day  7500from Sept 24 to Sept 25 (2 days) -want to send each day 8000. Could you please help me to do this.RegardsSatya

Hi,I've been trying to implement some custom SQL functions into the expression editor, but keep encountering one issue that interferes with a clean implementation. The function will return the correct value in the correct type, but the workflow table will choose the wrong type for the column, throwing this:When I attempt to run a pretty simple function:I've been able to work around this by wrapping the function a couple ways, for example:But attempting to just call it as is (or pretty much any custom function), it will default the column to either an int or a string. Is this a known tricky thing to work around, or am I doing something wrong? DB is postgresql.

Hi all, We just had an update to our client console and the webview2 has been added. We are now on version (Adobe campaign classic v7) Since this update when we use the text editor it adds HTML code instantly. But in a lot of instances we don't want the code to be added. For example we make use of the personalization blocks and before the update the code would look like this: <p>This is an test</p> After the update this happens:<!DOCTYPE html> <html> <head> </head> <body> <p>This is an test</p> </body> </html> Is there a way to stop it from adding this code to the text? <!DOCTYPE html> <html> <head> </head> <body> </body> </html>  Hope you can help me out!

Hi all, Seeking your expertise advise on the below scenario.Scenario:We have around 20 to 25 products. These product details are captured in nms:operation table(Campaign table and a custom field).For each of the product, I need to have a different rule.Eg rules:I should not send an email to a recipient(recipient1) if he already received an email for a particular product(product1) within 1 month.I should not send a SMS to the same recipient(recipient1) if he already received a SMS for same product(product1) within 2 month.I should not send a Push message to the same recipient(recipient1) if he already received a push message for same product(product1) within 45 daysPlease check the below details too.There are around 70 combinations like this.For each of these, I have to create a dedicated typology rule. And I will get the product details by navigating from nms:recipient -> nms:broadLogRcp -> nms:delivery -> nms:operation -> product = product1.So finally, for each o

Hi All,  I need your help to understand and implement the integration between Adobe Campaign Classic v7, v8, and the WhatsApp channel for sending notifications. How can I achieve this?  Please help to provide more insights into creating a WhatsApp delivery in campaign workflows. Thanks

Hello, I'm facing a challenge that I need to tackle to be able to lower admin work on my side.I want to use a option as below: And use it in a query like this: Why does this not work? Any solution?

Hello, I've a table that i need to link with Recipient-table. The table is already linked with the SSN for B2C customers and I need to include B2B too and link them to the Recipient table. I've tried several solutions but nothing seems to work.Here is the current link that works for B2C customers:<element integrity="neutral" label="Recipient" name="recipientLink" pkgStatus="never"revCardinality="single" revLink="XXXCampaignLink" target="nms:recipient"type="link"><join xpath-dst="@SSN" xpath-src="@SSN"/></element>I changed it to this:<element integrity="neutral" label="Recipient" name="recipientLink" pkgStatus="never"revCardinality="single" revLink="XXXCampaignLink" target="nms:recipient"type="link"><join xpath-dst="@SSN" xpath-src="@SSN"/><join xpath-dst="@SSNb2b" xpath-src="@SSNb2b"/></element> But it does not work. I have both attributes in the recipient table of course and they are named the same.Any clues?