Hi Salvatore, I don't think you can do it in one filter as you need the count of clicks and count of deliveries received on the same period.But you can achieve it in an workflow using count on clicks, count on messages received and apply ratioOther than that, you have 2 ootb filters 'By number of clicks' and 'By number of messages received' that may be helpful ThanksDavid

Re: Not authorized to use SQL expressions DavidKangni - Adobe Campaign Classic

Hi, Add this option XtkPassUnknownSQLFunctionsToRDBMS and set it as integer with value equal to 1 ThanksDavid

Re: Resend the message who did not open the email 1st time DavidKangni - Adobe Campaign Classic

Right Click on the delivery then Open...you will see a pop up window ThanksDavid

Re: operation-id (Campaign) link is empty for Continuous... DavidKangni - Adobe Campaign Classic

Hi Darren,deliveries under Deliveries tab are automatically attached to Campaign. But deliveries under actions tab are not automatically linked as you can linked them in the technical workflows.So if you want to use them in a campaign, then you need to use a code. ThanksDavid

Re: Resend the message who did not open the email 1st time DavidKangni - Adobe Campaign Classic

Hi,You can build something like that. Once your target is identified and your first delivery created, you need to segment the target into different populations using filtering conditions.Add a Split activity to the workflow and open it.For the first subset, select the Add a filtering condition on the inbound population option and click Edit .Select Recipients of a delivery as the restriction filter and click Next .In the filter settings, select Recipients who have not opened or clicked (email) f...

Re: operation-id (Campaign) link is empty for Continuous... DavidKangni - Adobe Campaign Classic

Hi Darren, It's expected for deliveries under actions tab as they can be use in standalone workflows (workflows not linked to a campaign).If you need to attached them just add a js activity after the delivery and write a code.delivery.operation_id = instance.operation_id;ThanksDavid

Re: External API activity DavidKangni - Adobe Campaign Standard

Hi, Please note that the External API activity is meant for fetching of campaign-wide data (latest set of offers, latest scores etc.), not for retrieving specific information for each profile as that can result in large amounts of data being transferred. If the use case requires this, the recommendation is to use the Transfer File activity. ThanksDavid

Re: ACS - Unsubscription Error DavidKangni - Adobe Campaign Standard

Hi Michelle, As the opt out is working and confirmation message sending is the issue, please check the criteria for this confirmation message.You may also need to check if the key displayed in your error message exists. ThanksDavid

Re: Add UTM parameters with typology rules on Campaign DavidKangni - Adobe Campaign Classic

Hi Salvatore, The click tracking formula in Adobe Campaign can be modified to include UTM parameters. This is achieved by modifying the NmsTracking_ClickFormula contained in Administration > Platform > Options ThanksDavid

Re: Questions related to Adobe MC DavidKangni - Adobe Campaign Classic

Can you test the connection from the external account folder in ACC?

Re: Questions related to Adobe MC DavidKangni - Adobe Campaign Classic

you should use /nl/jsp/schemawsdl.jsp?schema=nms:rtEvent

Re: Questions related to Adobe MC DavidKangni - Adobe Campaign Classic

Hi 1) is it possible to add attachments (dynamic) to the transnational email?Yes, you need to upload the attachments on a sftp that url is accessible publicly2) is it allow to send a regular email (dynamic Subject, body, from and to)Yes, but there are some limitations. You need to pass them through variables in your payload e.g ctx.rtEvent.SubjectLine.For the from address it needs to be an authorized address on deliverability side ThanksDavid

Re: HELP - Understanding Delivery Indicators DavidKangni - Adobe Campaign Classic

Hi Wes, See there an explanation of Adobe campaign calculation method.For your export, you can build something like the screenshot belowquery the delivery from tracking logs to get all the logssplit and keep only url type equal opendedup on the recipient ID extract the fileOne more thing, I think if someone clicked on opt out link (flagged as opt-out category in ACC) it's not count in opens nor clicks in the reports ThanksDavid

Re: Derive Day of Week from Date DavidKangni - Adobe Campaign Classic

You can use formatDate option % A for short day name in a javascript https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/f-formatDate.html?hl=formatdate

Re: Any super users or experts available DavidKangni - Adobe Campaign Standard

For the reconciliation error, you need to use reconciliation keys instead of targeting dimension.The error on the file deletion: it's deleted the file from the sftp or s3 once it's picked. it's not deleting the file after the import is completed. You need someone to dive in the tool and fix your issues.ThanksDavid

Re: How can I change the date format in an email delivery... DavidKangni - Adobe Campaign Standard

you can use <%= formatDate(new Date(), "%4Y%2M%2D%2H%2N%2S") %>. replace newDate() by your date field

Re: How to set typology rule to restrict no of communicat... DavidKangni - Adobe Campaign Classic

Hi Maheswari, Depending on your offering, Campaign Optimization can be included or an add-on. Please check your license agreement.If you have Campaign Optimization then refer to Pressure rules.If you don't have the module, you can use a filter rule by counting the sent delivery logs in the last days. ThanksDavid

Re: How can I change the date format in an email delivery... DavidKangni - Adobe Campaign Standard

Hi Bjorn, For the date you can use formatDate function in your html. Not sure if there is an equivalent in Dutch but I knew it's working for English and French.For the number, ACS is not that custom so the approach is to convert the fields as string befor your delivery. ThanksDavid

Re: Is there a way in ACS to consume exposed APIs DavidKangni - Adobe Campaign Standard

external API is meant for fetching of campaign wide data (latest set of offers, latest scores etc.) not for retrieving specific information for each profile as that can result in large amounts of data being transferred.

Re: User history for export lists DavidKangni - Adobe Campaign Classic

You can update the form to keep a trace of export job in the database

Re: Is there a way in ACS to consume exposed APIs DavidKangni - Adobe Campaign Standard

Hi Chan, ACS is not able to do any outbound API call and all the inbound API calls need to go through Adobe IO. ThanksDavid

Re: Email testing: How to add targeted profiles from an e... DavidKangni - Adobe Campaign Standard

Hi Bjorn, You have to configure the schedule to not send the email immediately. Thanks

Re: ACS - Data backup and restore guidelines DavidKangni - Adobe Campaign Standard

Hi Mohini, You have to contact Adobe Support to get your backup policy. I knew that they are doing several database backup per day on ACS and they are able to restore everything on demand. ThanksDavid

Re: Email testing: How to add targeted profiles from an e... DavidKangni - Adobe Campaign Standard

Hi Bjorn, It will not appear in your recurring delivery but in a normal delivery. Can you check the delivery generated when you run your workflow? ThanksDavid

Re: Email testing: How to add targeted profiles from an e... DavidKangni - Adobe Campaign Standard

Hi Bjorn, You need to prepare the delivery first and then the option will be available. ThanksDavid

Re: JWT creation in Adobe IO console for Adobe Campaign S... DavidKangni - Adobe Campaign Standard

Hi Subrat, Yes it's do-able.You can request a python code from Adobe Support. It is a set of 3 python files (config.py, create_JWT.py and get_accessToken_from_JWT.py)You can also follow this process Using Postman for JWT Authentication on Adobe I/OThanksDavid

Re: How to export columns dynamically in ACC? DavidKangni - Adobe Campaign Classic

Hi Jon,@wodnicki It's a set of cols per event ThanksDavid

How to export columns dynamically in ACC? DavidKangni - Adobe Campaign Classic

Hi All, I have a requirement to export data dynamically in ACC. Basically i have my recipients who can attend events from 1 to 10. So i can do a campaign today with 3 incoming events or 5 events. My question is there a way to generate an export dynamically of the recipients info + number of events using a JS activity?If yes, can someone provide a snippet of code? ThanksDavid

Likes given to

User

Count

Likes from

User

Count