Reports and Statistics in OpenX Ad Server

Exclusive offer: get 50% off this eBook here
OpenX Ad Server: Beginner's Guide

OpenX Ad Server: Beginner's Guide — Save 50%

Build and maintain professional advertising solutions for your web sites with OpenX Ad Server

$26.99    $13.50
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

OpenX Ad Server: Beginner's Guide Build and maintain professional advertising solutions for your web sites with OpenX Ad Server
Published: March 2010
eBook Price: $26.99
Book Price: $44.99
See more
Select your format and quantity:
  1. The following screenshot shows that the statistics of each banner under the campaign are listed according to the same criterion that is applied for sorting the campaign statistics:

    Reports and Statistics in OpenX Ad Server

  2. Let's click on any banner.

    Reports and Statistics in OpenX Ad Server

  3. We can now see the banner history on a daily basis sorted according to clicks. Let's sort it according to Day column as shown in the following screenshot:

    Reports and Statistics in OpenX Ad Server

  4. Let's click on Export Statistics to Excel link on the top of the statistics.
  5. Reports and Statistics in OpenX Ad Server

  6. OpenX Ad Server automatically generated an Excel (.xls) file for us. Let's open it with Excel.

    Alternatively, if you don't have MS Excel, you can download and use Open Office for free from openoffice. You can achieve everything in further examples using Open Office as well.

    Reports and Statistics in OpenX Ad Server

  7. Let's select three columns from the spreadsheet—Day, Impressions, and Clicks columns in the spreadsheet. Then, let's insert a chart by choosing Insert | Column | 3-D Column.

    Reports and Statistics in OpenX Ad Server

  8. We can now see that a chart is created and shows the progress of clicks and impressions over a period of time.

    Reports and Statistics in OpenX Ad Server

  9. Let's see clicks progressing only by time. To achieve this, right-click on the chart and choose Select Data… option.

    Reports and Statistics in OpenX Ad Server

  10. Then choose Impressions column, click on Remove button, and Finally click on OK button to complete the process.

    Reports and Statistics in OpenX Ad Server

  11. We can now see only data pertaining to progress of number of clicks on the chart as shown in the following screenshot. Note that the Days row is decreasing over time. This is due to order of the data selected before the chart retrieval.

    Reports and Statistics in OpenX Ad Server

  12. Let's return to statistics screen and click on Website Distribution tab.

    Reports and Statistics in OpenX Ad Server

  13. Now, we can see how the statistics for the banner was distributed among the websites.

    Reports and Statistics in OpenX Ad Server

  14. Click on the tiny arrow near a website name and we can see how the statistics are distributed among the zones under the website.

    Reports and Statistics in OpenX Ad Server

What just happened?

We started with advertiser level statistics and progressed into banner level step by step. During this process, we learned how effective advertisers and campaigns statistics screens were, to see values such as impressions, clicks, and CTR (Click-through rates) for a certain period of time. After this, we have exported the statistics of a banner to Excel for making a simple analysis chart. Finally, we learned that it was possible to jump into website and zone statistics for any advertiser, campaign, or banner.

Have a go hero – exploring other statistics screens

As we already know how to get statistics for advertisers and campaigns, we are ready to further explore websites and zones and global history statistics. Let's find and investigate these sections under statistics menu until we learn what kind of additional statistics we can get from the OpenX Ad Server system.

>> Continue Reading OpenX Advanced Reports.

If you have read this article you may be interested to view :

OpenX Ad Server: Beginner's Guide Build and maintain professional advertising solutions for your web sites with OpenX Ad Server
Published: March 2010
eBook Price: $26.99
Book Price: $44.99
See more
Select your format and quantity:

About the Author :


Murat Yilmaz

Murat Yilmaz is a software developer and an online entrepreneur who lives in Antalya, Turkey. He has over 10 years of experience in different IT fields, including development of web-driven solutions, large databases, and OLAP systems. He has worked in several multinational companies in Istanbul and Moscow as a consultant. He currently runs his own blog and an e-commerce and online advertising network. He holds a bachelor's degree in Computer Science from Marmara University at Istanbul. He spends his free time playing progressive rock songs, online chess, and reading scientific books.

He has also authored two other books, OpenCart 1.4: Beginner's Guide and OpenX Ad Server: Beginner's Guide.

Books From Packt

 

Amazon SimpleDB Developer Guide
Amazon SimpleDB Developer Guide

NHibernate 2.x Beginner's Guide
NHibernate 2.x Beginner's Guide

Drupal 7 First look
Drupal 7 First look

JavaFX 1.2 Application Development Cookbook
JavaFX 1.2 Application Development Cookbook

VirtualBox 3.1: Beginner's Guide
VirtualBox 3.1: Beginner's Guide

Pentaho 3.2 Data Integration: Beginner's Guide
Pentaho 3.2 Data Integration: Beginner's Guide

Microsoft Silverlight 4 Business Application Development: Beginner’s Guide
Microsoft Silverlight 4 Business Application Development: Beginner’s Guide

Moodle 1.9 Theme Design: Beginner's Guide
Moodle 1.9 Theme Design: Beginner's Guide

 

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
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