since ‎17-08-2018
‎09-02-2021
RaulOcana
Level 2
Statistics by OS, Device, Browser and Domain for a whole year
Avatar

RaulOcana

RaulOcana
- Adobe Campaign Classic
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

Views

2.6K

Likes

0

Replies

1
Exclude recipients schema from Recipient Delivery Log schema + Recipient tracking Log schema
Avatar

RaulOcana

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

Views

2.7K

Likes

0

Replies

2
Build email extracting a pdf from SFTP
Avatar

RaulOcana

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

Views

2.3K

Likes

0

Replies

1
Re: Create a timestamp after a field is updated
Avatar

RaulOcana

RaulOcana
- Adobe Campaign Classic
thank you, it works

Views

3.1K

Likes

0

Replies

0
Create a timestamp after a field is updated
Avatar

RaulOcana

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

Views

3.1K

Likes

0

Replies

2
Re: Control group to check behaviour over deliveries
Avatar

RaulOcana

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

Views

2.4K

Likes

0

Replies

0
Control group to check behaviour over deliveries
Avatar

RaulOcana

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

Views

5.8K

Likes

2

Replies

3
Re: About get the result of Query Activity from JavaScript Activity in a workflow
Avatar

RaulOcana

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

Views

3.6K

Likes

0

Replies

0
Use REGEX to filter emails
Avatar

RaulOcana

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

Views

4.3K

Likes

2

Replies

2
Re: Adobe Campaign Classic - Data Extraction
Avatar

RaulOcana

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

Views

2.6K

Likes

0

Replies

0
Re: Adobe Campaign Classic - Data Extraction
Avatar

RaulOcana

RaulOcana
- Adobe Campaign Classic
like recipients.blacklist equals to Yes ?

Views

2.5K

Likes

0

Replies

0
GDPR - Audit fields changes
Avatar

RaulOcana

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

Views

1.3K

Likes

0

Replies

0
Re: Send random delivery between two options to single user
Avatar

RaulOcana

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

Views

2.2K

Likes

0

Replies

0
Send random delivery between two options to single user
Avatar

RaulOcana

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

Views

3.5K

Like

1

Replies

3
Re: JS to return schema?
Avatar

RaulOcana

RaulOcana
- Adobe Campaign Classic
Alright, thank you Jon!

Views

2.5K

Likes

0

Replies

0
Re: JS to return schema?
Avatar

RaulOcana

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

Views

2.5K

Likes

0

Replies

0
JS to return schema?
Avatar

RaulOcana

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;

Views

4.1K

Likes

0

Replies

4
Re: subquery with 3 schemas is not returning data
Avatar

RaulOcana

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...

Views

2.2K

Likes

0

Replies

0
subquery with 3 schemas is not returning data
Avatar

RaulOcana

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

Views

2.6K

Like

1

Replies

2
query result to JSON object (using javascript action)
Avatar

RaulOcana

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

Views

4.4K

Like

1

Replies

4
using xtk.queryDef to get fields from a subquery?
Avatar

RaulOcana

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

Views

2.0K

Likes

0

Replies

1
Re: Pressure rule for 2 emails per week
Avatar

RaulOcana

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

Views

2.4K

Likes

0

Replies

0
Re: Pressure rule for 2 emails per week
Avatar

RaulOcana

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

Views

2.4K

Likes

0

Replies

0
Re: Pressure rule for 2 emails per week
Avatar

RaulOcana

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

Views

2.4K

Likes

0

Replies

0
Re: Nurturing Workflow
Avatar

RaulOcana

RaulOcana
- Adobe Campaign Classic
Awesome thank you Kapil!

Views

2.4K

Like

1

Replies

0
Re: Nurturing Workflow
Avatar

RaulOcana

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

Views

2.4K

Likes

0

Replies

0
Pressure rule for 2 emails per week
Avatar

RaulOcana

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

Views

8.1K

Like

1

Replies

9
Nurturing Workflow
Avatar

RaulOcana

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...

Views

4.8K

Likes

3

Replies

4
Re: Skip typology rule
Avatar

RaulOcana

RaulOcana
- Adobe Campaign Classic
thank you Jon

Views

1.9K

Likes

0

Replies

0
Re: Skip typology rule
Avatar

RaulOcana

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

Views

1.9K

Likes

0

Replies

0