Understand the export data
This topic explains the format of exported CSV file names and describes the columns within the file, which can be used for further analysis in external tools.
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:
|
|
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
|
|
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
|
|
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:
|
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.