Variables

Default variables

User universe

• 'User ID'

• 'Hashed email address'

• 'First visit date'

• 'Last visit date'

• 'Total page views'

• 'Total conversion amount'

• 'First conversion date'

• 'Last conversion date'

• 'Continent' 'Country'

• 'Region' 'City'

• 'Postal code'

• 'User gender'

• 'User age in years'

• 'User postal code'

• 'User address'

• 'User firstname'

• 'User lastname'

• 'Timestamp'

• 'Stream segment public IDs'

• 'Stream segment labels'

• 'Audience public IDs'

• 'Audience labels'

• 'User alias'

• 'User category'

• 'User agency'

• 'User loyalty card id'

• 'Last Device Name'

• 'Last Device Type'

• 'Total sessions'

• 'User Id List'

• 'User Email Hash List'

• 'Is master user'

• 'Original Products Count'

• 'Cancelled Products Count'

• 'Returned Products Count'

• 'Exchanged Products Count'

• 'Final Products Count'

• 'Total Original Conversion Amount'

• 'Total Cancelled Conversion Amount'

• 'Total Returned Conversion Amount'

• 'Total Exchanged Conversion Amount'

• 'Total Final Conversion Amount'

• 'Number of conversions'

• 'Date of First Conversion'

• 'Date of Last Conversion'

• 'Flags'

Pageviews universe

• 'New session'

• 'Env template'

• 'Env work'

• 'Country'

• 'Language'

• 'Channel'

• 'User ID'

• 'User logged'

• 'Gender'

• 'Age'

• 'Postal code'

• 'Address'

• 'Fistname'

• 'Lastname'

• 'Email (hashed)'

• 'New customer'

• 'Page Category 1 name'

• 'Page Category 2 name'

• 'Page Category 3 name'

• 'Page Category 1 ID'

• 'Page Category 2 ID'

• 'Page Category 3 ID'

• 'Key Words'

• 'Product ID'

• 'Product ID variation'

• 'Product name'

• 'Product name variation'

• 'Product quantity'

• 'Product unit price'

• 'Product unit price discount'

• 'Product URL'

• 'Product Image URL'

• 'Product Category 1 ID'

• 'Product Category 2 ID'

• 'Product Category 3 ID'

• 'Product Category 1 name'

• 'Product Category 2 name'

• 'Product Category 3 name'

• 'Product custom field 1'

• 'Product custom field 2'

• 'Product custom field 3'

• 'Product custom field 4'

• 'Product custom field 5'

• 'Basket ID'

• 'Basket custom field 1'

• 'Basket custom field 2'

• 'Basket custom field 3'

• 'Basket custom field 4'

• 'Basket custom field 5'

• 'Order ID'

• 'Order amount'

• 'Order products number'

• 'Conversion Product Name'

• 'Products list'

• 'Ordered products list'

If you need to map your segments:

• Stream segment labels => Labels of segments selected for the stream

• Stream segment public IDs => IDs of segments selected for the stream

• Audience labels => Labels of all segments to which the user belongs

• Audience public IDs => IDs of all segments to which the user belongs

Q&A

"Default variables" means ...

1. They are declared on each account per default? --> Yes, by our servers

2. They are populated automatically by DataCommander tag? No

'Custom variables' are variables that could be created especially for you, to suit to your business. Limits:

Variable name : varchar(128) Variable shortname : varchar(55)

TRUST variables

Consents from our product Trust (our Consent Management Platform) are stored on users and you can segment or export these values with these variables:

Trust variables in Data Commander

Variables types

String

• Allows to treat all kinds of data, incl. "" (empty)

• Can come from collect, API, import

• Can be used with text operator such as 'contains', 'begins with'...

• All variables coming from MIX must be declared as String

• Limit: 32766 bytes

Integer

• Is either negative {-1, -2,-3, -4, -5, ... }, positive {1, 2, 3, 4, 5, ... }, or zero {0}

• Can come from collect, API, import

• Can be used with numeric operators for segmentation

• Limit: 2147483647 bytes

Cannot be empty

Date

• Please be careful when you try to use this very specific type

• Format is very specific: YYYY-MM-DDTHH:mm:ss

• Cannot be empty

• Can come from collect, API, import

• Can be used for timing segmentation, in the past "ago" AND in the future "from now"

Boolean

• Is used to retrieve true / false for a specific information

• Can come from collect, API, import

• Can be used in the segmentation either with 1/0 - true/false - T/F: these 3 options retrieve the same results, any other usage will retrieve the value of true

• Cannot be empty

• Be careful this is case sensitive!!!

Float

• Is whatever figure you want

• Cannot be empty

• Can come from collect, API, import

• Can be used with numeric operator

Object

• Used to store several information in one variable

Example: { age : 12, gender : M }

• Cannot be updated from collect data layer (because tag converts objects to strings); Can only be updated by API or FTP import

• Cannot be used for segmentation, only for exports

• Cannot be empty

Session variables

This is the list of proper variables you can use

How to use them?

Variables available in the user universe

• First session date / Last session date = the first / last session date that is associated to a TCID

  • date format

  • can be used for segmentation

  • available operators: beteween / not between + date range

• Count session = the number of sessions associated to a TCID for a specific date range

  • integer

  • can be used for segmentation

  • available operators: exactly / at least / at most + date range

• Total session = the total number of sessions associated to a TCID

  • integer

  • can be used for segmentation

  • available operators: all operators that can be used for integers

  • as a classic user property there is no date range

Variable available in the page view universe

• New session = the first session variable populated on pageviews

  • boolean

  • can be used for segmentation (but honestly quite complicated to really use it...)

  • available operators: equals T/F

  • Be careful: it never matches 100% as you have many TCID older than 30 days where the variable new session in page views is not populated

Variable encryption

Some information about how data is encrypted in DataCommander (in AES 256 format)

If you need encrypted data in DataCommander don't forget to pick 'Yes' in encrypted option in Create variable step.

This is the encryption scheme:

DATA	Start	SSL	FTP Server	In base	In Export
Datalayer	Clear	encrypted	-	encrypted	Clear
CSV file	Clear	encrypted	Clear	encrypted	Clear

It means that we store encrypted data, and we are able to export clear data for our partners.

It is very important especially for emails, as it is a sensitive data that many clients want to over-secure, but we need to export it in clear for emailers to be able to use it