Advanced Data Warehouse Settings

Accessing Advanced Settings

  1. In Analytics, click on the gear icon and select Project Settings.
    Access project settings
  2. This will list all of your data sources. Find the Data Warehouse that you would like to edit and select Edit Details.
    Edit data warehouse details
  3. Click on the Advanced tab.
    Open advanced settings tab

Advanced Settings Configurations

Exclude Events

Exclude events settings

We typically pull all of the events in your data source, but if there are exclusions that you would like to make, place them here. We pull data with a blacklist approach, meaning everything will be ingested except specific exclusions.

  1. In the Event Name matches field, include any event names to exclude when extracting your data. You can place a pattern or if there isn’t one, separate multiple event names with a ;.
    For example, if you want to exclude all events that start with ‘test’, put ‘test*’ in this field.
  2. For Property Value matches, we will exclude events based on property values.
    For example, if you want to exclude any events where device = ‘test’, place that in this field.

Exclude Properties By

Exclude properties settings

Similar to the Exclude Events section, we will pull all properties and make exclusions with a blacklist.

  1. If there are any properties to exclude during extract, list them out in this field.
    For example, if you want to exclude the device_screen_size property, place that in this field.

Context Field Exclusions

Context field exclusions settings

Include Event Property Prefix

Include event property prefix - Snowplow

Note: This option is only available for Snowplow schemas.

User ID Null Values

User ID null values settings

Some organizations may use non-null values to represent an undefined User ID. Please enter any values that are used to represent null User IDs in this field. We exclude NULL by default, so you do not need to specify that here.

Note: If you use an empty string for null user IDs, put two single quotes and press Enter to mimic the picture above.

Was this page helpful?