How do you organize your mailers you send out?

[Mr. Wright]

Hi Everyone,

I’m starting to scale up in a major way by sending out A LOT more mail to a few counties but starting to see how keeping track on the counties that I mailed can be a challenge. Currently I have a folder of the counties I have mailed with a description of the different size ranges & demographics so that I can reference when they call back. Is there a better way? How do some of the Land Ninjas combat this problem? Is there a software I should be looking at?

Any ideas would help…thanks a bunch!!!

P. Wright

Topic

[Laurie Phillips]

#25434

Hi Palini,

This is a great question. For each mailer I track:

Reference numbers
Date I pulled the data
Date the mail went out from Offers2Owners
Number of letters sent
Quantity downloaded to produce that many letters
If there’s a large gap between the two, why I had to throw away so many downloaded records
Acre range mailed
Total dollar amount of the mailer
Average offer price for the mailer
Prices per acre offered
Retail prices per acre at the time I mailed
Expiration date of the offer

I also track the mailer performance, and that plus the data above tell me more about the area in case I mail there or to an adjacent county in the future.

I store this data in Airtable, which is similar to an online worksheet with pseudo-relational database capabilities. This makes it easier to search, sort, calculate, etc.

Hope that helps.

Laurie

[Mr. Wright]

#25438

Laurie,,,Thank you SOOOOOOO much.

P. Wright

[Laurie Phillips]

#25439

You’re welcome, and good luck with your mailers!

[Reed Jacobs]

#29769

Hi Laurie! Would you be willing to share some info on your Airtable set up process? Did you do it all yourself? I’ve used it for around a year and haven’t found a system that works efficiently for me yet. Thanks!

[Laurie Phillips]

#29778

Hi Reed,

I set this up myself. I kept the number of columns to a minimum because too many fields becomes unwieldy and ultimately ignored. Over time I’ve automated the data I want as much as I can, either through grouped views with summaries/averages or with calculated fields. Calculated fields are an adventure in AirTable but they make my life much more efficient when I finally get them to work. The other thing is I hate using an app with an ugly interface so I’d never track this data in Excel. With AirTable I can create simple views for input that only have the couple of fields I need. For instance, I have a view for inputting notes. It only has the key field for that row and the notes field. Wham, I can input notes without scrolling to find it.

You can hire someone to do this for you. I have a programming background so I had a little advantage. Either way, I recommend you keep it simple to start and automate what you need over time.

Best,
Laurie

[Reed Jacobs]

#29779

Thank you so much for the detailed response! This is very helpful and confirms that it will be worthwhile to spend more time customizing Airtable automations/views to fit what I’m doing. Lots of good ideas from you, appreciate it! -Reed

[Author]

Replies