Overview
In the case we are not able to integrate via API for our standard integrations or require additional data, we can power our program by sending and receiving data files. This document outlines the common use cases for File Transfer Integrations and lists the file format specifications. Any deviations are considered non-standard and will need to be scoped by Wunderkind. Additionally, Standard and Custom Performance/Analytics reports can be created within the Autonomous Marketing Platform.
Table of Contents
- Hosting Options
-
Available Functionality
- Receive New Subscribers from Wunderkind
- Receive New Unsubscribes from Wunderkind
- Send Wunderkind New Subscribers
- Send Wunderkind New Unsubscribes
- Send Wunderkind Customer/Purchaser Status
- Send Wunderkind External ID (URL Appending)
- Send Wunderkind User Attributes
- Send Wunderkind GDPR/CCPA Requests for Processing
- Build & Test Process
- Appendix
Hosting Options
Wunderkind creates separate GCS buckets for each client. These contain several folders which are scanned every 15 minutes for new file drops. If your team cannot send data to our GCS buckets, Wunderkind supports connecting to a client hosted SFTP or Amazon S3 Bucket to pull information once per day.
If you require that Wunderkind servers be authenticated in order to access, please let us know and we’ll provide a list of IPs.
Wunderkind GCS Bucket
Through Wunderkind's Client specific GCS buckets, you can upload .csv files directly to Wunderkind. Please contact your CSM for the connection information. Please review the file format instructions below, the format for GCS file ingestion is strict. The GCS buckets can only be used for sending files to Wunderkind and the data cannot be encrypted using this method. To receive files (Wunderkind sending to you), Wunderkind will still need an SFTP, S3, or external GCS location.
Client SFTP
Please provide your Wunderkind contact with your server’s appropriate access information:
- SFTP host address
- Username and password
- or Username and SSH key
- Port Number
- Filepath
Client Amazon S3 Bucket
Please provide your Wunderkind contact with your server’s appropriate access information. Wunderkind will need an IAM User with List, Read, and Write Permissions. Please note that Wunderkind cannot create an AWS IAM User, one will need to be provided:
- Server
- Access Key
- Secret Access Key
- Region
Client GCS Bucket
Please provide your Wunderkind contact with your server’s appropriate access information:
- GCS Keyfile json
- Project ID
- Bucket Name
- Filepath
Available Functionality
All file transfer integrations utilize the .csv file format and are typically used to achieve the functionality listed below. The Autonomous Marketing Platform can generate several Standard Data Exports (Receiving Files from Wunderkind).
Any export/import not listed requires explicit approval from the Wunderkind Analytics team.
- e.g. Encrypted files, custom column titles, etc.
Receive New Subscribers from Wunderkind
Wunderkind will send email addresses captured onsite to your system for ingestion to an ESP/CRM
- This exists as a standard Data Export in our Autonomous Marketing Platform. Custom reports require explicit approval from the Wunderkind Analytics team.
A unique file can only be generated once per day containing the previous day's data, it can be sent more than once but the data will not be different.
Client Owned S3 bucket, SFTP or GCS bucket
In addition to the Host-Specific information, please provide us with the following:
- Filepath (e.g. Client_SFTP/Incoming_Data/Wunderkind)
- Desired Naming Convention (e.g. client_wunderkind_new_subscribers_MM_DD_YYYY.csv)
- Time for Wunderkind to post file (eg daily at 07:00am EST)
- Additional Attributes
Receive New Unsubscribes from Wunderkind
Wunderkind will send a daily file of the users that have unsubscribed from emails or sms messages.
- This exists as a standard Data Export in our Autonomous Marketing Platform. Custom reports require explicit approval from the Wunderkind Analytics team.
A unique file can only be generated once per day containing the previous day's data, it can be sent more than once but the data will not be different.
Client Owned S3 bucket, SFTP or GCS bucket
In addition to the Host-Specific information, please provide us with the following:
- Filepath (e.g. Client_SFTP/Incoming_Data/Wunderkind)
- Desired Naming Convention (e.g. client_wunderkind_new_subscribers_MM_DD_YYYY.csv)
- Time for Wunderkind to post file (eg daily at 07:00am EST)
- Additional Attributes
Send Wunderkind New Subscribers
The Client will send captured email addresses for ingestion into the Wunderkind uCRM. A historical ingestion is required for all clients while a recurring ingestion is only required for some use cases but recommended for all clients
Wunderkind GCS Bucket - The Wunderkind system will scan for a new file every 15 minutes and can ingest a new file every hour.
- The csv file format is shown below
- GCS bucket credentials can be obtained from your CSM
- Use the /subscribers folder
Client Owned S3 bucket, SFTP or GCS bucket - The Wunderkind automation will run once per day to pull the new file for ingestion
In addition to the Host-Specific information, please provide us with the following:
- Filepath (e.g. Client_SFTP/Incoming_Data/Wunderkind)
- Desired Naming Convention (e.g. client_wunderkind_new_subscribers_MM_DD_YYYY.csv)
- Time the file will be available (eg daily at 07:00am EST)
Example
Send Wunderkind New Unsubscribes
The Client will send records of users that have unsubscribed to email marketing notifications for our internal eligibility check. Both historical and recurring (daily) file drops are required.
Wunderkind GCS Bucket - The Wunderkind system will scan for a new file every 15 minutes and can ingest a new file every hour.
- The csv file format is shown below
- GCS bucket credentials can be obtained from your CSM
- Use the /unsubscribes folder
Client Owned S3 bucket, SFTP or GCS bucket- The Wunderkind automation will run once per day to pull the new file for ingestion
In addition to the Host-Specific information, please provide us with the following:
- Filepath (e.g. Client_SFTP/Outgoing_Data/Wunderkind)
- Naming Convention (e.g. client_wunderkind_new_unsubscribes_MM_DD_YYYY.csv)
- Time the file will be available (eg daily at 07:00am EST)
Example
Send Wunderkind Customer/Purchaser Status
The client will send user's customer status to confirm whether a user has previously purchased for email segmentation purposes. A historical and recurring file are both recommended.
Wunderkind GCS Bucket - The Wunderkind system will scan for a new file every 15 minutes and can ingest a new file every hour.
- The csv file format is shown below
- GCS bucket credentials can be obtained from your CSM
- Use the /customers folder
Client Owned S3 bucket, SFTP or GCS bucket- The Wunderkind automation will run once per day to pull the new file for ingestion
In addition to the Host-Specific information, please provide us with the following:
- Filepath (e.g. Client_SFTP/Incoming_Data/Wunderkind)
- Naming Convention (e.g. client_wunderkind_new_customers_MM_DD_YYYY.csv)
- Time the file will be available (eg daily at 07:00am EST)
Example
Send Wunderkind External ID (URL Appending)
URL Appending is one of Wunderkind’s most impactful identification methods. It allows us to identify users returning to your site from marketing messages (non-WKND marketing emails). It is a reverse lookup that we're able to do using a key (unique identifier) that maps to a plaintext email address and appended to all clickout email links. A historical and recurring file may be required, based on your SOW.
Initial Setup:
- Assign a key to each email address that can be appended as a URL parameter
- All records must contain a value for this key, the key itself is not important but it should not contain PII.
- Many clients set this to the sha256 email hash to ensure it’s a unique, PII-safe value - but it could be any system generated id that’s unique to an email address.
- Send a file of your full subscriber list and recurring daily deltas
- The files require an explicit format with the first column being the email addresses and column header of "email". The second column should be the PII-safe value that corresponds to that email address, and the column header should be the key you're using in the URL.
- For example, if you're appending bxid={hashed email} to all email links; the file headers would look like this:
Wunderkind GCS Bucket - The Wunderkind system will scan for a new file every 15 minutes and can ingest a new file every hour.
- The csv file format is shown below, the column title for B should be the name of the parameter
- GCS bucket credentials can be obtained from your CSM
- Use the /external-id-uploads folder
Client Owned S3 bucket, SFTP or GCS bucket - The Wunderkind automation will run once per day to pull the new file for ingestion
In addition to the Host-Specific information, please provide us with the following:
- Filepath (e.g. Client_SFTP/Outgoing_Data/Wunderkind)
- Naming Convention (e.g. client_wunderkind_url_appending_MM_DD_YYYY.csv)
- Time the file will be available (eg daily at 07:00am EST)
Send Wunderkind User Attributes
Wunderkind's internal uCRM database can be filled with discrete user preference data (e.g. loyalty status, loyalty points, membership expiration date, etc.) to allow for segmentation and dynamic designs. This requires Design, Copywriting, Engineering, and QA team involvement and will be prioritized as net new campaigns/experiences per your SOW. More information can be found here.
Wunderkind GCS Bucket - The Wunderkind system will scan for a new file every 15 minutes and can ingest a new file every hour.
- The csv file format is shown below, the column titles are strict and must be selected from the list of standard attributes
- GCS bucket credentials can be obtained from your CSM
- Use the /universal folder
Client Owned S3 bucket, SFTP or GCS bucket - The Wunderkind system will scan for a new file every 15 minutes and can ingest a new file every hour.
In addition to the Host-Specific information, please provide us with the following:
- Filepath (e.g. Client_SFTP/Outgoing_Data/Wunderkind)
- Naming Convention (e.g. client_wunderkind_user_attributes_MM_DD_YYYY.csv)
- Time the file will be available (eg daily at 07:00am EST)
Example
Send Wunderkind GDPR/CCPA Requests for Processing
Please review this linked page for more information on processing GDPR and CCPA requests
Build & Test Process
After providing file transfer details per the specs above, the Wunderkind team will review and reach out with any follow-up questions.
From there, Wunderkind will set up jobs to put and pull files from your servers, based on the file names and folder paths provided. At the same time, we ask that you place your files on the server and set up the relevant jobs on your end. You can do this right away; there are no dependencies on the Wunderkind end outside of confirming the file structure and path.
We will place test files on the server during the integration period and ask you to confirm that they look good on your end before setting live.
Comments
0 comments
Article is closed for comments.