Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Timestamp operators are used You can use timestamp operators to set what a time frame that you want to use in your segment. The timestamp is the time the data came into our system.

The Segment Timestamp Operators were upgraded as of November 19, 2019. This upgrade was done to make the user experience more intuitive. As part of this upgrade, some operators were kept and changed and others were removed. All timestamp operators are converted to UNIX timestamps when SQL statements are generated in the processing engine. Operators follow SQL logic.

...

For existing segments, you are able to see and use the current operators. If you create a new segment, you are only able to see and use the new operators. To help you transition to the equivalent new operator, select the link to the New Timestamps UI as shown in the following.

...

All existing segments, once edited, saved and reopened, will automatically convert to the new timestamp operator.

Here we have included the original, current, and new operators for your reference.

Original

Operator

Current Operators

Example

- Current Operators

equal to

= is

New Operator

Example - New Operators

= is

(FixedTimestamp 2019-10-11 00:00:00)= is

date

= is date 2019-10-11 00:00:00

is one of

= is (multiple)

= is (multiple) 1530199107, 1530223860, 1530600353

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

equal to

= is (number)

= is (Number 3)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

equal to

= is (relative)

= is (RealtiveTimestamp (unit) year, last (number) 0)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) Last 3rd day to this 3rd day

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) Last March until this March

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) Last Mon until this Mon

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) Last month

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) Last Sun until this Sun

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) Last year's last quarter

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) Last year's same quarter

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) Past until last Monday

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) Past until this 3rd day

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) This quarter until now

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) This Sun until now

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) This year until now

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (advanced)

!<-> not between (advanced) Until this July

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is not between

!<-> not between (number)

!<->

not between

(Number 1 and Number 100)

No longer supported

Tool Tip: You can upgrade this rule. Learn about

the

New Timestamp UI

is not between

!<-> not between (relative)

!<-> not between ((RelativeTimestamp (unit) hour, last (number)12) and (RelativeTimestamp (unit) hour, last (number) 6))

not between the

past

not between the past 6 - 12 hours

is not between

!<-> not between

(timestamp)

!<-> not between (FixedTimestamp 2019-03-06 06:33:11 and FixedTimestamp 2019-10-19 12:45:24)

!<-> not between

dates

!<-> not between dates 2019-03-06 06:33:11 - 2019-10-19 12:45:24

not equal to

!= is not (fixed)

!= is not (FixedTimestamp 2018-08-01 00:00:00)

!= is not date

!= is not date 2018-08-01 00:00:00

is not one of

!= is not (multiple)

!= is not (multiple) 1530199107, 1530223860, 1530600353

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

not equal to

!= is not (number)

!= is not (Number 3)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

not equal to

!= is not (relative)

less than

< less than (fixed)

!= is not (RealtiveTimestamp (unit) year, last (number) 0)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

<

less than (FixedTimestamp 2019-06-26 09:36:14)<

before date

< before date 2019-06-26 09:36:14

less than

< less than (number)

< less than (Number 52)does

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

not

exist or less than

< less than (or null) (fixed)

< less than (or null) (FixedTimestamp 2019-10-16 00:00:00)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or less than

< less than (or null) (number)

< less than (or null) (Number 10)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or less than

< less than (or null) (relative)

< less than (or null) (RelativeTimestamp (unit) quarter, last (number)1)

not

in the past

not in the past 1 quarters

less than

< less than (relative)

<

less than (RelativeTimestamp (unit) month, last (number) 0

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is between

<-> between

<

-> between

(FixedTimestamp 2019-10-09 00:00:00 and FixedTimestamp 2019-10-11 00:00:00)<-> between

dates

<-> between dates 2019-10-09 00:00:00 - 2019-10-11 00:00:00

is between (time)

<-> between (advanced)

<-> between (advanced) Last 3rd day to this 3rd day

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is between (time)

<-> between (advanced)

<-> between (advanced) Last March until this March

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is between (time)

<-> between (advanced)

<-> between (advanced) Last Mon until this Mon

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is between (time)

<-> between (advanced)

<-> between (advanced) Last month

last

last month

is between (time)

<-> between (advanced)

<-> between (advanced) Last Sun until this Sun

last

last week

is between (time)

<-> between (advanced)

<-> between (advanced) Last year's last quarter

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is between (time)

<-> between (advanced)

<-> between (advanced) Last year's same quarter

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is between (time)

<-> between (advanced)

<-> between (advanced) Past until last Monday

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is between (time)

<-> between (advanced)

<-> between (advanced) Past until this 3rd day

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is between (time)

<-> between (advanced)

<-> between (advanced) This quarter until now

this

this quarter

is between (time)

<-> between (advanced)

<-> between (advanced) This Sun until now

this

this week

is between (time)

<-> between (advanced)

<-> between (advanced) This year until now

this

this year

is between (time)

<-> between (advanced)

<-> between (advanced) Until this July

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is between (time)

<-> between (advanced)

<-> between advanced, (relative (unit) day, last (number) 1, (duration) 1 day)

yesterday

yesterday

is between (time)

<-> between (advanced)

<-> between advanced, (relative (unit) day)

today

today

is between (time)

<-> between (advanced)

<-> between advanced, last quarter (relative (unit) quarter, last (number) 1, (duration) 1 quarter)

last

last quarter

is between (time)

<-> between (advanced)

<-> between advanced, this month until now (relative (unit) month)

this

this month

is between

<-> between (number)

<-> between (Number 52 and Number 54)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

is between

<-> between (relative)

<-> between ((RelativeTimestamp (unit) quarter, last (number) 5) and RelativeTimestamp (unit) quarter, last (number) 3)

last

last month; last week; last quarter

this

this week; this month; this quarter; this year

yesterday

yesterday

today

today

in between the past

in between the past 3 - 5 quarters

less than or equal to

<= at most (fixed)

<=

at most (FixedTimestamp 2019-06-12 01:51:59)<=

on or before date

<= on or before date 2019-06-12 01:51:59

less than or equal to

<= at most (number)

<= at most (Number 50)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or less than or equal to

<= at most (or null) (fixed)

<= at most (or null) (Fixed Timestamp 2017-08-23 09:10:53)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or less than or equal to

<= at most (or null) (number)

<= at most (or null) (Number 10)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or less than or equal to

<= at most (or null) (relative)

<= at most (or null) (RelativeTimestamp (unit) day, last (number) 0)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

less than or equal to

<= at most (relative)

<= at most (RelativeTimestamp (unit) hour)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

greater than

> greater than (fixed)

>

greater than (FixedTimestamp 2019-04-04 04:35:54)>

after date

> after date 2019-04-04 04:35:54

greater than

> greater than (number)

> greater than (Number 52)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or greater than

> greater than (or null) (fixed)

> greater than (or null) (FixedTimestamp 2019-03-20 05:10:25)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or greater than

> greater than (or null) (number)

> greater than (or null) (Number 10)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or greater than

> greater than (or null) (relative)

> greather than (or null) (RelativeTimestamp (unit) day, last (number) 0)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

greater than

> greater than (relative)

> greater than (RelativeTimestamp (unit) month, last (number) 0

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

greater than or equal to

>= at least (number)

>= at least (Number 192)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or greater than or equal to

>= at least (or null) (fixed)

>= at least (or null) (Fixed Timestamp 2017-08-23 09:10:53)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or greater than or equal to

>= at least (or null) (number)

>= at least (or null) (Number 10)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist or greater than or equal to

>= at least (or null) (relative)

>= at least (or null) (RelativeTimestamp (unit) day, last (number) 0)

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

greater than or equal to

>= at least (relative)

> = at least, (RelativeTimestamp, (unit) month, last (number) 5)

in the past

In the past 5 months

greater than or equal to

>= at least (fixed)

>= at least (FixedTimestamp 2017-08-23 09:10:53)

>= on or after date

>= on or after date 2017-08-23 09:10:53

contains

contains

contains 1530755859

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

ends with

ends with

ends with 0

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

exists

is not null

is not null

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not exist

is null

is null

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not contain

not contains

not contains 1530223860, 1530755859,1530529619

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not end with

not ends with

not ends with 1529551826, 1530146097

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

not ends with

not ends with

not ends with 0

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not match regex

not regex

not regex 3

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

does not start with

not starts with

not start with 1530199107

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

matches regex

regex

regex 1420066800

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI

starts with

starts with

starts with 1

No longer supported

Tool Tip: You can upgrade this rule. Learn about the New Timestamp UI