Hi guys, I know there is a report Open tracking which shows the statistics for OS, Device, Browser and email Domain, but it doesn't work when I pick several deliveries. Is there an option, through a Query, to get this information for a whole year? Regards,Raúl

Exclude recipients schema from Recipient Delivery Log schema + Recipient tracking Log schema RaulOcana - Adobe Campaign Classic

Hi guys, I created an exclusion from Recipient Delivery Log schema vs Recipient tracking Log schema from several deliveries to get the "No Openers". Now I have received a list that was uploaded into Recipients schema and I need to exclude this list to the No Openers result. I have tried Change dimension or Enrichment to find a workaround but either I get errors or the exclusion throws 0 results. Do you guys know how to solve it? Regards,Raúl

Build email extracting a pdf from SFTP RaulOcana - Adobe Campaign Classic

Hi guys, I have to send several emails to our customers, each email has it's own database (csv file from SFTP) and it's own attachment (pdf from SFTP). I know how to automatically extract the CSV file to prepare the segmentation and send the emails on a workflow, but is there a way to extract the PDF from the SFTP and attach it to the html before sending it automatically? Thanks! Regards,Raúl

Re: Create a timestamp after a field is updated RaulOcana - Adobe Campaign Classic

thank you, it works

Create a timestamp after a field is updated RaulOcana - Adobe Campaign Classic

Hi guys, It is possible to insert a date (in a new field) once a recipient's field is updated, for instance, the blacklist field? So we can check when a user opted-in or opted-out? Thank you! Regards,Raúl

Re: Control group to check behaviour over deliveries RaulOcana - Adobe Campaign Classic

Hi Kapil,I don't get it. People from Delivery #1 will be split in the next deliveries, some random will be in #3, others in #7 and so on.How could I get the Opens, Clicks, etc from those deliveries, but only taking into account the group of #1 delivery?Thank you!Regards,Raúl

Control group to check behaviour over deliveries RaulOcana - Adobe Campaign Classic

Hi guys,Is there such an option or a "workaround" to check the behaviour a group of people (a list or a specific delivery) over other deliveries?So if I sent a Delivery #1. I want to check all the poeple of Delivery #1 across all future deliveries. And with check I mean, see Opens, Clicks, OPt-Outs, etc.Thank you!Regards,Raúl

Re: About get the result of Query Activity from JavaScript Activity in a workflow RaulOcana - Adobe Campaign Standard

Hi,Can this be done with SQL-type-of query? I need to use Regular Expressions...Thank you!

Use REGEX to filter emails RaulOcana - Adobe Campaign Classic

Hi guys,I was reading that ACC understands REGEX using LIKE operator. So I used @email LIKE '^[A-Za-z]+[A-Za-z0-9\._-]+@[A-Za-z0-9\.-]+\.[A-Za-z]{2,5}[\.]*$'to filter all emails that matches the REGEX expression, however it its returning 0 results.Is this the correct way to use it or am I missing something?Thank you!- Raúl

Re: Adobe Campaign Classic - Data Extraction RaulOcana - Adobe Campaign Classic

Hi Dusan,There is not a date field for that. I think you must extend your recipients schema so you can store the opt-out date and any other needed field.-Raúl

Re: Adobe Campaign Classic - Data Extraction RaulOcana - Adobe Campaign Classic

like recipients.blacklist equals to Yes ?

GDPR - Audit fields changes RaulOcana - Adobe Campaign Classic

Hi guys,Due ACC doesn't track changes (old value vs new value) of recipient's fields, it is necessary to implement an audit tracking system so it stores every change or at least the last change on a specific field?For instance, I want to track the date+time and the campaign where a user opted-out from a campaign. So basically is to create something like a trigger that is activated each time the blacklist field has changed.Is that possible or are there any GDPR features in campaign?Regards,Raúl

Re: Send random delivery between two options to single user RaulOcana - Adobe Campaign Classic

Hi Anita,Thanks for your response. I will always have one record on the flow, but I want the system to send the delivery randomly, I mean, sometimes send the A and other times the B, but never both.The set up that I posted is always picking the A option since my segment is always 1 record.Regards,Raúl

Send random delivery between two options to single user RaulOcana - Adobe Campaign Classic

Hi guys,I have this WF that is triggered by a query that reads a schema and sends the delivery. The point is that I have two deliveries (A and B) and I want that to send the A or B randomly. Since there is only 1 person by send, I don't know how to use the Split activity since it is based on segment and my segment is always 1. So this set is not working:Do you have any idea how to workaround this please?Regards,Raúl

Re: JS to return schema? RaulOcana - Adobe Campaign Classic

Alright, thank you Jon!

Re: JS to return schema? RaulOcana - Adobe Campaign Classic

Hi Jon,So you mean that I have to delete the records that doesn't match with the criteria from the "temp" result, right? That will only affect the temp results or it will delete it from the actual schema?Thank you!-Raúl

JS to return schema? RaulOcana - Adobe Campaign Classic

Hi guys,Is it possible to Query a schema, send it to a Javascript to apply a condition and then return the schema result, therefore send it to another flow activity? I have tried it without result.Here's my jsquery = xtk.queryDef.create( );resultSet = query.ExecuteQuery();return resultSet;

Re: subquery with 3 schemas is not returning data RaulOcana - Adobe Campaign Classic

I ended out using a SQL expression and it worked.var sql = "select ai.iId_aeropuerto, ai.iId_ciudad, ai.iId_pais, ai.sCodigo_iata, ai." + name + ", ci.sCodigo_iata, ci." + name + ", co.iId_region, co.sCodigo_iata, co." + name + " from SearchAirport ai join SearchCity ci on ai.iId_ciudad = ci.iId_ciudad join SearchCountry co on ci.iId_pais = co.iId_pais where ai.sCodigo_iata = '" + iataCode + "'";var format = "resSQLResult, @idAirport:string, @idCity:string, @idCountry:string, @iataAirport:string...

subquery with 3 schemas is not returning data RaulOcana - Adobe Campaign Classic

Hi guys,I have built this query to join 3 schemas, but when executing is not returning any data, if I use only one sub-query it does work, but adding a second schema to join, it fails.var query = xtk.queryDef.create( );query.SelectAll(false);result = query.ExecuteQuery();Regards,Raúl

query result to JSON object (using javascript action) RaulOcana - Adobe Campaign Classic

Hi guys,It is possible to convert from a query result to a JSON object?This is the query:var query = xtk.queryDef.create( );query.SelectAll(false);result = query.ExecuteQuery();The result is: Thank you!Regards,Raúl

using xtk.queryDef to get fields from a subquery? RaulOcana - Adobe Campaign Classic

Hi team,It is possible to get the fields from a sub-query?I have created a query so it joins two schemas, but I need to bring ALL fields from main and sub schemas, is that possible?Regards,Raúl

Re: Pressure rule for 2 emails per week RaulOcana - Adobe Campaign Classic

Hi Marcel,Thank you that was a very detailed explanation.But I have a question, why aren't you using a pressure rule, weren't those made for that? and maybe using them will avoid the fact to create "custom" queries to match the required scenario? Regards,Raúl

Re: Pressure rule for 2 emails per week RaulOcana - Adobe Campaign Classic

Hi Marcel,So if we avoid the part of "future events", how can I set up the rules so if I send on Thu, it will check past deliveries from Monday to date if there are 1 or more?Thank you!Regards,Raúl

Re: Pressure rule for 2 emails per week RaulOcana - Adobe Campaign Classic

Hi Kapil,I have created the rule and added it to a Typology. But how can I set it so it evaluates the week from Monday to Sunday? So if the max numero of deliveries is two in a week, that checks only from last Monday to next Sunday (if there are scheduled deliveries).Regards,Raúl

Re: Nurturing Workflow RaulOcana - Adobe Campaign Classic

Awesome thank you Kapil!

Re: Nurturing Workflow RaulOcana - Adobe Campaign Classic

Hi Craig,Thanks for your response. So how it is possible to achieve a Nurture Campaign in ACC?Regards,Raúl

Pressure rule for 2 emails per week RaulOcana - Adobe Campaign Classic

I'm trying to understand how to set up the pressure rule so the system will allow to send only 2 emails per week.But I don't understand how to set the period so the week starts at Sunday and ends on Saturday, so that is the only period of time to check the past or scheduled deliveries. Also I want to trigger this rule only in certain deliveries, I know I can control this by the Scheduling option of each delivery. If I set it blank the rule won't be triggered, right?Thanks!Regards,Raúl

Nurturing Workflow RaulOcana - Adobe Campaign Classic

Hi guys,I've been creating a nurturing workflow, the idea is that this WF will be triggered each 15 minutes and will do a query then send an email, wait for 3 days, then send the second email, wait for 5 days and finally send a last email. After that a last query will check for Openers and No Openers and add those to a list.I have 2 questions.1. Due the WF runs every 15 minutes, but it sets recipients on a wait activity, will it queue them or will it restart the whole wf and therefore it will ne...

Re: Skip typology rule RaulOcana - Adobe Campaign Classic

thank you Jon

Re: Skip typology rule RaulOcana - Adobe Campaign Classic

Hi Jon,Thank you, so I have to use 2 typology rules, one for normal deliveries and other for operational emails. But why did you say about moving an optimisation rule?Regards,Raúl

Likes given to

User

Count

Likes from

User

Count

Guidelines

Cookie preferences