Report Builder > Numeric fields
- Arunima Kurup Prasad
Analytics
Item No. | Data Type | Field Name | Description | Result when Grouped by: Campaign ID | Result when Grouped by: Campaign ID, Publisher ID | Result when Grouped by: Campaign ID, Publisher ID, Campaign Payout Band ID |
1 | Campaign | Total Publisher Leads Delivered |
| This will show the total delivered leads from all publishers in the campaign | This will show the total delivered leads per lead generator in the campaign, as a separate row per lead generator | This will show the total delivered leads per publisher band per lead generator in the campaign, as a separate row per publisher band |
2 | Campaign | Campaign Percentage Allocated |
Leads required for a campaign: 100 No. of leads allocated to Publisher P2= 30 Total leads allocated = 25+30 => 55/100 Campaign Percentage Allocated is therefore 55% For uncapped campaigns, this will be shown as Uncapped | This will show the campaign allocation % as in the description. Should be consistent across group by selection. | This will show the campaign allocation % as in the description column. Should be consistent across group by selection. | This will show the campaign allocation % as in the description column. Should be consistent across group by selection. |
3 | Campaign | Publisher Percentage Allocated | This is the percentage of the total leads allocated to a publisher compared to the campaign requirements (Publisher Allocation/Campaign Requirement)*100% |
|
|
|
4 | Campaign | Valid Leads | This is the number of valid leads for the selected time period in the campaign |
|
|
|
5 | Campaign | Invalid Leads | This is the number of invalid leads for the selected time period in the campaign |
|
|
|
6 | Campaign | Caution Leads | This is the number of caution leads for the selected time period in the campaign |
|
|
|
7 | Campaign | Total Billable Leads | This is the running total of billable leads on the campaign |
|
|
|
8 | Campaign | Total Delivered Leads | This is the running total of all leads delivered for the campaign | This is the running total of all leads delivered for the campaign | This is the running total of all leads delivered for the campaign | This is the running total of all leads delivered for the campaign |
9 | Campaign | Billable Leads | This is the number of billable leads for a given time period in the campaign | This should show the number of billable leads, for a given time period, in the campaign | This should show the number of billable leads, for a given time period, per lead generator in the campaign, as a separate row for each lead generator | This should show the number of billable leads, for a given time period, per publisher band in the campaign, as a separate row for each band |
10 | Campaign | Total Valid Leads | This is the running total of all Valid leads in the campaign | This is the running total of all valid leads in the campaign | This is the running total of all valid leads in the campaign | This is the running total of all valid leads in the campaign |
11 | Campaign | Total Invalid Leads | This is the running total of all Invalid leads in the campaign | This is the running total of all invalid leads in the campaign | This is the running total of all invalid leads in the campaign | This is the running total of all invalid leads in the campaign |
12 | Campaign | Total Caution Leads | This is the running total of all Caution leads in the campaign | This is the running total of all Caution leads in the campaign | This is the running total of all Caution in the campaign | This is the running total of all Caution leads in the campaign |
13 | Campaign | Total Returned Leads | This is the the running total of leads that have been flagged as invalid with a reason of Returned | This will show the running total of returned leads in the campaign | This will show the running total of returned leads in the campaign | This will show the running total of returned leads in the campaign |
14 | Campaign | Total Replaced Leads | This is the running total of leads that have been flagged as Replaced | This is the running total of all replaced leads in the campaign | This is the running total of all replaced leads in the campaign | This is the running total of all replaced leads in the campaign |
15 | Campaign | Total Campaign Value | This is the overall value of the campaign, the calculation will be Lead Volume Required x Advertiser CPL
| This will show the overall value of the campaign as per calculation in the description | This will show the overall value of the campaign as per calculation in the description | This will show the overall value of the campaign as per calculation in the description |
16 | Campaign | Total Publisher Revenue | This is the running revenue total of the publisher revenue generated.
| This will show the overall publisher revenue calculated for the campaign | This will show publisher revenue per lead generator of the campaign, as a separate row. For N/A leads, this will be blank because they are not publisher billable | This will show publisher revenue per publisher band per publisher of the campaign, as a separate row. For N/A leads, this will be blank. For N/A leads, this will be blank because they are not publisher billable |
17 | Campaign | Percentage remaining | This is calculated as:[Total Volume - Billable (Delivered)]/ Total*100%
| This will show the percentage of leads remaining, for the entire campaign | This will show the percentage of leads remaining, for the entire campaign | This will show the percentage of leads remaining, for the entire campaign |
18 | Campaign | Total Revenue Remaining | This is calculated as: Advertiser CPL x (Total Lead Volume - Billable leads)
| This will show the total revenue remaining as calculated in the description column | This will show the total revenue remaining as calculated in the description column | This will show the total revenue remaining as calculated in the description column |
19 | Campaign | Margin Calculation | This is the margin of Number of leads x revenue amount vs number of leads x cost
| This should show the margin calculation for the entire campaign | This should show the margin calculation at a publisher level | This should show the margin calculation at a band level |
20 | Campaign | Margin % | This is the percentage of the margin calculated in line item 5 | This should show the margin percentage as in the description column | This should show the margin percentage as in the description column | This should show the margin percentage as in the description column |
21 | Campaign | Total Actual Revenue | This is the running revenue total for the campaign.
| This will show the running revenue total calculated for the entire campaign | This will show the running revenue total calculated for the entire campaign | This will show the running revenue total calculated for the entire campaign |