In order to create and manage a campaign based on Segmentation service, the file with the information must comply with following guidelines:
1.- The mobile number or email account must be the first field in the file
2.- The mobile number must only contain numbers
3.- The mobile number must be unique. If there are duplicates in the file, the registers will be overwritten.
4.- There are 3 ways for uploading a file into the platform: From a Dropbox account, from an URL or from your PC. However, it must be taken into account these following considerations:
a.- For files larger than 5 MB you must either provide an URL or upload them from Dropbox. b.- For files size less than 5 MB, you must be able to use any mechanism including the direct upload from your pc. c.- The upload time will depend on the file size. For example, a 160 MB file may take 15 minutes (more or less) to upload. We strongly recomend for Demo purposes the use of small files and to upload the data prior to the demo.
5.- The standard date formats accepted are:
| NAME | FORMAT | EXAMPLES | DESCRIPTION |
|---|---|---|---|
| date | yyyy-MM-dd yyyy/MM/dd | 2016-08-18 2016/08/18 | A basic date with four digits for year, two digits for month of year, and two digits for day of month, separated whit - or / |
| date2 | dd-MM-yyyy dd/MM/yyyy | 18-08-2016 18/08/2016 | A basic date with two digits for day of month, two digits for month of year, and four digits for year, separated whit - or / |
| date_hour24_minute | yyyy-MM-dd HH:mm dd-MM-yyyy HH:mm | 2016-08-18 12:35 18/08/2016 12:35 | This combines a basic date (date or date2) and time, separated with only one blank space. The time uses two digits for hour (24 hour notation), and two digits for minutes of hour, separated with : |
| date_hour24_minute_second | yyyy-MM-dd HH:mm:ss dd-MM-yyyy HH:mm:ss | 2016-08-18 12:35:10 18/08/2016 12:35:15 | This combines a date_hour24_minute and two digits for seconds of minute, separated with : |
| date_hour24_minute_second_fraction | yyyy-MM-dd HH:mm:ss.SSS dd-MM-yyyy HH:mm:ss.SSS | 2016-08-18 12:35:10.010 18/08/2016 12:35:15.560 | This combines a date_hour24_minute_second with three digits for fractions of second, separated with . |
| date_hour12_minute | yyyy-MM-dd hh:mm aa dd-MM-yyyy hh:mm aa | 2016-08-18 12:35 am 18/08/2016 12:35 PM | This combines a basic date (date or date2) and time, separated with only one blank space. The time uses two digits for hour (12 hour notation), two digits for minutes of hour, and two letters for period of day (am, AM, pm and PM) |
| date_hour12_minute_second | yyyy-MM-dd hh:mm:ss aa dd-MM-yyyy hh:mm:ss aa | 2016-08-18 12:35:10 AM 18/08/2016 12:35:15 pm | This combines a date_hour12_minute and two digits for seconds of minute |
| date_hour12_minute_second_fraction | yyyy-MM-dd hh:mm:ss.SSS aa dd-MM-yyyy hh:mm:ss.SSS aa | 2016-08-18 12:35:10.010 am 18/08/2016 12:35:15.560 PM | This combines a date_hour12_minute_second and three digits for fractions of second |
| date_hour24_minute_second_timezone | yyyy-MM-dd HH:mm:ss zzz yyyy-MM-dd HH:mm:sszzz | 2016-08-30 10:15:30 EDT 2016-08-30 10:15:30EDT | This combines a date_hour24_minute_second and time zone abbreviation (PST, PDT, CDT, EDT, UTC, CST, EST, MDT, GMT y MST) |
| date_hour24_minute_second_fraction_timezone | yyyy-MM-dd HH:mm:ss.SSS zzz yyyy-MM-dd HH:mm:ss.SSSzzz | 2016-08-30 10:15:30.016 PST 2016-08-30 10:15:30.016PST | This combines a date_hour24_minute_second_timezone and three digits for fractions of second |
| date_time | yyyy-MM-ddTHH:mm:ss.SSSZ yyyy-MM-ddTHH:mm:ss.SSS-zz:zz | 2016-08-18T12:35:10.000Z 2016-08-18T12:35:10.000-04:30 | This combines a basic date (date or date2), time and time zone offset. Date and time must be separated by a T. Time uses two digits for hour (24 hour notation), two digits for minutes of hour and two digits for seconds of minute |
Pattern meanings:
| SYMBOL | y | M | d | H | h | m | s | S | z | a |
|---|---|---|---|---|---|---|---|---|---|---|
| MEANING | year | month of year | day of month | hour of day (0-23) | clockhour of halfday (1-12) | minute of hour | second of minute | fraction of second | time zone | halfday of day |
6.- General rules for the CSV file are the following: CSV is a delimited data format that has fields/columns separated by the comma character and records/rows terminated by newlines. All records should have the same number of fields, in the same order. Adjacent fields must be separated by a single comma. Any field may be quoted (that is, enclosed within double-quote characters). Some fields must be quoted, as fields with embedded commas, double-quote characters or each of the embedded double-quote characters Excel allows CSV export.