Ad System Domains
Overview
The adsystem_domains dataset contains data that is collected from the domains:detect_domains module, as well as the mapping from a given adsystem to their associated adsystem_domains. This dataset allows users to understand the popularity of any given ad technology related domain in the ecosystem.
It is effectively a sibling dataset to publisher domains, as they are both created from the same crawl module. Each row in the dataset is a unique sub-domain associated to an Ad System.
Dataset
| Field | Type | Description |
|---|---|---|
| id | integer | unique identifier that applies to specific adsystem_domain. |
| domain | string | The domain (truncated to sub-level domain) that is associated with a given Ad System |
| root_domain | string | The top-level domain of the adsystem_domain. This is provided for convenience purposes. |
| detected_count | integer | this is a count of how many times the given sub-domain was detected across all of Sincera. |
| adsystem_id | integer | this is a foreign key of Ad System, allowing for easy joining to a given parent company / Ad System. |
| created_at | datetime | Date the record was created, which is effectively the first detection date of the domain. |
| updated_at | datetime | The last time the record was updated, which is effectively the last detection date of the domain. |
| description | string | Optional description or background of the domain. More commonly found on domain values with high detected_count values. |
| domainpurpose_id | integer | Foreign key for joining on the Domain Purpose dataset, which canonically defines how the domain is used. |