Reports and Statistics in OpenX Ad Server

by Murat Yilmaz | March 2010 | Open Source

In this article by Murat Yilmaz, author of OpenX Ad Server: Beginner's Guide, we will learn how to provide every tool to efficiently analyze the performance of websites, website zones, advertisers, campaigns, and banners. We will learn how we can get such statistics online. Then, we will investigate how we can export the data into a spreadsheet such as in Excel and analyze it with a real example.

In this article series, we shall learn:

  • How to view advertisers and campaign statistics
  • How to export data to Excel for further analysis
  • Types of advanced OpenX reports
  • How to retrieve advertising analysis reports using Excel

OpenX provides a very detailed and useful statistics and reports mechanism to evaluate the progress as well as performance of any campaign. OpenX reports and statistics tools have the ability to retrieve data on several groupings such as advertisers, campaigns, banners, websites, and zones.

Advertisers and campaigns statistics

It is the default OpenX statistics type. It provides current statistics of all advertisers under an account. It is also possible to retrieve statistics according to start and end dates.

Time for action – getting advertisers and campaign statistics

Now, let's learn how to get the statistics for a certain advertiser and the campaigns under it. We will then see how to analyze them on a spreadsheet.

  1. Click on Statistics menu item. Advertisers & Campaigns screen should automatically open. If not, click on Advertisers & Campaigns link.

    Reports and Statistics in OpenX Ad Server

  2. Now, we should be able to see current date's statistics as a default for all the advertisers under an account. Note that following screenshots are from a real OpenX Ad Server implementation and do not necessarily have to match with your screens.

    Reports and Statistics in OpenX Ad Server

  3. Let's view all the statistics for the advertiser, starting from the installation of OpenX Ad Server. Select All statistics option from the date list.

    Reports and Statistics in OpenX Ad Server

  4. We can now see all of the statistics for the advertiser.

    Reports and Statistics in OpenX Ad Server

  5. Click on tiny arrow near the advertiser name.
  6. Reports and Statistics in OpenX Ad Server

  7. We can now see the all the campaigns statistics under the advertiser.

    Reports and Statistics in OpenX Ad Server

  8. Click on the Clicks column.

    Reports and Statistics in OpenX Ad Server

  9. You can note that the campaign's statistics are sorted accordingly:

    Reports and Statistics in OpenX Ad Server

  10. Click on the tiny arrow near one of the campaign names.

    Reports and Statistics in OpenX Ad Server

Sign up for a Packt account to see the rest of this article

Now that you've read a few articles, you might want to consider signing up for a Packt account. It takes a matter of seconds, will give you access to all the articles on PacktPub.com, and once you've signed up you'll be returned here to carry on reading your article.

Furthermore, you'll gain access to nine free ebooks, and be offered a free trial of PacktLib, Packt's online library. Simply enter your details here, or log in to your existing account.

Log in

...or register

Post new comment

Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Sort A-Z