Write the reason you're deleting this FAQ
We all have websites or we are in the process of setting one up. I know this because why else would you be here reading my post lol 
When setting up a website you'll want to definitely focus on your on page optimization as your getting each page up and running. If you're using a wordpress theme then you can go through all your pages one by one using the Yoast plugin to make it a bit easier on your brain. On page is definitely important, but just having on page optimization won't get your ranked for those difficult keywords unless your website goes super viral. And getting a website to go super viral is almost impossible if you think about it.
Your off page optimization is the peanut butter to your onpage jelly optimization. You can't have one without the other, it just doesn't work well. I do love my peanut butter sandwiches, but I'm not here to talk about food ;)
When you get started with your off page optimization for your new website you'll need to be careful and take it slow. You're going to be posting links, or paying someone to do it, so you can increase in the the SERPs (search engine results pages) for specific keywords in order to pull in loads of traffic. But if you go all out guns blazing right after you get finished with your on page optimization, you're not going to last long.
Start with some forum posting and have your links in the signature so that everyone can see it, even the search engines. This will get you on the radar since a lot of forums get spidered on a regular basis. You can also get active on facebook and LinkedIn to get indexed almost overnight.
After about a week of this I would suggest posting to question and answer websites to get some links. Now you won't be able to post your links right away since you'll need to build up your profile. So go around and answer questions until you level up your profile to a point where you're allowed to post hyperlinks to outside sites. For this I usually pay someone here on SeoClerks to do it for me
I tend to pay Cristian for this type of work since he does a great job at it 
After another week of this I would say to pyramid, or tier, these links in order to push even more juice through them. To do this you can buy a GSA type service on SeoClerks and get it going fairly quick. You can compile all of your posts and have the GSA campaign blast links to them.
Keep posting manually to your forums and keep up with the Q&A type sites because you'll want to build an authority over time. After a couple months you can branch out and start doing much more linking and get a bit crazy. But until then you should be playing it safe and don't push it too much.
Like this post? Follow Me 
https://www.seoclerks.com/user/Razzy
Thanks,
Razzy
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 members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| 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='19873' | 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='19873' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='19821' | 1 | SELECT * FROM seoclerks.members WHERE USERID='19821' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=19821 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=19821 | /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=19873 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=19873
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19873' 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='19873' 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=108461 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=108461
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=108481 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=108481
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=138382 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=138382
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=168008 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=168008
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='19873' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='19873' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='19873' AND status='1' AND (question like '% terms SEO brand website.%' OR question like '%terms%' OR question like '%brand%' OR question like '%website.%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='19873' AND status='1'
AND (question like '% terms SEO brand website.%' OR question like '%terms%' OR question like '%brand%' OR question like '%website.%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='16580' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='16580' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='22885' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='22885' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='25957' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='25957' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='39787' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='39787' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='12262' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='12262' 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=19873%' 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=19873%'
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='134.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='134.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='306632.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='585810.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg' | /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 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 |
Cristian
1. Keywords research
2. Competitor analysis
3. Content development
4. Implement everything on-page related, including HTTPs, sitemap, robots, search console, speed tests, Headings, custom title tags and meta description, etc.
5. Go live and let Google index everything, keep a close eye on everything until I get indexed.
Only after these 5 first steps I start developing an off-page SEO strategy and that usually starts with creating a doable strategy and depending a lot on the client's budget, but for new websites, I like to take things slow, don't really want a huge burst of backlinks followed by a huge dry period.... I usually go throw the following stages before I start any off-page SEO campaigns: 1. Keywords research 2. Competitor analysis 3. Content development 4. Implement everything on-page related, including HTTPs, sitemap, robots, search console, speed tests, Headings, custom title tags and meta description, etc. 5. Go live and let Google index everything, keep a close eye on everything until I get indexed. Only after these 5 first steps I start developing an off-page SEO strategy and that usually starts with creating a doable strategy and depending a lot on the client's budget, but for new websites, I like to take things slow, don't really want a huge burst of backlinks followed by a huge dry period....
Are you sure you want to delete this post?