Set up an SFTP data destination to export data from Singular automatically to an SFTP Server. Note: data destinations are a premium feature (learn more).

 

Setup Instructions

To add an SFTP data destination in Singular:

  1. In your Singular account, go to Settings > Data Destinations and click Add a new destination.
  2. Type in either "SFTP Destination" (to export aggregated marketing data) or "SFTP User-Level Destination" (to export user-level data).
  3. In the window that opens, fill in the bucket name you created:

    mceclip1.png

  4. Fill in the Username, Password, Hostname, and Port Number.
  5. Select the output format - "CSV" or "Parquet".
  6. Choose the output path in your SFTP, e.g., "singular_marketing_data/{date}{extension}".
  7. The schema of the data loaded into the destination. For your schema options, see Data Destinations: Aggregated Marketing Data Schemas and Data Destinations: User-Level Data Schemas.

Note that Singular supports several placeholders (macros) that will get expanded automatically:

Placeholder Description Example
{date} Date of the data being exported from Singular 2020-03-19
{day} The day part of the data being exported from Singular (zero-padded) 19
{month} The month part of the data being exported from Singular 03
{year} The year part of the data being exported from Singular 2020
{extension} Output file extension .csv or .parquet
{job_timestamp}  The exact time the ETL job started running.
Use this if you would like to have a new file every day (for example, have a new folder for each run with all the dates that were pulled in that job)
2020-03-20 
{job_date}

The date the ETL job started running.

Similar to {job_timestamp}, but contains only the date of the job rather than the full timestamp.

2020-03-20
Was this article helpful?