For the PowerLead Marketing System

Auction insights report from Commercial Insurance Campaign.  As you can see, the impression share and position is higher then companies spending a greater amount on search ads.  Having an average position of 3 puts the ads in the top 4 above the organic search results.  Clicks result in more conversions because searchers are making an informed decision on the ad to click, looking at the top two before clicking the 3rd.  This often results in conversions of greater then 35% without having to pay a premium to be in position one.

Recent custom web based sales tracking system for a local insurance company.

Conversions for commercial insurance adwords.  Doing this for 3 years now I find the first 9 months of the year is strong and the last 3 months are good but weaker.  Click to view larger version.

Viewed weekly below:

​

Developed sales ad commission tracking system for an insurance agency.

With color svg icons instead of font awesome

​

One of my first database driven website development projects was a website builder/hosting system in 2000.  Now in 2017 it is still going strong, the company decided to upgrade the menu from a simple drop down javascript menu to a "mega menu".  What is nice about the mega menu is that you can add more descriptive help text... to cut down on your technical support. 

Menu is closed

Menu is open

Demo of drag and drop website builder in Las Vegas this year.  Just pull over blocks of structure to your page then edit.  Professional webpage in just a few minutes.

This is an amazing date range picker for bootstrap templates but it doesn't come with any sample code for posting back to your webpage, the developer assumes everyone is a javascript expert.  

Here is code to display the date range picker and post the information back the page on the querystring. 

<script type="text/javascript">
$(function() {

var start = moment().subtract(29, 'days');
var end = moment();

function cb(start, end) {
$('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
//alert("A new date range was chosen: " + start.format('YYYY-MM-DD') + ' to ' + end.format('YYYY-MM-DD'));
//window.location.href = "/activity.html?start=" + start.format('YYYY-MM-DD') + '&end=' + end.format('YYYY-MM-DD'));
}
$('#reportrange').daterangepicker({
startDate: start,
endDate: end,
ranges: {
'Today': [moment(), moment()],
'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
'Last 7 Days': [moment().subtract(6, 'days'), moment()],
'Last 30 Days': [moment().subtract(29, 'days'), moment()],
'This Month': [moment().startOf('month'), moment().endOf('month')],
'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
}
}, cb);

cb(start, end);

$('#reportrange').on('apply.daterangepicker', function (ev, picker) {
//console.log(picker.startDate.format('MM/DD/YYYY'));
//console.log(picker.endDate.format('MM/DD/YYYY'));
window.location = "activity.html?s=" + picker.startDate.format('MM/DD/YYYY') + "&e=" + picker.endDate.format('MM/DD/YYYY')
});
});
</script>

Having a fully completed Google Business Listing can result in a lot of free advertising for your business.

Steps to a Good Organic Ranking in Google

1. On your homepage make the title tag "What Your Company Does" "Where Your Company Serves 90% of it's Business" "Action Term"
Example:  Cheap Business Liability Insurance for Contractors in San Diego & Los Angeles.  Call us at 855-773-1100

2. Go to Yelp and other review and mapping sites.  Sign up for free accounts and fill out all of the information plus put in your url.

3. Make some videos (using fiverr.com), post them to YouTube and put your website link and description into the video description text area.

4. Have some articles written for you, put them on your website and make sure the urls and content include your main service.

5. If you have local friends with businesses get them to link to you as a local business.  "Visit xyz company for xyz service in 123 city".  It only takes 3 or 4 links.

This should be enough to start appearing on the first page of Google in not-too competitive industries.  Be sure to buy Adwords with "Your company name" using phrase match (the quotes around your business name with a bid of $2.50 per click.  Google will reduce the click price but this is a good starting point.

These are videos that I wrote the text for and found a designer to make them.  Having video content allows you to market on video sites and put your url in the text describing the video, which helps build links to your site.  Every website needs videos... if not on the site then on video sites.
​

9 lead form fill outs
4 Google click to call
6 Calls from tracking number after Google ad click

Average cost per click $20.73. 
Cost per lead $37.32

When does it pay to spend $37 on a lead?  The same lead sold by a vendor that deals in leads would be sold 5x times and would cost about $15 to $25 to buy.  I have bought those leads before but it was a lot of work for the agents to sell, the competition was fierce, the agents didn't enjoy the experience. 

This is the Google Adwords Partners page where they diagnose if you are eligible to remain in their program.

One feature of the lead management system that I have designed is that it allows for sales agents to find their incoming calls and convert those into leads to work through the leads funnel steps.

Every lead, including incoming phone calls are assigned to agents.  From this page you can see the leads you assigned.

All incoming web leads go into this app to be distributed to each agent.  Each phone call that comes into the company is turned into a lead and given to the agent who picked up the call and is helping the customer with a quote. This distribution system keeps a count of how many and to who the leads were given to each day so they can be equally (or inequality) distributed. 

The end result is that each time the script runs it parses the remote CSV file from the county, it double checks the "businessaccount" field to make sure that even when it runs against the same data it won't make any duplicate entries into the SQL database... the data is imported and made available to the insurance salespersons when there is a lull in organic and adwords leads.  Now that the data is in the database the salesperson can pull this data into the lead management system without typing.  

Commercial insurance adwords campaign adding in call tracking after the initial adwords click over 50% conversion rate.

41% Conversion rate.  I average monthly about a 35% conversion rate.  Today things are starting out strong with a higher then usual conversion rate.

It has been awhile, but I have not posted that a few years back for CW TV station (www.cwconnex.com) they licensed a calendar, project manager, and contact database system from me and contracted for some modifications to suit their needs.