Exporting and Interpreting Consent Data

You can export the data presented in the dashboard to do in-depth analysis and generate reports. The data is presented in a highly granular fashion to allow for extensive sorting, cleaning, grouping, and recombination based on the needs of the analysis.

To Export Consent Data

  1. On the Cookie Consent menu select Dashboards. The Dashboards screen appears.

  2. Click the Export button. The Export Dashboard modal appears.

  3. Enter the parameters for the consent data you would like to export. See the Export Dashboard Screen Reference.
  4. Open the Alert Center and download the report. To see a description of the fields, see Data Fields in the Exported Spreadsheet.

Export Dashboard Screen Reference



Field
Description
Source

Collection Point(s) the consent data was sent from. Collection Points are set up in the Consent Module.

Template

Template(s) used to collect the consent data.

Time Range

The time range to display consent data. The calendar can be used to filter dates within that time range.

Data Fields in the Exported Spreadsheet

For detailed information, see Enabling Consent Logging and the Cookie Consent Dashboard. Enabling Consent Logging and the Cookie Consent Dashboard

Field
Description
Browser

Web browser used by the site visitors to provide consent data.

Country

The country the site visitors are accessing the website from.

Device

Device used to provide consent data.

Domain

Domain where consent data was given.

Policy

Geolocation Rule Group consent data was provided under.

Rule Name

Rule within the Geolocation Rule Group applied to the site visitors.

Template

Template used to display consent options to the site visitors.

Collection Point

Source of the consent data.

Window Start

Date when consent data was first collected from the site visitors.

Total Receipts

Total receipts collected for the specific combination of fields (includes Browser, Country, Device, Domain, Policy, Rule Name, Template, Collection Point, and Purpose).

Purpose

The Cookie Category or IAB TCF Purpose for which consent data was given.

Opt-in by Purpose

Number of times site visitors accepted all or enabled a category, purpose, or special feature.

Expired by Purpose

Number of times consent data expired for a site visitor by purpose.

No Choice by Purpose

Number of times site visitors were not given a choice to consent by purpose (purpose is configured as Notice Only).

Not Given by Purpose

Number of times site visitors navigated away from the Banner or Preference Center without providing a response.

Opt-out by purpose

Number of times site visitors rejected all or disabled a category, purpose, or special feature.

Pending by Purpose

Pending by Purpose is used when a double opt-in is required and only one has been provided. (for example when a box is checked and an email address is required).

Note:

Cookie Consent does not support double opt-in consent models. Entries in this column are from the Consent Module.

Withdrawn by Purpose

Number of times site visitors withdrew consent for a category, purpose, or special feature after initially opting in.

Interpretting Downloaded Consent Data

The consent data is presented in a completely granular manner in a Microsoft Excel spreadsheet. This data can be analyzed to accommodate a wide range of applications. Here we describe a basic application by calculating the opt-in, opt-out, and not given rates as percentages. Alternatively, you can paste the data from your .csv file into the attached template.

  1. Open the downloaded spreadsheet file with Excel.

  2. From the File menu, select and Save As. Save the file as a comma delimited file (.csv).

  3. Open the .csv with your spreadsheet program.

  4. Use the SUM command to get the column sums for Opt-in, Opt-out, and Not Given.

    CODE 
    V4 =SUM(L:L)
W4 =SUM(P:P)
X4 =SUM(O:O)

  5. Calculate the total number by taking the sum of of the consent receipts.

    CODE 
    U4 =SUM(V4,W4,X4)

  6. Calculate the percentage for each response.

    CODE 
    V5 =V4/U4
W5 =W4/U4
X5 =X4/U4

  7. Highlight V5, W5, and X5 and right-click. Select Format Cells from the menu.

  8. Change the Category to Percentage and select the number of decimal places.

  9. Click OK.