Subscriber segment upload

You can provide an external list of subscribers and their corresponding segment name to have it available in Attentive’s platform. While it’s also possible to upload segment lists directly through the platform, this method allows for your lists to update dynamically. To set up this process, you must provide a CSV file that includes the phone numbers or emails of subscribers and the name of the corresponding segmentation list. This file can then be placed in an assigned SFTP folder to connect to Attentive where they are processed every 24 hours, ensuring that your segmentation list in Attentive is up-to-date.

You must contact our White Glove team (whiteglove@attentivemobile.com) in order to configure this process.

Note the following:

  • A subscriber is identified as a phone number or email address. A single CSV cannot contain a mixture of the two, only one or the other.

    • Make sure to tell our White Glove team which identifier you plan to use.
  • If a phone number or email address provided does not match an active and opted-in subscriber in your Attentive program database, it is ignored and not added to the platform.
  • Files containing an existing segment name will replace the existing list, so the full subscriber list should be uploaded each day.
  • The upload limit for each file is 500,000 rows. If your file contains more rows, you’ll need to split it before uploading. You can upload as many files as needed.

File format

View the following table to understand how the CSV file must be formatted:

Description Example
File name Attentive accepts CSVs with the name format: {clientdomain}_subscriber_segment_{date}_{file_number}.csv

Note the following:

  • You can contact White Glove (whiteglove@attentivemobile.com) to retrieve the client domain for your account.
  • The date variable must be formatted as follows: YYYYMMDD, with days and months less than 10 being 0 padded.
  • The file_number variable may be omitted if only a single file is being uploaded for that date. Otherwise, please provide a different file number for each file.
  • If importing both email addresses and phone numbers, create two separate files with the following name format:
    • {clientdomain}_subscriber_segment_phone_{date}_{file_number}.csv
    • {clientdomain}_subscriber_segment_email_{date}_{file_number}.csv

sirendenim_subscriber_segment_20201125_1.csv

sirendenim_subscriber_segment_20201125_2.csv

sirendenim_subscriber_segment_phone_20201125_3.csv

sirendenim_subscriber_segment_email_20201125_4.csv
Header You don't need to include a header in the CSV file. Without a header, the first row should be a phone number or email address and the corresponding segment name (see example). If you must include a header, notify our White Glove team whiteglove@attentivemobile.com for assistance.
Important! Don't switch between including headers and not including them. 		1234567890, segment 1
Phone number The phone number of the subscriber.

Note the following:

  • Phone numbers should be formatted as: XXX-XXX-XXXX or XXXXXXXXXX
  • Country codes may be included.
The following list outlines accepted values:
  • 1234567890
  • 123-456-7890
  • 1123-456-7890
  • 11234567890
Segment name The name of your segmentation list.

Note the following:

  • Segment names must not contain special characters.
  • Segment names have a maximum length of 64 characters.
  • If the subscriber is to be allocated to an existing segment, this value must be equivalent to the existing segment’s name.
  • If the segment does not yet exist, it will be created when this file is processed.
Most Loyal Customers

The following is an example of what your CSV file should resemble:

1234567890​ segment 1
2345678901​ segment 2
0234567890​ segment 2
4567890123​ segment 1

Attentive SFTP folder

The following is an overview of where the SFTP folder is located:

  • Host: sftp.attentivemobile.com
  • Path: /uploads
  • Filename: {clientdomain}_subscriber_segment_{date}_{file_number}.csv