SEOClerks

Clear
Sign In Join

Feature Request: Sales reports daily/weekly/monthly etc

  • idealmike Level X3
    • 9

    Write the reason you're deleting this FAQ

    Feature Request: Sales reports daily/weekly/monthly etc

    Hello. I would like to suggest a feature for being able to see sales reports to see how much money you've made in sales for the week, or month or year. I know we can see how many sales we've had in our My Balance page. And you can count them and add them up manually as it shows the month/date next to them. So you can work out how much you've made each month in sales. But I don't have time for that! Feature Request: Sales reports daily/weekly/monthly etc

    I'd like to be able to generate a sales/earnings report. Have it shown to me in a nice graphical UI. Bar charts of my earnings by day/week/month etc.

    Something like this for example for earnings:
    Feature Request: Sales reports daily/weekly/monthly etc
    But obviously with a bit more meaning to it than that. Maybe even a pie chart for each of my services. So I can see which of my services are the highest earning/yielding services etc.

    I guess it's more of a vanity thing than anything else. But being able to see how much earnings I made one month from the next. Would let me see some insights into which services are performing better over others at different times of the year.

    I think this would be an awesome feature though right!?

    What do YOU think about this feature suggestion?

    Would it be useful and/or helpful to you?

    Would you like to use it if it was a feature?

    Discuss!

    #Sales #Reports #Barcharts #Earnings #Feature SEOClerks
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    EliteWriter

    EliteWriter

    I agree that this would be a nice feature for sellers to have. It could help to keep you motivated, as when there are periods of low sales you can get to check if previous periods made up for that. Sometimes when you get several sales you tend to get confused too and I am the kind of person who likes some regularity, which is of course almost impossible as a freelancer. So this feature could certainly help me to see what is actually happening over periods of time. All we can see are total earnings since we joined, and how many sales there were per service. A pictorial option would indeed be nice.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Well poor old me, I haven't made any sales here... ok but then again I don't sell anything so I can't be too miffed LOL.

    I have started promoting SeoClerks as an affiliate though and I hope soon to make some affiliate sales. I like pie charts. I like checking everything. I like to stare happily at my income and compare it to the previous day or week or month.

    So anything that adds cool reporting features for when I make sales will be very much appreciated.
    10 years ago

    Are you sure you want to delete this post?

    idealmike

    idealmike

    Thanks Lynne. I'll take that as a vote! And I'm the same. I think it will be very useful for knowing just how well you're doing (or not doing) each month from the next. But just fun to look back at as well. For historical purposes of course! Feature Request: Sales reports daily/weekly/monthly etc
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Staring at pie charts is VERY important work... I really do get off on that.
    10 years ago

    Are you sure you want to delete this post?

    Cristian

    Cristian

    Having reports on seoclerks will be a step in the right direction. Can transform this into a more professional platform if you ask me.
    Awesome idea Mike! Maybe for higher level users the reports can be send on email every 24h or every week. I would love to see how many views my services got and if they are doing well or not on the long run.

    I will also like to see a conversion rate to figure out how well optimized my content for my services is and how good my actual marketing on SC is. These features can help sellers on the long run, especially very dedicated sellers who are SC obsessed.
    10 years ago

    Are you sure you want to delete this post?

    procoder

    procoder

    Yeah i agree with you Mike! It would be cool to have a feature like that, because as a freelancer i would like to see all of my freelancing statistics in graphical charts.

    Also, i would love to have a feature that would allow us to generate a report file with our sales statistics.
    10 years ago

    Are you sure you want to delete this post?

    idealmike

    idealmike

    Yes and yes! Same here. I would like to see them in graphical format so I could see how well I done from one month to the next. Or even one year to the next. I could look back and see which months of the year I get the most sales in and see which services I sold the most of in any given month of the year. That could help me to know that certain services sell more at certain times of the year and I could focus on creating more services like it which would increase our sales and earnings. It's a no brainer! Feature Request: Sales reports daily/weekly/monthly etc
    10 years ago

    Are you sure you want to delete this post?

    Maranatha

    Maranatha

    Upvote for this feature request! I am so looking forward to seeing this feature soon on SEOClerks as this will be of big help for us sellers and affiliates. To some that are really interested in this feature, I also have the similar request here (along with Affiliate Sales Analytics) which you can upvote.
    10 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.75433492660522

    Possible Duplicate queries found!
    MatchCountSQLScript
    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='18981'1SELECT 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='18981'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='272'1SELECT * FROM seoclerks.members WHERE USERID='272'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM seoclerks.members WHERE USERID=2721SELECT googleplus_profile FROM seoclerks.members WHERE USERID=272

    		/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=18981 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=18981 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18981' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT 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='18981' 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=104835 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=104835 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=104770 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=104770 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=104775 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=104775 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=104783 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=104783 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=105054 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=105054 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=104846 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=104846 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=104885 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=104885 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=107459 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107459 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='18981'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='18981'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='18981' AND status='1' AND (question like '%Feature Request: Sales reports daily/weekly/monthly etc%' OR question like '%Feature%' OR question like '%Request:%' OR question like '%Sales%' OR question like '%reports%' OR question like '%daily/weekly/monthly%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='18981' AND status='1' AND (question like '%Feature Request: Sales reports daily/weekly/monthly etc%' OR question like '%Feature%' OR question like '%Request:%' OR question like '%Sales%' OR question like '%reports%' OR question like '%daily/weekly/monthly%') -- ORDER BY RAND() LIMIT 15

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM seoclerks.members WHERE USERID='8619' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='8619' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='3489' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3489' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='3764' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3764' 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 11SELECT 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=18981%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=18981%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM categories1SELECT * FROM categories

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='212316.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='212316.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='306632.jpg'1SELECT 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='272.jpg'1SELECT 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='134.png'1SELECT 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='377074.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='377074.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='8619.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='8619.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    select * from categories_faq order by name asc1select * from categories_faq order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin