---
title: Exporting Data
description: SiteSpect's Data Export feature allows you to export the data that SiteSpect tracks. You can then analyze the exported data outside of SiteSpect using a third-party data analysis tool. To perform the
---

[Skip to content](https://doc.sitespect.com/knowledge/exporting-data#main-content)

English

Show submenu for translations

![Monetate-Logo-Full-Color-1](https://doc.sitespect.com/hs-fs/hubfs/Monetate-Logo-Full-Color-1.png?width=340&height=49&name=Monetate-Logo-Full-Color-1.png)

- [A/B Testing](https://www.sitespect.com/testing-and-experimentation/)
- [Personalization](https://www.sitespect.com/personalization-targeting/)
- [Recommendations](https://www.sitespect.com/recommendations/)

Open main navigation

Close main navigation

- [A/B Testing](https://www.sitespect.com/testing-and-experimentation/)
- [Personalization](https://www.sitespect.com/personalization-targeting/)
- [Recommendations](https://www.sitespect.com/recommendations/)
- English
  
  Show submenu for translations

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://doc.sitespect.com/knowledge?hsLang=en)
2. [Analyze](https://doc.sitespect.com/knowledge/analyze?hsLang=en)
3. [Data Export and Integration](https://doc.sitespect.com/knowledge/analyze?hsLang=en#data-export-and-integration)

# Exporting Data

SiteSpect's **Data Export** feature allows you to export the data that SiteSpect tracks. You can then analyze the exported data outside of SiteSpect using a third-party data analysis tool.

To perform the export, you need to complete the following steps, explained below in this topic:

1. First specify how to segment the data and set a date-range.
2. Choose from among the fields that SiteSpect tracks.
3. Choose the format for the exported file.
4. Choose whether or not to export an explanations file.

#### Launching the Export

To access the export function:

1. Select **Analyze**.
2. Select the Campaign whose data you want to export.
3. Select **Data Export**.

The Export page opens. By default, SiteSpect exports all the data it tracks. However, you can specify what to export and how it is sorted.

#### Selecting Segmentation Options

At the top of the Data Export page is a section that allows you to select Segmentation options, which determine how the data is sorted and grouped.

![Exporting Data](https://doc.sitespect.com/hs-fs/hubfs/Kbase%20Images/Exporting%20Data.png?width=688&name=Exporting%20Data.png)

1. Use the **View By** drop-down field to select how you want each row to report data. This determines what you are looking at in each row. 
     - **Visit** – Each row of data shows the sum of a single user's visit.
     - **User** – Each row of data shows the sum of all visits by a single user.
2. Use the **Segment By** drop-down field to determine how you want Segments to apply.
   
     - **Visit** – Applies the Segment by Visit.
     - **User** – Applies the Segment by User.
   
   **Note: Segment By** and **Visit By** do not have to match. For example, if you select **Visit** in the **View By** field and **User** in the **Segment By** field, and use a Segment that filters in all users who spent more than $300, SiteSpect creates a row for each visit for each user who meets the Segment criteria, including the visits during which the user spent nothing as long as the total for each user adds up to more than $300.
3. Segments allow you to identify a subset of users within a Campaign who exhibit similar behaviors while visiting your site. They allow you to limit the data to a subset that matches settings you define, such as Visit Attributes and Metrics. To select **Segments** to include in the export, click their check boxes in the Include column of the drop-down. To exclude a Segment, click its check box in the Not column. Select AND to include all visits or users that satisfy *all* the selected Segments. Select OR to include visits or users that satisfy *any* of the selected Segments. You can apply up to twenty Segments.

#### Specifying a Date Range for the Export

To specify a date range for the export, set a **Start Time** and an **End Time**. Click in either of the date fields to open a standard date selection pop-up. Complete the **Start Time** and **End Time**.

#### Selecting Fields to Export

The following fields are available for export. Note that all the fields are available when you select **Visit** from the **View By** drop-down list. Some are not available when you select **User** from the **View By** drop-down list and are marked as such below:

| **Metrics** | Select which metrics will be included in the download. |
| --- | --- |
| **User\_GUID** | The value of the User Tracking cookie (SSID) used by SiteSpect. |
| **AsmtVisitCount** | The visit number within the Campaign (i.e., 1=first, 2=second, etc.). Not available when you View By User. |
| **StartTime\_SSE** | Start time of visit in seconds-since-epoch, i.e., since Jan 1, 1970, in Greenwich Mean Time. |
| **StartTime\_English** | Start time of visit in English, e.g., 2008-10-06 09:56:44, in the time zone selected in your profile. |
| **StartTime\_Excel** | Start time of visit in Excel-compatible format. |
| **TotalVisits** | The total visits to the site, incremented each time a user visits your site, regardless of which Campaign the user is assigned to. |
| **TimeSinceFirstVisit** | The total number of days since the users first ever visited the site. |
| **VisitLength** | Elapsed time of visit in seconds. |
| **RefererUrl** | URL that referred/linked the user to the site. Not available when you View By User. |
| **User's IP Address** | The IP address of the user. Not available when you View By User. |
| **EntryPageUrl** | URL where the user entered the site (i.e., the landing page). Not available when you View By User. |
| **UserAgent** | The User-Agent string of the web browser. Not available when you View By User. |
| **Pageviews** | Number of pages viewed during a visit. |
| **Factor\_nnn** | ID of Variations shown for each tested factor. These fields are listed in the Export Explanation File (see below). |
| **Factor\_name** | The name and ID of the Variations shows for each tested Factor. |
| **AncillaryCookieValue** | The value captured from the ancillary cookie (if configured). Not available when you View By User. |
| **ConcurrentCampaigns** | This lists concurrent Campaign:VariationGroup IDs. |
| **Show data pertaining to type of mobile device used:** | Whether a visit was on a smartphone. Also includes the deprecated mobile details. Not available when you View By User. |

 

The following fields are automatically included in all exports:

| **VariationGroup\_ID** | The unique ID for each Variation Group. |
| --- | --- |

#### Selecting the File Format

The File Format section of the Data Export page allows you to set several options that determine the format of the output.

You may opt to include a header row with all field names by selecting the **Show Header Row with Field Titles** check box.

Select one of the following formats for the data export:

- **Text File: Comma Separated Values (CSV)** – Useful for importing into external statistical analysis programs or data collectors.
- **Text File: Tab Separated Values (TSV)** – Useful for importing into external statistical analysis programs or data collectors.
- **HTML File Type, Table** – This format is useful if you wish to present your data on a web site or import it into a web-based reporting system.

Select what type of quotes you want in the data export:

- **Double-quote (") Field Values** – Surrounds each value with double-quotes.
- **Singe-quote (') Field Values** – Surrounds each value with single-quotes.
- **No quotes** – Uses no quotes.

Select what you want to happen at the end of a line:

- **LF** – Just a line feed
- **CR** – Just a carriage return.
- **CRLF** – A carriage return and a line feed.

#### Exporting the Data

When you have made your selections, export the data by clicking **Export Data** at the bottom of the page.

You may also export a text file that explains the Metrics and Factor/Variation ID's by clicking Export Explanation File (TXT). This creates a text file or opens the data in a browser window.

- [Get Started](https://doc.sitespect.com/knowledge/get-started?hsLang=en#main-content)

    - [SiteSpect Support](https://doc.sitespect.com/knowledge/get-started?hsLang=en#sitespect-support)
    - [Overview Information](https://doc.sitespect.com/knowledge/get-started?hsLang=en#overview-information)
    - [Intro to SiteSpect](https://doc.sitespect.com/knowledge/get-started?hsLang=en#intro-to-sitespect)
    - [Account Setup](https://doc.sitespect.com/knowledge/get-started?hsLang=en#account-setup)
    - [Artificial Intelligence](https://doc.sitespect.com/knowledge/get-started?hsLang=en#artificial-intelligence)
- [Dashboard](https://doc.sitespect.com/knowledge/dashboard?hsLang=en)
- [Build](https://doc.sitespect.com/knowledge/build?hsLang=en#main-content)

    - [Setting Up a Campaign](https://doc.sitespect.com/knowledge/build?hsLang=en#setting-up-a-campaign)
    - [Create a Client-Side Campaign](https://doc.sitespect.com/knowledge/build?hsLang=en#create-a-client-side-campaign)
    - [Create a Server-Side Campaign](https://doc.sitespect.com/knowledge/build?hsLang=en#create-a-server-side-campaign)
    - [Metrics](https://doc.sitespect.com/knowledge/build?hsLang=en#metrics)
    - [Audiences](https://doc.sitespect.com/knowledge/build?hsLang=en#audiences)
    - [Triggers](https://doc.sitespect.com/knowledge/build?hsLang=en#triggers)
    - [Variations](https://doc.sitespect.com/knowledge/build?hsLang=en#variations)
    - [Traffic Management](https://doc.sitespect.com/knowledge/build?hsLang=en#traffic-management)
    - [Preview](https://doc.sitespect.com/knowledge/build?hsLang=en#preview)
    - [Factors](https://doc.sitespect.com/knowledge/build?hsLang=en#factors)
    - [Advanced Settings](https://doc.sitespect.com/knowledge/build?hsLang=en#advanced-settings)
    - [Omnichannel](https://doc.sitespect.com/knowledge/build?hsLang=en#omnichannel)
    - [Regular Expressions (Regex)](https://doc.sitespect.com/knowledge/build?hsLang=en#regular-expressions-regex)
    - [WATTS](https://doc.sitespect.com/knowledge/build?hsLang=en#watts)
    - [Recommendations](https://doc.sitespect.com/knowledge/build?hsLang=en#recommendations)
- [Monitor](https://doc.sitespect.com/knowledge/monitor?hsLang=en)
- [Analyze](https://doc.sitespect.com/knowledge/analyze?hsLang=en#main-content)

    - [Data Export and Integration](https://doc.sitespect.com/knowledge/analyze?hsLang=en#data-export-and-integration)
    - [SiteSpect Reports](https://doc.sitespect.com/knowledge/analyze?hsLang=en#sitespect-reports)
- [Site](https://doc.sitespect.com/knowledge/site?hsLang=en#main-content)

    - [Tools](https://doc.sitespect.com/knowledge/site?hsLang=en#tools)
    - [Configuration](https://doc.sitespect.com/knowledge/site?hsLang=en#configuration)
- [Developers](https://doc.sitespect.com/knowledge/developers?hsLang=en#main-content)

    - [API Reference](https://doc.sitespect.com/knowledge/developers?hsLang=en#api-reference)
    - [Code Samples](https://doc.sitespect.com/knowledge/developers?hsLang=en#code-samples)
    - [Tips & Tricks](https://doc.sitespect.com/knowledge/developers?hsLang=en#tips-tricks)
- [Mobile](https://doc.sitespect.com/knowledge/mobile?hsLang=en)
- [Implementation, Deployment, and Security](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#main-content)

    - [How does SiteSpect work with CDNs?](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#how-does-sitespect-work-with-cdns)
    - [Single Tenant Implementations](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#single-tenant-implementations)
    - [Security Features](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#security-features)
    - [Deployment and Implementation Overview](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#deployment-and-implementation-overview)
    - [SiteSpect Engine & Admin API](https://doc.sitespect.com/knowledge/implementation-deployment-and-security?hsLang=en#sitespect-engine-admin-api)
- [Third-Party Integration](https://doc.sitespect.com/knowledge/third-party-integration?hsLang=en#main-content)

    - [Google](https://doc.sitespect.com/knowledge/third-party-integration?hsLang=en#google)
    - [Zuko](https://doc.sitespect.com/knowledge/third-party-integration?hsLang=en#zuko)
- [Troubleshooting](https://doc.sitespect.com/knowledge/troubleshooting?hsLang=en)
- [Releases](https://doc.sitespect.com/knowledge/releases?hsLang=en#main-content)

    - [Superfresh](https://doc.sitespect.com/knowledge/releases?hsLang=en#superfresh)
- [Feedback](https://doc.sitespect.com/knowledge/feedback?hsLang=en)

- [A/B Testing](https://www.sitespect.com/testing-and-experimentation/)
- [Personalization](https://www.sitespect.com/personalization-targeting/)
- [Recommendations](https://www.sitespect.com/recommendations/)

[![Monetate-Logo-Full-Color-1](https://doc.sitespect.com/hs-fs/hubfs/Monetate-Logo-Full-Color-1.png?width=200&height=29&name=Monetate-Logo-Full-Color-1.png "Monetate-Logo-Full-Color-1")](http://monetate.com)

<https://www.facebook.com/> <https://www.twitter.com/> <https://www.instagram.com/> <https://podcasts.apple.com/> [mailto:email@email.com](mailto:email@email.com)

Copyright © 2026, Monetate