This guide explains how to update your domain with Golden Addresses the verified, corrected mailing addresses used to improve direct mail accuracy and deliverability. This process includes validating, formatting, importing, and manually updating address records as needed.
What Is a Golden Address?
A Golden Address is a corrected version of the property's address that replaces inaccurate or incomplete data. Updating to golden addresses helps improve targeting, reduces mailing errors, and supports fulfillment accuracy.
Step-by-Step Instructions
1. Prepare Your File in Excel
Open the original file received
Copy the following 6 columns:
old_add
old_zip
new_add
new_city
new_state
new_zip
2. Paste into a New Sheet
Paste the 6 columns into a new, clean sheet
This new sheet will be the one used for import
3. Rename the Column Headers
Make sure your headers are exactly as follows:
Original Column | Rename to |
---|---|
old_add | Property Address |
old_zip | Property Zip |
new_add | Golden Address |
new_city | Golden City |
new_state | Golden State |
new_zip | Golden Zip |
Save the file as a .CSV
4. Import the Golden Address File
Log in to the client’s domain
Go to Properties → Import Property
Click “Import File” and upload the updated CSV
After Import: Review & Manual Update Steps
5. Go to Import History
Check the results of the upload:
“Updated” Properties: These are records where Property Address and Mailing Address match (automatically updated)
“New” Properties: These have different mailing and property addresses and must be updated manually
6. Export the Records to Be Manually Updated
In Properties, click “New” → Apply your Golden Address filter
Use the Actions menu and select Export
Choose Export Configuration → “Direct Mail - Fulfillment”
Click “Export”
You will receive an email with the download link
Open the file and identify which properties require manual updates
7. Match Records for Manual Update
Open the original file and filter to match the properties from the exported file
Copy the
old_add
value of one of the matching properties
8. Update the Property in the Domain
In the domain, go to Mailing Address
Paste the copied
old_add
and searchClick into the correct property
Return to the Excel file and copy the matching
new_add
Click the current property address field
Replace it with the Golden Address
Click Save
Repeat steps 1–7 for all matched records.
Required Information
Property Address
Zip Code
Golden Address
details (new values)
Why This Matters
Ensures accurate delivery of direct mail
Reduces waste and returned mail
Helps fulfillment vendors match validated mailing addresses
Sample File
You can download a sample import format from the Import Property page in your domain.
Need Help?
If you’re unsure how to complete this import or need assistance with manual updates:
Contact your Customer Success Manager, or
Email us at support@8020rei.com
We're here to help ensure your data is clean and your mail reaches the right audience.