Formatting CSV files to speed up ingestion into Viable


Data required for CSV uploads in Viable


Optional data


How to structure your columns

A lot of customer text data you want to analyze comes in CSV format. Free form responses in NPS, CSAT, and in-app surveys, as well as product reviews are some examples.

CSV documents, however, don’t all come formatted in the same way.

To speed up CSV data ingestion so you can start asking questions faster, here are tips for formatting the data before you send it our way.

Download sample CSV template.


Data required for CSV uploads in Viable

Data sent to us for ingestion should have rows of entries with the following columns:

  • Comment – that is, the free text response to a feedback survey, product review, etc
  • Timestamp – the date and/or time the response was submitted
  • Email of respondent – submissions may not all have email addresses, which is ok (see below Email section for more)


Optional data

Traits

Any customer segmentation data for respondents. Some examples include:

  • Behavioral traits such as active user, occasional shopper, promoter, device type
  • Demographics such as age, occupation, job title
  • Geographic such as country, city, zip code

Metadata

Any metadata that applies to the textual comment itself. Some examples include:

  • Review metrics, such as NPS or CSAT scores
  • Tags, such as any custom fields tagged in the source of the data
  • Prompts, such as the question asked of the user where their feedback was the answer (e.g. in an NPS survey, a question such as “Tell us more about why you chose x”)

ID

The ID of the piece of data from the source tool, i.e. the ID of a Zendesk ticket or Delighted survey.


How to structure your columns

The Comment column is where free text data will be captured. It doesn’t have to be labeled Comment specifically but it should be labeled the way you’d like to see it appear in Viable. 

The Timestamp column should preferably be in a format that the Javascript programming language can parse. It can be labeled as timestamp, created at, submitted at, etc.

These are some of the acceptable timestamp formats:

YYYY

YYYY-MM

YYYY-MM-DD

YYYY-MM-DDTHH:mm

YYYY-MM-DDTHH:mm:ss

YYYY-MM-DDTHH:mm:ss.sssZ

YYYY-MM-DDTHH:mm:ss.sss+HH:mm

YYYY-MM-DDTHH:mm:ss.sss-HH:mm

M/D/YYYY

MM/DD/YYYY

M/D/YYYY HH:mm

MM/DD/YYYY HH:mm

M/D/YYYY HH:mm:ss

MM/DD/YYYY HH:mm:ss

Examples:

2018

2018-12

2018-12-30

2018-12-30T20:59

2018-12-30T20:59:00

2018-12-30T20:59:00.000Z

2018-12-30T20:59:00.000+01:00

2018-12-30T20:59:00.000-01:00

3/3/2018

03/03/2018

3/3/2018 11:22

03/03/2018 20:59

3/3/2018 11:22:33

03/03/2018 11:22:33

The Email column should include the end user’s email address. If no email address is available, then we’ll associate the data to a uniquely identifiable Anonymous user.

Customer traits and metadata should be formatted similarly to each other by labeling the column as the type of trait or metadata (e.g. CSAT Score, NPS, Location, Age), the way you’d want to see it in Viable; that is how it'll show up as filters in Viable. For example, a location trait column should be labeled Location rather than user_geo_listed

The cleaner the column header in the CSV, the cleaner it will appear in Viable.

Data within a trait or metadata cell: if a cell contains more than one trait or metadata value (e.g. “design system, Figma, Jira” for metadata column Tags), these values should be separated by a comma. 

Download sample CSV template from this Google Sheet file. To download as a CSV file, go to File >> Download >> Comma-separated values (.csv, current sheet)



Viable Team

Viable Team

Staff

Last Updated: 04/19/21

Related walkthroughs

Data Security

Viable adheres to best practice standards for ingesting, handling and protecting data as well as responding to vulnerabilities or incidents. Our goal is to ensure a high level of security for our customer data as well as our own. PostgreSQL, with AES-256 at rest encryption. Hasura is what we use to …

Viable Team

Viable Team

Staff

Typeform Zap for Viable

You can analyze customer feedback collected via Typeform by connecting Typeform to Viable via Zapier. Under Set up action choose the fields you want to analyze. We recommend you set up a separate Zap for each free text question/response. (We do not recommend setting up a Zap for multiple choice or …

Viable Team

Viable Team

Staff

Twitter Zap for Viable

You can analyze customer feedback from tweets by connecting Twitter to Viable via Zapier. Under Set up action choose the fields you want to analyze: You should be ready to turn on the Zap.

Viable Team

Viable Team

Staff