LinkBack URL
About LinkBacks
For direct mail marketing or telemarketing of homeowner's insurance, it's best to contact the customer about 45 days from the date their insurance is to renew by their current carrier.
And, the mailings or calls are most easily managed by lumping all the contacts who need to be contacted during a work week into a single category, like "December Week 1".
This list can then be given to the telemarketers or the printers for direct marketing of customers whose insurance renews in January. They'd be given the list on Monday and work it through Saturday.
By the way, for those of you who object to telemarketing, it's legal in Texas for insurance agents (or, really, any state licensee) to make telemarketing calls to numbers in Texas regardless of whether or not they're on either a Federal or State DoNotCall list. So, please, if you object to telemarketing on first principles and choose to disregard its legality in Texas so as to deride me for asking for assistance on this project, please don't respond at all.
The renewal date is known. And, there's no problem calculating which date preceeds that date by 45 days (just subtract 45 from the renewal date and render in date format).
But I can't figure out how to assign those dates to a standard 7 day Sunday to Sunday calendar week so as to label the row with a category label like "December Week 1". Furthermore, I can't find a way to deal with partial weeks, an example of which would be if the month began on a Thursday or ended on a Tuesday.
If anyone could point me in the right direction, I'd appreciate it.
LongFisher
Register To Reply
Bookmarks