Dimension columns

๐Ÿ“˜

Dimension columns identify a given dimension.

Dimension columns

Dimension
column
Type Description Applicable dimensions

date

Date

A date-time, indicating the start of the reporting period for a given row.

by_hour
by_smallest_time_bucket
by_campaign_by_smallest_time_bucket
by_site_by_smallest_time_bucket

campaign_id

Number

The numeric campaign ID.

by_campaign
by_campaign_by_smallest_time_bucket

campaign_name

String

The human-readable campaign name.

by_campaign
by_campaign_by_smallest_time_bucket

site_id

Number

The numeric Site ID.

by_site
by_site_by_smallest_time_bucket

site_name

String

The human-readable site name.

by_site
by_site_by_smallest_time_bucket

country

String

The 2-letter ISO-3166 country code.

by_country
by_country_by_smallest_time_bucket

country_name

String

The human-readable country name.

by_country
by_country_by_smallest_time_bucket

platform

String

The platform enum. Possible values: DESK, PHON, TBLT.

by_platform
by_platform_by_smallest_time_bucket

platform_name

String

The human-readable platform name.

by_platform
by_platform_by_smallest_time_bucket

Dimensions and their dimension columns

Dimension Dimension column(s)

by_hour

date

by_smallest_time_bucket

date

by_campaign

campaign_id
campaign_name

by_campaign_by_smallest_time_bucket

date
campaign_id
campaign_name

by_site

site_id
site_name

by_site_by_smallest_time_bucket

date
site_id
site_name

by_country

country
country_name

by_country_by_smallest_time_bucket

date
country
country_name

by_platform

platform
platform_name

by_platform_by_smallest_time_bucket

date
platform
platform_name