Csv Usa No Pass Affinitiv DB - from bf - 500k + customer info - email - etc
- Thread starter
- Thread Author
- #1
This one is from the bf files. This one is from USA affinitiv database.
Download link -
these are the files inside the zip file -
Report
=====================
File: 20210119_Affinitiv Open Workshop Campaign List Request_V2.csv
Headers: BP Number,Email/Mail,Title,Academic Title,First Name,Initials,Last Name,Suffix,Company name 1,Street Address,Supplement,City,State,Zip Code,Country,Phone,Cell Phone,Email,VIN,Model Year,Model Description,Model (6-Digit),Vehicle On Order - Commission Number,Vehicle On Order - Model Description,Dealer Name,Responsible Sales Dealer,Service Advisor,New Warranty End Date,CPO Warranty End Date,Last Service Date,Campaign ID
Rows: 77901
Unique Emails: 59797
--------------------
File: BDC customers reassigned to sam 2.11.csv
Headers: CustomerID,FirstName,LastName,Salutation,Spouse,Address,City,State,Zip,Email,WorkEmail,Home_Number,Work_Number,Cell_Number,Employee
Rows: 24996
Unique Emails: 8385
--------------------
File: CUST_NXGEN_SMI_20191210_174119_007.csv
Headers: "CUST_NO","FIRST_NAME","MIDDLE_NAME","LAST_NAME","ADDR_1","ADDR_2","CITY","STATE","ZIP","HOME_PHONE","BUS_PHONE","MOBILE_PHONE","FAX","COUNTY","GENDER","SALUTATION","EMAIL_ADDR","DNC_CALL","DNC_MAIL","DNC_EMAIL","CREATE_DATE","LAST_UPDATE_DATE","SLSMAN_NAME","CUST_TYPE","LEAD_INFO","ADV_NAME","BIRTHDAY","DNC_DMA_CALL","DNC_DMA_EMAIL","DNC_DMA_MAIL","DNC_FED_CALL","DNC_FED_EMAIL","DNC_FED_MAIL","DNC_STATE_CALL","DNC_STATE_EMAIL","DNC_STATE_MAIL","OPT_OUT","BUSINESS_NAME","CUSTOMER_UUID","CUSTOMER_CHECKSUM"
Rows: 5001
Unique Emails: 4308
--------------------
File: GM-DMSLegacyOptOuts_20210419.csv
Headers: IsDmsEmail|IsNonDmsEmail|IsDmsMail|IsNonDmsMail|IsDmsVoice|IsNonDmsVoice|IsDmsSms|IsNonDmsSms|dmsid|direction|category|customeremail|customervoicephone|customertextphone|streetaddress|address2|city|stateprovince|postalcode
Rows: 165737
Unique Emails: 33485
--------------------
File: GM-DMSLegacyOptOuts_20210420.csv
Headers: IsDmsEmail|IsNonDmsEmail|IsDmsMail|IsNonDmsMail|IsDmsVoice|IsNonDmsVoice|IsDmsSms|IsNonDmsSms|dmsid|direction|category|customeremail|customervoicephone|customertextphone|streetaddress|address2|city|stateprovince|postalcode
Rows: 88293
Unique Emails: 15863
--------------------
File: SNE Customer List 2.2025.csv
Headers: RETAILER_NAME,RETAILER_CODE,VIN,FIRST_NAME,LAST_NAME,EMAIL_ADDRESS,HOME_PHONE,WORK_PHONE,MOBILE_PHONE,SERVICE_SEGMENT
Rows: 280272
Unique Emails: 252934
--------------------
File: SocialRoots Audience.csv
Headers: Subscriber,SocialCampaignId,CampaignDescription,email,email1,email2,phone,phone1,phone2,madid,fn,ln,zip,ct,st,country,dob,doby,gen,age,uid
Rows: 130791
Unique Emails: 89491
--------------------
File: sales customers reassigned to sam 2.11.csv
Headers: CustomerID,FirstName,LastName,Salutation,Spouse,Address,City,State,Zip,Email,WorkEmail,Home_Number,Work_Number,Cell_Number,Employee
Rows: 10094
Unique Emails: 6585
--------------------
Total Rows: 783085
Total Unique Emails: 470848
Download link -
these are the files inside the zip file -
Report
=====================
File: 20210119_Affinitiv Open Workshop Campaign List Request_V2.csv
Headers: BP Number,Email/Mail,Title,Academic Title,First Name,Initials,Last Name,Suffix,Company name 1,Street Address,Supplement,City,State,Zip Code,Country,Phone,Cell Phone,Email,VIN,Model Year,Model Description,Model (6-Digit),Vehicle On Order - Commission Number,Vehicle On Order - Model Description,Dealer Name,Responsible Sales Dealer,Service Advisor,New Warranty End Date,CPO Warranty End Date,Last Service Date,Campaign ID
Rows: 77901
Unique Emails: 59797
--------------------
File: BDC customers reassigned to sam 2.11.csv
Headers: CustomerID,FirstName,LastName,Salutation,Spouse,Address,City,State,Zip,Email,WorkEmail,Home_Number,Work_Number,Cell_Number,Employee
Rows: 24996
Unique Emails: 8385
--------------------
File: CUST_NXGEN_SMI_20191210_174119_007.csv
Headers: "CUST_NO","FIRST_NAME","MIDDLE_NAME","LAST_NAME","ADDR_1","ADDR_2","CITY","STATE","ZIP","HOME_PHONE","BUS_PHONE","MOBILE_PHONE","FAX","COUNTY","GENDER","SALUTATION","EMAIL_ADDR","DNC_CALL","DNC_MAIL","DNC_EMAIL","CREATE_DATE","LAST_UPDATE_DATE","SLSMAN_NAME","CUST_TYPE","LEAD_INFO","ADV_NAME","BIRTHDAY","DNC_DMA_CALL","DNC_DMA_EMAIL","DNC_DMA_MAIL","DNC_FED_CALL","DNC_FED_EMAIL","DNC_FED_MAIL","DNC_STATE_CALL","DNC_STATE_EMAIL","DNC_STATE_MAIL","OPT_OUT","BUSINESS_NAME","CUSTOMER_UUID","CUSTOMER_CHECKSUM"
Rows: 5001
Unique Emails: 4308
--------------------
File: GM-DMSLegacyOptOuts_20210419.csv
Headers: IsDmsEmail|IsNonDmsEmail|IsDmsMail|IsNonDmsMail|IsDmsVoice|IsNonDmsVoice|IsDmsSms|IsNonDmsSms|dmsid|direction|category|customeremail|customervoicephone|customertextphone|streetaddress|address2|city|stateprovince|postalcode
Rows: 165737
Unique Emails: 33485
--------------------
File: GM-DMSLegacyOptOuts_20210420.csv
Headers: IsDmsEmail|IsNonDmsEmail|IsDmsMail|IsNonDmsMail|IsDmsVoice|IsNonDmsVoice|IsDmsSms|IsNonDmsSms|dmsid|direction|category|customeremail|customervoicephone|customertextphone|streetaddress|address2|city|stateprovince|postalcode
Rows: 88293
Unique Emails: 15863
--------------------
File: SNE Customer List 2.2025.csv
Headers: RETAILER_NAME,RETAILER_CODE,VIN,FIRST_NAME,LAST_NAME,EMAIL_ADDRESS,HOME_PHONE,WORK_PHONE,MOBILE_PHONE,SERVICE_SEGMENT
Rows: 280272
Unique Emails: 252934
--------------------
File: SocialRoots Audience.csv
Headers: Subscriber,SocialCampaignId,CampaignDescription,email,email1,email2,phone,phone1,phone2,madid,fn,ln,zip,ct,st,country,dob,doby,gen,age,uid
Rows: 130791
Unique Emails: 89491
--------------------
File: sales customers reassigned to sam 2.11.csv
Headers: CustomerID,FirstName,LastName,Salutation,Spouse,Address,City,State,Zip,Email,WorkEmail,Home_Number,Work_Number,Cell_Number,Employee
Rows: 10094
Unique Emails: 6585
--------------------
Total Rows: 783085
Total Unique Emails: 470848
