Report Builder Additional fields
- Barnaby Murtagh (Unlicensed)
Analytics
Fields in blue: Need to be available in Conditions tab ALSO
Fields in green: Existing fields that require renaming and migration. No development work is expected
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 (including N/A leads) in the campaign | This will show the total delivered leads per lead generator (including N/A leads) in the campaign, as a separate row per lead generator | This will show the total delivered leads per publisher band per lead generator (including N/A leads) 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% | This will show the campaign allocation % as in the description column | This will show the campaign allocation % as in the description column | This will show the campaign allocation % as in the description column |
3 | Campaign | Publisher Percentage Allocated |
| Rename | Rename | Rename |
4 | Campaign | Valid Leads |
| Rename | Rename | Rename |
5 | Campaign | Invalid Leads |
| Rename | Rename | Rename |
6 | Campaign | Caution Leads |
| Rename | Rename | Rename |
7 | Campaign | Total Billable Leads |
| Rename | Rename | Rename |
8 | Campaign | Additional reference |
| Rename | Rename | Rename |
9 | 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 |
10 | Campaign | Billable Leads |
| 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 (including N/A leads) 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 (including N/A leads) in the campaign, as a separate row for each band |
11 | Campaign | Total Valid Leads | Introduce new field | 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 |
12 | Campaign | Total Invalid Leads | Introduce new field | 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 |
13 | Campaign | Total Caution Leads | Introduce new field | 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 |
14 | Campaign | Total Returned Leads | Introduce new field | 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 |
15 | Campaign | Total Replaced Leads | Introduce new field | 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 |
16 | Campaign | Total Campaign Value |
| 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 |
17 | Campaign | Total Publisher Revenue |
| 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 |
18 | Campaign | Percentage remaining |
| 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 |
19 | Campaign | Total Revenue Remaining |
| 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 |
20 | Campaign | Margin Calculation |
| This should show the margin calculation as in the description column | This should show the margin calculation as in the description column | This should show the margin calculation as in the description column |
21 | Campaign | Margin % |
| 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 |
22 | Campaign | Time Remaining (Days) | Introduce new field | This will show the remaining time, in days, for the campaign | This will show the remaining time, in days, for the campaign | This will show the remaining time, in days, for the campaign |
23 | Campaign | First Activity Timestamp |
| Timestamp of the first lead in the campaign, that is not test | Timestamp of the first lead in the campaign, that is not test | Timestamp of the first lead in the campaign, that is not test |
24 | Campaign | Campaign Creation Date |
| This will be the campaign creation date | This will be the campaign creation date | This will be the campaign creation date |
25 | Campaign | Publisher assignment date |
| Will show the date of the first publisher assigned to the campaign. If no publisher is assigned, this will be blank | Will show the date of the publisher assignment, per publisher, as a separate row, in the campaign | Will show the date of the publisher assignment, per publisher, as a separate row, in the campaign |
26 | Campaign | Total Actual Revenue |
| 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 |
Item No. | Data Type | Field Name | Description |
|
|
|
27 | Lead | Returned Timestamp |
|
|
|
|
28 | Lead | Replaced Timestamp |
|
|
|
|
|
|
|
|
|
|
|