Creating On-Demand Focus Reports in PSXLink

KB Article #4460

PSX_Availability_All.jpg


PSXLink allows you to create custom data reports to drill into specific details about your dealership's performance. These reports can be sorted or filtered to view specific details and downloaded to share within your dealership.


Available Focus Reports

Report Description
CollisionLink
Customers

The total sales quantities, sales dollars, orders, reimbursements, and conversions by customer. Click the 4460_CustomFocusReports15.jpg to view transaction level detail for a specific customer. 

TIP: Important information that you should review on a frequent basis are a shop's Last Order Date, Total Qty Requested, OE Qty Sold, Possible Conversions, and Conversions.

Parts

The total sales quantities, sales dollars, orders, reimbursements, and conversions by part number. Click the 4460_CustomFocusReports15.jpg to view transaction level detail for a specific part. 

TIP: Important information that you should review on a frequent basis are a part's Last Order Date, Qty Requested, Qty Sold, Possible Conversions, and Number of Conversions.

Salesperson

The total sales quantities, sales dollars, orders, reimbursements, and conversions by salesperson. Click the 4460_CustomFocusReports15.jpg to view transaction level detail for a specific salesperson. 

TIP: Important information that you should review on a frequent basis are a salesperson's OE Parts Sold in Dollars, Conversions in Percent, and Gross Margin.

RepairLink
Customers

The total sales quantities, sales dollars, orders, reimbursements, and conversions by customer. Click the 4460_CustomFocusReports15.jpg to view transaction level detail for a specific customer.

TIP: Important information that you should review on a frequent basis are a shop's Last Order Date, Qty Requested, and Qty Sold.

Parts

The total sales quantities, sales dollars, orders, reimbursements, and conversions by part number. Click the 4460_CustomFocusReports15.jpg to view transaction level detail for a specific part. 

TIP: Important information that you should review on a frequent basis are a part's Last Order Date, Qty Requested, and Qty Sold.

D2DLink
My Locates The number of locates, the number of locate searches performed, and the total e-commerce requests by part number.
Idle Parts A summary of idle part inventory by age (6 months or older, 9 months or older, 12 months or older, 15 months or older, and 24 months or older).
D2D Express
Referral Activity Summarizes (by day) the number of D2D Express referrals received and what was done with them (Misses, Committed, Shipped, Canceled, or Declined). Click the 4460_CustomFocusReports15.jpg to view transaction level detail for a specific date.
MarketplaceDirect
Parts Summarizes the total sales quantity, sales dollars, dealer cost, and margni by part. Click the 4460_CustomFocusReports15.jpg to view transaction level detail for a specific part. 

Creating an On-Demand Report

To create an on-demand focus report:

  1. Choose Focus Report from the Segments drop-down menu. 
    4460_CustomFocusReports1.jpg
  2. Select a Solution from the drop-down. (Only OEC solutions that you subscribe to will be available from this list.)
    4460_CustomFocusReports16.jpg
  3. Select the report you want to run from the Focus drop-down (see the table above for descriptions). Note: The Solution you selected will determine the available reports.
    4460_CustomFocusReports3.jpg
  4. If your dealership services multiple manufacturers, use the Manufacturer drop-down to select the desired option.
    4460_CustomFocusReports4.jpg
  5. Click the date range fields to select your date range from the calendar. 
    4460_CustomFocusReports5.jpg
    1. Reports using the fixed date ranges in the Date Range drop-down menu can be scheduled on a recurring basis. (Click here for more information.)
      4460_CustomFocusReports6.jpg
  6. Click Generate Report.
  7. Once a report has been generated, you can:
    1. Click a column header to sort by that information.
      4460_CustomFocusReports7.jpg
    2. Drag columns to a new location to change the display order.
      4460_CustomFocusReports8.jpg
    3. Click the 4460_CustomFocusReports9.jpg icon to filter the report by specific data.
      4460_CustomFocusReports10.jpg
    4. Use the Export option to download report data into a Microsoft Excel  or CSV file. 
      4460_CustomFocusReports11.jpg
    5. Add or remove data by clicking the Columns option.
      4460_CustomFocusReports12.jpg
      1. Simply check the items you would like to see and use the 4460_CustomFocusReports14.jpg icon to drag a column into the desired location on the report.
        4460_CustomFocusReports13.jpg

Was this article helpful?