Details CSV

The Details CSV report is a form of the Summary report which is easily imported into programs such as:

• Microsoft Excel
• Apple Numbers
• NeoOffice
• OpenOffice

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

• ConversionRuler Report Tab