Meet the TheyDo Agent

Read more in our blog→

How to import metrics from a CSV file

Overview

Use CSV import to create or update metrics in bulk — no need to enter data point by point. You can import multiple metrics of different types (NPS, CSAT, CES, Ratio, and more) in a single file, and map dimensions alongside your date and value columns.

Before you start

Your CSV file needs at minimum:

  • A date column (YYYY-MM-DD format)
  • A value column
  • A metric identifier column — if the file contains data for more than one metric (e.g. a METRIC_NAME column)

Files up to 100,000 rows are supported.

Steps

  1. Go to Metrics in the left sidebar.
  2. Click Import Metrics in the top right.
  3. Drag and drop your CSV file into the upload area, or click Select file.
  4. Under Identify metrics in your file, confirm which column TheyDo should use to tell metrics apart. TheyDo will auto-detect the most likely match — adjust if needed.
  5. Click Continue.
  6. On the Review step, check how TheyDo has mapped your CSV columns to metric properties. For each detected metric:
    • Confirm the metric name and whether to create a new metric or update an existing one.
    • Verify the columns mapped to Date, Value, and any Dimensions.
    • Use the live preview to catch any mismatches before importing.
  7. Click Import.
  8. Review the confirmation summary. Click Go to library to see your updated metrics, or Upload another file to continue importing.

Tip: If your file contains data for only one metric, you don't need an identifier column — all rows will be imported into that single metric.

Tips and notes

  • TheyDo matches metrics by name or ID. If a metric in your file doesn't match an existing one, it will be created automatically — unless you set Import into to Existing metric and pick the target yourself.
  • Re-uploading the same rows adds new data points rather than updating existing ones. To avoid duplicates, make sure your file includes an identifier column so TheyDo can match rows correctly.
  • If date values aren't recognized, check that dates follow YYYY-MM-DD format, or select the correct format in the date column dropdown on the Review step.
  • Metric names that show as raw column names (e.g. FOOT_TRAFFIC) mean TheyDo couldn't find a matching metric and created a new one. You can rename it from the metrics library after import.