Details CSV

From Market Ruler Help
Revision as of 23:58, 13 March 2011 by Admin (talk | contribs) (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]…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

See also