| brand__v |
varchar(250) |
Name of the brand in the platform |
| campaign__v |
varchar(250) |
Name of the DIFA campaign |
| reported_time__v |
date |
Reported time from the DIFA dashboard |
| view__v |
varchar(256) |
The overarching view in which the media is being reported on |
| publisher__v |
varchar(250) |
The specific media partner the audience was exposed to |
| placement_group__v |
varchar(256) |
The specific set of content on a media partner the audience was exposed to |
| placement_id__v |
varchar(100) |
The Id of the placement in a media partner's ad server |
| site_type__v |
varchar(256) |
The type of site the publisher belongs to. |
| audience__v |
varchar(100) |
The name of the audience exposed to a specific media strategy |
| tactic__v |
varchar(100) |
The specific technique used to reach the audience |
| ad_type__v |
varchar(100) |
The type of media the audience was exposed to (i.e. Audio, Online Video, etc.) |
| report__v |
varchar(256) |
Campaign Report Type |
| metric__v |
varchar(512) |
Class of metrics reported |
| percentage__v |
decimal(10,9) |
Incidence rate of metric within population of analysis |
| targeting_multiple__v |
decimal(10,9) |
Comparison to Baseline Index for each specific metric or report |
| projection__v |
numeric(24) |
Volume within the population that meet criteria for each metric |
| statistical_significance__v |
numeric(1) |
Metric Statistical Significance (1=Low, 2= Medium, 3=High) |
| average_months_post_exposure__v |
numeric(24) |
Average number of months that have elapsed from each consumers first exposure of the digital campaign to the latest deliverable date. Capped at 3 months of exposure time. |
| average_cpm__v |
numeric(24) |
Cost per 1,000 impressions in USD |
| estimated_cost__v |
numeric(24) |
Estimated cost of the given population in USD |
| cost_per_target__v |
numeric(24) |
Calculated as Estimated Cost/Projection in USD |
| overlap_range__v |
varchar(51) |
Indicates the % overlap of individuals exposed to the first publisher that were also exposed to the second publisher. Ex: If the population is WebMD - Everyday Health and the overlap range is 0.05-0.1 then this is saying that among individuals exposed to WebMD media, 5-10% were also exposed to Everyday Health media. |
| metric_type__v |
varchar(250) |
The type of metric used for benchmarking |
| condition_size__v |
varchar(250) |
Relevant condition size for the audience metric that is being used for benchmarking |
| benchmark_1_dimension__v |
varchar(256) |
Defines the benchmark analysis dimension the population is being compared to in the Crossix benchmark. |
| benchmark_1_category__v |
varchar(256) |
The population category the benchmark is for |
| benchmark_1_quartile__v |
varchar(256) |
Compares the population's targeting multiple (Audience metrics) or % (Doctor Visitation metrics) to the benchmark of the given metric type, dimension and category. |
| benchmark_1_version__v |
varchar(15) |
The benchmark version. In the format <Year>-<Version #> |
| benchmark_2_dimension__v |
varchar(256) |
Defines the benchmark analysis dimension the population is being compared to in the Crossix benchmark. |
| benchmark_2_category__v |
varchar(256) |
The population category the benchmark is for |
| benchmark_2_quartile__v |
varchar(256) |
Compares the population's targeting multiple (Audience metrics) or % (Doctor Visitation metrics) to the benchmark of the given metric type, dimension and category. |
| benchmark_2_version__v |
varchar(15) |
The benchmark version. In the format <Year>-<Version #> |
| benchmark_3_dimension__v |
varchar(256) |
Defines the benchmark analysis dimension the population is being compared to in the Crossix benchmark. |
| benchmark_3_category__v |
varchar(256) |
The population category the benchmark is for |
| benchmark_3_quartile__v |
varchar(256) |
Compares the population's targeting multiple (Audience metrics) or % (Doctor Visitation metrics) to the benchmark of the given metric type, dimension and category. |
| benchmark_3_version__v |
varchar(15) |
The benchmark version. In the format <Year>-<Version #> |
| file_name__v |
varchar(200) |
Raw filename which loaded this record into Nitro |
