Allow Clarivoy to export your leads data for you
This is our preferred method.
Please create a VinSolutions login for Clarivoy with ADMIN level access.
- Pick a username of your choosing. Most dealers use clarivoy-clientname where clientname is your dealership name. Do not make the username the email address. You cannot use symbols like @+#$%& in the username.
Example: If your dealership name is ABC Autos, the username might be clarivoy-abcautos - 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 your dealership name is ABC Autos, the email address would be datateam+abcautos@clarivoy.com. - If you have multiple stores, please enable access to all stores under the same login.
- Enable ADMIN level access. Admin access is required for Clarivoy to create Leads Reports (Insights).
-
For each store, Enable reporting access:
- Settings
- Users
- Reporting Settings
- Search for the username you created for Clarivoy
- Next to Custom Reporting, check both "Allow Access" and "Allow Edit".
NOTE: This reporting access is required for Clarivoy to create Leads Reports (Insights).
- Please provide your CSL or Onboarding Specialist with the username and password.
Account Setup for exporting on your own
1. Click on INSIGHTS at top menu
2. Click on MY REPORTS
3. Click on 3 little dots to the far right, under the blue “Reports” bar, then click CREATE REPORT
4. Select “Leads” under the “Select Data” menu
5. Ensure each of the below boxes is checked Leads: (11 boxes total)
Dealer
Inventory Type
Lead Last Modified Date
Lead Origination Date
Lead Source
Lead Type
Make
Model
Stock Number
VIN
Year
6. Select “Add Customers to Leads” under the next “Select Data” menu
7. Ensure each of the below boxes is checked
Customers: (14 boxes total)
Address
Alt Email
Cell Phone
City
Daytime Phone
Email
Evening Phone
Fax
First Name
Last Name
Middle Name
Postal Code
State
Total Sale Price
8. Click OK at the bottom.
9. At the top, click FILTER
10. In the “Filter Column” dropdown, select LEAD ORIGINATION DATE
11. In the “Comparison” dropdown, select DATE RANGE
12. Next to the first “Specific Date” dropdown, enter the 1st day of the first month of backdata and the time 12:00 AM (If you were getting May and June backdata – you would enter 5/1/2019 and 12:00 AM)
13. Next to the second “Specific Date” dropdown, enter the last day of the second month of backdata and the time 11:55 PM (If you were getting May and June backdata – you would enter 6/30/2019 and 11:55 PM)
14. Click ADD
15. At very top next to “Untitled Analysis”, click on the small gear icon and rename as “Clarivoy CRM Report”. Click Save.
16. Click on the Export icon (down arrow into tray) and select “CSV”
17. Save the file somewhere you will remember. Name it with your dealership name, the words “VinSolutions CRM” and the months the data is for. Example: ABC Autos – VinSolutions CRM – Jan 2022 to Mar 2022.csv
18. If your VinSolutions login contains multiple rooftops:
Repeat this backdata download process for each rooftop.
a. Close the browser tab with the report in it.
b. Switch rooftops by clicking on the name of rooftop in upper right corner of main screen and click next desired rooftop in the “Dealer Selector” pop-up
c. The “Clarivoy CRM Report” you just created will now automatically show up under “My Reports” in each rooftop within that client’s VinSolutions login, so no need to re-create the report. Just open it and export it for each rooftop.
If you have only one rooftop, proceed directly to step 19.
19. Click on the date filter that you setup (it will be highlighted in light blue)
20. Change both “Specific Date” dropdowns to SLIDING DATE
21. Select LAST MONTH START from the first dropdown menu to the right of “Sliding Date”
22. Select LAST MONTH END from the 2nd dropdown menu to the right of “Sliding Date”
23. Click REPLACE
24. Click OK
25. Close the tab with “Clarivoy CRM Report”
26. Exit VinSolutions
27. Go to https://upload.clarivoy.com/mtsa to securely upload all files, checking the box for “CRM Leads”.
To export the data on a monthly basis moving forward, follow the below instructions.
Exporting Call Logs Monthly
- Click on INSIGHTS at top menu
- Click on REPORTS
- In the left side menu, click My Reports
- Click on “Clarivoy CRM Report”
- Click on the Export icon (down arrow into tray) and select “CSV”
- Save the file somewhere you will remember. Name it with your dealership name, the words “VinSolutions CRM” and the months the data is for.
Example: ABC Autos -VinSolutions CRM – Jan 2022 to Mar 2022.csv - If you have multiple stores:
- Close the report tab.
- In the top right corner, click on the store name to bring up the store selector.
- Select the next store.
- Repeat steps 1-7 for each additional store, exporting each store's call log.
- Go to https://upload.clarivoy.com/mtsa to securely upload all files, checking the box for "CRM Leads”