EliteWriter
Level 3
Write the reason you're deleting this FAQ
An SEO campaign is not a one off plan, but rather a means to an end that needs to be evaluated as you go along so as to fix anything that may not be working as well as it should. What are the main strategic objectives that you set when starting an SEO campaign?
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='10039' | 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='10039' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='212316' | 1 | SELECT * FROM seoclerks.members WHERE USERID='212316' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=212316 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=212316 | /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=10039 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=10039
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='10039' 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='10039' 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=39298 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=39298
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=154264 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=154264
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='10039' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='10039' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='10039' AND status='1' AND (question like '% strategic objectives embarking SEO campaign?%' OR question like '%strategic%' OR question like '%objectives%' OR question like '%embarking%' OR question like '%campaign?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='10039' AND status='1'
AND (question like '% strategic objectives embarking SEO campaign?%' OR question like '%strategic%' OR question like '%objectives%' OR question like '%embarking%' OR question like '%campaign?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='19821' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='272' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='301993' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='301993' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='21811' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='21811' 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=10039%' 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=10039%'
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='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.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 |
| Avg Time | Count | SQL | Max | Min |
idealmike
Before I even start a website, the first thing I do is keyword research. Find a keyword that is high in demand, but low in competition. Sometimes I might choose high competition though because you can sometimes get lucky. But by doing keyword research I will know whether the keywords I would want to rank for are worth trying to rank for or not. It all starts with keyword research for me.
2nd. Social Media
Once I'd created my site and its all setup and live on the Internet. I would set about setting up homes and pages on all the top social media sites. Facebook, Twitter, Pinterest, Google+, YouTube etc etc. It might not be possible to populate them with content, posts, images etc straight away though as even though your site is live, it might not have many posts on it if it's a new site yet and not much content, images etc that you can share and post on those social media sites. Still, the more aged they are the better so creating them early means not having to do it later as it's already done. At first, I would create them on the top 5 social media sites. But later on, I would be creating them on many of the others as well that I think would be able to help me if there was likely to be users on those places that happened to be interested in my websites, products services etc.
3rd. Web 2.0
Like I would do with all the top social media sites, I'd start creating a bunch of Web 2.0 sites and blogs on all the top web 2 sites like Blogger, WordPress, Tumblr, LiveJournal etc etc etc. I'd probably create the site, tweak and customize it, then add some unique article to each that was an overview of my website and all that it does and link to some of its important pages/products etc. Right away right there you are creating some very sound, high quality, authority site backlinks to your new site from starters and this will help in the long run. For that, I would probably use a site like Knowem.com or Namecheckr.com to see if my keywords I'm trying to target, are available as the URL for those web 2's. But that's why sites like that were created for people like us in the first place. I actually found out about those sites from an affiliate marketer on YouTube called the "Lazy Ass Stoner". He loves to get stoned but he kills it in the SERPs both with his own affiliate sites and as a guru in that industry.
4th. Content Creation
Having a great domain name, a nice looking site, and homes on all the top social media and web 2 sites is one thing. But if you can't come up with content to post to them or your site regularly, you're likely going to struggle to get the site off the ground and into the ether! This is where brain storming comes into play. If you know about your product, service or niche then great! You'll be able to write about a lot of things regarding that niche right off the bat. And from that, you'll be able to come up with more things to write about as well. But will you be doing all that brain storming and content creation yourself? Or should you outsource that part? Or both? I prefer to do both. I write my own content that I know is about something that is high in demand. But I also outsource it as well to content writers. That way, I've always got new fresh content coming in which I can use on my site, on my social media sites and on my web 2's as well. There are some truly amazing content creation and writing services right here on SEOClerks by some very professional and talented writers for a great price too.
5th. Other SEO
Other SEO would be things like, contacting related websites and asking them if they will let you write for them (guest post). To things like, directory submission (to only good related directories). Social bookmarking or forum posting, promotion and advertising. Likewise, all of these can be purchased right here on SEOClerks. There are some very effective social bookmarking services that I often take advantage of here by different people who post to the top social bookmarking sites manually using different accounts etc that I can vouch for. And of course there are some very appealing SEO and link building services as well. But I might not use them on a new site. I like to take things slow, let the site age a bit first. Rather like a good cheese or a bottle of wine tastes better in time.
Are you sure you want to delete this post?