Reports
| Note: This article is for an old version of OpenX. The latest OpenX documentation can be found at the following URLs: |
In the Reports tab you can generate a range of reports which can be downloaded in Excel file format. The following reports are available:
- Advertising Analysis Report
- Campaign Analysis Report
- Conversion Tracking Report
- Campaign Delivery Report
To create a report, click on the link for the relevant report and then:
- Select the Period to include in the report, such as Today, This month or All statistics from the drop-down menu. If you select Specific dates from the menu, enter these in the date fields.
- Select the Limitations, such as for a particular advertiser, publisher or campaign.
- Select the Worksheets you want to create. Each report type - except the campaign delivery report - features options for a number of standard worksheets that provide various views of the activity on your system.
Some Report Abbreviations
Req: requests (user requests an ad; by default this is not logged)
Impr: impressions (user requests an ad, and ad is delivered to user)
Clicks: click
Ctr: click through ratio
Conv: conversion (sale)
Pend conv: pending conversion (not approved)
Impression SR column: sale ratio: ratio of sales to impressions
Click SR column: sale ratio: ratio of sales to clicks
Rev: revenue
Cost: media cost
Num.Items: the number of items inside a conversion (i.e. when you sell two books in one sale)
Tech Cost: tech cost of a banner
Income: revenue minus technology cost
Inc. Margin: income/revenue
Profit: (revenue) minus (technology cost) - (cost)
Margin: gross profit/revenue
ERPM: (revenue/impressions * 1000)
ERPC: (revenue/clicks)
ERPS: (revenue/conversions)
EIPM: (income/impressions * 1000)
EIPC: (income/clicks)
EIPS: (income/conversions)
ECPM: (cost/impressions * 1000)
ECPC: (cost/clicks)
ECPS: (cost/conversions)
EPPM: (profit/impressions * 1000)
EPPC: (profit/clicks)
EPPS: (profit/conversions)
Show ERPM column: effective revenue per thousand impressions (e.g. 1,000,000 imps -> 1,000 clicks -> 10 sales @ $100/sale => 10*$100 / 1,000,000 per imp)
Show ERPC column: effective revenue per click
Show ERPS column: effective revenue per sale
Show EIPM column: effective income per thousand impressions (subtracting costs, like technology costs and generating net amounts)
Show EIPC column: effective income per click
Show EIPS column: effective income per sale
Show ECPM column: effective cost-per-thousand impressions (e.g. 1,000,000 imps -> 1,000 clicks -> 10 sales. Cost per imp = 0.01c : 0.01*1,000 = 10c)
Show ECPC column: effective cost-per-click
Show ECPS column: effective cost-per-sale
EPPM: effective profit per thousand
EPPC: effective profit per click
EPPS: effective profit per sale

RSS
Twitter
Facebook
FriendFeed