Difference between revisions of "Details CSV"

From Market Ruler Help
Jump to: navigation, search
m
 
Line 47: 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.

See also