How can we help you today?

Formatting your data

Modified on: Wed, Jun 19, 2019 at 2:29 PM


Data files must be in a specific format in order to be uploaded into Luminoso Daylight.  Before you can upload data to your project, please ensure that your spreadsheet meets the following qualifications:

  1. Column headers follow the Luminoso Daylight guidelines
    Data columns without correct headers will not be processed

  2. Saved in the comma-separated value (CSV) format (sample CSV file below)


Daylight v5 accepts the following kinds of data and metadata:  

text

Text data is the only required data column in any Luminoso project.  Label the column of the text data you want to analyze with the "text" header.   Analytics accepts only one text column per spreadsheet.  Individual rows may have blank text entries. 


title

You can add a title or identifier to each piece of text data.  Label the column containing the title data with the "title" header.  The title will be viewable but not analyzed with the text data.  


string_[FIELD]

Label your categorical metadata with the column header “string_[FIELD]”.  The FIELD designates the metadata group (e.g. “string_Country of Origin”).  You may have multiple string columns, with as many values as needed, but will only be able to filter on fields with up to 10,000 values.  Note that fields with fewer than 30 values are represented as a list of checkboxes ...


... while fields with 30 - 10,000 values are represented as search boxes:


score_[FIELD]

Label your score metadata with the column header “score_[FIELD]”.  Score-type metadata values can be either integers or floating point numbers.  The FIELD designates the score metadata by group (e.g. “score_NPS” or “score_rating”).  Score-type metadata is filtered by specifying a range in the filter tool:


number_[FIELD]

Label your numeric metadata with the column header “number_[FIELD]”.  Numeric metadata values can be either integers or floating point numbers.  The FIELD designates the numeric metadata by group (e.g. “number_Customer Age”).  Numeric metadata is filtered by specifying a range in the filter tool:


date_[FIELD]

Analyze trends by adding one or more columns of date metadata to your project, which can be filtered by specifying a range in the filter tool:

All ISO 8601 compatible date and time strings are supported, as well as Unix timestamps and US-style dates.

The following are some examples of ISO 8601 dates for April 10th, 2018:

  • 2018-04-10

  • 2018-04-10 13:45

  • 2018-04-10T13:45:00Z

When using US-style dates, we support one or two digit months and days, as well as two or four digit years. Time can be specified as “HH:mm” or “HH:mm:ss” if seconds are desired. You’ll need to specify AM or PM (case insensitive) if using a 12-hour clock, as in “1:24 PM”.

The following are some examples of US-style dates for April 10th, 2018:

  • 04/10/2018

  • 4/10/2018 13:45

  • 4/10/18 1:45 PM

Note: All dates and times are assumed to be relative to UTC unless they are ISO 8601 strings, which can include a timezone designation.



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.