Custom - Email Custom Data Network Connection

Data you report on doesn't always come through a provider that NinjaCat connects to through an API. The Email Custom Data Network Connection is one of the methods available to NinjaCat users when that situation arises. This article documents the details of the Email Custom Data Network Connection.

Function

The Email Custom Data Network Connection receives an email from a data provider. The email must have a report attached that is configured by the data provider interface. The report must be in the compatible format. Once the email is received, NinjaCat reads the report attached, parses and stores the data enclosed.

Mappings 

In order to make sense of the data for display and reporting purposes, a mapping must be created by the NinjaCat user that assigns Dimension and Metric designations to the different columns in the report attached to the email.

Requirements

The email that is sent to NinjaCat must contain any of the following to provide data to the Email Custom Data Network Connection:

• an attached .CSV (comma separated value) file
• an attached .TSV (tab separated value) file
• an attached, compressed .CSV (comma separated value) or .TSV (tab separated value) file in ZIP format
• an attached, compressed .CSV (comma separated value) or .TSV (tab separated value) file in GZ format
• a URL (uniform resource locator or web address) to a web hosted .CSV (comma separated value) file
• a URL (uniform resource locator or web address) to a web hosted .TSV (tab separated value) file

In order to create the above mentioned mapping the NinjaCat user must have access to a downloaded and saved example of the report from the data provider to use as a model for the mapping.