Mar 02, 2020 10:32 PM
I am about to obtain my broker’s license and I would like to start marketing to a very specific niche of properties that fit this sort of criteria:
I have a list of properties in one neighborhood and the list is about 1,000 properties. I imagine this list could get up to 5,000 and that’s the maximum I’d focus marketing on. I want to use airtable so that I can keep track of all of the communications, notes, data, and be able to see the properties on a map block. I use Airtable as my personal CRM and like how i can access it through an app or through my browser.
How you best create a base to organize everything? My thought is the following:
PROPERTY TABLE
The following would be fields in no particular order:
OWNER TABLE
This would be important to see if anyone owns a bunch of properties and is interested in one property, they might be interested in selling multiple
MAILER CAMPAIGN TABLE
COMPS TABLE
I think this is how I initially would set it up. I probably am way overthinking this, but I’ve set up Airtable bases before that have been both (1) way too complex to start where you get lost, and also (2) too simple initially where I’ve had fields but then all of the existing data becomes “bare” without useful information.
What do you all think?
Also another question would be should I create another Base to organize any other contacts? Or should I create another Table that could be the following?
CONTACTS TABLE
Last question, I would like to hire an assistant or another agent to help me with this, but I don’t want them to have access to EVERYTHING. For instance, maybe I would only like this person to have access to a specific view and don’t want this person to have access to my entire database. Can anything be done about this?
Mar 03, 2020 10:27 PM
At first glance a few things pop out at me.
If you don’t have a Pro subscription yet, you would need one to handle that many records.
It looks like you want two addresses for each property and two addresses for each owner. That is a lot of fields. Consider moving all addresses to a single [addresses] table. Then link to that table. it will make it easier to tell if the property address, mailing address, and owner address are all the same.
Consider combining both contacts and owners in the same [people] table. Use fields to specify what type of contact. Link [properties] to [people] to show who owns what. This would be considered a one-to-many relationship. (One owner can have many properties.)
This sounds like a lot of data. Make sure you have a data entry method that will work. You may need to setup the base one way to accommodate the initial source for the data and then adjust the structure later to fit how you would like to use it.
If the assistant or agent you hire would need to edit any of the data, you would have to give access to all of the data in the base.