To understand the general principles for using first party data with the Passendo Adserver, please first consult this article: First Party Data onboarding .
In this article, we will dive into exactly how the ‘key value booking string’ field on bookings is used, what the correct syntax to use is, and how multiple variables can be used.
The field used for matching a booking with first party data points that are set up on a placement, is found on the create/edit bookingpage:
The field needs to contain only the key value pairs, not the whole url link of the placement. It needs to be used with caution, since the booking will only be eligible if the input matches 100% 1:1 with the tag output.
For example, if the placement output is:
images.passendo.com/2/1234/support@passendo.com/01-01-2001?datapoint=adserver
… but the key value booking string field contains “data=adserver”, the booking would NOT be shown. Of course, if the parameter is correct, but the variable is not, the booking will not be shown either, i.e. “datapoint=SSP” in this example.
Syntax
The Key Value Booking String field supports using equations, less than/greater than, not-equal-to statements and logical operators like "AND", "OR", to separate multiple key value pairs.
| Statements and operators | Examples | Explanation |
| = | key=value | Equals to is expressed with “=” between the parameter and the variable. |
| != | key!=value | Not-equals-to is expressed with "!=" between the parameter and the variable. |
| > | key>value | Less than is expressed with ">" betweeen the parameter and the variable |
| < | key<value | Grater than is expressed with ">" betweeen the parameter and the variable |
| >= or <= | key>=value or key<=value | Grater/Less than or equal to is expressed with ">="/"<=" betweeen the parameter and the variable |
| [-] | age=[18-35] | Define a range of variables within square brakets [value-value] |
| OR / , |
city=copenhagen,newyork,belgrade
city=copenhagen OR city=newyork OR city=belgrade |
The booking will be shown if ANY of the conditions are met.
|
| AND | age=20 AND gender=female | The booking will be shown if both conditions are met. |
| Combination of logical operators | (key=value AND key=value) OR (key>value AND key<value AND key=value) |
Syntax rules:
-
no spaces between key, operator and value. Example: age=20/age>20/country!=denmark
-
space between the logical operations (AND, OR). Example: age=20 AND gender=female
- you can also use commas to separate multiple variables: key=x,y,z
- if you are using OR operator you need to include the parameter for each variable. Example: city=copenhagen OR city=newyork OR city=belgrade
-
do not use quotes. Example: gender=”female”
Examples
1. Booking input: Gender=F OR City=Washington
Placement output: images.passendo.com/2/1234/support@passendo.com/01-01-2001?Gender=F&City=Copenhagen
This booking will be SHOWN, because the “Gender=F” parameter is matching with the “Gender=F” part of the booking input, even though the “City” variable is not fulfilled.
2. Booking input: age=[18-25]
Here, a broader group of users can be included in the booking’s targeting. Consider a few different placement outputs:
Placement output
images.passendo.com/2/1234/support@passendo.com/01-01-2001?Age=18
images.passendo.com/2/1234/sales@passendo.com/01-01-2001?Age=30
For these two users, the booking input “Age=18” would mean the booking would be SHOWN, while “Age=30” would mean that the booking would NOT be shown.
3. Booking input: (age=20 AND gender=m) OR (age>20 AND age<30 AND gender=f)
Placement output
images.passendo.com/2/1234/support@passendo.com/01-01-2001?age=22&gender=f
Here, the booking input “age=22,gender=f” means the booking is SHOWN, since both parameters are fulfilled.