CDK (Sales & Service)

Owned by TJ VanWert
Last updated: Oct 17, 2023
7 min read

Document status

in progress

Target release

2022 / Q1

Epic Link

Type /Jira to add Jira epics and issues

Document owner

@TJ VanWert

Lean Canvas

 

Tech Prerequisites

 

Pricing & Packaging

Legacy Dealer = N/A

Silver Package = N/A

Gold Package = Currently For L5 Clients Only

Platinum Package = Currently For L5 Clients Only

SKU

Legacy Dealer = N/A

Silver Package = N/A

Gold Package = Currently For L5 Clients Only

Platinum Package = Currently For L5 Clients Only

Additional Confluence Links

 

Quick Links

Overview

 Objective

This product allows dealers to see their sales and service transaction data as an activity type based on data from their CDK system. We capture specific fields regarding the sale or service transaction and display it within the contacts activity. This allows dealers to follow the customers progression from when they were shopping for an RV, what purchased they made, and what services they have had done since their purchase.

 

 

How Does it Work

We setup a data import sync specifically for CDK (similarly how we import unit data for the dealers inventory) but instead of unit data, we are receiving sales or service data and adding that data as a contact activity. For CDK specifically we go grab that data through an endpoint using the specific sales or service CMF number. Dealers will have to give us their CFM# and grant us a one time permission to access those endpoints. See the setup instructions for full details.

 

Technical Details

 Requirements

Requirement

User Story

Task

Notes

Requirement

User Story

Task

Notes

Create a Sold Unit activity type.

As IRV I need to be able to create an activity type called Sold Unit and display within the Contact Activity screen so that a user can sort by Sold Units

 

For Sold Unit Data

 Display a Sold Date

As IRV I need to be able to display "Sold Date" field within the iCC screen for the Sold Unit Activity details 

 

For Sold Unit Data

Connect to CDK Endpoint

As IRV I need to be able to pull the Sales/Service data from CDK system

 

For Sold Unit Data

Contact check to see if we need to create a new contact or add activity to a current contact in the dealers CP.

As IRV I need to check the contact info to see if we already have that contact in our system to add the additional sold activity or if we have to add the contact to our system and add the sold activity 

 

For Sold Unit Data

Finance/Sold Date

As IRV I need to be able to consume "FinanceDate" field from CDK Reporting file and display that date inplaces of the Created Date

 

For Sold Unit Data

Cash Purchase

As IRV I need to be able to consume Cash Purchase as a Yes or No field, Yes if "AmtFinanced" field in CDK does not display data (Then grey out the finance info that displays on the Sold Unit detail screen.), No if the "AmtFinanced" in CDK field does display data.

 

For Sold Unit Data

Finance Term

As IRV I need to be able to consume "Term" field from CDK Report file to display as the Term

 

For Sold Unit Data

Monthly Payment

As IRV I need to be able to consume "Payment" field from CDK Report file to display as the Monthly Payment

 

For Sold Unit Data

Last Payment Date

As IRV I need to be able to consume "DaysToFirst" as the first payment date which is "FinanceDate" and "Term"  field then calculate to display as the Final Payment. The last scheduled payment date on the unit.

 

For Sold Unit Data

 

 

 

 

Create a Work Order activity type.

As IRV I need to create an activity called "Work Order" when we consume service transaction data into iCC

 

For Service Unit Data

Contact check to see if we need to create a new contact or add activity to a current contact in the dealers CP.

As IRV I need to create or find a customer and add the activity to the customer in iCC

 

For Service Unit Data

Work Order Number

As IRV  I need to consume "RONO" from the file and display it as Work Order Number in the activity details, if not available then use other fields as unique ID.

 

For Service Unit Data

Service Amount

As IRV  I need to consume "TotalOwed" from the file and display it as Work Order Amount in the activity details so the dealer can see the total service work order amount. 

 

For Service Unit Data

Unit Data

As IRV I need to consume unit data (what is available in data, mfg, make, model, type) from the file and display it in the description field.

 

For Service Unit Data

VIN

As IRV I need to consume "VIN" to possible match up with unit data

 

For Service Unit Data

 User interaction and design

Activity Segment Search:

 

Sales Activity Details:

 

Service Activity Details:

 

 Open Questions

Question

Answer

Date Answered

Question

Answer

Date Answered

Are we able to display any Sales or Service data from the dealers DMS that the dealer is requesting to see in their Command Center?

No, we are limited to what we are able to display within iCC.

Are we able to exclude activity data from exporting to CRM’s?

Yes, there are exclusions available in the lead exports to not send any data regarding sales or service transaction.

 

Additional Details

 

 

 Out of Scope

  • Dealers ability to customize what data points we consume from the DMS system. Requests can be made through the suggestion intake form, but at this time we are only consuming specific data points, the dealer can utilize the product as is, but their is no customization for this product available.

 

 

 

Future Requests

Request Details

Suggestion Form Link

Date Requested

Request Details

Suggestion Form Link

Date Requested

 

 

 

 

Setup/Enable

Account Managers or Client Support Team Members you must provide a task with the following information:

  1. You need to get the CFM# for Sales and/or Service from the dealer. There is a separate number for each within their CDK system. (If the dealer does not know, they need to contact CDK to ask them)

  2. You will need to give the instructions to the dealer for them to give our feed team permission to access the data. You will need to download the PDF to send to the client. They will need to follow the instructions to give us permission to access the data. If they do not give us permission we are not able to access the data even if we have the CFM#. After the dealer has completed this step it takes around 12 hours before the data becomes available to us within CDK.

    1. Dealer Instructions:

  3. Both #1 and #2 need to be done before Feed Team can start any work.

  4. Create a Task for the T2 Support Team with the CFM# and ensure that your client has completed the permission process. If you have not ensured that is completed the Feed Team cannot set this up.

Instructions (Feeds Team)

You will need to create a new Feed Import for each Sales and Service data separately, you will need a CDK CFM# for each of those. The setup for Sales and Service data is the same as how we setup for inventory imports, we are just connecting to different endpoints within CDK via the URL/CFM#.

Sales Feed Import Transaction

  1. Details

  1. Parameters

  1. Transport

  1. BasicHttp

    1. Details

    2. Parameters

      1. @filename = dealername.json

        1. (Note - insert the proper CDK dealer name)

      2. @password = RFRnj75uBVb58AP

      3. @url = https://int.lightspeeddataservices.com/lsapi/DealDetail/76223662?$filter=FinanceDate gtdatetime'[#dt.now-7d]'

        1. (Note - change out the CFM# in the URL with the dealers CFM# you are setting up)

      4. @username = InteractRVRep

 

  1. RefetchHttp

    1. Details

    2. Parameters

      1. @password = RFRnj75uBVb58AP

      2. @url = https://int.lightspeeddataservices.com/lsapi/Customer/76223662?$top=1&$filter=CustomerId eq {0}

        1. (Note - change out the CFM# in the URL with the dealers CFM# you are setting up)

      3. @username = InteractRVRep

  1. Update XML Lead Export

    1. After setting up the data imports, you will need to make adjustments to the XML Lead Export (if dealer is sending leads to a CRM) to ensure that we do not send Sales or Service data to their CRM.

    2. Follow the XML Lead Export document to exclude Sales or Service data from being included in the lead export data.

Service Feed Import Transaction

  1. Details

 

  1. Parameters

 

  1. Transport

 

  1. BasicHttp

    1. Details

      1.  

    2. Parameters

      1. @filename = dealername.json

        1. (Note - insert the proper CDK dealer name)

      2. @password = RFRnj75uBVb58AP

      3. @url = https://int.lightspeeddataservices.com/lsapi/ServiceDet/76223662?$filter=closedate gt datetime'[#dt.now-3d]'

        1. (Note - change out the CFM# in the URL with the dealers CFM# you are setting up)

      4. @username = InteractRVRep

 

  1. RefetchHttp

    1. Details

      1.  

    2. Parameters

      1. @password = RFRnj75uBVb58AP

      2. @url = https://int.lightspeeddataservices.com/lsapi/Customer/76223662?$top=1&$filter=CustomerId eq {0}

        1. (Note - change out the CFM# in the URL with the dealers CFM# you are setting up)

      3. @username = InteractRVRep

 

  1. After setting up the data imports, you will need to make adjustments to the XML Lead Export (if dealer is sending leads to a CRM) to ensure that we do not send Sales or Service data to their CRM.

    1. Follow the XML Lead Export document to exclude Sales or Service data from being included in the lead export data.

Terminate/Disable

Account Managers or Client Support Team Members you must follow the contract before requesting the termination process of this product.

Instructions (Feed Team)

  1. If we are just pausing the feed, we can mark the feed disabled.

  2. If the dealer no longer wants to continue to receive Sales or Service data, we can delete the import sync.

 

Product Support

 

 

 

Pricing & Packaging Notes