Removed Co-Buyer Disclaimer about “Helps with Matching” as we are not using it to match
3/25/2022
Charlie Gilbert
Added TV Spot Log requirements
9/13/2022
Charlie Gilbert
Added INTERNAL ONLY target_field to all
10/11/2022
Charlie Gilbert
Combined Canadian & US requirements so we only have 1 set
11/09/2023
Matt Dailey
Date Time formats added
Date/Time Formats
# Parses datetime strings and returns formatted string.
Example Input : datetime="July 22, 2017 01:25:43pm"
Example Output: “2017-07-22 13:25:43”
# timezone is an optional parameter. If included, the returned datetime string will include UTC offset.
Example Input : datetime="July 22, 2017 01:25:43pm", timezone='America/New_York'
Example Output: “2017-07-22 13:25:43 -04:00”
# to_utc will convert the datetime to UTC. Can only be used if timezone is provided.
Example Input : datetime="July 22, 2017 01:25:43pm", timezone='America/New_York', to_utc=True
Example Output: “2017-07-22 17:25:43 -00:00”
# to_epoch will convert the datetime to Unix Epoch Time. Can only be used if timezone is provided.
Example Input : datetime="July 22, 2017 17:25:43pm", timezone='America/New_York', to_utc=True
Example Output: “1500758743”
~
There are several optional parameters to control the format of the resulting string
- return_date_only
- return_time_only
- return_tz
Example Input : datetime="July 22, 2017 01:25:43pm", timezone='America/New_York',
Example Output: “2017-07-22 13:25:43 -04:00”
Example Input : datetime="July 22, 2017 01:25:43pm", timezone='America/New_York'
Example Output: “2017-07-22 13:25:43 -04:00”
Example Input : datetime="July 22, 2017 01:25:43pm", timezone='America/New_York'
Example Output: “2017-07-22 13:25:43 -04:00”
~
If provided a date with no time, the returned datetime will be set at midnight of that date.
If provided a time with no date, the returned datetime will be set at the current date at that time
Example Input : datetime="2017-05-01"
Example Output: “2017-05-01 00:00:00”
Example Input : datetime="05:25pm"
Example Output: “2017-09-01 17:25:00”
Multi-Touch Sales Attribution
Sales Records
Field Name
Field Description
Required?
INTERNAL ONLY target_field
Dealership Name
Name of Dealership
Only required if multiple rooftops are combined in one file
*property
Sales Date
Accounting date of sale
YES
sales_date
First Name
First name of vehicle buyer
YES
first_name
Middle Name
Middle name of vehicle buyer
NO
middle_name
Last Name
Last name of vehicle buyer
YES
last_name
Suffix
Suffix of vehicle buyer
NO
suffix
Street 1
Street address of buyer
YES
street_address_1
Street 2
Apt, Suite, etc. of buyer
NO
street_address_1
City
City of buyer
YES
city
State or Province
State of buyer (or Province for Canada)
YES
state
Zip or Postal Code
Zip code of buyer (or Postal Code for Canada)
YES
zip_code
Phone 1
Example: Home phone number of buyer
YES*
phone_number
Phone 2
Example: Mobile phone number of buyer
YES*
phone_number
Phone 3
Example: Work phone number of buyer
YES*
phone_number
Email 1
Primary email of buyer
YES*
email
Email 2
Secondary email of buyer
YES*
email
New or Used
Vehicle purchased new or used
YES
new_or_used
Sale Type
Description of sale type (retail, wholesale, fleet, transfer, etc)
YES
sale_type
Year
Year of the vehicle purchased
YES
vehicle_year
Make
Make of the vehicle purchased
YES
vehicle_make
Model
Model of the vehicle purchased
YES
vehicle_model
VIN
Vehicle identification number
YES
vin
Front Gross
Sales price of the vehicle less the cost of the vehicle
YES✝
front_gross
Back Gross
Profits made in F&I on warranty and other insurance sales
YES✝
back_gross
Total Gross
Front Gross + Back Gross
YES✝
total_gross SEE NOTE
Price
Sale price of vehicle
YES✝
price (✝ = not absolutely required)
* At least one phone number or one email is required but please provide all that are available for best results
✝ Front Gross, Back Gross and Price are required to see ROI.
If one of the Gross values is missing (Front, Back, Total), it will be calculated. See Price or Gross Issues section of the SA+TVA Ops Overview Monthly Processing process doc for explanation on how values are calculated.
CRM Leads Files
Field Name
Field Description
Required?
INTERNAL ONLY target_field
Dealership Name
Name of Dealership
Only required if multiple rooftops are combined in one file
*property
Date
Date of lead origination
YES
*date OR start_time
Lead Source
Specific vendor/marketing source associated with the lead (e.g. AutoTrader, CarFAX, etc.)
YES*
raw_source
Lead Source Detail
More detailed source for the lead (e.g. AutoTrader Phone Lead, Edmunds Chat, etc.)
Highly Recommended
raw_source_detail
Lead Type
A broad description of the Lead Source category (e.g. Phone, Web, Walk In)
NO
raw_lead_type
Full Name
Full Name of prospect
YES
full_name OR (if separate columns for name parts) first_name middle_name last_name
Street
Street address of prospect
YES
street_address_1 AND (if addtl address fields) street_address_2
City
City of prospect
YES
city
State or Province
State of prospect (or Province for Canada)
YES
state
Zip or Postal Code
Zip code of prospect (or Postal Code for Canada)
YES
zip_code
Phone - Home
Home phone number of prospect
YES**
phone_number
Phone - Mobile
Mobile phone number of prospect
YES**
phone_number
Phone - Work
Work phone number of prospect
YES**
phone_number
Email 1
Email of prospect
YES**
email
Email 2
Email of prospect
YES**
email
** At least one phone number OR one email is required but please provide all that are available for best results
Call Tracking Logs
Field Name
Field Description
Required?
INTERNAL ONLY target_field
Dealership Name
Name of Dealership
Only required if multiple rooftops are combined in one file
*property
Date
Date of phone call
YES
*date OR start_time
Phone Number Dialed
Marketing phone number dialed by prospect
YES✝
campaign_phone_number
Campaign/ Source
Name of campaign or marketing source associated with number dialed
YES✝
campaign_name
AND/OR raw_source
Caller Phone Number
Phone number of prospect
YES
phone_number
Full Name
Full name of prospect
NO*
full_name OR (if separate columns for name parts) first_name middle_name last_name
Street
Street address of prospect
NO*
street_address_1 AND (if addtl address fields) street_address_2
City
City of prospect
NO*
city
State or Province
State of prospect (or Province for Canada)
NO*
state
Zip or Postal Code
Zip code of prospect (or Postal Code for Canada)
NO*
zip_code
Email
Email of prospect
NO*
email
✝ Either Phone Number Dialed or Campaign/Source are required, but for best results please provide both
* Not required but any additional personal information (names, addresses, & emails) will help with matching
** Any data that cannot be mapped accurately to a specific rooftop will be loaded to the parent property
Web Chat Logs
Field Name
Field Description
Required?
INTERNAL ONLY target_field
Dealer Name
Name of Car Dealership
YES if file contains more than one dealership
*property
Date
Date of chat
YES
*date OR start_time
Phone Number
Phone number of prospect
YES✝
phone_number
Email
Email of prospect
YES✝
email
Full Name
Full name of prospect
NO*
full_name OR (if separate columns for name parts) first_name middle_name last_name
Street
Street address of prospect
NO*
street_address_1 AND (if addtl address fields) street_address_2
City
City of prospect
NO*
city
State or Province
State of prospect (or Province for Canada)
NO*
state
Zip or Postal Code
Zip code of prospect (or Postal Code for Canada)
NO*
zip_code
✝ Either Phone Number or Email Address are required, but for best results please provide both
* Not required but any additional personal information (name, address) will help with matching
Email Opens/Clicks Lists
Field Name
Field Description
Required?
INTERNAL ONLY target_field
Dealer Name
Name of Car Dealership
YES if file contains more than one dealership
*property
Date
Date of event (open or click)
YES
*date OR start_time
Email
Email of recipient
YES
email
Campaign
Name of campaign associated with email
YES
campaign_name
Full Name
Full name of recipient
NO*
full_name OR (if separate columns for name parts) first_name middle_name last_name
Phone Number
Phone number of recipient
NO*
phone_number
Street
Street address of recipient
NO*
street_address_1 AND (if addtl address fields) street_address_2
City
City of recipient
NO*
city
State or Province
State of recipient (or Province for Canada)
NO*
state
Zip or Postal Code
Zip code of recipient (or Postal Code for Canada)
NO*
zip_code
* Not required but any additional personal information (names, addresses, & phone numbers) will help with matching
Direct Mail Manifests
Field Name
Field Description
Required?
INTERNAL ONLY target_field
Dealer Name
Name of Car Dealership
YES if file contains more than one dealership
*property
Date
Date mailer was sent
YES
*date OR start_time
Campaign
Name of campaign associated with the direct mail piece
YES
campaign_name
Full Name
Full name of recipient
YES
full_name OR (if separate columns for name parts) first_name middle_name last_name
Street
Street address of recipient
YES
street_address_1 AND (if addtl address fields) street_address_2
City
City of recipient
YES
city
State or Province
State of recipient (or Province for Canada)
YES
state
Zip or Postal Code
Zip code of recipient (or Postal Code for Canada)
YES
zip_code
Phone Number
Phone number of recipient
NO*
phone_number
Email
Email of recipient
NO*
email
* Not required but any additional personal information (phone numbers, email addresses) will help with matching.
Text/SMS Lists
Field Name
Field Description
Required?
INTERNAL ONLY target_field
Dealer Name
Name of Car Dealership
YES if file contains more than one dealership
*property
Date
Date of interaction
YES
*date OR start_time
Campaign/ Source
Name of campaign or marketing source
YES
campaign_name
Campaign Phone Number
Phone number associated with the campaign
NO
campaign_phone_number
Phone Number
Phone number of prospect (customer)
YES
phone_number
Full Name
Full name of recipient
YES
full_name OR (if separate columns for name parts) first_name middle_name last_name
Street
Street address of recipient
YES
street_address_1 AND (if addtl address fields) street_address_2
City
City of recipient
YES
city
State or Province
State of recipient (or Province for Canada)
YES
state
Zip or Postal Code
Zip code of recipient (or Postal Code for Canada)
YES
zip_code
Email
Email of recipient
NO*
email
* Not required but any additional personal information (phone numbers, email addresses) will help with matching.
Single Source Attribution
Single Source Attribution Sales Records
Field Name
Field Description
Required?
Dealership Name
Name of Dealership
Only required if multiple rooftops are combined in one file
Sales Date
Accounting date of sale
YES
First Name
First name of vehicle buyer
YES
Middle Name
Middle name of vehicle buyer
NO
Last Name
Last name of vehicle buyer
YES
Suffix
Suffix of vehicle buyer
NO
Street 1
Street address of buyer
YES
Street 2
Apt, Suite, etc. of buyer
NO
City
City of buyer
YES
State or Province
State of buyer (or Province for Canada)
YES
Zip or Postal Code
Zip code of buyer (or Postal Code for Canada)
YES
Phone 1
Example: Home phone number of buyer
YES*
Phone 2
Example: Mobile phone number of buyer
YES*
Phone 3
Example: Work phone number of buyer
YES*
Email 1
Primary email of buyer
YES*
Email 2
Secondary email of buyer
YES*
New or Used
Vehicle purchased new or used
YES
Sale Type
Description of sale type (Example values = Retail, Wholesale, Fleet, Transfer, etc). This field should NOT indicate “Purchase” or “Lease”.
YES
Year
Year of the vehicle purchased
YES
Make
Make of the vehicle purchased
YES
Model
Model of the vehicle purchased
YES
VIN
Vehicle identification number
YES
Front Gross
Sales price of the vehicle less the cost of the vehicle
Highly Recommended
Back Gross
Profits made in F&I on warranty and other insurance sales
Highly Recommended
Total Gross
Front Gross + Back Gross
Highly Recommended
Price
Sale price of vehicle
Highly Recommended
On-Demand Attribution
ODA Sales Records - provided by vendor
Field Name
Field Description
Required?
Dealer ID
Unique ID assigned to dealership by vendor
YES^
Dealership Name
Name of Dealership
NO*
Sales Date
Accounting date of sale
YES
First Name
First name of vehicle buyer
YES
Middle Name
Middle name of vehicle buyer
NO
Last Name
Last name of vehicle buyer
YES
Suffix
Suffix of vehicle buyer
NO
Street 1
Street address of buyer
YES
Street 2
Apt, Suite, etc. of buyer
NO
City
City of buyer
YES
St
State of buyer
YES
Zip
Zip code of buyer
YES
Phone 1
Example: Home phone number of buyer
YES**
Phone 2
Example: Mobile phone number of buyer
YES**
Phone 3
Example: Work phone number of buyer
YES**
Email 1
Primary email of buyer
YES**
Email 2
Secondary email of buyer
YES**
New or Used
Vehicle purchased new or used
YES
Year
Year of the vehicle purchased
YES
Make
Make of the vehicle purchased
YES
Model
Model of the vehicle purchased
YES
VIN
Vehicle identification number
YES
^ Only required if data is being provided by the vendor to Clarivoy
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
*** Not required but any co-buyer personal info will help with matching
ODA Lead Records (phone, web form / email, chat, text) - provided by vendor
Field Name
Field Description
Required?
Lead Source
Vendor/product that lead is associated with
YES
Lead Type
Method lead was obtained (phone, web form / email, chat, text, etc.)
YES%
Lead Date
Date lead was submitted
YES
Dealer ID
Unique ID assigned to dealership by vendor
YES^
Dealership Name
Name of Dealership
NO*
First Name
First name of vehicle buyer
If Available
Middle Name
Middle name of vehicle buyer
If Available
Last Name
Last name of vehicle buyer
If Available
Suffix
Suffix of vehicle buyer
If Available
Street 1
Street address of buyer
If Available
Street 2
Apt, Suite, etc. of buyer
If Available
City
City of buyer
If Available
St
State of buyer
If Available
Zip
Zip code of buyer
If Available
Phone 1
Example: Home phone number of buyer
YES**
Phone 2
Example: Mobile phone number of buyer
YES**
Phone 3
Example: Work phone number of buyer
YES**
Email 1
Primary email of buyer
YES**
Email 2
Secondary email of buyer
YES**
% Leads can be provided as separate files for each lead type OR one combined file with a Lead Type column
^ Only required if data is being provided by the vendor to Clarivoy
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
ODA Service Records - provided by vendor
Field Name
Field Description
Required?
Dealer ID
Unique ID assigned to dealership by vendor
YES^
Dealership Name
Name of Dealership
NO*
Service Date
Date vehicle was serviced
YES
First Name
First name of customer
YES
Middle Name
Middle name of customer
NO
Last Name
Last name of customer
YES
Suffix
Suffix of customer
NO
Street 1
Street address of customer
YES
Street 2
Apt, Suite, etc. of customer
NO
City
City of customer
YES
St
State of customer
YES
Zip
Zip code of customer
YES
Phone 1
Example: Home phone number of customer
YES**
Phone 2
Example: Mobile phone number of customer
YES**
Phone 3
Example: Work phone number of customer
YES**
Email 1
Primary email of customer
YES**
Email 2
Secondary email of customer
YES**
Year
Year of the vehicle serviced
YES
Make
Make of the vehicle serviced
YES
Model
Model of the vehicle serviced
YES
VIN
Vehicle Identification Number
YES
Mileage
Odometer reading at service date
NO
^ Only required if data is being provided by the vendor to Clarivoy
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
ODA Sales Records - provided by dealer
Field Name
Field Description
Required?
Dealership Name
Name of Dealership
NO*
Sales Date
Accounting date of sale
YES
First Name
First name of vehicle buyer
YES
Middle Name
Middle name of vehicle buyer
NO
Last Name
Last name of vehicle buyer
YES
Suffix
Suffix of vehicle buyer
NO
Street 1
Street address of buyer
YES
Street 2
Apt, Suite, etc. of buyer
NO
City
City of buyer
YES
St
State of buyer
YES
Zip
Zip code of buyer
YES
Phone 1
Example: Home phone number of buyer
YES**
Phone 2
Example: Mobile phone number of buyer
YES**
Phone 3
Example: Work phone number of buyer
YES**
Email 1
Primary email of buyer
YES**
Email 2
Secondary email of buyer
YES**
New or Used
Vehicle purchased new or used
YES
Year
Year of the vehicle purchased
YES
Make
Make of the vehicle purchased
YES
Model
Model of the vehicle purchased
YES
VIN
Vehicle identification number
YES
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
*** Not required but any co-buyer personal info will help with matching
ODA Service Records - provided by dealer
Field Name
Field Description
Required?
Dealership Name
Name of Dealership
NO*
Service Date
Date vehicle was serviced
YES
First Name
First name of customer
YES
Middle Name
Middle name of customer
NO
Last Name
Last name of customer
YES
Suffix
Suffix of customer
NO
Street 1
Street address of customer
YES
Street 2
Apt, Suite, etc. of customer
NO
City
City of customer
YES
St
State of customer
YES
Zip
Zip code of customer
YES
Phone 1
Example: Home phone number of customer
YES**
Phone 2
Example: Mobile phone number of customer
YES**
Phone 3
Example: Work phone number of customer
YES**
Email 1
Primary email of customer
YES**
Email 2
Secondary email of customer
YES**
Year
Year of the vehicle serviced
YES
Make
Make of the vehicle serviced
YES
Model
Model of the vehicle serviced
YES
VIN
Vehicle Identification Number
YES
Mileage
Odometer reading at service date
NO
^ Only required if data is being provided by the vendor to Clarivoy
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
Canadian ODA Sales Records - provided by vendor
Field Name
Field Description
Required?
Dealer ID
Unique ID assigned to dealership by vendor
YES^
Dealership Name
Name of Dealership
NO*
Sales Date
Accounting date of sale
YES
First Name
First name of vehicle buyer
YES
Middle Name
Middle name of vehicle buyer
NO
Last Name
Last name of vehicle buyer
YES
Suffix
Suffix of vehicle buyer
NO
Street 1
Street address of buyer
YES
Street 2
Apt, Suite, etc. of buyer
NO
City
City of buyer
YES
Province
Province of buyer
YES
Postal Code
Postal Code of buyer
YES
Phone 1
Example: Home phone number of buyer
YES**
Phone 2
Example: Mobile phone number of buyer
YES**
Phone 3
Example: Work phone number of buyer
YES**
Email 1
Primary email of buyer
YES**
Email 2
Secondary email of buyer
YES**
New or Used
Vehicle purchased new or used
YES
Year
Year of the vehicle purchased
YES
Make
Make of the vehicle purchased
YES
Model
Model of the vehicle purchased
YES
VIN
Vehicle identification number
YES
^ Only required if data is being provided by the vendor to Clarivoy
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
*** Not required but any co-buyer personal info will help with matching
Canadian ODA Lead Records (phone, web form / email, chat, text) - provided by vendor
Field Name
Field Description
Required?
Lead Source
Vendor/product that lead is associated with
YES
Lead Type
Method lead was obtained (phone, web form / email, chat, text, etc.)
YES%
Dealer ID
Unique ID assigned to dealership by vendor
YES^
Dealership Name
Name of Dealership
NO*
First Name
First name of vehicle buyer
If Available
Middle Name
Middle name of vehicle buyer
If Available
Last Name
Last name of vehicle buyer
If Available
Suffix
Suffix of vehicle buyer
If Available
Street 1
Street address of buyer
If Available
Street 2
Apt, Suite, etc. of buyer
If Available
City
City of buyer
If Available
Province
Province of buyer
If Available
Postal Code
Postal Code of buyer
If Available
Phone 1
Example: Home phone number of buyer
YES**
Phone 2
Example: Mobile phone number of buyer
YES**
Phone 3
Example: Work phone number of buyer
YES**
Email 1
Primary email of buyer
YES**
Email 2
Secondary email of buyer
YES**
% Leads can be provided as separate files for each lead type OR one combined file with a Lead Type column
^ Only required if data is being provided by the vendor to Clarivoy
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
Canadian ODA Service Records - provided by vendor
Field Name
Field Description
Required?
Dealer ID
Unique ID assigned to dealership by vendor
YES^
Dealership Name
Name of Dealership
NO*
Service Date
Date vehicle was serviced
YES
First Name
First name of customer
YES
Middle Name
Middle name of customer
NO
Last Name
Last name of customer
YES
Suffix
Suffix of customer
NO
Street 1
Street address of customer
YES
Street 2
Apt, Suite, etc. of customer
NO
City
City of customer
YES
Province
Province of buyer
YES
Postal Code
Postal Code of buyer
YES
Phone 1
Example: Home phone number of customer
YES**
Phone 2
Example: Mobile phone number of customer
YES**
Phone 3
Example: Work phone number of customer
YES**
Email 1
Primary email of customer
YES**
Email 2
Secondary email of customer
YES**
Year
Year of the vehicle serviced
YES
Make
Make of the vehicle serviced
YES
Model
Model of the vehicle serviced
YES
VIN
Vehicle Identification Number
YES
Mileage
Odometer reading at service date
NO
^ Only required if data is being provided by the vendor to Clarivoy
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
Canadian ODA Sales Records - provided by dealer
Field Name
Field Description
Required?
Dealership Name
Name of Dealership
NO*
Sales Date
Accounting date of sale
YES
First Name
First name of vehicle buyer
YES
Middle Name
Middle name of vehicle buyer
NO
Last Name
Last name of vehicle buyer
YES
Suffix
Suffix of vehicle buyer
NO
Street 1
Street address of buyer
YES
Street 2
Apt, Suite, etc. of buyer
NO
City
City of buyer
YES
Province
Province of buyer
YES
Postal Code
Postal Code of buyer
YES
Phone 1
Example: Home phone number of buyer
YES**
Phone 2
Example: Mobile phone number of buyer
YES**
Phone 3
Example: Work phone number of buyer
YES**
Email 1
Primary email of buyer
YES**
Email 2
Secondary email of buyer
YES**
New or Used
Vehicle purchased new or used
YES
Year
Year of the vehicle purchased
YES
Make
Make of the vehicle purchased
YES
Model
Model of the vehicle purchased
YES
VIN
Vehicle identification number
YES
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
*** Not required but any co-buyer personal info will help with matching
Canadian ODA Service Records - provided by dealer
Field Name
Field Description
Required?
Dealership Name
Name of Dealership
NO*
Service Date
Date vehicle was serviced
YES
First Name
First name of customer
YES
Middle Name
Middle name of customer
NO
Last Name
Last name of customer
YES
Suffix
Suffix of customer
NO
Street 1
Street address of customer
YES
Street 2
Apt, Suite, etc. of customer
NO
City
City of customer
YES
Province
Province of buyer
YES
Postal Code
Postal Code of buyer
YES
Phone 1
Example: Home phone number of customer
YES**
Phone 2
Example: Mobile phone number of customer
YES**
Phone 3
Example: Work phone number of customer
YES**
Email 1
Primary email of customer
YES**
Email 2
Secondary email of customer
YES**
Year
Year of the vehicle serviced
YES
Make
Make of the vehicle serviced
YES
Model
Model of the vehicle serviced
YES
VIN
Vehicle Identification Number
YES
Mileage
Odometer reading at service date
NO
^ Only required if data is being provided by the vendor to Clarivoy
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
Authenticated Audiences
AA Sales Records
Please provide Sales records for the past ten (10) years.
Field Name
Field Description
Required?
Dealership Name
Name of Dealership
NO*
Sales Date
Accounting date of sale
YES
First Name
First name of vehicle buyer
YES
Middle Name
Middle name of vehicle buyer
NO
Last Name
Last name of vehicle buyer
YES
Suffix
Suffix of vehicle buyer
NO
Street 1
Street address of buyer
YES
Street 2
Apt, Suite, etc. of buyer
NO
City
City of buyer
YES
St
State of buyer
YES
Zip
Zip code of buyer
YES
Phone 1
Example: Home phone number of buyer
YES**
Phone 2
Example: Mobile phone number of buyer
YES**
Phone 3
Example: Work phone number of buyer
YES**
Email 1
Primary email of buyer
YES**
Email 2
Secondary email of buyer
YES**
New or Used
Vehicle purchased new or used
YES
Sales Type
Description of sale type (retail, wholesale, fleet, transfer, etc)
YES
Year
Year of the vehicle purchased
YES
Make
Make of the vehicle purchased
YES
Model
Model of the vehicle purchased
YES
VIN
Vehicle identification number
YES
Lease Contract End Date
Date the buyer’s lease will end
NO
Date of Birth
Buyer’s birthday
NO
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
*** Not required but any co-buyer personal info will help with matching
Historical Service Records
Please provide Service records for the past ten (10) years.
Field Name
Field Description
Required?
Dealership Name
Name of Dealership
NO*
Service Date
Date vehicle was serviced
YES
First Name
First name of customer
YES
Middle Name
Middle name of customer
NO
Last Name
Last name of customer
YES
Suffix
Suffix of customer
NO
Street 1
Street address of customer
YES
Street 2
Apt, Suite, etc. of customer
NO
City
City of customer
YES
St
State of customer
YES
Zip
Zip code of customer
YES
Phone 1
Example: Home phone number of customer
YES**
Phone 2
Example: Mobile phone number of customer
YES**
Phone 3
Example: Work phone number of customer
YES**
Email 1
Primary email of customer
YES**
Email 2
Secondary email of customer
YES**
Year
Year of the vehicle serviced
YES
Make
Make of the vehicle serviced
YES
Model
Model of the vehicle serviced
YES
VIN
Vehicle Identification Number
YES
Mileage
Odometer reading at last service date
NO
^ Only required if data is being provided by the vendor to Clarivoy
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
AA CRM Data
Please provide CRM data for the past five (5) years.
Field Name
Field Description
Required?
Lead Date
Date lead was submitted
YES
Dealership Name
Name of Dealership
NO*
First Name
First name of vehicle buyer
If Available
Middle Name
Middle name of vehicle buyer
If Available
Last Name
Last name of vehicle buyer
If Available
Suffix
Suffix of vehicle buyer
If Available
Street 1
Street address of buyer
If Available
Street 2
Apt, Suite, etc. of buyer
If Available
City
City of buyer
If Available
St
State of buyer
If Available
Zip
Zip code of buyer
If Available
Phone 1
Example: Home phone number of buyer
YES**
Phone 2
Example: Mobile phone number of buyer
YES**
Phone 3
Example: Work phone number of buyer
YES**
Email 1
Primary email of buyer
YES**
Email 2
Secondary email of buyer
YES**
% Leads can be provided as separate files for each lead type OR one combined file with a Lead Type column
^ Only required if data is being provided by the vendor to Clarivoy
* Only required if multiple rooftops are combined in one file
** At least one phone number or one email is required but please provide all that are available for best results
AA Inbound Call Tracking Data
Please provide inbound call tracking data for the past two (2) years.
Field Name
Field Description
Required?
Timestamp
Date and Time of call
YES
Dealership Name
Name of Dealership
NO*
First Name
First name of vehicle buyer
If Available
Middle Name
Middle name of vehicle buyer
If Available
Last Name
Last name of vehicle buyer
If Available
Suffix
Suffix of vehicle buyer
If Available
Phone 1
Phone number of caller
YES
* Only required if multiple rooftops are combined in one file
TV Analytics
TV Spot Logs
Field Name
Field Description
Required?
Air Date
The date a spot aired on (preferred format: MM/DD/YYYY)
YES
Air Time
The actual time a spot aired at (preferred format: HH:MM:SS AM/PM)
YES
Network/Station
The cable network or broadcast station a spot aired on
YES
Program
The program/show a spot aired during
Highly Recommended
Spot Name
The unique designation, name, or Ad-ID given to each spot
YES
Spot Length
The total length of a spot in seconds
Highly Recommended
Spot Cost
The cost of a spot
YES
Provider
The name of the cable provider
YES (only if cable)
Zone
The designation given to a specific smaller area within a DMA