Data export

Role required: Customer Admin, Channel Admin, or Pro. See Video user roles.

A Medallia Video channel Data Export is a file containing video and audio transcripts and select media data.

The Data Export is available as:

  • a .CSV file (Excel, Numbers, Google Sheets)
  • a .TXT file (TextEdit, Notepad)
  • an .XLSX file (Excel)

Sections in this topic include:

Generating a Data Export

  1. In the Media Library, click More Actions and select Data Export.

  2. Click User icon and select Download icon Exports.

  3. On the Exports screen, find the generated Data Export. The newest export appears at the top of the export list.

  4. To initiate download:

    1. By default, Download (CSV) is displayed. Click Download CSV for the .CSV file

    2. To retrieve the .XLSX download, click Down arrow and select Download Excel.

    3. To retrieve the .TXT download:

      Chrome — Click Down arrow and select Download TXT. The TXT file opens in a new browser tab. In the web browser, click File > Save Page As..., select and confirm the local destination, and save.

      Safari — Click Down arrow and select Download TXT. The TXT file opens in a new browser tab. Copy and paste as needed.

      Firefox — Click Down arrow and select Download TXT. The TXT file opens in a new browser tab. In the web browser, select Save Page As..., select and confirm the local destination, and save.

      Microsoft Edge — Click Down arrow and select Download TXT. The TXT file opens in a new browser tab. In the web browser, select Save Page As..., select and confirm the local destination, and save.

Tip: The Data Export pulls transcripts and data from the media displayed in the Media Library. Use Search or Filters to access section of media, such as by Country, CaptureMe project, or programmed survey Custom filters. Click the Data Export icon to only download the transcripts and data for the selected media displayed in the Media Library.
This video shows how to generate the Data Export from a Video channel.

Information in a Data Export

  • Media Id — the unique identifier in the Media View URL.
  • Type — the media type.
  • Duration — Video and Audio duration in seconds. Image value is 0.
  • Title
  • Description — blank unless media has a description.
  • Tags — blank unless tags are applied.
  • CountryCode — two digit country code.
  • Country — Country name.
  • LanguageCode — media language code.
  • Language — Language name.
  • NativeTranscription — Video and Audio spoken word transcription.
  • TranscriptionType — the spoken word transcription service.
  • EnglishTranslation — Video and Audio non-English to English translation.
  • TranslationType — the English translation service.
  • Facial — Facial Emotion Analysis data. Blank unless this service is activated.
  • Tone — Deprecated service, no longer offered. Tone Emotion Analysis data. Blank unless legacy data is available.
  • Object — Object Recognition data. Blank unless this service is activated.
  • EnglishTranscriptionSentiment — Sentiment Analysis aggregate sentiment value.
  • Filters — one column for each filter applied to media. Format is Filter group:Filter value.

It is not possible to configure the Data Export in the platform to add or remove columns.

Exports screen

The Exports screen shows all users' Data Export requests and is where users download Data Export files. Any Customer Admin, Channel Admin, or Pro user can view all channel Data Export requests and download any Data Export files.

If a user generates a Data Export based on a search term, the search term appears in the Exports screen Name column.

Click Down arrow and select Delete Export next to any Data Export request to remove it.

The main use case for deleting an export is to organize the Exports screen and consolidate the list of requests to only the most useful. Any Customer Admin, Channel Admin, or Pro user can delete any Data Export. If deleted, the Date Export needs to be re-generated from the Media Library.