Scripts: Expression Syntax

ADDING A NEW FIELD

1 - The name of the script

2 - the name of the field being addressed

3 - A literal value in every row using an IF - ELSE statement

4 - the ELSE condition

5 - A regular expression as part of the IF condition

SYNTAX

• {} - address the field content
• '' - literal value in field content 
• == - equals
• != - does not equal
• {field_name}.split ('-')[0] - split a specific field on a certain character (-) and take first element (0)

EXAMPLES

addfieldx

{
"field": "count_emails",
"expression": "'1' if {email} else 0"
}

addfieldx

{
"field": "ad_group2",
"expression": "{Ad group} if {Ad group} in ('Campaign 2018','Summer 2018') else ''"
}

addfieldx

{
"field": "Campaign_duplicate",
"expression": "{Campaign}"
}

addfieldx

{
"field": "New_Publisher",
"expression": "'AlwaysGoogle'"
}

NOTE: To use IF-ELSE logic, read the dedicated help desk article for further information.