Dimension columns

πŸ“˜

Dimension columns identify a given dimension.

Dimension columns

Dimension
column
TypeDescriptionApplicable dimensions
dateDateA date-time, indicating the start of the reporting period for a given row.by_item_by_smallest_time_bucket
item_idNumberThe numeric Item ID.by_item
by_item_by_smallest_time_bucket
item_typeStringPossible values:
"ITEM" (a regular item)
"RSS" (see: RSS Items)
by_item
by_item_by_smallest_time_bucket
descriptionStringThe description for the item (ad).by_item
by_item_by_smallest_time_bucket
thumbnail_urlStringThe URL for the item (ad) thumbnail.by_item
by_item_by_smallest_time_bucket
urlStringThe target URL for the item (ad).by_item
by_item_by_smallest_time_bucket

πŸ“˜

The 2 dimensions have nearly identical dimension columns.