Skip to main content
All CollectionsCookie Consent
BigQuery Field Documentation
BigQuery Field Documentation

Field documentation for the Enzuzo BigQuery integration.

Updated over 4 months ago

Enzuzo Enterprise Consent Analytics allows you to gather deeper insights into your cookie banner's traffic. Available only on our Enterprise plan, this feature makes data from your CMP accessible in BigQuery, which can be connected to Looker Studio or other data visualization platforms. Your data is organized for you by domain, which enables fine-grained exploration of your banner's consent patterns.

The following is a description of the available fields in the BigQuery data:

Field name

Description

uuid

Unique identifier for each incoming event.

event_time

Time the event was sent from the cookie banner.

event_type

The type of the event - see below for more details.

ip

The IP address of the event - not available for privacy reasons.

user_agent

The user agent of the browser that sent the event (more info)

country

The country the event was sent from.

region

The region (state/province, etc.) the event was sent from.

city

The city the event was sent from.

hostname

The hostname of the page the event was sent from. (e.g., enzuzo.com)

url

The URL of the page the event was sent from. (e.g. https://enzuzo.com/privacy-policy)

language

The language of the page the event was sent from (e.g. en-US).

referrer

The previous page the event's user came from (more info).

screen

The screen size of the user that sent the event (e.g. 1080x720)

title

The title of the page the event was sent from.

consent_analytics

Whether analytics was consented to when the event was sent. NULL indicates the user took no consent action.

consent_marketing

Whether marketing was consented to when the event was sent. NULL indicates the user took no consent action.

consent_functional

Whether functional was consented to when the event was sent. NULL indicates the user took no consent action.

consent_preferences

Whether preferences was consented to when the event was sent. NULL indicates the user took no consent action.

per_event_params

Miscellaneous parameters for each kind of event.

dnt

The value of the user's Do Not Track setting.

browser_signature

A unique identifier of the user's browser. Computed from the IP, location, screen, user agent and DNT fields.

serving_domain

The domain of the Enzuzo account this event was sent to.

banner_settings_tag

(Coming soon) A user-specified tag provided when banner settings are saved.

Event Types

  • accept/decline: The user pressed accept/decline on the cookie banner.

  • accept-all/decline-all: The user pressed accept all/decline all in the cookie manager modal.

  • accept-selected: The user pressed accept selected in the cookie manager modal.

  • close-cm/close-banner: The user closed the cookie manager or cookie banner.

  • page-view: The banner was shown to the user. This does not trigger if the banner is not shown (e.g. the user has already consented or the banner is set to "Don't Show" for their region.)

Unique Visitors

To estimate unique visitors, the browser_signature field can be used. This field is calculated from the user's IP and other unique browser details, making it a good approximation of a unique browser identifier. The number of unique values of browser_signature over a given period can be used to estimate your number of unique visitors during that period.

Did this answer your question?