180: Setting Up DMS Sales Reports

Allow Clarivoy to export your leads data for you

Please create an Activix CRM account for Clarivoy so that we may create reports and export your CRM leads for use in Sales Attribution.

  1. Use this format for the email address: datateam+clientname@clarivoy.com
    Replace clientname with your dealership name (no spaces).  Make sure you include the + sign.  Example: If you dealership name is ABC Autos, the email address would be datateam+abcautos@clarivoy.com.
  2. In order to export data from 180, set the account to “General Manager" access level or higher (”General Sales Manager" access does not allow exporting).
  3. You will need to obtain the “Export Password” for the dealership (an Admin for your 180 DMS should have this) and provide it to Clarivoy.
  4. Please email us with the login information and the Export Password.

If you have any questions, please contact us.

 

Exporting Sales Data on your Own

Account Setup for Exporting Data

Note: To export data from 180, you will need:

  • “General Manager" access level or higher (”General Sales Manager" access does not allow exporting)
  • The Export Password for the dealership (an Admin for your 180 DMS should have this)

Report Setup

  1. Login
  2. In the menu at the top, click Management
  3. Click Export Data
  4. Click Retail Deal Data
  5. Add each of the required fields from the Available Fields list on the left to the Selected Fields list on the right by selecting each field then click the → button in the middle
    1. Address
    2. BOGross
    3. City
    4. Cost
    5. Email
    6. FirstName
    7. HomePhone
    8. IsWholesale
    9. LastName
    10. Make
    11. MiddleName
    12. MobilePhone
    13. Model
    14. Postal
    15. Province
    16. SoldDate
    17. VehicleGross
    18. VehicleStatus
    19. Vin
    20. WorkPhone
    21. Year
  6. Under the “Export data for:” section at the bottom, set the Delivery Date Range to the dates needed
  7. Under “Save Report as (optional)”, enter Clarivoy Sales Report
  8. Enter the Export Password
  9. Click the gray Export File button
  10. Save the file somewhere you will remember. Name it with your dealership name, the word “Sales” and the months the data is for
    Example: ABC Autos - Sales - April 2024 to Jun 2024.csv
  11. Go to upload.clarivoy.com/mtsa to securely upload the file, checking the box for “Sales”.

 

INTERNAL ONLY

180 Support

Owned by CDK - Use CDK ServiceConnect button in top right corner of 180 CRM for support.

 

Mappings for 180 Sales files

For 180 sales files, add to sales_schema_mapping_custom_headers for each individual dealer folder:

cost price
vehiclegross front_gross
bogross back_gross
 

 



Can’t find what you’re looking for?

Our award-winning customer care team is here for you.

Contact Support