Bulk Upload Cohorts

Cohort name. This needs to be a unique name and must be exactly how you want it to appear in the dashboard

Tags. You can tag your cohort with keywords to help with organising your cohorts

For the first clause of the cohort, use this column to add a description to help other platform users understand the audience that you are building. For additional clauses, use this column to denote whether they should be separated by AND or OR.

This column should be used for the Event or cohort functionality (engagement or cohort transition). The Event's spelling has to be exactly as it appears in the Events tab in the dashboard, including case sensitivity.

• If column D is an Event name (e.g. Pageview), use column E to denote the operation associated with the 'frequency': exactly, not, at least, at most, between.
• If column D is 'engaged time', use column E to express any of the following operations associated with the number of engaged seconds: is, is not, less than, more than, less or equal to, more or equal to.
• If column D is 'engaged completion', use column E to express any of the following operations associated with the % of completion: is, is not, less than, more than, less or equal to, more or equal to.
• If column D is 'engaged with pageviews', use column E to denote the operation associated with the frequency: exactly, not, at least, at most.
• If column D is 'cohort transition', use column E to choose entered or left.

• If column D is an Event name (e.g. Pageview), use column F to choose the Event 'frequency'.
• If column D is 'engaged time', use column F to specify the number of seconds e.g 60.
• If column D is 'engaged completion', use column F to specify the % of completion e.g 50.
• If column D is 'engaged with pageviews', use column F to specify the pageview frequency.
• If column D is 'cohort transition', use column F to specify the cohort using the cohort code.

• If column D is an Event name (e.g. Pageview), column G should be left blank.
• If column D is 'engaged time', column G should be left blank.
• If column D is 'engaged completion', column G should be left blank.
• If column D is 'engaged with pageviews', use column G to specify 'engaged time' or 'completion'.
• If column D is 'cohort transition', column G should be left blank.

• If column D is an Event name (e.g. Pageview), column H should be left blank.
• If column D is 'engaged time', column H should be left blank.
• If column D is 'engaged completion', column H should be left blank.
• If column D is 'engaged with pageviews', use column G to choose the operation associated with time %: is, is not, less than, more than, less or equal to, more or equal to.
• If column D is 'cohort transition', column H should be left blank.

• If column D is an Event name (e.g. Pageview), column I should be left blank.
• If column D is 'engaged time', column I should be left blank.
• If column D is 'engaged completion', column I should be left blank.
• If column D is 'engaged with pageviews', use column I to specify the number of seconds or completion % e.g 50.
• If column D is 'cohort transition', column I should be left blank.

Time. Specify the recency of the Event or cohort functionality by the number of days.

all/any. If you're adding multiple properties, decide if you want them separated by an 'and' (all) or by an 'or' (any). 

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.

This can be any of the following property types: String, List of Strings, Integer, and Boolean. Please note that we cannot support properties where the parent property is a List of Objects.

Property operation. Decide whether the property is, is empty, contains (and their negations) specific values. It has to have exactly one value from the list.

Property value 1. Enter the values or keywords you want the property to be or contain. If entering more than one value, separate them with a comma eg. sport, football, basketball. These will be separated by 'or' in the platform.

Use these columns to add multiple properties following the same format described in columns L-N.