convertduration

Convert duration values into the ISO 8601 format.

Introduction

Use the convertduration enrichment instruction to duration data (such as time spent on a page) into the ISO 8601 format. The ISO 8601 format stores duration data as integers.

Creating the enrichment

For more information on creating an enrichment, see Using custom scripts.

Configuring the enrichment

To configure the enrichment, fill in the following fields. Required fields are marked with an asterisk (*).

Fields

Enter the names of the columns that contain the duration data to convert.

Input duration format

Select the format of the duration data.

Example 1

Enrichment configuration

Fields

Ad view time (average)

Format

MM:SS

Data tables before enrichment

Ad	Ad view time (average)
Summer collection	00:45
Winter sale	01:01
Superbowl	00:13

Data tables before enrichment

Ad	Ad view time (average)
Summer collection	45
Winter sale	61
Superbowl	13