NOTE: When the DOMAIN function parses a multi-tiered top-level domain such as co.uk, the output is the first part of the domain value (e.g. co). To return other parts of the domain information, you can use the HOST function. See HOST Function.

column_url

Name of the column or URL or String literal whose values are used to extract the domain value.

Missing input values generate missing results.

Multiple columns and wildcards are not supported.

Usage Notes:

Required?

Data Type

Example Value

Yes

String literal or column reference (URL)

http://www.example.com

Examples

Example - Filter out internal users

Here is some example web visitor information, including the name of the individual and the referring URL. You would like to filter out the internal users, whose referrer values include test-value.

Name

Referrer

Joe Guy

http://www.example.com

Ian Holmes

http://www.test-value.com/support

Nick Knight

http://www.test-value.com

Axel Adams

http://www.example.com

Teri Towns

http://www.example.com/test-value

Transform:

The referrrer values include test-value as a non-domain value and varying URLs from the test-value.com domain. So, you should use the DOMAIN function to parse only the domain versions of these values. The following evaluates the Referrer column values for the test-value domain and generates true/false answers in a new column accordingly: