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

dimension

Datum

Datum

metric

Dauer

Dauer

metric

Day

Day

metric

Endzeit

Endzeit

metric

Hour

Hour

metric

Min

Min

metric

Month

Month

metric

Sec

Sec

metric

Sender

Sender

dimension

Spot_costs

Spot_costs

metric

Startzeit

Startzeit

metric

Year

Year

metric

ad_id

ad_id

ID of ad

dimension

ad_image_url

ad_image_url

url of ad

dimension

ad_media_url

ad_media_url

url of ad media

dimension

airing

airing

metric

block_channel

block_channel

name of broadcast channel

dimension

block_edi_block_code

block_edi_block_code

block_edi_block_code

dimension

block_finish

block_finish

end time of broadcast block

dimension

block_genre

block_genre

genre of TV-program-empty string if no program data available

dimension

block_id

block_id

ID of block

dimension

block_length

block_length

total number of broadcasts in broadcast block

metric

block_program

block_program

name of TV-program during broadcast-empty string if no program data available

dimension

block_region

block_region

region code of broadcast region

dimension

block_start

block_start

start time of broadcast block

dimension

block_start_time

block_start_time

dimension

block_subgenre

block_subgenre

subgenre of TV-program-empty string if no program data available

dimension

blockindex

blockindex

position of broadcast in broadcast block starting at 0

metric

brand

brand

the advertised brand-empty string if no brand assigned

dimension

categories

categories

categories of ad

dimension

company

company

company associated with brand- empty string if no company assigned

dimension

count

count

metric

count_spots

count_spots

metric

date

date

broadcast date

dimension

description

description

short description of advertised content-empty string if no description made

dimension

duration

duration

ad duration in seconds

metric

hour

hour

metric

nbroadcasts

nbroadcasts

number of broadcasts

metric

product_category

product_category

dimension

time

time

time of broadcast

dimension

year

year

metric