Overview

Bulk Data Export service is designed to provide you with a streamlined and efficient way to export your MCM data into your analytics services and cloud storage provider. This service provides daily export of data containing campaign information and ad performance metrics, packaged in the efficient and fast parquet file format. Data Export makes it easy to ingest large amounts of data automatically without the need to make requests to the MCM Report API.

Version Information

If you are already using Bulk Data Export please examine the data storage path to find your version number. The version (v1, v2, or v3) can be found after the name of your platform’s storage bucket.

Format: gs://{bucket}/{version}/...

Example: gs://mcm-export-my-platform-name/v2/... indicates data export version 2.0.

🚧
For customers using Data Export version 1.0 please see Guide v1.1 for more information.

Version 3.0 Update

Data Export version 3.0 adds enhanced support for the latest ad campaign features, campaign configurations, and targeting options along with improved storage path granularity. Version 3.0 supports daily, scheduled, and on-demand reporting, please see the information below for details.

Migration Options

Customers may continue to use their current version of Data Export, no mandatory migration is required. However, we highly recommend migrating to version 3.0 if you are using or planning to use campaign targeting options or Sponsored Brands and Display ads. Data Export 3.0 provides extended reporting for these ad formats and features.

📘
Please reach out to your Moloco team to activate Data Export or migrate to the latest version.

Reports and Metrics

Data Export provides distinct reports for ad campaign configurations and ad performance metrics. Please see the links below for full details, including schema information for each export version.

The Campaign Information export contains all campaign configuration settings on the platform.

The Ad Performance export contains all ad performance data for the platform.

Export Schedule

Data Exports allows customers to choose the time of export, local or UTC, to guarantee the data from the previous day is complete and available for retrieval at your convenience.

Export Timezone

Depending on your chosen timezone, we'll use the local time clocks for our daily data export jobs. For instance, if you pick US Eastern Timezone, we'll automatically use either Eastern Standard Time (EST) or Eastern Daylight Time (EDT). If you opt for Coordinated Universal Time (UTC), we'll base our daily processing on the UTC time you choose.

📘
Note
During daylight saving time shifts, the daily export job will account for a 23-hour time window for the day. For example, on the second Sunday of March, the US East switches its clock to Eastern Daylight Time (UTC+4) from Eastern Standard Time (UTC+5). On the day daylight saving starts, the day's total hours will be 23.
Conversely, on the first Sunday of November, the region switches back to EST from EDT. On the day when daylight saving ends, the day's total hours will be 25.

Data Export vs Real Time Metrics

🚧
Metric discrepancies are expected within the attribution window, as data export revises all dates in the attribution window (typically 7 or 14 days) during each export cycle, the metrics for those dates may change daily.

Within the attribution window the metrics in the MCM web portal data would contain the latest real time data.

All dates outside the attribution window are finalized, in this scenario exported data metrics will align with the MCM web portal metrics.

Data Lifecycle

MCM export data files are stored for a period of up to 30 days in the provided GCP bucket. We recommend using an automated continuous transfer service to maintain a copy of the data to conduct analytics beyond 30 days.

Accessing Your Data

MCM Data should be exported to your cloud storage provider, the transfer method can vary per cloud service, for detailed access instructions and support, refer to our guide (How to Transfer Data).

Questions

Please see the MCM FAQ.