Bulk Upload Segments

In this article

Instructions on how to bulk upload segments to the Permutive platform

How to Bulk Upload Segments

Bulk uploading segments is a way to automatically upload 25 or more segments into the platform without having to build them manually.

To do so, open this Google sheet and go to 'File' > 'Make a copy' and name it with your publication.

Warning: Do not change columns, headers or file structure (ie. no columns are added, deleted or moved).  These must be exact.

Screenshot_2020-01-16_at_16.57.03.png

Example Format

Fill in the Google sheet, following the examples you can find under the 'Example' tab.

Screenshot_2020-07-22_at_12.28.09.png

Tag
You can tag your segments with keywords to help with organising your segments.
Segment Name
This needs to be a unique name and must be exactly how you want it to appear within the dashboard.
Description
Add a description to help other platform users understand the audience you are building.
Event
This refers to the Event you are choosing to segment the user by: See screenshot below

Screenshot_2020-07-22_at_12.32.29.png

Note: The spelling has to be exactly as it appears in the Events tab in the dashboard (it's case-sensitive).

Segment Conditions and Modifiers

Frequency

Mark the number of times the event must fire for a user to fall into this segment. The default operation is 'at least':

Screenshot_2020-07-22_at_12.34.29.png

Note: Valid entries are non-negative integers and ranges with no spaces (ie. 7-14 means between 7 and 14 times)

Time

Specify the recency of the Event by the number of days. The default operation is 'the last':

Screenshot_2020-02-03_at_16.35.58.png

Note: Valid entries are positive integers.

All/Any

If you're adding multiple properties, decide if you want them separated by an 'and' (All) or by an 'or' (Any). This field can have only an 'and' or 'or' value (case-sensitive).

Screenshot_2020-02-03_at_16.39.42.png

Property 1

The property must be entered into the spreadsheet exactly as it is ingested into Permutive, eg. 'client.referrer'. You can find the correct property name in the Events Tab, by clicking on 'Quick View' of the corresponding Event and looking in the second column: 

Screenshot_2020-05-01_at_12.16.43.png

is/is not/contains/doesn't contain/is empty/isn't empty

decide whether the property isis empty, contains (and their negations) specific values. It has to have exactly one value from the list.

Screenshot_2020-02-03_at_16.46.11.png

Property 1 Value

Here is where you need to enter the values or keywords you want the property to be or contain.

Note: If entering more than one value, separate them with a comma in the spreadsheet eg. sport, football, basketball. These will be separated by 'or' in the platform.

Screenshot_2020-02-03_at_16.49.58.png

You can continue to add multiple properties following the same format described above for 'Property 1'.

 

Segments Using Multiple Events

It is possible to bulk upload segments that use multiple Events separated by 'OR'.

Please navigate to the 'Example of Multiple Events' tab in the template Google sheet to see an example.

The second Event, and those thereafter, need to be added as additional rows below the first Event.

The Number, Tags, Segment Name, and Description columns need to be left blank for any additional Events.

The example in the template Google sheet translates into the segment builder as below:

Screenshot_2020-07-22_at_12.44.41.png

Tip: As a best practice, please send a sample upload of ~10 segments to support@permutive.com for alignment confirmation.

Once alignment has been confirmed, please complete the final upload and send the document to support@permutive.com to be actioned.

Note: We usually expect the upload to be complete within two weeks.

 

If you have any questions, please contact customer support by emailing support@permutive.com or chat to the Customer Operations Team via the LiveChat icon in the bottom right corner of your screen.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request