OpenX Advanced Reports

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 series 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.

Here, 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

Read Reports and Statistics in OpenX Ad Server.

Advanced reports section provides a more organized and easier way to analyze OpenX statistics to work further with MS Excel. There are three types of advanced analysis reports:

  • Advertising analysis report: This report provides a breakdown of advertising statistics for a particular advertiser or publisher. The generated report has three sections—daily, campaign, and zone breakdowns.
  • Campaign analysis report: This report type is suitable to analyze the details of a particular campaign. There are three breakdowns including day, banner, and zone.
  • Campaign delivery report: This advanced report shows the delivery statistics of campaigns for a certain selected period. It also highlights the underperforming campaigns.

Advertising analysis report

Now let's learn how to retrieve one of the most useful analysis reports in OpenX.

Time for action – getting advertising analysis reports

  1. Click on Advanced Reports link in Statistics menu.

    OpenX Advanced Reports

  2. Click on Advertising Analysis Report link in Standard Reports section.

    OpenX Advanced Reports

  3. Click on the Generate button, without changing any options.

    OpenX Advanced Reports

  4. Choose Open with Microsoft Office Excel (default) and click on OK button.

    OpenX Advanced Reports

  5. We can see the Daily Breakdown tab selected by default.

    OpenX Advanced Reports

  6. Click on Campaign Breakdown tab to get the details of all campaigns.

    OpenX Advanced Reports

  7. Finally, click on Zone Breakdown tab to see the statistics of all zones

    OpenX Advanced Reports

What just happened?

We learned how to generate an advertising analysis report in a few steps. This helps us get very useful statistics to determine the daily progress, success rates of campaigns, and zones that are organized in separate Excel tabs for easy analysis.

Have a go hero – exploring other advanced report types

Now, go and examine other report types including campaign analysis report and campaign delivery report. Try to understand the differences between the report types.

Have a go hero – playing with statistics columns

Try to specify the columns you need for online statistics screen using the account preferences.

Pop quiz – understanding OpenX reports and statistics

Suppose we (as an account manager) opened an advertiser account user for one of the advertisers. Which of the following report types will be available for the new user?

  1. Advertiser analysis report
  2. Campaign analysis report
  3. Campaign delivery report
  4. All of the reports
  5. None of the reports

Summary

In this article series, we have learned how to use reports and online statistics to evaluate the performance of OpenX advertisers, campaigns, banners, websites, and zones.

We have specifically covered:

  • Advertisers and campaigns statistics
  • Exporting data to Excel for further analysis
  • Types of advanced OpenX reports
  • Getting advertising analysis reports in Excel

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