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'"
  }