Punchh: SFTP bulk user profiles synchronization

You can connect Attentive with the loyalty platform, Punchh, to upload a segmentation list to Attentive to send SMS campaigns to your loyal customers. To connect your Punchh segmentation list with Attentive, you must work with our White Glove team (whiteglove@attentivemobile.com) at Attentive to set up an SFTP folder. Then, contact your Punchh account representative to enable the integration. Once the integration is enabled, a CSV file that includes the Punchh segmentation list can be placed in the assigned SFTP folder to connect to Attentive. These files are processed every 24 hours, ensuring that your Punchh segmentation list in Attentive is up-to-date.

If you'd like to pass back a subscriber’s email address and phone number to your Punchh account, see the Punchh: postback and messaging integration article.

Note the following:

  • A subscriber is identified as a phone number or email address.
  • If a phone number provided does not match an active and opted-in subscriber in Attentive’s database, it is ignored and not added to the platform.
  • Once this integration is configured, your Punchh segmentation list appears in Attentive.

File format

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

Description Example
UserId The unique identifier in Punchh for the subscriber. 123456XXX
Email The email address of the subscriber. email1@email.com
Guest Sign Up Date This is the time in which the loyalty account was created within Punchh. This sign-up data allows us to fetch historical users and understand when they joined Punchh. "March 16, 2022"
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
Guest Type The subscriber is segmented into a Guest Type (either Loyalty or eClub) in Punchh. Loyalty

OR

eClub

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

UserId Email Guest Sign Up Date Phone Guest Type
61817588 mail@example.com "March 16, 2022" 5555555566 Loyalty
61820355 email@example.com "March 18, 2022" 5555555555 Loyalty