Cristian
Level X3
Write the reason you're deleting this FAQ
Most business owners out there need to have an online presence, and once you go online and you have a website, you eventually want to get more traffic, visits, and conversions, you want to make the most of the Internet, right?
Most clients that come to me in need of SEO " heard" that buying some "SEO" will increase their traffic coming from Google and overall conversions. They know and understand simple facts about SEO, most already use Google, and they can figure out that being in the first position is the best place to be when it comes to search results.
So, they go out seeking SEO services or SEO specialists but fail to realize what SEO is and how much time and money should be invested for them to reach their goals.
I'm not sifting the blame completely on the clients; there are plenty of bad SEO services and SEO "experts" out there.
But if you are a client and you buy/hire SEO services, here are a couple of things that you might be doing the wrong way and this may be the main reasons you aren't profiting from SEO.
1. You are asking for very specific SEO services.
I've seen this mistake plenty of times, clients that understand some SEO and figure out for themselves what it is better for their website when it comes to SEO. So, they usually go around buying highly specific SEO services like link building or on-page optimisation.
I'm not saying link building services or on-page SEO tasks are a bad thing; I'm just insinuating that these are very specific points from a much larger picture. Most of these clients fail to understand the importance of UX (User Experience) and how overall website architecture and structure impacts not only SEO but overall conversion rates.
The idea is not to focus strictly on specific parts of SEO but to move your website into the year 2018 as a whole. Keep in mind SEO plays just a part of the big story that is online marketing.
2. You don't have the budget to back you up, but you want EVERYTHING
Are you the type of client that want everything under the sun?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
[size=100]All of your points paint a picture of a person with a totally unrealistic view of the online world.
Your number 5 point is one thing that I can say I have certainly learned over the years. PATIENCE! I watched a TV commercial where a team had put up their website and they were finally online. To their surprise, the view counter clicks once, then again and again and again and all of a sudden it's a million views within like 5 minutes!! Ha ha. Yeah. [i]It doesn't quite happen that way. [/i]:D[/size]
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='25242' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='25242' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='134' | 1 | SELECT * FROM seoclerks.members WHERE USERID='134' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=134 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=134 | /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() () |
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=25242 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=25242
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='25242' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='25242' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc | /opt/clerks-staging/docroot/viewfaq.php 1245 () () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=146755 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=146755
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=177452 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=177452
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=146797 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=146797
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=146888 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=146888
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=146942 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=146942
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=146957 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=146957
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=148150 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=148150
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=164078 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=164078
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='25242' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='25242' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='25242' AND status='1' AND (question like '%Main reasons profiting SEO%' OR question like '%Main%' OR question like '%reasons%' OR question like '%profiting%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='25242' AND status='1'
AND (question like '%Main reasons profiting SEO%' OR question like '%Main%' OR question like '%reasons%' OR question like '%profiting%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='16573' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='16573' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='318' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='318' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1915' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1915' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1364' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1364' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=25242%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=25242%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='600657.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='615678.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='615678.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='596028.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='596028.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
TommyCarey
This annoys me a lot when someone contacts me and only wants specific things done for their website, but I tell them they need more, and they end up complaining. Usually, they just think I'm trying to get them to spend more money so I profit more, but that's not the case at all lol. Most of my clients pay at least $500 a month, which isn't actually a lot when it comes to SEO, but a lot of the people who contact me want to rip apart my packages/services to build their own like they know what they're doing haha
I don't mind losing clients like this, because they will likely turn into disgruntled clients later on when they get their way and nothing turns out how I thought it would.
2. You don't have the budget to back you up, but you want EVERYTHING
Again, this is VERY annoying when I get people contacting me and they want EVERYTHING, but they have $7 for a $3,000 service lol. I lay everything on the table and tell them exactly what I can do for their budget, and usually it will take longer to rank due to me having to customize everything for them, which usually means I remove some things from my normal services. I don't mind working with people that have lower budgets, but I don't like working with people that expect everything and have a lower budget lol.
3. You don't follow that advice given by the SEO specialists
Every time someone contacts me for SEO, I always tell them that they need to do proper on page optimization as well as add a ton of content to their blog and subpages in order for my off page services to show how well they can work for them. It never fails, 9/10 the client doesn't do what I told them to do and they complain about their investment not being worth it because I AM NOT DOING MY JOB lol. In reality, I'm doing everything I said I would and THEY WEREN'T FOLLOWING MY ADVICE! haha
4. You have a website that simply sucks
Good designs area always going to boost your sales, it's a proven fact
5. You are impatient
Ughhhh, so many people are impatient when it comes to SEO. They either say it doesn't work at all or they start doing it themselves, boosting the process, and actually hurting their own rankings in the process. I've had plenty of clients "Help" me with SEO after they paid me and complain when nothing is going according to the plan. They always say something along the lines of "I thought it would speed up the process and help you out!" which it never does.
6. You aren't offering content that Google deems important
I touched on this above, but it surprises me how many people think they're a competitor for top rankings of a difficult keyword when they have a website that is 2 months old and they have a total of 3,000 words of content split up between 10 blog posts
Are you sure you want to delete this post?