Skip to main content

Manadge API Extract (MFS)

Nathan avatar
Written by Nathan
Updated over 11 months ago

The Manadge Extract API is an optional feature available for an additional fee. For more information, speak with your Triton Digital Client Success Manager.


The Manadge Extract API allows you to extract and export data from a Manadge workspace securely and efficiently. This documentation covers the available endpoints, response formats, and authentication methods.

The Extract API is based on the Export feature in the Manadge Workspace. Limits remains the same.

Authentication and Token Access

The API uses token-based authentication to ensure secure access. Tokens are generated on the Manadge UI Workspace and are dedicated to each user. These tokens are the primary means of authentication for accessing the API.

Token Usage

Once generated, the token needs to be manually saved by you (the user) as it won't be accessible later. You must include your token as Basic Auth with:

  • Email address used to log in to your Workspace

  • API Token generated on your workspace

Token Lifecycle

  • Expiration: Tokens expire every three months, for security purposes.

  • Refreshing: Tokens can be refreshed to extend their validity for another three months. This process is managed solely within the Manadge UI Workspace and cannot be done via the API.

  • Revoking: Tokens can be revoked if needed. Again, this action is managed solely within the Manadge UI Workspace.

Important: Since token management (refreshing or revoking) is handled exclusively within the Manadge UI Workspace and not via the API, you must ensure you refresh or revoke tokens as necessary through the appropriate page.

Endpoints

GET /config

The API provides an endpoint to retrieve configuration possibilities of a report. This endpoint allows you to obtain information about available dimensions, metrics, currencies, fees, and other criteria.

  • Retrieve Data Extraction Configuration

    • Endpoint: GET /api/stats/extract/config

    • Description: Retrieves information about dimensions, metrics, currencies, fees, and other criteria available for data extraction.

Example Request:

curl 'https://<workspace>.manadge.tritondigital.com/api/stats/extract/config' -u '<your email adress>:<your access token from api key>' -H 'Content-Type: application/json'

Plain text

Copy

Example Response:

"dimensions": { "Month": { "dimension": "month", "name": "month" }, "Ad Network": { "dimension": "ad_network", "name": "ad_network" }, "Advertiser Domain": { "dimension": "advertiser", "name": "advertiser" }, "Device Type": { "dimension": "device", "name": "device" }, ... }, "metrics": { "Impressions": { "description": "", "precision": 0, "short_name": "Imp.s", "unit": "", "views": [ "auction", "bid" ], "name": "sumImpressionsRef" }, "Bid request Count": { "description": "Requests to Yield-Op for an ad (number of auctions). Each auction generates many requests.", "precision": 0, "unit": "", "views": [ "auction" ], "name": "bidRequestsRef" }, ... } } }

POST /extract

The API provides an endpoint to generate reports by extracting ZIP files including:

  • Metadata of the report (Date, filters, dimensions, period, etc.)

  • CSV files with the data.


This endpoint allows you to specify parameters such as dates, currency, dimensions, metrics, order by, filters, and view type, for generating the report.

  • Generate Report

    • Endpoint: POST /api/stats/extract

    • Method: POST

    • Description: Generates a report by extracting data in Parquet format based on specified parameters.

    • Request Body:

      • dates*: A DateQuery object representing the date range for the report.

      • dimensions*: A list of ExtractDimension objects specifying the dimensions for the report.

      • metrics*: A list of strings representing the metrics to be included in the report.

      • filters*: A dictionary containing key-value pairs for applying filters to the report data. It can be empty if no filters are applied.

      • order_by*: A string specifying the field to order the report data by.

      • view*: A string specifying the view type for the report data (i.e., Auction or bid)

      • fee (optional): A string representing the fee associated with the report data.

      • currency (optional): A string representing the currency for the report data.

* mandatory fields

Example Request:

curl --location 'https://{workspace}.manadge.tritondigital.com/api/stats/extract' \ -u '<your email adress>:<your access token from api key>' --header 'Content-Type: application/json' \ --data '{ "dates": {"from":"2024-04-29T00:00:00Z","to":"2024-04-30T00:00:00Z"}, "dimensions":[{"name":"device","top":100}], "metrics":["publisher_revenueRef"], "order_by":"publisher_revenueRef", "filters":{}, "view":"auction" }'

Example of the body of a request:

{ "dates": {"from":"2024-04-29T00:00:00Z","to":"2024-04-30T00:00:00Z"}, "currency":"USD", "dimensions":[{"name":"device","top":10}], "metrics":["sumRevenue"], "order_by":"sumRevenue", "filters":{}, "view":"bid" }

Limits and Quotas

When using the Data Export API, you should be aware of the following limits and quotas:

  • 30 Reports per Company per Day: Each company can generate up to 30 reports per day using the Data Export API.

  • Maximum 3 raw Dimensions per Report: Each report can include a maximum of three raw dimensions.

  • Unlimited Metrics per Report: There is no limit to the number of metrics that can be included in a report.

  • Additional security limits and quotas are currently being set up.

Did this answer your question?