Email Integration

Improvado can ingest your data by setting up an email address created specifically for your data set.

Requirements and preconditions

  • - Data should be in one of the following formats: tsv, csv, xls(x) files or its compressed versions (zip, gzip, tar.gz archives), sent as:
  • - File attacments
  • - Valid download link in email body
  • - The data set should be presented as a flat table (no tabulation, no data hierarchy, no images, column names in the first row, one table per file)
  • - Data structure should NOT be changed (this includes field names, field order and data types).
  • - Your data provider should be able to send reports via email
  • - It must happen automatically and regularly

If your data provider fits all of these conditions, we can easily create this email integration for you.

How to setup an email integration

Step 1. Contact our technical support and tell us what you want:

  • - Which data source you need to connect
  • - An example of your data frame is very helpful (for uncommon report types or data formats it is necessary)
  • - How often should this data be refreshed (typically - on a daily basis)?
  • - Update policy: should we insert, update or replace data

Step 2. We will confirm whether we have successfully loaded the data.

Step 3. Send the first email with data to given email address

  • - Typically we create an email by the following scheme: reports+{business name}+{report type}+{platform}

Step 4. We will confirm that we have successfully loaded the data

Step 5. Schedule reports from your data platform using the email given.

That’s all! Your data platform sends us your data with the selected frequency and we do the rest of the job on our side.

Special options

In addition to the above, we can offer the following additional options:

  • - One-time historical data download or reference data download if required for custom reports or data transformations
  • - For unstructured or atypical data formats (examples of data set needed), we offer a client data analysis in order to select the best data loading method
  • - Data update frequency changes (if necessary)
  • - Report format or data structure update (if data source changes the set of fields available)