Zephr User Guide

Understand the Export Data

0 views 0

The name of the exported CSV file has the following format:

<tenant>-<implementation>-<feature>-<version>-<datatype>

For example, given the following:

  • Tenant name is Muirton
  • Implementation type is HTML
  • Feature is called Subscription
  • Version is 234

A file containing aggregated data would have the following name:

muirton-html-subscription-234-all-time.csv

A file containing daily data would have the following name:

muirton-html-subscription-234-daily.csv

As you can see from these examples, the <datatype> identifies whether the downloaded data is aggregated or daily.

The columns in the CSV file are as described in the following table:

Column Heading Description
tab Identifies the user type canvas that contains the outcome

Can be any of the following:

  • anonymous
  • registered
  • customer
outcomePath Identifies the path on the user type canvas that is followed to reach the outcome

For example, the following entry shows a path in a subrule where the user encounters an output named Payment after selecting button 3:

SubruleNode,InputNode,DecisionPoint,DecisionPoint,DecisionPoint,SubruleOutputNode:
button3,SubruleNode,InputNode,DecisionPoint,SubruleOutputNode:Payment

outcomeId Identifies the outcome to which the data refers by ID

For example, Transformation:Create Account Data Capture Form

total Provides the total number of users that encountered the outcome
bucketStart Only populated if daily data has been exported

If daily data has been exported, identifies the date and time on which the conversion numbers were collected in the format yyyy-mm-ddThh:00Z

bucketInterval Only populated if daily data has been exported

If daily data has been exported, identifies the period to which the conversion numbers apply

This is always P1D, to show that this is daily data

conversion: <type> Provides the number of end users who converted when they encountered this output

<type> identifies the type of conversion. Some common examples are as follows:

  • conversion: Data Captured
  • Conversion: CUSTOMER
  • Conversion: REGISTERED

For further information on exporting data, see the Export the Data section.

You can import the CSV file to an external tool for further analysis.

For example, you could add a percentage column to the sheet in Google Sheets, or add a Pivot table to present the data. For further information on adding percentages to a Google sheet, refer to the Add formulas and functions topic in the Google Docs Editors Help. For further information on adding a pivot table, refer to the Create and edit pivot tables topic in the Google Workspace Learning Center.