BGVARM Emails
New Loan Email
In Marketing Cloud: BGVARM-Loan-NewLoan
File Upload Requirements
Excel File Name (MUST MATCH): Loan-NewLoan.csv
Excel File REQUIRED fields:
| PersonSalesforceSubscriberKey |
| CSCEmail |
| Conversion Account Number |
| Owner First Name |
| Owner Last Name |
| Account Number |
| First Payment Date |
| Account Code |
| Delinquent Amount |
| Days Deliquent Correct |
Loan EzPay
In Marketing Cloud: BGVARM-Loan-EzPay
File Upload Requirements
Excel File Name (MUST MATCH): Loan-EzPay.csv
Excel File REQUIRED fields:
| PersonSalesforceSubscriberKey |
| CSCEmail |
| Conversion Account Number |
| Owner First Name |
| Owner Last Name |
| Account Number |
| First Payment Date |
| Account Code |
| Delinquent Amount |
| Days Deliquent Correct |
Loan Late Payment
In Marketing Cloud: BGVARM-Loan-Late-Payment
File Upload Requirements
Excel File Name (MUST MATCH): Loan-Late-Payment.csv
Excel File REQUIRED fields:
| PersonSalesforceSubscriberKey |
| CSCEmail |
| Conversion Account Number |
| Owner First Name |
| Owner Last Name |
| Account Number |
| First Payment Date |
| Account Code |
| Delinquent Amount |
| Days Deliquent Correct |
HOA Deedback
In Marketing Cloud: BGVARM-HOA-Deedback
File Upload Requirements
Excel File Name (MUST MATCH): HOA-Deedback.csv
Excel File REQUIRED fields:
| PersonSalesforceSubscriberKey |
| Contract Account Number |
| OwnerEmail1 |
| Owner First Name |
| Owner Last Name |
| Contract Number |
| Last Payment Date |
| Account Code |
| Delinquent Amount |
| Days Delinquent |
HOA Blackwell
In Marketing Cloud: BGVARM-HOA-Blackwell
File Upload Requirements
Excel File Name (MUST MATCH): HOA-Blackwell.csv
Excel File REQUIRED fields:
| PersonSalesforceSubscriberKey |
| Contract Account Number |
| OwnerEmail1 |
| Owner First Name |
| Owner Last Name |
| Contract Number |
| Last Payment Date |
| Account Code |
| Delinquent Amount |
| Days Delinquent |
HOA Monthly Reminder
In Marketing Cloud: BGVARM-HOA-Monthly-Reminder
File Upload Requirements
Excel File Name (MUST MATCH): HOA-Monthly-Reminder.csv
Excel File REQUIRED fields:
| PersonSalesforceSubscriberKey |
| Contract Account Number |
| OwnerEmail1 |
| Owner First Name |
| Owner Last Name |
| Contract Number |
| Last Payment Date |
| Account Code |
| Delinquent Amount |
| Days Delinquent |
HOA Payment Plan Removal
In Marketing Cloud: BGVARM-HOA-Payment-Plan-Removal
File Upload Requirements
Excel File Name (MUST MATCH): HOA-Payment-Plan-Removal.csv
Excel File REQUIRED fields:
| PersonSalesforceSubscriberKey |
| Contract Account Number |
| OwnerEmail1 |
| Owner First Name |
| Owner Last Name |
| Contract Number |
| Last Payment Date |
| Account Code |
| Delinquent Amount |
| Days Delinquent |
HOA FAQs
In Marketing Cloud: BGVARM-HOA-FAQs
File Upload Requirements
Excel File Name (MUST MATCH): HOA-FAQ.csv
Excel File REQUIRED fields:
| PersonSalesforceSubscriberKey |
| Contract Account Number |
| OwnerEmail1 |
| Owner First Name |
| Owner Last Name |
| Contract Number |
| Last Payment Date |
| Account Code |
| Delinquent Amount |
| Days Delinquent |
PrePlacement Arrivals with Balance
In Marketing Cloud: BGVARM-PrePlacement-AWB
File Upload Requirements
Excel File Name (MUST MATCH): HOA-PrePlacement-AWB.csv
Excel File REQUIRED fields:
| PersonSalesforceSubscriberKey |
| Contract Number |
| CSCEmail |
| Reservation Primary Guest Name |
| Person Owner Number |
| Site Name |
| HOA Account Number |
| Reservation Number |
| Reservation In Date |
| Reservation Type |
| Reservation Sub Type |
Arrivals with Balance For Rent
In Marketing Cloud: BGVARM-ArrivalsWithBalance-Rent
File Upload Requirements
Excel File Name (MUST MATCH): BGVARM-ArrivalswithBalance-Rent.csv
Excel File REQUIRED fields:
| PersonSalesforceSubscriberKey |
| Person Owner Number |
| CSCEmail |
| Site Name |
| First Name |
| Last Name |
| Reservation In Date |
| Reservation Number |













