Market Ruler HelpDifference between revisions of "Details CSV"
From Market Ruler Help
(Created page with 'The '''Details CSV'' report is a form of the '''Summary''' report which is easily imported into programs such as: * [http://office.microsoft.com/en-us/excel Microsoft Excel]…') |
m |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | The '''Details [[CSV]]'' report is a form of the '''Summary''' report which is easily imported into programs such as: | + | The '''Details [[CSV]]''' report is a form of the '''Summary''' report which is easily imported into programs such as: |
* [http://office.microsoft.com/en-us/excel Microsoft Excel] | * [http://office.microsoft.com/en-us/excel Microsoft Excel] | ||
| Line 13: | Line 13: | ||
* '''summary_or_detail''' - The value is always '''DETAIL''' | * '''summary_or_detail''' - The value is always '''DETAIL''' | ||
| − | * '''Category''' - This visitor's landing to the site (Level ) | + | * '''Category''' - This visitor's landing to the site (Level 0) |
* '''Source''' - This visitor's landing to the site (Level 1) | * '''Source''' - This visitor's landing to the site (Level 1) | ||
* '''Campaign''' - This visitor's landing to the site (Level 2) | * '''Campaign''' - This visitor's landing to the site (Level 2) | ||
| Line 40: | Line 40: | ||
* Additional columns correspond to the action configured for this site, and include reference and total values, if configured | * Additional columns correspond to the action configured for this site, and include reference and total values, if configured | ||
| + | The header labels for the '''Category''' through '''Split 4''' columns may change depending on the configuration of the site. | ||
== See also == | == See also == | ||
* [[ConversionRuler Report Tab]] | * [[ConversionRuler Report Tab]] | ||
| Line 46: | Line 47: | ||
[[Category:ConversionRuler Features]] | [[Category:ConversionRuler Features]] | ||
[[Category:ConversionRuler Report]] | [[Category:ConversionRuler Report]] | ||
| + | [[Category:File Formats]] | ||
Latest revision as of 18:33, 18 May 2018
The Details CSV report is a form of the Summary report which is easily imported into programs such as:
Or can be easily manipulated by external programs.
The Details CSV file format is line-based, and contains fields, separated by a comma, and optionally enclosed with double quotes. Each line ends with a carriage return (0x10) and a new line (0x13).
The columns are as follows:
- summary_or_detail - The value is always DETAIL
- Category - This visitor's landing to the site (Level 0)
- Source - This visitor's landing to the site (Level 1)
- Campaign - This visitor's landing to the site (Level 2)
- Segment - This visitor's landing to the site (Level 3)
- Split 1 - This visitor's landing to the site (Level 4)
- Split 2 - This visitor's landing to the site (Level 5)
- Split 3 - This visitor's landing to the site (Level 6)
- Split 4 - This visitor's landing to the site (Level 7)
- keyword - The extracted keyword taken from this visitor's referrer
- userip - The IP Address of this visitor
- user - A unique ID for this user. Should never change for the lifetime of the visitor. Corresponds to the User concept.
- session - A unique ID for this user's session. Changes every Session.
- has_javascript - Whether this visitor has javascript turned on or off.
- city - The geographic city associated with this visitor's IP Address
- state - The geographic state associated with this visitor's IP Address (if applicable)
- zip - The U.S. Postal code associated with this visitor's IP Address (U.S. IP addresses only)
- country - The country associated with this visitor's IP Address
- domain - The domain name or host associated with this visitor's IP Address
- landing_timestamp - The time this visitor landed on the site
- landing_url - The URL where this visitor landed
- action_timestamp - The time when this visitor performed an action (blank for landings)
- action_url - The URL where this visitor performed this action (blank for landings)
- referrer - The referring web page for this visitor
- user_agent - The user's browser user agent
- Landing - 1 if this was a landing, blank if this was an action
- Additional columns correspond to the action configured for this site, and include reference and total values, if configured
The header labels for the Category through Split 4 columns may change depending on the configuration of the site.