Lead Tracking Spreadsheet for Tracking Online Leads
Lead Tracking Spreadsheet for Tracking Online Leads
Most of the websites I have developed over the years for my clients use contact forms to generate leads from the websites. And 99% of those contact forms simply sent an email to a specific email address and that was the end of the tracking pipeline. Some of my more savvy clients used a lead tracking spreadsheet to manage their leads, but even using a spreadsheet is quite a cumbersome and outdated process.
Instead of using a lead tracking spreadsheet for tracking online leads, I am working on a lead tracking and lead management database system for small businesses to easily manage their website inquiries without the need for blowing their budgets on a complicated CRM system or even more advanced tools like a marketing automation system. Most companies that do not already have a CRM most likely are not at the stage of needing a CRM just yet. Obviously, a full-featured CRM makes sense for large or fast-growing companies, but for the most part, a lot of small businesses just want a way to ensure their website contact forms are always working and a place to store these leads. That’s it.
A lead tracking spreadsheet is one way to track leads, but as I said above, spreadsheets most of the time are only accessible on a local computer for one specific user. So the system I am working on will consist of an online database that can be accessible from anywhere by anyone at anytime.
Verizon iPhone 4 vs HTC Incredible vs HTC Thunderbolt – Why do I have to keep entering my password on my Verizon iPhone to install free apps?
Verizon iPhone 4 vs HTC Incredible vs HTC Thunderbolt – Why do I have to keep entering my password on my Verizon iPhone to install free apps? And other questions about the iPhone from an Android user.
After dropping my HTC Droid Incredible one too many times so that the screen was cracked badly that it was essentially rendered useless, I decided to finally switch over to iPhone. I always thought I had wanted an iPhone but since I was on Verizon, that was never an option until they just released it last month. So today I took my busted HTC Incredible to the Verizon store to pick up an iPhone. Even though I’ve had the iPhone for a couple hours, there are already a few things I don’t like about the iPhone and things I miss having in the HTC Incredible.
The thing that keeps bothering me enough to write this blog post on a Friday night is that each time I try to download a free app from the App Store, I am prompted to enter in my Apple ID password. The first time I let it slide, the second time it was annoying, and the third time, it’s just getting ridiculous. Especially since the password has to be at least one uppercase letter, one number and one lowercase letter. Which on a tiny touchscreen keyboard, it gets to be frustrating switching the keys over to uppercase or to numerical characters. What is the point of requiring the password? Especially since the apps are free? I *might* understand if it required them for paid apps to prevent children racking up outrageous fees on oblivious parents, but for free apps? This is going to be a dealbreaker if I have to keep typing in the password every freaking time.
There are a few other things I already don’t like about the Apple iPhone 4 that I like in the HTC Incredible:
1. No automatic rotating keyboard? – On the HTC Incredible, I turned the phone sideways and the keyboard automatically rotated and got bigger, which made it much easier to type. The iPhone keyboard apparently doesn’t rotate? Why not?
2. When you click on Install on an app in the app store, you are taken to the home screen for some unknown reason whereas apps are downloaded in the background on the Droid. What’s the point of leaving the App Store each time you want to install an app?
3. No Google Maps?
4. No ‘Back’ button – The HTC Incredible has a physical back button at the bottom of the phone. This is helpful navigating in so many different ways. The iPhone requires you to press the random buttons at the top of the screen, which look different and are located in different spots in different apps. I understand Apple’s whole mantra is simplicity by only offering one button at the bottom of the phone, but I’d much rather have buttons that actually are useful, and the Back button is one of them.
5. Camera button – Why doesn’t the iPhone camera app allow you to use the physical button to take a picture? It would be much easier to hold the phone in one hand and push the button with your thumb, but that’s not really an option since you have to click the icon on the touchscreen. Stupid.
6. Holding the button down long enough brings up a Voice Control screen? WTF?
7. I backed up my contacts from my Droid Incredible through Verizon’s Backup Assistance app. I downloaded the iPhone Verizon app to import my contacts. However, when I opened that app, I got a prompt saying that the app could not work with WiFi so I had to exit the app, manually turn off WiFi, and then open the app again. I’m not sure if this is just an iPhone issue or what, but why the hell can’t it work with WiFi and if it can’t, why can’t it request to use the 3G network automatically? I had no problems automatically switching between WiFi and 3G on my Incredible and never encountered any apps that required me to turn one of them off.
Again, I’ve only had the iPhone 4 for a little over 6 hours now so maybe it will grow on me over the weekend. Otherwise, I still have 14 days to decide whether I like it enough to keep it or return it for a refund. Hopefully the HTC Thunderbolt will be released within the next two weeks which will make my decision to return the phone a lot easier. Otherwise, I may just swap out the iPhone for another Incredible. This time, I’ll make sure to also buy the case.
Conversion Tracking Code Script for Google Analytics & Google AdWords
Conversion Tracking Code Script for Google Analytics & Google AdWords
This is just a quick post about how and where to install your conversion tracking code or script to begin tracking conversions on your website. Believe it or not, most people do not have a clue what a conversion is and why they should be tracking them. Below are some examples of things that could be counted as conversions on your website:
- Sales of products or services generated through your website
- Leads, or inquiries generated through a contact form on your website, about your products or services in which it is up to the company to follow up and close the deal
- Website membership sign ups
- Newsletter subscription sign ups
- Phone calls generated through a specific number on your website
Other examples of “micro-conversions” that may be worth tracking:
- Downloads of a specific file such as a white paper PDF
- Views of specific pages on your website
- Amount of time spent on your site
- Clicks on any specific buttons or links to gauge interest
Most of these can be tracked with Google Analytics and Google AdWords conversion tracking codes. Below are two handy links to get started with either of these:
How Does Google Analytics Conversion Tracking compare with Google AdWords Conversion Tracking? – http://www.google.com/support/analytics/bin/answer.py?hl=en&answer=55535
Guide to Setting Up Ecommerce Conversion Tracking in Google Analytics – http://code.google.com/apis/analytics/docs/tracking/gaTrackingEcommerce.html
Google AdWords Conversion Tracking Set Up Guide – http://adwords.google.com/support/aw/bin/answer.py?hl=en&answer=115794
Outer Banks Mile Marker Map – Milepost Map OBX
Outer Banks Mile Marker Map – Milepost Map OBX. I have gone to the beaches of the Outer Banks of North Carolina for summer vacation at least ten times throughout my life, but I always seem to forget exactly everything is. Obviously, Corolla and Duck are north of the bridge, and that the mileposts or mile markers begin as you travel south. We are researching houses to book for a big family reunion this summer and were trying to figure out which location was best – houses at Milepost 10, Milepost 12, Milepost 16 or Milepost 18. I attempted to search for a mile post map of the Outer Banks on Google and surprisingly was not able to find one.
Eventually we decided on a house in South Nags Head, just beyond mile post 18. Apparently anything after Mile Post 16 or so becomes a lot more residential and less commercial. This is perfectly fine, but it would have been helpful if I could have found an OBX mile marker map somewhere just in case any of the other locations were a lot closer to the restaurants and activities that we may want to experience.
Anyways, this just goes to show how Google and other search engines still have a long ways to go. If I somehow come across an image of the map, I will post it in this entry just in case anybody else looking for it will actually be able to find it!
CRO Tools – Conversion Rate Optimization Software & Tools
CRO Tools - Conversion Rate Optimization and Landing Page Optimization are all of the rage these days. It’s no longer suffice to generate 500 visitors from SEO or PPC campaigns if those 500 visitors convert into sales or leads for the client. Conversion Rate Optimization, or CRO, is the process of setting up different A/B split and multivariate tests in order to improve the conversion rate of the traffic once they are already on your site. Here are some CRO Tools that I am aware of:
Unbounce – Landing page optimization platform
Visual Website Optimizer – Set up A/B and multivariate tests
Google Website Optimizer – Free testing platform
CrazyEgg – Visitor heatmaps
Clicktale – Record user activity with videos
Does anybody have any other Conversion Rate Optimization Tools suggestions?
Working From Home – The Challenges & Benefits
Sure, working from home has its perks, but it also is not for everyone. After I graduated college, I worked from home on my own websites for a little over a year. Then I started to go stir crazy because I pretty much did the exact same thing every day, which was sit on my couch with my laptop and update websites all day by myself. Oftentimes, I did not leave the house for several days at a time and had very limited social interaction with, you know, actual real-life human beings. So I started looking around for possible side jobs for an excuse to get out of the house. I scoured Craigslist for random gigs and seriously considered being a neighborhood dog walker for 6 dogs three times a week, but just as I was about to accept that position, I came across an opening at a local online marketing company, which was right up my alley so I jumped on it. That was all fine and dandy for the first few weeks, but then I realized that the company was gradually going out of business and bouncing my paychecks. They eventually were acquired by some other company and offered me a job to stay on board, but I declined and I am glad I did.
Since I wasn’t expecting to only be at the job for six months, I didn’t really have a back up plan in place. I had neglected the websites I had previously worked on everyday from home and as a result, they weren’t bringing in as much dough as they did when I updated them 7 days a week. So I started looking for other jobs. Just by chance, I fell into a position as a web developer for a small local web design company. This was actually my ideal job and I couldn’t have asked for anything more. While the office was in a sweet location in the heart of downtown, I eventually started to get tired of having to wake up early, take a shower, dress in clothes other than pajamas, and drive 15 minutes downtown every day. You know, like what everyone else does that has a job. So I started to work from home once a week and then go into the office the other days. I would gradually work more and more from home and then eventually I just made the switch to work entirely from home once again (except for random meetings with clients, etc.), which I have been doing for the past 10 months or so. For the most part, I prefer working from home versus working in an office.
However, there are some challenges for working from home:
1. The biggest one is that anyone who doesn’t work from home assumes that everyone who does work from home “doesn’t have a real job.” Which somehow means you should always be available to run and pick up their dry cleaning at a moment’s notice or just hang out whenever they want to hang out. Because, I mean, what else are you gonna do?
The way to solve this is by clearly explaining to them that you do have a real job with real tasks and real responsibilities. Then ask them if they would like it if you just came and visited them at their office and hung out in their cubicle for three hours. Obviously, they would say that is a ridiculous question and it is. But explaining it that way somehow gets through to them that they should acknowledge that you have a job just like everyone else, regardless of whether you work from home or in an office.
If they still don’t get it, then just don’t talk to them during business hours. Don’t answer their calls or respond to their texts and emails. Eventually they’ll get the hint.
2. Once you’ve conveyed to your friends and family that you in fact do actually have a job and that they shouldn’t ask you to babysit their twins on Tuesday for three hours while they go to the mall, the next hardest challenge is dealing with yourself. I am talking about self discipline. When you work in an office in a cube farm where there are mid-level managers constantly walking around to make sure everyone is doing what they are supposed to be doing, it is a lot easier to stay on task. When you are working from home and/or being your own boss, it is entirely up to you to get things done.
At first, you love your new found freedom. You can work in pajamas, eat anytime you want, play the radio or TV as loud as you want, keep the thermostat exactly where you want it, etc. etc. However, this excitement will eventually subside when the novelty wears off and you realize that no matter how comfortable your pajamas and your recliner are, you still have to get work done. This can be challenging because you figure, “Oh, I can do a load of laundry while I’m working from home” which may eventually turn into “multiple loads of laundry, and a quick trip to the post office and maybe catch a movie while I’m out” if you do not have really strict self discipline.
What I have found to help A LOT is to set aside a designated room or area of your house that you use ONLY as an office or for work related activities. Previously, while I was enjoying working from the couch, I could feel that my productivity was starting to slip, so I converted a small extra bedroom into my office that I only use during the workweek. This works for several reasons, two of which I will include here. First, you can keep all of your work related supplies and materials all in one place so you don’t need to worry about whether or not your wife threw out your latest invoice that was sitting on the coffee table. Second, you have a specific place that you can focus on only working and being in a work mindset, which gives you the rest of the house to enjoy and relax in. This is critical to success working from home, which I will explain more about in my next point.
3. Another challenge for work-at-homers is keeping your work and home life separate. To people who do not work from home, they actually have a physical distance separating the office from their homes. It may not sound like a big deal if you have never worked from home, but keeping the two separate is paramount to success.
Otherwise, once you start blending the two by doing something like answering work related email after business hours while you’re supposed to be watching a movie with your kids or pulling all-nighters to work on a project just because you can in the comfort of your own home, then you start getting into trouble. The biggest effect is that you will eventually be in a constant working mindset, which means you will never be able to truly relax since you are always thinking about work. Not only is that just unnecessary stress that can take its toll on your emotional and physical well-being, you are not able to enjoy the things you should be enjoying. Which means your relationships with everyone you care about may start to suffer, which can cause huge problems with your spouse and/or kids. Obviously, this is not ideal!
So the old adage still rings true – “Don’t bring your work home” especially if you work from home. 
These three points I made above are what I think are the primary challenges. If you can handle all three of those, then you should have no problem successfully working from home. Here are a few other challenges that I consider less important -
4. Exercise! – When you work from home, you can roll out of bed and walk downstairs to your home office and remain there for the rest of the day, effectively burning about a total of six calories all day. Unless you actively make a choice to do some kind of physical exercise and/or watch what you eat, it is almost certain that you will put on some pounds. The movements that non-home-workers take for granted such as walking to your car, walking down the steps in the parking deck to your office, walking around the office throughout the day, walking to and from lunch, walking back to your car at the end of the day all add up and burn calories without even realizing it. So in order to simply be on par with the rest of the normal workforce, you must actually move around. Whether its walking around the block or doing 50 pushups, you need to make sure you do some kind of physical activity every day. I recently purchased a FitBit, which has helped me keep track of the amount of, or lack thereof, physical activity needed to burn enough calories to not get really fat. Doing so is not only beneficial for not getting really obese and physical unhealthy, but it is also critical for keeping your mental health in check, which I will explain in my next point.
5. Working from home every day usually means you don’t have to leave the house unless you really need to. This means you can go days without leaving the house and if you live alone or have a spouse or roommate and you only see them whenever they are home, you can go days without ever actually seeing another human being in real life. Even if you prefer to work by yourself, like many computer geeks like myself usually do prefer, going too many days without seeing and interacting with other people can really take its toll. Believe it or not, human beings are social animals and NEED this human interaction to survive. Otherwise, you can gradually lose your ability to act normal in social situations, thus leading to anxiety and paranoia and possibly even depression, resulting in an awful downward spiral that will eventually lead to your death! Okay, just kidding, that was a little extreme, but I definitely have experienced anxiety interacting even with some of my closest friends after having not seen anyone else for several days in a row.
Now that I am married, we actually make it a point to hang out with friends or go out to dinner or play on random sports teams so it’s no longer really a problem for me. But if I was still a single bachelor living alone and working from home, I could easily see myself still going days on end without interacting with other people and probably turning into a social retard.
6. If you have a job that requires you to interact and meet with clients, then more often than not, your home office is not an option for an appropriate meeting place. Luckily, I have access to an office downtown to meet with clients whenever I need to, but for others, this may be a problem. The lack of a “real office” may also limit your ability to attract new clients since a lot of people and businesses still don’t consider working from home to be a “real job.”
Also, real offices usually have all of the resources and tools necessary for running everyday operations, such as always having enough printer paper or a fax machine. If you don’t have a fax machine in your home office, like I don’t, and your job requires you to use one often then you need to either get access to one or sign up for an online faxing service, which usually does whatever you need to do anyways. But my point is that it is up to you to make sure your home office is fully equipped for whatever you need to complete your job, otherwise you will need to go out and buy them or somehow get access to whatever you need.
Along the same lines, if you work from home and not in a “real office”, then you will have the distractions that come with the home. That means when you are on a conference call, the neighbor’s dog starts barking or the UPS guy keeps ringing the doorbell. Obviously, this is less than ideal and doesn’t exactly convey “professional” to whomever you are talking to on the phone.
—
That covers all of the main challenges and benefits of working from home that I can think of. Let me know if you have any other suggestions or comments.
WordPress SEO Plugin by Yoast vs. All in One SEO Pack Plugin
I have been using the All-in-one SEO Pack plugin for all of my WordPress websites and it has worked for the past few years just fine. Now I just came across Yoast’s WordPress SEO plugin which does so much more. I didn’t even realize what I was missing. Not only does it do everything that All-in-One SEO plugin does, but it handles a lot of advance stuff such as custom snippets, canonical tags and sitemap generation.
For the most part, Yoast’s WordPress SEO plugin has worked flawlessly. However, he is careful to note that the plugin is still in Beta so there may be some unexpected bugs that still need to be worked out. Unfortunately, I encountered one of those bugs tonight when trying to rebuild the XML sitemap. For some reason, when I try to rebuild the sitemap, it says that the sitemap was created successfully, but when I try to view the sitemap, it doesn’t exist on the server. I have a feeling this may be a memory limit issue, because it was working fine yesterday. However, I have imported a ton of old posts from my client’s old website to the new one which may be the culprit. However, I am not seeing any error messages at all so I could be wrong. Anybody have any ideas?
Call Tracking & Privacy Issues with Google Voice
I have several online marketing clients and most of them are brick and mortar businesses looking to increase traffic to their websites and ultimately generate more sales, leads, appointments, etc. The beauty of online marketing is that it’s the most trackable form of advertising since you can track where your visitors came from, how long they were on the site, what keyword they used on a search engine, and so on with web analytics tools like Google Analytics. However, what happens if the ultimate goal is to get the user to actually visit the store or place of business to complete the transaction? It’s not exactly cut and dry when it comes to tracking those users.
One of the first “next” steps of tracking offline customers is tracking phone calls generated through your website or online advertising campaigns. For example, all of the visitors that came to your website from a banner ad on another website will see a specific number, and all visitors that came from the Google AdWords campaign will see a different phone number. We can easily track that the first phone number generated 5 phone calls and the second phone number generated 25 phone calls. You can also narrow it down to having a different phone number for every keyword in the Google AdWords campaign, but I’ll keep it simple for the purpose of this post.
One of my clients is a specialty law firm who wanted to know more about exactly where the phone calls were coming from. I suggested setting up call tracking by purchasing multiple phone numbers. The person I work with asked about using Google Voice numbers, which are extremely cheap and easily tie in with other Google products like AdWords, GMail, Google Analytics, etc. However, she brought up a good point – What about Privacy concerns? And not just concerns about the fear of customers finding out their phone calls are being recorded and tracked, but what exactly is Google planning to do with the phone call data? This could be a serious problem in terms of actually violating privacy laws for businesses that deal with sensitive information like law firms and doctors offices.
It is no secret that Google provides the free services that it does in exchange for tracking usage to better target advertising to the users of the service. And for the most part, most users are willing to sacrifice a little privacy to use free products like GMail, Google Analytics, Google Docs, YouTube, etc. But for businesses like law firms, doctors offices, health insurance companies, and even government agencies, they may want to take some extra time to really consider the pros and cons of using Google’s free services, including Google Voice, especially if the risk is that they could end up violating privacy laws in their respective industries.
I have done a little research on Google Voice and privacy concerns, but I haven’t had much luck for the most part. Does anyone have any insight about using Google Voice for a law firm, or if there are any other call tracking solutions that have a better policy for managing privacy concerns?
Yahoo is Shutting Down Delicious, MyBlogLog and Other Sites
Yahoo is shutting down the popular social bookmarking website Delicious (del.icio.us) and the blog networking service MyBlogLog among other sites so they can focus on their core services, which is apparently display advertising. Yahoo has already abandoned their efforts in search and search advertising since now both the organic search results and the pay per click ads beside the SERPs are powered by Bing. They also shut down Geocities earlier this year, essentially wasting millions or billions of dollars in potential revenue since they simply shut it down and served up 404 errors.
I don’t understand why Yahoo and other companies buy popular websites only to neglect them and shut them down completely. I understand businesses need to cut their losses on unprofitable services, but I can’t be the only one who thinks paying millions of dollars for websites only to shut them down a couple years later makes absolutely zero sense at all. Why don’t they just sell them? Considering Delicious is still one of the top 300 websites in the entire world, they would be sure to find a buyer willing to pay at least SOMETHING. If they can’t find a buyer, at least redirect the old sites to relevant new sites to preserve the years of link equity and search engine rankings.
The only service Yahoo is good at anymore is Fantasy Sports. I’ve used ESPN, CBS Sportsline and SI.com for various fantasy leagues throughout the years and Yahoo is so much better than any of them. However, knowing Yahoo, they’ll neglect fantasy sports eventually and shut them down as well. Ugh.
Yahoo is dying. And my prediction is that Yahoo will either be completely out of business or acquired by another company within 2 years.
Facebook Photo Viewer Pop Up Window Sucks
It looks like Facebook updated their photo viewer interface. Now instead of easily navigating between photos in a seamless transition in the native Facebook interface, now there’s a stupid pop up shadow box modal window thing that is ugly, slow and way too cramped. What’s with the black background? The photo sizes have been resized so they are much smaller than before. I’m hoping it’s just a little buggy since it’s brand new, and I am hoping they will work out the kinks. Yeah, yeah, everyone hates any kind of change that Facebook does and then they get used to it and end up liking it more than before. However, this change is currently downright awful. Why mess with a good thing?