Publisher Domains
Overview
The publisher_domains dataset contains data that is collected from the domains:detect_domains module. This table serves as a broad source of interpreting what domains are called from a given publisher.
It is effectively a sibling dataset to adsystem domains, as they are both created from the same crawl module, and stored for easy lookup against Adsystems or Publishers
Dataset
| Field | Type | Description |
|---|---|---|
| id | integer | unique identifier that applies to specific publisher domain row. |
| publisher_id | integer | foreign key of the publisher that the given domain detection event applies to. |
| domain | string | The domain (truncated to sub-level domain) that was detected on the associated publisher. This can be joined to adsystem domains for additional data. |
| detected_count | integer | this is a count of how many times the given sub-domain was detected on the publisher. |
| 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. |