since ‎05-12-2017
‎10-12-2019
christophec3473
Level 2
Re: Trigger Workflow in Campaign V6
Avatar

christophec3473

christophec3473
- Adobe Campaign Standard
It's just the default name of the default Typology. So it's just an example.Christophe

Views

559

Like

1

Replies

0
Re: Trigger Workflow in Campaign V6
Avatar

christophec3473

christophec3473
- Adobe Campaign Standard
Hi,The goal is to design a workflow with a main target and the target to exclude. This target corresponds to recipient from delivery whose the typology is Trigger. In my example, it will be defaultTypologyWe need to parameter our query (nom interne de diffusions égal...).Open it and clic on the button (red square)Select BroadlogRcpThis table content all recipients having received previously a messageClic on delivery (red square)In the delivery schema, open typology and select your criteria (@lab...

Views

559

Like

1

Replies

0
Re: Trigger Workflow in Campaign V6
Avatar

christophec3473

christophec3473
- Adobe Campaign Standard
Hi,You can add a filter rule where broadlogRcp/delivery such as typology.@name = "Trigger".It's an idea.Or you give always the same beginining of name to your campaign with Trigger "Trigger_XXXXX", "Trigger_YYYYY" and after you can design a rule easier to build and using this field delivery.@label.Christophe

Views

553

Like

1

Replies

0
Re: Insert records in 'trackingLogRcp'
Avatar

christophec3473

christophec3473
- Adobe Campaign Standard
Hi,It's not a good practice to update or insert data in broadlog or trackingLog (Adobe Staff Advice).It's better to create a table link to recipient to bring back your tracking. You can too create agregage to avoid 0-n relation.Same for historical delivery.After, you can do queries on this new table easily.Christophe

Views

2.4K

Likes

2

Replies

1
Re: Clearing Segment Codes
Avatar

christophec3473

christophec3473
- Adobe Campaign Standard
Hi,You can get the temporary table name with a Javascript activity : vars.tableName.After with a SQL activity, you can update a codeSegment of this temporary table.Christophe

Views

941

Likes

2

Replies

0
Re: How to query recipients targeted for a failed delivery
Avatar

christophec3473

christophec3473
- Adobe Campaign Standard
Hi,U have the field @state which give you the state of a delivery.To find the recipient, you can begin your query by broadlogRcp as delivery.@state = ...I answer to your question ?Christophe

Views

242

Like

1

Replies

0
Re: Execute JS in subject variable
Avatar

christophec3473

christophec3473
- Adobe Campaign Standard
Hi,If you use a typologie rule which consider the content of your delivery text content, you will able to add your script in this content.//script in your rulevar txtStr = delivery.content.text.source;delivery.content.text.source = '<% document.write(delivery.mailParameters.subject); %>' + txtStr;Return true;I don't know if your Javascript don't work in the text context but, it's ok in the html context.This answer can help you ?Christophe

Views

596

Like

1

Replies

0
Re: Temporary lookup tables within the workflow
Avatar

christophec3473

christophec3473
- Adobe Campaign Standard
Hi,I'm not sure to understand but, I try to answer to you :If you use a upload data activity (if yours datas are in a Excel file for example)If you use a query activity (if yours data are in a schema on Adobe Campaign)You will obtain your temporary table.After that, you can use a union activity to join these data to recipient dataI answer to your question?Christophe

Views

653

Like

1

Replies

0
Likes given to