arifdoll
Level 3
Write the reason you're deleting this FAQ
Hello everyone, I joined seoclercks 3months ago. I don't know much about it. Can anyone please tell me how can i do paid promotion and is it worth? and if i can then can u please tell me how much will be the minimum and which one will be good for me as i don't have many services for sale. thank you
| 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='28551' | 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='28551' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='772267' | 1 | SELECT * FROM seoclerks.members WHERE USERID='772267' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=772267 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=772267 | /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=28551 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=28551
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='28551' 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='28551' 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=187156 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=187156
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=187172 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=187172
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='28551' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='28551' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='28551' AND status='1' AND (question like '%How i paid promotion? worthy ???%' OR question like '%paid%' OR question like '%promotion?%' OR question like '%worthy%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='28551' AND status='1'
AND (question like '%How i paid promotion? worthy ???%' OR question like '%paid%' OR question like '%promotion?%' OR question like '%worthy%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='8860' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='8860' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2044' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2044' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='19120' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19120' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2537' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2537' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='13558' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='13558' 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=28551%' 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=28551%'
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='772267.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='772267.png' | /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 |
TommyCarey
Paid promotion isn't too difficult to set up. All you have to do is go to the service you want to promote and choose the promotion you want to pay for.
Go here: https://www.seoclerks.com/manage_services
You'll see any of your services, active or suspended, and you can choose which you want to promote. There are two main promotion types, featured and category featured. The featured option is more expensive and is on a bidding option meaning the highest bid wins; the category feature is a static price meaning it will be the same no matter how many people buy it. The homepage featured is on a bidding system to give everyone a chance to show their services on the front page whereas the category feature is static because not as many people want to purchase it.
You can see the two options here:
You can choose to highlight your listing, which I'm not sure will increase your sales or not, but it's always an option. Bumping your sales thread will keep you at the top of your category for an undetermined amount of time, but it should help you bring in additional sales if done at the right times.
I've never done a homepage feature because it's been out of my price range for the longest time. I have heard great stories coming from those who were lucky enough to get a homepage feature. They paid for the featured spot and got sales almost immediately to their services. If you set it up just right, you can also funnel people to your other services and get a bigger ROI from your paid featured spot
As for the category featured spot, I've done that a few times for my writing services and I've seen plenty of people coming in and purchasing. I suggest testing out the category featured service first if you're not in a saturated part of the marketplace because you'll likely double or even triple your investment in the first week or two if your service is good
Hope that helps
- Tommy Hello there! Paid promotion isn't too difficult to set up. All you have to do is go to the service you want to promote and choose the promotion you want to pay for. Go here: [url=https://www.seoclerks.com/manage_services]https://www.seoclerks.com/manage_services[/url] You'll see any of your services, active or suspended, and you can choose which you want to promote. There are two main promotion types, featured and category featured. The featured option is more expensive and is on a bidding option meaning the highest bid wins; the category feature is a static price meaning it will be the same no matter how many people buy it. The homepage featured is on a bidding system to give everyone a chance to show their services on the front page whereas the category feature is static because not as many people want to purchase it. You can see the two options here: [img h=500 w=500]https://i.gyazo.com/2d9951923544570be687307961885369.png[/img] You can choose to highlight your listing, which I'm not sure will increase your sales or not, but it's always an option. Bumping your sales thread will keep you at the top of your category for an undetermined amount of time, but it should help you bring in additional sales if done at the right times. I've never done a homepage feature because it's been out of my price range for the longest time. I have heard great stories coming from those who were lucky enough to get a homepage feature. They paid for the featured spot and got sales almost immediately to their services. If you set it up just right, you can also funnel people to your other services and get a bigger ROI from your paid featured spot :D As for the category featured spot, I've done that a few times for my writing services and I've seen plenty of people coming in and purchasing. I suggest testing out the category featured service first if you're not in a saturated part of the marketplace because you'll likely double or even triple your investment in the first week or two if your service is good :) I had a service that was 3x as expensive as anyone else in my category and still made plenty of money to have a good ROI, so I know you can do it as well :) Hope that helps :) - Tommy
Are you sure you want to delete this post?