What is OData?

OData is a system designed to deliver data to end users with simple web URL addresses. The data can be filtered in place and complex operations done directly from the browser, application or Excel. There are many applications on the market designed to integrate with the OData 2.0 standard.

OData 2.0 spec and url information can be found at the documentation for the protocol. http://www.odata.org/documentation/odata-version-2-0/uri-conventions/

How to setup with Excel

The easiest way to use the data from an OData feed is using excel. There are many guides on the internet for advanced filtering, but this quick specific guide should set you on the way.

In Excel, click the Data tab, then “New Query”

Then “From Other Sources” -> OData Feed

This will now ask for the URL for the entity you wish to get the data for. You can specify any URLs from the table above. In this example we are going to be getting the stats for all users on a weekly basis.

Once the URL is in and you continue, the service will provide a raw sample of the data from Max.

Click edit to get the query editor

You can change criteria that you wish to report on, such as User/Campaign Name/ Id/ etc as well as date ranges. Excel will then re-evaluate the selection changes and re-pull the data

Example: Filter to a specific date. You can drop a header down for more advanced filtering. For this example we are going to be putting a custom date range in.

As you can see, these data will be pulled from between these ranges

Excel will store a list of steps that are applied to make sure the data matches your criteria.

When you are ready, click “Close and Load” This will pull the data into excel for your manipulation

You can refine the selection at any time by clicking the Query Tab

Examples of tables you can access;

Data Cube Table Description

Append the time period to the URL you want to report on e.g. StatsCampaigns would become StatsCampaignsWeekly to get the data on a row per week basis

List of Types Table (users, campaigns etc)