Ad Manager Data Warehouse: Overview
From Dot2DotCommunications
The Ad Manager data warehousing solution consists of a data pump utility which:
- extracts data from one or more Ad Manager databases;
- transforms it into a form more suitable for business analysis based on the Relational online analytical processing approach;
- loads the data into an external SQL Server database which can be used directly or as a staging database for reporting, business analysis, data mining, etc.
The data pump can be scheduled to run periodically using the Windows Task Scheduler.
Each run of the data pump captures a new snapshot of the Ad Manager data and appends it to the older snapshots in the data warehouse. The existence of multiple snapshots allows for historical analysis of the data. Snapshot retention is configurable.
The data in the warehouse is broadly organized into:
- fact tables storing data about locations, contracts, bookings, invoices, and lease payments;
- dimension tables describing attributes of the facts, e.g. advertisers, advertiser categories, agencies, salespeople, markets, general ledger accounts, etc.
