Data Delivery Service

In this Article:

How it works

ECAL provides a Data Delivery Service that can be used to load Subscriber data into your CRM. The service:

  • Uploads your User data into a sFTP or AWS s3 bucket as a CSV file
  • Provides customisation for data formatting for the CSV file
  • Can combine data from multiple ECAL accounts into a single file
  • Data can be uploaded to your destination on a daily or weekly basis
  • You can import this data file into your CRM and enrich user profiles

Please contact support@ecal.com if you would like to utilise this service.

Data Delivery File Structure

  • Columns A to AF are fixed and will always be exported
    • A data column’s value can be empty
  • After the column AF, any standard and/or custom fields that are used to collect Subscriber data will be available
Column Title Description Data
A Logged Date of Subscriber registration Date, for e.g. 2020-08-01 11:23:16
B First Name Subscriber’s First name String, for e.g. John
C Last Name Subscriber’s Last name String, for e.g. Smith
D Gender Subscriber’s Gender (if entered) String, M of F
E Email Subscriber’s Email String, for e.g. user@email.com
F Age Group Subscriber’s Age Group (if entered) String, for e.g. 25-34
G Mobile Subscriber’s Mobile no. (if entered) String, for e.g. 04100101010
H Country Subscriber’s Mobile Country Code (if entered) String, for e.g. MX
I Zip Subscriber’s Zip (if entered) String, for e.g. 11320
J Category Subscriber’s Device Category String, for e.g. Phone or Desktop
K Application Subscriber’s Calendar Application String, for e.g. apple or google or ics
L Schedules Subscribed Schedules(comma separated) String, for e.g. All Fixtures or Aresenal, Tottenham
M Opt-in 1 Subscriber Optin-1 Preference (if set) String, for e.g. Y or N
N Opt-in-1 Text Subscriber Optin-1 Text copy (if set) String, for e.g. I would like to hear from the Publisher via email
O Opt-in-3 Reference Subscriber Optin-1 Reference (if set) String, for e.g. gen_comms that could be used to map with CRM pref.
P Opt-in 2 Subscriber Optin-2 Preference (if set) String, for e.g. Y or N
Q Opt-in-2 Text Subscriber Optin-2 Text copy (if set) String, for e.g. I would like to hear direct from the Club(s) I selected with news and updates via email.
R Opt-in-2 Reference Subscriber Optin-2 Reference (if set) String, for e.g. club_comms that could be used to map with CRM pref.
S Opt-in 3 Subscriber Optin-3 Preference (if set) String, for e.g. Y or N
T Opt-in-3 Text Subscriber Optin-3 Text copy (if set) String, for e.g. I have read and agree to the Publisher's Terms and Conditions
U Opt-in-3 Reference Subscriber Optin-3 Reference (if set) String, for e.g. t_n_c that could be used to map with CRM pref.
V Opt-in 4 Subscriber Optin-4 Preference (if set) String
W Opt-in-4 Text Subscriber Optin-4 Text copy (if set) String
X Opt-in-4 Reference Subscriber Optin-4 Reference (if set) String
Y Country Code Subscriber’s Country Code (based on IP Location) String e.g. MX
Z Country Name Subscriber’s Country Name (based on IP Location) String e.g. Mexico
AA State Code Subscriber’s State Code (based on IP Location) String e.g. CMX
AB State Name Subscriber’s State Name (based on IP Location) String e.g. Mexico City
AC City Name Subscriber’s City Name (based on IP Location) String e.g. Mexico City
AD Zip Code Subscriber’s Zip Code (based on IP Location) String e.g. 11320
AE Latitude Subscriber’s Location Latitude (based on IP Location) Decimal e.g. 19.4498
AF Longitude Subscriber’s Location Longitude (based on IP Location) Decimal e.g. -99.1727
AG - AZ Custom Subscriber Data Additional Subscriber data (if collected) String

Example CSV Output:

Logged,First Name,Last Name,Gender,Email,Age Group,Mobile,Country,Zip,Category,Application,Schedules,Opt-in 1,Opt-in-1 Text,Opt-in-1 Reference,Opt-in 2,Opt-in-2 Text,Opt-in-2 Reference,Opt-in 3,Opt-in-3 Text,Opt-in-3 Reference,Opt-in 4,Opt-in-4 Text,Opt-in-4 Reference,Country Code,Country Name,State Code,State Name,City Name,Zip Code,Latitude,Longitude
2020-08-01 11:23:16,John,Smith,M,user@email.com,25-34,04100101010,Mexico,11320,Phone,apple,Liverpool,Y,I would like to hear from the Publisher via email,gen_comms,Y,I would like to hear direct from the Club(s) I selected with news and updates via email.,club_comms,Y,I have read and agree to the Publisher's Terms and Conditions.,t_n_c,,,,MX,Mexico,CMX,Mexico City,Mexico City,11320,19.4498,-99.1727

Example CSV File

Click this link to download the file.