SASOFT
Level 3
Write the reason you're deleting this FAQ
Hello Everyone:
Actually Nowadays I am very worried about boosting my services Because of Nowadays I am not getting orders So please can you people help me with choosing the best time when I boost my services I am calling who persons those experts in this issue
Thank you so much
| 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='29268' | 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='29268' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='792333' | 1 | SELECT * FROM seoclerks.members WHERE USERID='792333' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=792333 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=792333 | /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=29268 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=29268
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29268' 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='29268' 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=188593 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=188593
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=188596 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=188596
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29268' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29268' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29268' AND status='1' AND (question like '%Which time bump(Boost) service?%' OR question like '%Which%' OR question like '%time%' OR question like '%bump(Boost)%' OR question like '%service?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29268' AND status='1'
AND (question like '%Which time bump(Boost) service?%' OR question like '%Which%' OR question like '%time%' OR question like '%bump(Boost)%' OR question like '%service?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='3881' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3881' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2988' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2988' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2921' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2921' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1490' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' 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=29268%' 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=29268%'
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='792333.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='792333.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 |
TommyCarey
Boosting your services at specific times varies greatly depending on who you want to target. I like to bump my services early in the morning and around dinner time so I'm sure people will see them in the USA. I bump at 6am CST and 6pm CST so I'm sure people will see them when waking up (the early birds) and when they're getting done with dinner when they're winding down.
You can do this for any region you want, just be sure you stay on top of things. You'll also want to play around with it and see if bumping at lunchtime will be more beneficial than bumping in the early morning and late evening. People coming back from lunch tend to be more rejuvenated than someone who just got off of work, so you'll need to factor that into your bumping schedule.
You can also bump different services strategically if you've constructed your descriptions just right.
If you've read through some of my discussions and responses here, you'll know that I talk about structuring your service descriptions in a way that will increase your sales. One of the main things I like to mention is when you're writing your service description you should always link to your main services within the bottom of every service.
Example:
Service 1 links to Service 2, Service 3, and Service 4
Service 2 links to Service 1, Service 3, and Service 4
Service 3 links to Service 1, Service 2, and Service 4
Service 4 links to Service 1, Service 2, and Service 3
This way you can share traffic between all of your top services, generate some additional sales, and make sure your bumps and paid advertising is better used to build your sales
You'll want to test, double test, triple test, and then test some more to figure out the optimal time to bump your services since not many people will be able to tell you exactly when the right time to do it is. Hey SASOFT, Boosting your services at specific times varies greatly depending on who you want to target. I like to bump my services early in the morning and around dinner time so I'm sure people will see them in the USA. I bump at 6am CST and 6pm CST so I'm sure people will see them when waking up (the early birds) and when they're getting done with dinner when they're winding down. You can do this for any region you want, just be sure you stay on top of things. You'll also want to play around with it and see if bumping at lunchtime will be more beneficial than bumping in the early morning and late evening. People coming back from lunch tend to be more rejuvenated than someone who just got off of work, so you'll need to factor that into your bumping schedule. You can also bump different services strategically if you've constructed your descriptions just right. If you've read through some of my discussions and responses here, you'll know that I talk about structuring your service descriptions in a way that will increase your sales. One of the main things I like to mention is when you're writing your service description you should always link to your main services within the bottom of every service. Example: Service 1 links to Service 2, Service 3, and Service 4 Service 2 links to Service 1, Service 3, and Service 4 Service 3 links to Service 1, Service 2, and Service 4 Service 4 links to Service 1, Service 2, and Service 3 This way you can share traffic between all of your top services, generate some additional sales, and make sure your bumps and paid advertising is better used to build your sales :) You'll want to test, double test, triple test, and then test some more to figure out the optimal time to bump your services since not many people will be able to tell you exactly when the right time to do it is.
Are you sure you want to delete this post?