Grouparoo Docs

Getting StartedStep 1: InstallStep 2: Configure

Step 3: RunStep 4: DeployCLIDevelopmentCommunitySupport

Groups (Enterprise)

Last Updated: 2021-02-11

This guide covers configuration with Grouparoo's Enterprise Edition. If your application is using the Community Edition, use the Community Groups Guide instead.

If you are interested in using the Enterprise Edition, send us a message.

Once you have an App, Source, and Properties (start with an App if you don't have any), then you're ready to define your Groups.

Groups are where the magic happens in Grouparoo. (It's in the name, after all!) Groups are a segment or cohort of Profiles. They are useful in that you can use Groups to target a specific set of users to export to some Destination. You can have Calculated Groups and Manual Groups. See here to learn more about the core concepts in Grouparoo.

Adding Calculated Groups

Calculated Groups add and remove Profiles automatically based on Group Rules that you define. Each Rule has several options for logically determining if a profile belongs in the group. Those options are listed below, followed by a few examples.

Rule Operation Options

Each Rule has an operator — a logical statement to filter profiles. A profile must match every Rule to be included in the Group.

Available operations depends on both the type of Property and the underlying Grouparoo database (SQLite vs. Postgres). See below for a list of rules. (If in doubt, choose Postgres.)

The following operators are available on boolean properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to

The following operators are available on date properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`gt`	is after
`lt`	is before
`gte`	is on or after
`lte`	is on or before
`relative_gt`	is in the past
`relative_lt`	is in the future

The following operators are available on email properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`like`	is like (case sensitive)
`notLike`	is not like (case sensitive)
`startsWith`	starts with
`endsWith`	ends with
`substring`	includes the string
`iLike`	is like (case insensitive)
`notILike`	is not like (case insensitive)

The following operators are available on float properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`gt`	is greater than
`lt`	is less than
`gte`	is greater than or equal to
`lte`	is less than or equal to

The following operators are available on integer properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`gt`	is greater than
`lt`	is less than
`gte`	is greater than or equal to
`lte`	is less than or equal to

The following operators are available on phoneNumber properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`like`	is like (case sensitive)
`notLike`	is not like (case sensitive)
`startsWith`	starts with
`endsWith`	ends with
`substring`	includes the string
`iLike`	is like (case insensitive)
`notILike`	is not like (case insensitive)

The following operators are available on string properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`like`	is like (case sensitive)
`notLike`	is not like (case sensitive)
`startsWith`	starts with
`endsWith`	ends with
`substring`	includes the string
`iLike`	is like (case insensitive)
`notILike`	is not like (case insensitive)

The following operators are available on url properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`like`	is like (case sensitive)
`notLike`	is not like (case sensitive)
`startsWith`	starts with
`endsWith`	ends with
`substring`	includes the string
`iLike`	is like (case insensitive)
`notILike`	is not like (case insensitive)

The following operators are available on boolean properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to

The following operators are available on date properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`gt`	is after
`lt`	is before
`gte`	is on or after
`lte`	is on or before
`relative_gt`	is in the past
`relative_lt`	is in the future

The following operators are available on email properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`like`	is like (case sensitive)
`notLike`	is not like (case sensitive)
`startsWith`	starts with
`endsWith`	ends with
`substring`	includes the string

The following operators are available on float properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`gt`	is greater than
`lt`	is less than
`gte`	is greater than or equal to
`lte`	is less than or equal to

The following operators are available on integer properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`gt`	is greater than
`lt`	is less than
`gte`	is greater than or equal to
`lte`	is less than or equal to

The following operators are available on phoneNumber properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`like`	is like (case sensitive)
`notLike`	is not like (case sensitive)
`startsWith`	starts with
`endsWith`	ends with
`substring`	includes the string

The following operators are available on string properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`like`	is like (case sensitive)
`notLike`	is not like (case sensitive)
`startsWith`	starts with
`endsWith`	ends with
`substring`	includes the string

The following operators are available on url properties:

Operator	Description
`exists`	exists with any value
`notExists`	does not exist
`eq`	is equal to
`ne`	is not equal to
`like`	is like (case sensitive)
`notLike`	is not like (case sensitive)
`startsWith`	starts with
`endsWith`	ends with
`substring`	includes the string

Examples

Here are a few different examples of Calculated Groups and their rules:

Example: Repeat Purchasers

Group Rules:

Profiles who have purchased more than once
Profiles with an email

Example: High-Value & Abandoned Cart Recently

Group Rules:

Profiles who have a Life-time Value (LTV) of over 30
Profiles who have recently added an item to their cart
Profiles with an email

Example: High-Value Xhosa Speakers

Group Rules:

Profiles with a language set to xhosa
Profiles who have a Life-time Value (LTV) of over 50

Adding Manual Groups

While a great deal of the value of Grouparoo comes from our Calculated Groups, Manual Groups are still valuable in certain circumstances. Manual Groups are Groups of profiles where you manually add or remove Profiles from the Group.

Next Steps

Once you've grouped your users, you're ready for the last step in the Grouparoo configuration journey, exporting Groups to Destinations.

Having Problems?

If you are having trouble, visit the list of common issues or open a Github issue to get support.

Grouparoo Docs

Getting StartedStep 1: InstallStep 2: Configure

Step 3: RunStep 4: DeployCLIDevelopmentCommunitySupport