Spotwatch: Most-used fields

Spotwatch: Most-used fields#

The table below gives information about most-used fields that you can import from Spotwatch. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name

Adverity UI name

Description

Use in Adverity

Basis (Tsd.) Adults 10-19

Basis (Tsd.) Adults 10-19

dimension

Basis (Tsd.) Adults 12+

Basis (Tsd.) Adults 12+

dimension

Basis (Tsd.) Adults 12-39

Basis (Tsd.) Adults 12-39

dimension

Basis (Tsd.) Adults 12-49

Basis (Tsd.) Adults 12-49

dimension

Basis (Tsd.) Adults 14-19

Basis (Tsd.) Adults 14-19

dimension

Basis (Tsd.) Adults 14-29

Basis (Tsd.) Adults 14-29

dimension

Basis (Tsd.) Adults 14-39

Basis (Tsd.) Adults 14-39

dimension

Basis (Tsd.) Adults 14-49

Basis (Tsd.) Adults 14-49

dimension

Basis (Tsd.) Adults 16-24

Basis (Tsd.) Adults 16-24

dimension

Basis (Tsd.) Adults 18+

Basis (Tsd.) Adults 18+

dimension

Basis (Tsd.) Adults 18-34

Basis (Tsd.) Adults 18-34

dimension

Basis (Tsd.) Adults 18-35

Basis (Tsd.) Adults 18-35

dimension

Basis (Tsd.) Adults 18-39

Basis (Tsd.) Adults 18-39

dimension

Basis (Tsd.) Adults 18-45

Basis (Tsd.) Adults 18-45

dimension

Basis (Tsd.) Adults 18-49

Basis (Tsd.) Adults 18-49

dimension

Basis (Tsd.) Adults 18-59

Basis (Tsd.) Adults 18-59

dimension

Basis (Tsd.) Adults 18-59 ABC1

Basis (Tsd.) Adults 18-59 ABC1

dimension

Basis (Tsd.) Adults 20-29

Basis (Tsd.) Adults 20-29

dimension

Basis (Tsd.) Adults 20-39

Basis (Tsd.) Adults 20-39

dimension

Basis (Tsd.) Adults 20-49

Basis (Tsd.) Adults 20-49

dimension

Basis (Tsd.) Adults 20-50

Basis (Tsd.) Adults 20-50

dimension

Basis (Tsd.) Adults 20-50 ABC

Basis (Tsd.) Adults 20-50 ABC

dimension

Basis (Tsd.) Adults 25-45

Basis (Tsd.) Adults 25-45

dimension

Basis (Tsd.) Adults 25-49

Basis (Tsd.) Adults 25-49

dimension

Basis (Tsd.) Adults 25-49 AB

Basis (Tsd.) Adults 25-49 AB

dimension

Basis (Tsd.) Adults 25-49 with kids

Basis (Tsd.) Adults 25-49 with kids

dimension

Basis (Tsd.) Adults 25-54

Basis (Tsd.) Adults 25-54

dimension

Basis (Tsd.) Adults 25-55

Basis (Tsd.) Adults 25-55

dimension

Basis (Tsd.) Adults 30-39

Basis (Tsd.) Adults 30-39

dimension

Basis (Tsd.) Adults 30-49

Basis (Tsd.) Adults 30-49

dimension

Basis (Tsd.) Adults 30-55 AB

Basis (Tsd.) Adults 30-55 AB

dimension

Basis (Tsd.) Adults 30-55 ABC1

Basis (Tsd.) Adults 30-55 ABC1

dimension

Basis (Tsd.) Adults 40-49

Basis (Tsd.) Adults 40-49

dimension

Basis (Tsd.) Adults 40-69

Basis (Tsd.) Adults 40-69

dimension

Basis (Tsd.) Adults 50+

Basis (Tsd.) Adults 50+

dimension

Basis (Tsd.) Adults 50-59

Basis (Tsd.) Adults 50-59

dimension

Basis (Tsd.) Adults 60+

Basis (Tsd.) Adults 60+

dimension

Basis (Tsd.) Children 4-10

Basis (Tsd.) Children 4-10

dimension

Basis (Tsd.) Householders 18-39

Basis (Tsd.) Householders 18-39

dimension

Basis (Tsd.) Householders 18-49

Basis (Tsd.) Householders 18-49

dimension

Basis (Tsd.) Householders 20-49

Basis (Tsd.) Householders 20-49

dimension

Basis (Tsd.) Householders 24-54

Basis (Tsd.) Householders 24-54

dimension

Basis (Tsd.) Householders 25-49

Basis (Tsd.) Householders 25-49

dimension

Basis (Tsd.) Householders 30-54

Basis (Tsd.) Householders 30-54

dimension

Basis (Tsd.) Householders 30-59

Basis (Tsd.) Householders 30-59

dimension

Basis (Tsd.) Householders Female 20-49

Basis (Tsd.) Householders Female 20-49

dimension

Basis (Tsd.) Householders with kids

Basis (Tsd.) Householders with kids

dimension

Basis (Tsd.) Men 12-39

Basis (Tsd.) Men 12-39

dimension

Basis (Tsd.) Men 14-34

Basis (Tsd.) Men 14-34

dimension

Basis (Tsd.) Men 18-39

Basis (Tsd.) Men 18-39

dimension

Basis (Tsd.) Men 18-49

Basis (Tsd.) Men 18-49

dimension

Basis (Tsd.) Men 18-59

Basis (Tsd.) Men 18-59

dimension

Basis (Tsd.) Men 25-39

Basis (Tsd.) Men 25-39

dimension

Basis (Tsd.) Men 25-54

Basis (Tsd.) Men 25-54

dimension

Basis (Tsd.) Men 25-59

Basis (Tsd.) Men 25-59

dimension

Basis (Tsd.) Women 15-29

Basis (Tsd.) Women 15-29

dimension

Basis (Tsd.) Women 18-39

Basis (Tsd.) Women 18-39

dimension

Basis (Tsd.) Women 18-49

Basis (Tsd.) Women 18-49

dimension

Basis (Tsd.) Women 20-39

Basis (Tsd.) Women 20-39

dimension

Basis (Tsd.) Women 20-49

Basis (Tsd.) Women 20-49

dimension

Basis (Tsd.) Women 20-59

Basis (Tsd.) Women 20-59

dimension

Basis (Tsd.) Women 23-54

Basis (Tsd.) Women 23-54

dimension

Basis (Tsd.) Women 25-40

Basis (Tsd.) Women 25-40

dimension

Basis (Tsd.) Women 25-45

Basis (Tsd.) Women 25-45

dimension

Basis (Tsd.) Women 25-49

Basis (Tsd.) Women 25-49

dimension

Basis (Tsd.) Women 25-59

Basis (Tsd.) Women 25-59

dimension

Basis (Tsd.) Women 25-65

Basis (Tsd.) Women 25-65

dimension

Basis (Tsd.) Women 30+

Basis (Tsd.) Women 30+

dimension

Basis (Tsd.) Women 30-59

Basis (Tsd.) Women 30-59

dimension

Basis (Tsd.) Women 35-59

Basis (Tsd.) Women 35-59

dimension

Basis (Tsd.) Women 50-75

Basis (Tsd.) Women 50-75

dimension

DRW (%) Adults 10-19

DRW (%) Adults 10-19

dimension

DRW (%) Adults 12+

DRW (%) Adults 12+

dimension

DRW (%) Adults 12-39

DRW (%) Adults 12-39

dimension

DRW (%) Adults 12-49

DRW (%) Adults 12-49

dimension

DRW (%) Adults 14-19

DRW (%) Adults 14-19

dimension

DRW (%) Adults 14-29

DRW (%) Adults 14-29

dimension

DRW (%) Adults 14-39

DRW (%) Adults 14-39

dimension

DRW (%) Adults 14-49

DRW (%) Adults 14-49

dimension

DRW (%) Adults 16-24

DRW (%) Adults 16-24

dimension

DRW (%) Adults 18+

DRW (%) Adults 18+

dimension

DRW (%) Adults 18-34

DRW (%) Adults 18-34

dimension

DRW (%) Adults 18-35

DRW (%) Adults 18-35

dimension

DRW (%) Adults 18-39

DRW (%) Adults 18-39

dimension

DRW (%) Adults 18-45

DRW (%) Adults 18-45

dimension

DRW (%) Adults 18-49

DRW (%) Adults 18-49

dimension

DRW (%) Adults 18-59

DRW (%) Adults 18-59

dimension

DRW (%) Adults 18-59 ABC1

DRW (%) Adults 18-59 ABC1

dimension

DRW (%) Adults 20-29

DRW (%) Adults 20-29

dimension

DRW (%) Adults 20-39

DRW (%) Adults 20-39

dimension

DRW (%) Adults 20-49

DRW (%) Adults 20-49

dimension

DRW (%) Adults 20-50

DRW (%) Adults 20-50

dimension

DRW (%) Adults 20-50 ABC

DRW (%) Adults 20-50 ABC

dimension

DRW (%) Adults 25-45

DRW (%) Adults 25-45

dimension

DRW (%) Adults 25-49

DRW (%) Adults 25-49

dimension

DRW (%) Adults 25-49 AB

DRW (%) Adults 25-49 AB

dimension

DRW (%) Adults 25-49 with kids

DRW (%) Adults 25-49 with kids

dimension

DRW (%) Adults 25-54

DRW (%) Adults 25-54

dimension

DRW (%) Adults 25-55

DRW (%) Adults 25-55

dimension

DRW (%) Adults 30-39

DRW (%) Adults 30-39

dimension

DRW (%) Adults 30-49

DRW (%) Adults 30-49

dimension

DRW (%) Adults 30-55 AB

DRW (%) Adults 30-55 AB

dimension

DRW (%) Adults 30-55 ABC1

DRW (%) Adults 30-55 ABC1

dimension

DRW (%) Adults 40-49

DRW (%) Adults 40-49

dimension

DRW (%) Adults 40-69

DRW (%) Adults 40-69

dimension

DRW (%) Adults 50+

DRW (%) Adults 50+

dimension

DRW (%) Adults 50-59

DRW (%) Adults 50-59

dimension

DRW (%) Adults 60+

DRW (%) Adults 60+

dimension

DRW (%) Children 4-10

DRW (%) Children 4-10

dimension

DRW (%) Householders 18-39

DRW (%) Householders 18-39

dimension

DRW (%) Householders 18-49

DRW (%) Householders 18-49

dimension

DRW (%) Householders 20-49

DRW (%) Householders 20-49

dimension

DRW (%) Householders 24-54

DRW (%) Householders 24-54

dimension

DRW (%) Householders 25-49

DRW (%) Householders 25-49

dimension

DRW (%) Householders 30-54

DRW (%) Householders 30-54

dimension

DRW (%) Householders 30-59

DRW (%) Householders 30-59

dimension

DRW (%) Householders Female 20-49

DRW (%) Householders Female 20-49

dimension

DRW (%) Householders with kids

DRW (%) Householders with kids

dimension

DRW (%) Men 12-39

DRW (%) Men 12-39

dimension

DRW (%) Men 14-34

DRW (%) Men 14-34

dimension

DRW (%) Men 18-39

DRW (%) Men 18-39

dimension

DRW (%) Men 18-49

DRW (%) Men 18-49

dimension

DRW (%) Men 18-59

DRW (%) Men 18-59

dimension

DRW (%) Men 25-39

DRW (%) Men 25-39

dimension

DRW (%) Men 25-54

DRW (%) Men 25-54

dimension

DRW (%) Men 25-59

DRW (%) Men 25-59

dimension

DRW (%) Women 15-29

DRW (%) Women 15-29

dimension

DRW (%) Women 18-39

DRW (%) Women 18-39

dimension

DRW (%) Women 18-49

DRW (%) Women 18-49

dimension

DRW (%) Women 20-39

DRW (%) Women 20-39

dimension

DRW (%) Women 20-49

DRW (%) Women 20-49

dimension

DRW (%) Women 20-59

DRW (%) Women 20-59

dimension

DRW (%) Women 23-54

DRW (%) Women 23-54

dimension

DRW (%) Women 25-40

DRW (%) Women 25-40

dimension

DRW (%) Women 25-45

DRW (%) Women 25-45

dimension

DRW (%) Women 25-49

DRW (%) Women 25-49

dimension

DRW (%) Women 25-59

DRW (%) Women 25-59

dimension

DRW (%) Women 25-65

DRW (%) Women 25-65

dimension

DRW (%) Women 30+

DRW (%) Women 30+

dimension

DRW (%) Women 30-59

DRW (%) Women 30-59

dimension

DRW (%) Women 35-59

DRW (%) Women 35-59

dimension

DRW (%) Women 50-75

DRW (%) Women 50-75

dimension

DRW (Tsd.) Adults 10-19

DRW (Tsd.) Adults 10-19

dimension

DRW (Tsd.) Adults 12+

DRW (Tsd.) Adults 12+

dimension

DRW (Tsd.) Adults 12-39

DRW (Tsd.) Adults 12-39

dimension

DRW (Tsd.) Adults 12-49

DRW (Tsd.) Adults 12-49

dimension

DRW (Tsd.) Adults 14-19

DRW (Tsd.) Adults 14-19

dimension

DRW (Tsd.) Adults 14-29

DRW (Tsd.) Adults 14-29

dimension

DRW (Tsd.) Adults 14-39

DRW (Tsd.) Adults 14-39

dimension

DRW (Tsd.) Adults 14-49

DRW (Tsd.) Adults 14-49

dimension

DRW (Tsd.) Adults 16-24

DRW (Tsd.) Adults 16-24

dimension

DRW (Tsd.) Adults 18+

DRW (Tsd.) Adults 18+

dimension

DRW (Tsd.) Adults 18-34

DRW (Tsd.) Adults 18-34

dimension

DRW (Tsd.) Adults 18-35

DRW (Tsd.) Adults 18-35

dimension

DRW (Tsd.) Adults 18-39

DRW (Tsd.) Adults 18-39

dimension

DRW (Tsd.) Adults 18-45

DRW (Tsd.) Adults 18-45

dimension

DRW (Tsd.) Adults 18-49

DRW (Tsd.) Adults 18-49

dimension

DRW (Tsd.) Adults 18-59

DRW (Tsd.) Adults 18-59

dimension

DRW (Tsd.) Adults 18-59 ABC1

DRW (Tsd.) Adults 18-59 ABC1

dimension

DRW (Tsd.) Adults 20-29

DRW (Tsd.) Adults 20-29

dimension

DRW (Tsd.) Adults 20-39

DRW (Tsd.) Adults 20-39

dimension

DRW (Tsd.) Adults 20-49

DRW (Tsd.) Adults 20-49

dimension

DRW (Tsd.) Adults 20-50

DRW (Tsd.) Adults 20-50

dimension

DRW (Tsd.) Adults 20-50 ABC

DRW (Tsd.) Adults 20-50 ABC

dimension

DRW (Tsd.) Adults 25-45

DRW (Tsd.) Adults 25-45

dimension

DRW (Tsd.) Adults 25-49

DRW (Tsd.) Adults 25-49

dimension

DRW (Tsd.) Adults 25-49 AB

DRW (Tsd.) Adults 25-49 AB

dimension

DRW (Tsd.) Adults 25-49 with kids

DRW (Tsd.) Adults 25-49 with kids

dimension

DRW (Tsd.) Adults 25-54

DRW (Tsd.) Adults 25-54

dimension

DRW (Tsd.) Adults 25-55

DRW (Tsd.) Adults 25-55

dimension

DRW (Tsd.) Adults 30-39

DRW (Tsd.) Adults 30-39

dimension

DRW (Tsd.) Adults 30-49

DRW (Tsd.) Adults 30-49

dimension

DRW (Tsd.) Adults 30-55 AB

DRW (Tsd.) Adults 30-55 AB

dimension

DRW (Tsd.) Adults 30-55 ABC1

DRW (Tsd.) Adults 30-55 ABC1

dimension

DRW (Tsd.) Adults 40-49

DRW (Tsd.) Adults 40-49

dimension

DRW (Tsd.) Adults 40-69

DRW (Tsd.) Adults 40-69

dimension

DRW (Tsd.) Adults 50+

DRW (Tsd.) Adults 50+

dimension

DRW (Tsd.) Adults 50-59

DRW (Tsd.) Adults 50-59

dimension

DRW (Tsd.) Adults 60+

DRW (Tsd.) Adults 60+

dimension

DRW (Tsd.) Children 4-10

DRW (Tsd.) Children 4-10

dimension

DRW (Tsd.) Householders 18-39

DRW (Tsd.) Householders 18-39

dimension

DRW (Tsd.) Householders 18-49

DRW (Tsd.) Householders 18-49

dimension

DRW (Tsd.) Householders 20-49

DRW (Tsd.) Householders 20-49

dimension

DRW (Tsd.) Householders 24-54

DRW (Tsd.) Householders 24-54

dimension

DRW (Tsd.) Householders 25-49

DRW (Tsd.) Householders 25-49

dimension

DRW (Tsd.) Householders 30-54

DRW (Tsd.) Householders 30-54

dimension

DRW (Tsd.) Householders 30-59

DRW (Tsd.) Householders 30-59

dimension

DRW (Tsd.) Householders Female 20-49

DRW (Tsd.) Householders Female 20-49

dimension

DRW (Tsd.) Householders with kids

DRW (Tsd.) Householders with kids

dimension

DRW (Tsd.) Men 12-39

DRW (Tsd.) Men 12-39

dimension

DRW (Tsd.) Men 14-34

DRW (Tsd.) Men 14-34

dimension

DRW (Tsd.) Men 18-39

DRW (Tsd.) Men 18-39

dimension

DRW (Tsd.) Men 18-49

DRW (Tsd.) Men 18-49

dimension

DRW (Tsd.) Men 18-59

DRW (Tsd.) Men 18-59

dimension

DRW (Tsd.) Men 25-39

DRW (Tsd.) Men 25-39

dimension

DRW (Tsd.) Men 25-54

DRW (Tsd.) Men 25-54

dimension

DRW (Tsd.) Men 25-59

DRW (Tsd.) Men 25-59

dimension

DRW (Tsd.) Women 15-29

DRW (Tsd.) Women 15-29

dimension

DRW (Tsd.) Women 18-39

DRW (Tsd.) Women 18-39

dimension

DRW (Tsd.) Women 18-49

DRW (Tsd.) Women 18-49

dimension

DRW (Tsd.) Women 20-39

DRW (Tsd.) Women 20-39

dimension

DRW (Tsd.) Women 20-49

DRW (Tsd.) Women 20-49

dimension

DRW (Tsd.) Women 20-59

DRW (Tsd.) Women 20-59

dimension

DRW (Tsd.) Women 23-54

DRW (Tsd.) Women 23-54

dimension

DRW (Tsd.) Women 25-40

DRW (Tsd.) Women 25-40

dimension

DRW (Tsd.) Women 25-45

DRW (Tsd.) Women 25-45

dimension

DRW (Tsd.) Women 25-49

DRW (Tsd.) Women 25-49

dimension

DRW (Tsd.) Women 25-59

DRW (Tsd.) Women 25-59

dimension

DRW (Tsd.) Women 25-65

DRW (Tsd.) Women 25-65

dimension

DRW (Tsd.) Women 30+

DRW (Tsd.) Women 30+

dimension

DRW (Tsd.) Women 30-59

DRW (Tsd.) Women 30-59

dimension

DRW (Tsd.) Women 35-59

DRW (Tsd.) Women 35-59

dimension

DRW (Tsd.) Women 50-75

DRW (Tsd.) Women 50-75

dimension

Date Generated

Date Generated

The timestamp indicating when an ad was generated (from the ‘created’ field of an Ad object), when a broadcast block started (from the ‘start’ field of a Block object), or when a broadcast occurred (from the ‘time’ field of a Broadcast object).

dimension

Day

Day

The day component extracted from a timestamp field such as ad creation time, broadcast start time, or block finish time. The API returns full timestamps, from which this component can be derived.

metric

Hour

Hour

The hour component of a timestamp, indicating the hour of the day (0-23) when an event (e.g., ad broadcast, block start) occurred. The Spotwatch API supports filtering broadcasts by hour.

metric

Min

Min

The minute component extracted from a timestamp field such as ad creation time, broadcast start time, or block finish time. The API returns full timestamps, from which this component can be derived.

metric

Month

Month

The month component extracted from a timestamp field such as ad creation time, broadcast start time, or block finish time. The API returns full timestamps, from which this component can be derived.

metric

Sec

Sec

The second component extracted from a timestamp field such as ad creation time, broadcast start time, or block finish time. The API returns full timestamps, from which this component can be derived.

metric

Spot_costs

Spot_costs

The cost associated with an ad spot or broadcast block. The Spotwatch API provides ‘edi_cost’ as a field in broadcast blocks.

metric

Year

Year

The year component extracted from a timestamp field such as ad creation time, broadcast start time, or block finish time. The API returns full timestamps, from which this component can be derived.

metric

ad_id

ad_id

A unique identifier for an advertisement. This ID is used to retrieve specific ad details or link broadcasts to their respective ads.

dimension

ad_image_url

ad_image_url

The URL or path to an image associated with the advertisement, such as a preview or grid image.

dimension

ad_media_url

ad_media_url

The URL to the media asset (e.g., video or image) associated with an advertisement.

dimension

block_channel

block_channel

The name of the broadcast channel where the ad block was aired.

dimension

block_finish

block_finish

The end time of the broadcast block.

dimension

block_genre

block_genre

The genre of the TV program within which the ad block was broadcast.

dimension

block_id

block_id

A unique identifier for the broadcast block, which contains one or more ad spots.

dimension

block_length

block_length

The total number of broadcasts (ad spots) within a specific broadcast block.

metric

block_program

block_program

The name of the TV program during which the ad block was broadcast.

dimension

block_region

block_region

The region code (e.g., country code) where the broadcast block was aired.

dimension

block_start

block_start

The start time of the broadcast block.

dimension

block_start_time

block_start_time

The start time of the broadcast block. This timestamp indicates when the block of advertisements began.

dimension

block_subgenre

block_subgenre

The subgenre of the TV program within which the ad block was broadcast.

dimension

blockindex

blockindex

The zero-based position of a specific broadcast within its corresponding broadcast block.

metric

brand

brand

The name of the advertised brand.

dimension

categories

categories

A list of categories associated with the advertisement (e.g., ‘telecommunication’).

dimension

date

date

The date component of various timestamps related to ad creation, last seen, or broadcast times. It is used to specify date ranges in API requests. This field is derived from API timestamp fields.

dimension

description

description

A short description of the advertised content.

dimension

duration

duration

The duration of the advertisement in seconds.

metric

hour

hour

The hour component of a timestamp, indicating the hour of the day (0-23) when an event (e.g., ad broadcast, block start) occurred. The Spotwatch API supports filtering broadcasts by hour.

metric

nbroadcasts

nbroadcasts

The total number of times an ad has been broadcast.

metric

time

time

The exact start time of a broadcast, as provided by the ‘time’ field within a Broadcast object. By default, timestamps are in ISO 8601 format in UTC.

dimension

year

year

The year component extracted from a timestamp field such as ad creation time, broadcast start time, or block finish time. The API returns full timestamps, from which this component can be derived.

metric