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]…') |
(No difference)
|
Revision as of 23:58, 13 March 2011
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 )
- 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