This article explains steps you can take to investigate issues with tasks that have a method of DVSFTP (DealerVault SFTP).

Investigating DV SFTP Sales Count Issues

If Sales Counts look low for any client on DV SFTP:

1. Ops - Check Looker Sales Counts Verification board
   1. Ops - If we DO have the current calendar month's data (we are showing Sales Counts for the month after the P Month we are working on), then DealerVault is receiving current data from the client and is delivering it to us.
      1. Ops - Note the issue in the conversation updates & tag the CSL. Ask the CSL to verify Sales Counts with the client.
      2. Ops - Set the task status to CSL/Dealer Stuck.
   2. Ops - If we do NOT have current calendar month's data:
      1. Ops - Take a screenshot of the Sales Counts Verification board. In an update on the Monthly Task item, paste the screenshot and tag the CSL. Let the CSL know that we are missing data after a certain date. If the account does not have a CSL, tag the CS Specialist.
      2. Ops - Set the task status to CSL/Dealer Stuck. (We are not using DealerVault Lagging Stuck yet as we do not know if it is a lagging feed at this point.)
      3. CS - As of January 2026, it is the CS Team's responsibility to investigate and open tickets for Lagging DealerVault feeds and follow up on them. Follow steps in Investigating DealerVault Lagging Feeds.

Investigating a DealerVault Data Mapping Issue

1. Ops - If needed, we can check the files we received from DealerVault
   1. The actual sales files for any client on DV SFTP can be found in Clarivoy's SFTP server under:
      dealervault/to_clarivoy/done
      The filename will start with the property ID, followed by an underscore, then the date the file was sent in YYYYMMDD format. Example: 49445_20220706_0724_SL.csv
2. You can also open a DV Ticket to request help or an investigation from DealerVault Support.

DV Data Mapping

• DealerVault's mapping from DMS fields → DealerVault files can be found in the article How We Count Sales
• DealerVault mappings (DV file columns → sales_raw) can be found here:  https://github.com/Clarivoy/data-server/blob/master/sftp_integration/helper_modules/dealervault_sales_helpers.py