NAVIGA-AD Internet Orders Starter W/ GL Revenue
Type: Campaigns
Report splitting revenue into GL buckets based on GL overrides.
Report splitting revenue into GL buckets based on GL overrides.
Bundle (TGZ): NAVIGA-AD Internet Orders Starter W/ GL Revenue
Definition JSON: naviga-ad-internet-orders-starter-w-gl-revenue.json
Summary
Notes
Description
Revenue report based on the AD Internet Orders mapping. It includes a derived GL field called Real GL Code. It uses the GL Type ID and the Client Type ID on the order to lookup the GL Code(s). If there is more than one GL Code, it will find the GL Percentage and split the Net Line Local Amount fields into the appropriate percentage breakout for each GL Code returned. NOTE: If you are using the G/L Override Settings "Industry Code" or "Sales Territory" this report will not take those into account. These setting are found here https://xxx.navigahub.com/EW/xxx/ad/setup/digital_setup
Fields
| Label | Alias | Type | Hidden | Description |
|---|---|---|---|---|
| Campaign ID | campaignId | keyword_text | Campaign Identifier | |
| Line ID | id | keyword_text | Line Identifier. Campaigns will have multiple lines and lines will have multiple line details | |
| Advertiser Id | a_d_internet_campaigns_assoc_advId | keyword_text | ||
| Advertiser Name | a_d_internet_campaigns_assoc_advName | keyword_text | ||
| Ad Type ID | adTypeId | keyword_text | ||
| Month Actual Amt | monthActualAmt | double | Used to calculate the GL Net/Gross amounts. | |
| Month Est Amt | monthEstAmt | double | Used to calculate the GL Net/Gross amounts. | |
| Month Start Date | monthStartDate | date | Can be considered the Issue date for a Print publication. The starting date of the Order details record. | |
| Month End Date | monthEndDate | date | The ending date of the Order details record. | |
| Product ID | webSiteId | keyword_text | Product Identifier | |
| Product | web_site_id_assoc_webPubName | keyword_text | Product Name | |
| Print Pub Ind | web_site_id_assoc_printPubInd | keyword_text | Y = Print publication N = Digital Publication | |
| Campaign Date Entered | a_d_internet_campaigns_assoc_dateEntered | date | Date that the campaign was entered into the system. | |
| Campaign Type | a_d_internet_campaigns_assoc_campaignType | keyword_text | M = Performance Campaign F = Flexible Campaign | |
| Campaign Status Code | a_d_internet_campaigns_assoc_statusCode | keyword_text | Only these status' are included in results IS = Invoice Started CO = Confirmed R* = Reserved (can have multiple codes R1, R2, etc) | |
| Gross Line Local Amount | grossLineLocalAmount | double | Total Gross Revenue (including Agency Commission) before GL percentage application. | |
| Net Line Local Amount | netLineLocalAmount | double | Total Net Revenue (excluding Agency Commission) before GL percentage application. | |
| Real Gl Code | RealGLCode | keyword_text | GL Code this Revenue is assigned to. | |
| Campaign Desc | a_d_internet_campaigns_assoc_campaignDescConv | keyword_text | ||
| GL Type ID | glTypeId | keyword_text | ||
| Advertiser Type ID | a_d_internet_campaigns_assoc_advertiser_id_assoc_clientTypeId | keyword_text | ||
| Gl Percent | glPercent | keyword_text | If the Line detail revenue is split across GL's this designates the percent allocated to this particular GL Code. | |
| Gl Net Revenue | glNetRevenue | double | GL Revenue NOT including Agency commission. | |
| Gl Gross Revenue | glGrossRevenue | double | GL Revenue including Agency commission. | |
| Gl Match Type | GLMatchType | keyword_text | GLMatchType indicates how the GL configuration was selected: GL_TYPE_AND_CLIENT_TYPE = Both GL Type and Client Type matched. GL_TYPE_ONLY = GL Type matched and product Client Type was blank. NO_MATCH = No matching GL configuration was found. | |
| No Agy Comm Ind | noAgyCommInd | keyword_text | Used to determine if Agency commission is to be applied. | |
| Month Unique ID | monthUniqueId | keyword_text | Identifier using the Line Id with an appended .n This is the order details identifier. However be aware that it is not a record unique identifier as if the GL has a split, it will be duplicated across the splits. |