View source for Ad Manager Data Warehouse: Overview

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 [https://en.wikipedia.org/wiki/Online_analytical_processing 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.

== See also ==

[[Ad Manager Data Warehouse: Setup and configuration|Setup and configuration]]