Report Identity
Code | ODPRODREPPERADVINFOOPINQ |
|---|---|
Name | Per Advisor Op Inq (Multi Make) |
Filename | OneDealer_PerAdvisor_Perf_Opp_Inq_EN_v1.3 |
Description | Per Advisor Opportunities Inquiries |
Business Case | 30064 |
Resource Code | OD0011670 |
Parameters
| Description | Field (U_IDMS_ParamName) | Provided by UI | Values | Default Value |
|---|---|---|---|---|
| Date from | PDateFrom | YES | ||
| Date to | PDateTo | YES | ||
| List of Manufactures | PListOfMakes | YES | Makes available in the environment | |
| Opportunity Type | POpportunityTypeCode | YES |
| |
| Branches | PListOfRangeBranches | YES |
Report Layout
In this report the data are displayed per Branch and the users can navigate between the Branches from the Group Tree of the Crystal Viewer.
Report Calculation Logic
Header (green section)
| Field | Description |
|---|---|
| Report Name | Sales Report: Advisors Performance & Sales Opportunities |
| Period | Date from - Date to selected from the parameters |
| Opportunity Type | Selected "Opportunity Type" from the parameters |
| Dealership (Range) | Selected "Branches" from the parameters |
| Make | Selected "Make" from the parameters |
| Company | Description of the Company |
| Dealership | Description of the displayed Branch |
Body (red section)
Report column | U_IDMS_EventTypeCode (values) | Workflow Transition/State | Description |
|---|---|---|---|
| Sales Opp | CurrentWeekSpontaneousCustomers (and/or CurrentWeekShownUpByPhone, CurrentWeekShownUpByEmail, CurrentWeekCustomersFromService) | ** State IN → Initial Contact | |
Offers | CurrentWeekOffers | * Transition IN → Offer | |
| Test Drives | CurrentWeekTestDrive | * Transition IN → Execute Test Drive & Receive Vehicle | |
Orders | CurrentWeekOrders | * Transition IN → Sign Order | |
| Cancellations | CurrentWeekCancelations | * Transition IN → Order Cancelled | |
| Sales Opp Follow Ups | CurrentWeekFollowUpCustomers | ** State IN → Follow Up call | |
Offer Follow Ups | CurrentWeekOfferFollowUp | ** State IN → Offer Follow Up Call | |
Delivery | CurrentWeekCarDeliveries | * Transition IN → Delivery Completed | |
Inquiries Assigned | Total requests assigned by Sales Employee (for the selected manufacturer, branch and time period) * The Requests (Inquiries) created manually from the inquiry page are not addressed to a specific manufacturer, they are of general content and therefore do not take part in the report. ** The Requests (Inquiries) calculated in the column "Inquiries Assigned" are inquiries that have been converted to Leads/Opportunities and have a salesperson assigned to them. | ||
Inquiries Converted | Total amount of Inquiries by Sales Employee (for the selected manufacturer, branch and time period) converted into Leads/Opportunities. |
* Transition IN: the record that will be considered by the event, is created when the user selects the relevant transition and saves.
** State IN: the record that will be considered by the event, is created when closing the activity of the STATE, during the selection of the next activity in the STATE (transition)
Fields considered from table "@IDMS_EVNTRESULT"
- Dates: "U_IDMS_EventDate" field
- EntityType: "U_IDMS_EntityType" field with the “IDMS_Lead” value set
- Entity: "U_IDMS_EntityCode" field
- MakeCode: "U_IDMS_Prop1Code" field
- BranchCode: "U_IDMS_Prop2Code" field
- CompanyCode: "U_IDMS_Prop3Code" field
- Location: "U_IDMS_Prop5Code" field
- EventType: "U_IDMS_EventTypeCode" field
- SalesAdvisor: "U_IDMS_Prop6Code" field
Add Comment