Data Guide

Data Structure

Custom Member Metrics should be sent to Movio using a CSV file format. This file should obey the following conventions:

• Using a comma as the separator character
• No unintended whitespace
• Use UTF-8 character encoding
• Each row has the correct amount of columns, (e.g For three columns, this is how you omit the second a,,c or to omit the first ,b,c etc)
• Quotes will not be included in a value unless they are escaped with the backslash (\) character.
• The first line of the CSV file (header) contains the columns names
• The first column must be ‘memberid’ or ‘memberId’ and list the members’ membership id (this should be the membership code from Vista or NCR)
• Each column must have a type, that must be communicated to Movio e.g. Integer, Double, String
  For each metric Movio will require the different possible combinations. For an integer this would be the range e.g. 1 – 100, for a string that would be all the possible combinations e.g. “Foo”, “Bar” etc.
• It is important to provide a metric for each member you’d like to use that metric for. If you don’t, there will be no value and it will appear blank in markers

Upload Modes

Custom Member Metrics allows you to update your files in two different modes ‘Append’ and ‘Replace’.

Append

Uploading using the ‘Append’ method will add any new members you upload in your CSV file as well as update any existing members with new values.

Replace

Uploading using the ‘Replace’ method will replace all data for the metrics that exist in the uploaded CSV file.

Upload Methods

Custom member metrics allows two methods of uploading files, FTP Dropbox and File Upload.

FTP Dropbox

The FTP Dropbox is an SFTP server hosted by Movio and should be used for large updates to metrics. More details regarding the SFTP are available here. 

Files must be uploaded into the directories provided based on the ‘Upload Mode’ required. Below is an example of the folder for the ‘Replace’ method:

/custom-member-metrics-data/replace

The folders are available in the information dialog found on the ‘Custom Member Metrics’ page by clicking the ‘FTP Dropbox’ button. The FTP Dropbox can be accessed at sftp.movio.co on port 22 and requires a username and password. If you do not know your FTP credentials, please contact your Account Manager.

File Upload

File Upload is available on the CMM page in your console; it is designed for small updates to your metrics. Please ensure you do not close your browser until the file has been fully uploaded. You can check the status of an upload looking at ‘Import History’ and verifying the file you uploaded has the status ‘Pending’.