Matrix for Media

Monarch - Wide Orbit API

Historically users that utilized Wide Orbit as their traffic solution needed to have access to a special revenue export report and needed to pull that report manually to send to Matrix each day to update the revenue. With the Wide Orbit Revenue Data API, there is no longer a need to continue to use the manual export, as the API will allow for the automated send of data to Matrix overnight to fully update the revenue in the system.

To get started with the Wide Orbit API, you must first contact your Success Manager at Matrix. They will assist with the paperwork needed from the Matrix end to get your account setup for the Wide Orbit API. 

Once the paperwork has been completed, Wide Orbit will provide Matrix with API keys to access your data for the API integration. Matrix will then configure the Matrix database so that it will begin to pull over the data from the Wide Orbit API. It is important to note that there will be a testing phase, you will still want to provide the daily manual Wide Orbit report until a representative of Matrix informs you that you no longer need to do so.

Matrix will review the data that is sent via the API to ensure that Matrix is able to map the data according to the current standards in your Matrix database, as well as to ensure revenue is being reported correctly.

Once Matrix has deemed that the file is accurate, a representative of Matrix will work with you to ensure that the revenue is also correctly reporting to your standards. A report created in Microsoft Excel will be provided to you to allow for the validation of the revenue. Once you have validated the revenue, Matrix will work to schedule a date to cutover to the Wide Orbit API.

Matrix will adjust the import packages and mapping for the updated API feed and ensure that the data imports correctly. After some initial QA by the Matrix team, the data will be available for you to review to ensure that all is accurate.

The data fields that are available in the API are:

  1. STATION_CALL_LETTERS
  2. REVENUE1_CODE
  3. SALES_OFFICE_NAME
  4. AE_CODE
  5. AGENCY_NAME
  6. ADVERTISER_NAME
  7. YEAR_NUMBER
  8. MONTH_NUMBER
  9. PRODUCT_CODE_NAME
  10. CALENDAR_TYPE
  11. CASH_OR_TRADE
  12. NET_AMOUNT
  13. GROSS_AMOUNT
  14. SALES_REGION
  15. REVENUE2_CODE
  16. REVENUE3_CODE
  17. SHARE_OF_ORDER
  18. ORDER_NUMBER
  19. DEMOGRAPHIC
  20. CHANNEL_NAME
  21. IS_NEW_BUSINESS
  22. UNIT_CODE
  23. ORDER_TYPE
  24. BRAND_NAME
  25. ADVERTISER_EXTERNAL_ID
  26. AGENCY_EXTERNAL_ID
Did you find it helpful? Yes No