Help centre
How can we help you?
← Go back
How Reporter works
Reporter is a component in the Mediagenix On-Demand infrastructure that runs every 2 hours and extracts, transforms and loads (ETL) the data from your Mediagenix On-Demand / Metadata and Sequence accounts:
- Extract. Every two hours, Reporter retrieves a snapshot of all your data from the Mediagenix On-Demand / Metadata and Sequence databases.
- Transform. The raw data, as extracted from the application databases, is not structured or optimised for reporting purposes. In this stage, Reporter cleans and schematizes the data to conform to a normalized data model optimal for reporting.
- Load. Finally, Reporter updates your own private dataset in Google BigQuery with the transformed data.