Excel Spreadsheets unless you have 2 million advertisers.
If you are new to domains and looking to buy, sell and learn about domains then you have come to the right place. DNForum is the largest domain name community on the internet and continues to grow every day. There are over 105,000 domainers on DNForum doing everything from buying domains, selling domains, learning about domains and discussing domains. Take a minute and Register.Register Today on DNForum IT'S FREE!
I have reached a point where it is hard to keep track of advertisers and when their ads expire across all of my sites. How are you keeping track of your advertisers to ensure on-time payments and links being removed when payment terms expire? Any suggestions?
All my offers are good for 12 hours unless otherwise stated.
Use quick book (accounting software) and set them up as customers where you provide services and set the billing terms: monthly, quarterly or yearly with due dates.
I am not sure if you can export the customers from Excel to quickbook!
Anyone use mysimpleads? I have used it in the past for my personal sites, but never to manage campaigns for advertisers.
With 1,000,000 advertisers and $500K per month...hire someone to write a script for you!!!
I wrote a script that automatically deleted ads when they expired and also emailed the customer to let them know it expired (which more often than not resulted in a repeat sale). This is hugely trivial. The ad details, including the expiry date and the customer's email address are in the database. A script running daily by cron picks out the ads that have expired, then deletes them (or marks them inactive...depends how you're doing it) then emails the customer.
I also had a service that was paid by PayPal subscription. If a payment isn't made or a subscription is canceled, you get a notification from the PayPal IPN (Instant Payment Notification). Again, hugely trivial to delete a record or mark as inactive.
Seriously, there is nothing to this, and with your numbers, a "no brainer".