System allows for entry of sales, exports to Google Sheets, allows for communication from the sales manager to sales person about each sale. Uses Bootstrap and SQL Server
Panel for sales manager to make updates and communicate about the sale back to the salesperson
Simple auditing for items looked for if they are are out of place
User editing by admin, add user to location(s), resend login info, create new user, disable users.
This is an example of my work ranking a local business site that is in a competitive market for the top 5 on key phrases that searchers are looking to find this type of business on.
Write concise ads designed to take the action you want with the goal to decrease your click rate.
It is better to have a 3% to 8% click rate from people ready to take action then spurius interest clicks from someone who might be considering taking action six months from now. You don't want information seekers you want clicks from those ready to buy.
With Google Ads I target bottom of funnel searchers that are ready to convert. Use cheaper Google Display Ads to find top-of-funnel interest seekers who might convert months or years from now. Be sure to take them to a page with a report or something they have to sign up for so you can put them into a funnel. This article is on Google Search Ads.
Set your daily budget low to start
The second you create your ad and it goes live you will find out that you made mistakes and will need to correct them. For example you might do business in one state but you just set your campaign to go live for the entire nation. Dumb things happen so set your daily budget to $20, let it run for a few hours, start fixing problems and increasing your daily budget as you have more confidence in your campaign.
Add negative keywords right now
Negative keywords will save you thousands of dollars in clicks that you would otherwise pay for people looking for other businesses.
For example if you are John's Insurance but Sam's Insurance is across the street and you run an ad with the world "Insurance" with a radius of 5 miles from your office then if a person typing in Sam's Insurance will see your ad and click on it, easily at a cost to you of $10.
for this example you want to make a negative keyword of Sam, Sams and Sam's immediately. The only way to make phrase and broad match work is to have hundreds if not thousands of negative keywords. This is the real work behind a successful Google Ad Search Campaign.
Remember that clicks on Google Ads cost anywhere from $3 to $50 each. You have to put the work in to make sure your ad doesn't match any other action then for people looking to buy.
Short list of Important Negative Keywords:
information, phone, directions, article, near, street, drive, address, alexa, number, directions, map, video, teacher, global, without, consultant, photography, transportation, design, translator, instant, market, writing, directory, advertising, payments, access, auditor, eCommerce, sample, outline, graphic, united, park, webinar, bank, planning, education, sitting, entertainment, football, manager, fault, hospital, common, deals, assistance, contract, border, compare, dental, administration, labor, carrier, people, animals, bite, agency, freight, total, practice, stats, papers, american, enterprise, terms, permit, wallet, defense, contact, against, seasonal, smart, certificate, surplus, ideas, financing, captive, staffing, customer, force, partnership, privacy, different, responsible, uhaul, transport, revenue, minority, binding, wash, adjuster, Starbucks, limited, dispute, elements, parent, suit, usaa, interactive
Exclude anywhere you don't sell
The tricky thing about Google Adwords is that it will allow someone outside of the area you are targeting to bring up your ad if it seems they have the intent to purchase in your area. If I am in Florida and I type in California General Liability Insurance my ad will show. However the company I work with have poor results from those leads, they only want leads from customers in California. To achieve this I exclude individually every state they do not operate in. The image below shows how that looks. California is not excluded, the blue areas in California are where I have bid adjustments higher or lower based upon the regions performance. Now if you were to ask Google they would tell you this is unnecessary. It has been my experience no matter what targeting I set that I get leads from outside of the area. Even if I set it to exclude anyone not in the area. By manually doing exclusions this way, there is no question to it. This just works, it is not a waste of time :) You will find differing opinions on this but in my experience of 8 years running adwords every day... better to exclude and not worry about it. You only have to do it once per campaign.
Keep working towards success
This is a screen capture of my work for last month. Add on another 10% to the conversion numbers below to account for direct calls from the website being promoted through Google Adwords. Normally in insurance you lose money in the first year and make it up over time. With my advertising, this company makes money right away because there are enough sales from the conversions. It takes time to build strong campaigns. For example I have 4,000 negative keywords. As you run your search terms report to find how people are searching for your ads you will see many opportunities to ad negative keywords. Every day try to add 20 negative keywords. Eventually your ads will show every time to searchers ready to buy and force out information searchers.
add 10% to account for direct phone calls from landing page.
1. Write an informative and informational article consisting of 1750-2500 words. Include a unique info-graphic and a You-Tube video (even if the video is not yours).
2. Inside the article link key phrases to other pages in your site (sales pages, capture pages, informational pages, etc). Also make a link out from your article (Wikipedia would be a good suggestion).
3. Post to bookmarking sites, Facebook and other sites the link to your article. Ask co-workers and friends to do the same.
4. Focus locally. It is easier to rank in a geographic area then to rank nationally.
5. Do a search that you want to rank on, then look at the suggested searches below. That is where Google will be directing people to, try to rank on several of those phrases.
5. Don't depend upon Google organic to be the only driver of business, try to have 7 different channels that are driving business. Some ideas are Google ppc, Yelp, Facebook ads, incentives for referrals, contacting other sites in your verticle for cross-promotion.
6. Quality of quantity. One good article a month is better then 10 half-baked articles.
Developed a web based DNS management system. As entries are added to the database, a wscript file runs on multiple servers updating the Windows DNS utilizing Windows command line commands to update that servers dns to match what was added (or removed) from the database. The database updates each time turning from red to green as the commands sync across the system
Expanded to show editor
Set theDoc = Server.CreateObject("ABCpdf10.Doc")
Set theDoc2 = Server.CreateObject("ABCpdf10.Doc")
theDoc.HtmlOptions.BrowserWidth = 1300
' apply a rotation transform
w = theDoc.MediaBox.Width
h = theDoc.MediaBox.Height
l = theDoc.MediaBox.Left
b = theDoc.MediaBox.Bottom
theDoc.Transform.Rotate 90, l, b
theDoc.Transform.Translate w, 0
' rotate our rectangle
theDoc.Rect.Width = h
theDoc.Rect.Height = w
'theDoc.Rect.Inset 72, 144
theDoc.HtmlOptions.UseScript = true
theDoc.HtmlOptions.AddLinks = true
theDoc.HtmlOptions.DoMarkup = true
theDoc.SetInfo 0, "CheckBgImages", "1"
theID = theDoc.AddImageURL(webPageURL)
If Not theDoc.Chainable(theID) Then Exit Do
theDoc.Page = theDoc.AddPage()
theID = theDoc.AddImageToChain(theID)
For i = 1 To theDoc.PageCount
theDoc.PageNumber = i
'theDoc.Append(theDoc2) ' can add text to the top of the document, advertising, etc
theDoc.Save(Server.MapPath("/pdfs/" & strPDFname & ".pdf"))
set thedoc = nothing
set thedoc2 = nothing
set thedata = nothing
With every incoming call, twilio sends a field callSID. Use the callSID field to go back and get the recording of the call. I run this code on the page that displays the call recordings, looping through each phone call that doesn't already have a recording url saved in the database.
private sub getRecordingFromTwilio(callSID)
baseUrl = "https://api.twilio.com/2010-04-01/Accounts/xxx/Calls/" & callSID & "/Recordings"
Set http = Server.CreateObject("MSXML2.ServerXMLHTTP")
http.open "GET", baseUrl, False, "xxxx", "xxxx"
http.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
displayReturn = http.responSetext 'Get Twilio Response
Set fn_xml = Server.CreateObject("msxml2.DOMDocument.6.0")
fn_xml.async = False
on error resume next
url = (fn_xml.selectSingleNode("//TwilioResponse/Recordings/Recording/Uri").text)
recordingDuration = (fn_xml.selectSingleNode("//TwilioResponse/Recordings/Recording/Duration").text)
recordingURL = "https://api.twilio.com" & url & ".mp3"
on error goto 0
strSQL = "update log_calls set recordingURL = '" & recordingURL & "',recordingDuration='" & recordingDuration & "' where callSID = '" & callSID & "'"
if len(recordingURL) > 10 then rs.Open strSQL, CONNECTIONSTRING, 3, 1
set fn_xml = nothing
Set http = Nothing