anwebservices
Level X5
Write the reason you're deleting this FAQ
I was thinking to buy some press release service from some quality freelancer at seoclerks and i was reading that it can improve organic traffic to my website and boost SEO. If you used this kind of service before, i would like to hear from you how it affected your website and what was your experience.
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='9869' | 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='9869' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='254580' | 1 | SELECT * FROM seoclerks.members WHERE USERID='254580' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=254580 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=254580 | /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=9869 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=9869
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='9869' 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='9869' 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=38663 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=38663
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=154043 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=154043
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='9869' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='9869' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='9869' AND status='1' AND (question like '%How improve web traffic press release?%' OR question like '%improve%' OR question like '%traffic%' OR question like '%press%' OR question like '%release?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='9869' AND status='1'
AND (question like '%How improve web traffic press release?%' OR question like '%improve%' OR question like '%traffic%' OR question like '%press%' OR question like '%release?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=9869%' 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=9869%'
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 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
I would advise you purchase from them, if extremely affordable, and aim it at an article on a 3rd party website that you don't care about. Watch the rankings of that article and if you like what you see then purchase from the seller.
Some people will use less than great software to distribute your article to a few hundred press release and news type websites in hopes you get some to stick.
Another thing to look for is if the seller is writing a unique article for each release or if they are just spinning an article so it is "unique". If they are writing a unique article for every submission then ask for a writing sample. If the sample looks like it was written by a third grader then I'd be purchasing form someone else or doing the release myself since the native language of the seller probably isn't English. If they are just spinning one article so that it's "Unique" you may run into a few problems later on when you get hit by a penalty if Google dumps an algorithm update on us that targets horribly spun content.
Another thing is that now press releases don't help with SEO as much as they did 5+ years ago. Only use a press release when you're pushing a new update or you just launched your site. A press release is more of a branding play than a shot at increase search engine rankings.
Ask the seller for a list of websites they'll be submitting to. If they don't want to divulge their list it probably means they're using a free service and/or software to post to free websites that are already spammed with these type of submissions. There are a few services out there that charge $300-$500 a month to use in order to push press releases through them and they are definitely worth it if you do them daily. Not all of us need to push press releases daily so if you find someone using these services it's probably because they are professionals at this type of job. If they are using these types of services then they will more than likely give you a list of where they will be posting your articles since you probably can't do this yourself. People are willing to pay the high price for these services because they either purchase for their company and have someone posting for their business every day. Or they have a press release service that sells $50 press releases and they make a couple hundred sales a month.
So in the end:
Thanks,
Razzy Be careful when purchasing press release distributions. This can actually kill your website if you buy from the wrong person. I would advise you purchase from them, if extremely affordable, and aim it at an article on a 3rd party website that you don't care about. Watch the rankings of that article and if you like what you see then purchase from the seller. Some people will use less than great software to distribute your article to a few hundred press release and news type websites in hopes you get some to stick. Another thing to look for is if the seller is writing a unique article for each release or if they are just spinning an article so it is "unique". If they are writing a unique article for every submission then ask for a writing sample. If the sample looks like it was written by a third grader then I'd be purchasing form someone else or doing the release myself since the native language of the seller probably isn't English. If they are just spinning one article so that it's "Unique" you may run into a few problems later on when you get hit by a penalty if Google dumps an algorithm update on us that targets horribly spun content. Another thing is that now press releases don't help with SEO as much as they did 5+ years ago. Only use a press release when you're pushing a new update or you just launched your site. A press release is more of a branding play than a shot at increase search engine rankings. Ask the seller for a list of websites they'll be submitting to. If they don't want to divulge their list it probably means they're using a free service and/or software to post to free websites that are already spammed with these type of submissions. There are a few services out there that charge $300-$500 a month to use in order to push press releases through them and they are definitely worth it if you do them daily. Not all of us need to push press releases daily so if you find someone using these services it's probably because they are professionals at this type of job. If they are using these types of services then they will more than likely give you a list of where they will be posting your articles since you probably can't do this yourself. People are willing to pay the high price for these services because they either purchase for their company and have someone posting for their business every day. Or they have a press release service that sells $50 press releases and they make a couple hundred sales a month. [size=140][u][b]So in the end:[/b][/u][/size] [list][*]Check writing samples. If the samples are bad, don't buy[/*][*]Try to avoid spammy looking spun articles that aren't written well in the first place[/*][*]Avoid sellers that are scraping together articles and spinning them.[/*][*]Use a press release as a branding play and don't focus on your rankings from them.[/*][*]Ask what type of sites you'll be submitted to. If they can give you a list, even better.[/*][*]Sellers who are subscribed to the $300-$500 distribution services are best to go through. They might charge $50 or more, but they are well worth the price tag.[/*][/list] Thanks, Razzy
Are you sure you want to delete this post?