Offline Data Source[Set up FTP File data source]
Overview
File Transfer Protocol (FTP) is a standard network protocol used to transfer computer files between a client and server on a computer network. FTP is built on a client-server model architecture and uses separate control and data connections between the client and the server. With this integration, you will be able to sync offline data with your server through an FTP/SFTP connection.
Pre-Requisites:
FTP server access details for reading files:
- The FTP server address
- The FTP server port
- The FTP server username
- The FTP server password
Getting Started:
Let’s go through the process required to set-up Files FTP for Offline events..
The First step is to select the File data type. This helps in Datahash in understanding what type of integration the user wants to do. Currently we support offline events, custom audience and leads data type integration across multiple advertising destinations.
- Go to the Datahash dashboard and locate the Sources card. Look for File FTP connector under Files category and click on it
- Select the Events options in the data type selection step as shown below and give a name to your connection.
- In order to setup the connection successfully, kindly download the file which help you understand the overall structure in which you need to get the data setup. Once done take the downloaded file set-up in an FTP location and add credentials in the next step.
- This is the most important step where the user needs to provide the FTP credentials which will help Datahash to access the file for further processing. These credentials are:
- FTP Hostname: This is the hosting server name
- FTP Port: This is the server port, the default port for FTP is 22
- FTP Username/Password: Your FTP credentials, usually they’re the same as your cPanel login details
- Relative path to data folder: A path like prefix name where you have stored the files in the FTP folder like myfolder/thistable
File Format
Overview – To Implement Offline events, the client needs to upload event data with the fields as mentioned in the file downloaded during the setup (Step 2) in a CSV using the below specified format. This file works for all three platforms i.e., Facebook, Google and Snap
Note on Encryption – All the Customer Data Fields that says ‘Hashed’ needs to be encrypted using the ‘SHA256’ format
Mandatory Fields:
| Taghash Fields | Required/Optional | Format |
| Event Data | ||
| event_time | Required | UNIX timestamp |
| event_name | Required | String |
| currency | Required for purchase events | Three-letter ISO currency code |
| value | Required for purchase events | Double |
| transaction_id | Required for purchase events | String |
| User Data | ||
| Email_hashed | Required | Trim leading and trailing white space and convert all characters to lowercase |
| Phone_hashed | Required | Number up to fifteen digits in length starting without 0 and removing any non-numeric characters such as whitespace, parentheses, ‘+’, or ‘-‘ from phone numbers |
Related Articles
Setting up Data Source for Snapchat Offline Conversions API
Offline Conversions API can be set-up using any one of the below available data sources that can provide offline events or conversion data. The type of data sources enable reading of CSV files at regular frequency e.g. daily. Data automation can be ...Setting up source as File FTP for Snap Leads Conversions API
Prerequisites: The FTP server address The FTP server port The FTP server username The FTP server password Set-up process: Log in to your Datahash account on https://studio.datahash.com/login Navigate to Files category under Sources list in the left ...TikTok Offline Events API[Step 1: Set up Offline Events Source(Step 1 (Option 1): Set-up FTP File data source)]
Overview File Transfer Protocol (FTP) is a standard network protocol used to transfer computer files between a client and server on a computer network. FTP is built on a client-server model architecture and uses separate control and data connections ...Meta Offline Conversions API[Step 1: Set up Offline Events Source(Step 1 (Option 1): Set-up FTP File data source)]
Description: The File Transfer Protocol (FTP) is a standard network protocol used to transfer computer files between a client and server on a computer network. FTP is built on a client-server model architecture and uses separate control and data ...Snapchat Offline Conversions API[Step 1: Set up Offline Events Source(Step 1 (Option 1): Set-up FTP File data source)]
Overview Description: The File Transfer Protocol (FTP) is a standard network protocol used to transfer computer files between a client and server on a computer network. FTP is built on a client-server model architecture and uses separate control and ...