SEOClerks

Clear
Sign In Join

Busy with my SeoClerks Review

  • Lynne Level 1
    • 13

    Write the reason you're deleting this FAQ

    Busy with my SeoClerks Review

    I am so excited, I am now busy with my review of SeoClerks for my website. I am looking forward to starting to earn some affiliate income from this website.

    I know it starts off slow and that it will take time to build up and this is of course the first step.

    Now this is just going to mess with the SEO contest that Mike wants to start because I won't know if affiliates come from my review or from the contest!

    It doesn't matter though, I am looking forward to a contest anyway just from the learning point of view.

    #Seoclerks #Review #Affiliate #Income SEOClerks
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    EliteWriter

    EliteWriter

    I am glad for you Lynne. I am sure you will do a great job as your heart is set to do it right, and being motivated is what matters the most. Doing a review for SeoClerks is also relatively simple as there are so many things you can discuss and elaborate upon. I am sure you will enjoy doing this while also gaining affiliates as you go along. I will try to take a leaf out of your book and start working to get affiliates too sometime, when I have some time to devote to it. Unfortunately at the moment I am way too busy and when I set out to do it I want to do it right.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    LOL we are on opposite sides of the same thing. I don't have time to add services and do that work and you don't have time to work on getting affiliates...

    Oh well. Maybe when I get you to do some content writing for me then I will have more time!
    10 years ago

    Are you sure you want to delete this post?

    hitmeasap

    hitmeasap

    Hey Lynne,
    That sounds awesome. I'm glad you've decided to jump aboard SEOClerks Affiliate Program. With that being said, I can't tell how accurate this is, for me it's not accurate at all actually.. But you have a "ref" in your affiliate list. It looks like this:


    Busy with my SeoClerks Review



    If that is accurate, then you'll be able to see where your affiliates are coming form.. And that way, you should be able to know if they come from your site or from the contest you're talking about. Busy with my SeoClerks Review

    I don't know if this is something that Jordan could take a look at and perhaps even sort out, so the ref actually works. I've never bothered with it really as I've kept track of my affiliates in other ways.


    Another way you could do it, is to use https://goo.gl/ for instance and shorten your affiliate link. Use one goo.gl link on your blog and another one for your contest. That way you'll be able to see the amount of clicks on each url. Like in this screenshot:

    Busy with my SeoClerks Review

    That should at least give you an estimate of how many affiliates you've got from each link.


    Best Regards,
    hitmeasap
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Oh that is way cool Hitmeasap! Thank you for that. I wouldn't have known because I haven't had any referrals yet.

    I use Pretty Link for my website posts so I can see how many clicks I get on each link.

    I was actually going to ask if anyone else uses a plugin like Pretty Link too.
    10 years ago

    Are you sure you want to delete this post?

    Everett

    Everett

    For me, I just Bit.ly or Goo.gl. Unfortunately, some big link shorteners have blocked the marketplace's domain due to people spamming links everywhere trying to either get affiliates or sales, or even both. Thankfully there's tons of link shorteners so that problem is very small. However, new new link shorteners often don't have many features. :/
    10 years ago

    Are you sure you want to delete this post?

    idealmike

    idealmike

    Hi Lynne that sounds awesome! Exciting times! Busy with my SeoClerks Review

    It does take baby steps at first, but even those who conquered Everest had to take small baby steps at first!

    Don't worry! The SEO contest isn't official yet. We're just throwing ideas around to see what people think of it. That thread didn't gather much momentum and not many people posted in it to say they'd like it to happen and take part in it so not really sure about it anyway.

    But if one is started, you will have a month to enter it and it will run on for about 5 months anyway so that will give you plenty of time to do your review. And you shouldn't rush your review, although you could probably write it up in one day, it's best to take your time with it so that you can make sure you're covering all the important things that you want to say about SEOClerks that you think are cool. Busy with my SeoClerks Review

    But as you've said you're looking forward to the contest, and some others said they wouldn't mind. I will look into starting something perhaps but it wont be for a while yet anyway. We will have to see what happens.

    And also as Andre has pointed out, your affiliate settings page will show where your affiliates came from anyway so there's no need to worry about knowing how many you got and from where as it's all recorded. I think it's pretty accurate too.

    PS. I don't use Pretty Link plugin but just checked it out it looks pretty cool will check it out. I usually just create a sub-folder and use a PHP redirect in it so it's the same URL on my site. You can see it in action on the small SEOClerks review I wrote on my site the other day.

    Anyway good luck with yours and I hope it's the first step to making Lynne a very happy bunny indeed! Busy with my SeoClerks Review
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Oh my gosh, you speak about a PHP redirect like I know what it is. I'm flattered you think I am that clued up LOL.

    I've written my review already, just added all my Pretty Links today and tomorrow I will add all the graphics and publish it Busy with my SeoClerks Review

    When I write reviews I always just say what my experience is Busy with my SeoClerks Review

    I hope some of you come and have a look when I am finished, then if I left anything important out, you can just add it in the comments for me?

    Yeah I saw Andre's explanation of the reference so I know where my referrals come from, that is going to be very helpful so I can see which marketing campaigns are working.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Thanks for the link to your review, I'll check it out Busy with my SeoClerks Review
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    Thanks Mike, I see we did our reviews very differently. I follow a certain format on my website that I stick to...

    I didn't know about the eBook section, is that in the marketplace? I never saw that before! Thanks for making me aware of it.
    10 years ago

    Are you sure you want to delete this post?

    cmoneyspinner

    cmoneyspinner

    Your review goes way beyond reviewing this site. It's more like a tutorial or a guide. It's loaded with all kinds of goodies! Busy with my SeoClerks Review I bookmarked it for future reference.
    9 years ago

    Are you sure you want to delete this post?

    prospernoah

    prospernoah

    Hi cmoneyspinner,

    Glad you found the article or review helpful!

    Of course I wanted to make sure the readers get to know every aspect.

    Thanks as you reference it in the future.
    9 years ago

    Are you sure you want to delete this post?

    prospernoah

    prospernoah

    Glad to hear you are doing great. Seoclerks is definitely the best place to start. This made me write a review on seoclerks earlier

    check it out here :
    http://tipsonblogging.com/2017/07/seoclerks-review-make-money-with-seoclerks/
     
    9 years ago

    Are you sure you want to delete this post?

    prospernoah

    prospernoah

    Sorry here rather: Seoclerks Review 2017: Plus how to make money with seoclerks
    9 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 2.0360350608826

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT 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='18081'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='18081'

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=3066321SELECT googleplus_profile FROM seoclerks.members WHERE USERID=306632

    		/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=18081 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=18081 LIMIT 5

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18081' 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='18081' 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=99087 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=99087 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=99090 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=99090 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=99089 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=99089 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=99091 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=99091 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=99111 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=99111 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=99112 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=99112 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=99140 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=99140 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=99143 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=99143 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=99144 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=99144 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=125808 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=125808 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=125817 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=125817 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=125119 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=125119 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=125121 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=125121 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='18081' AND status='1' AND (question like '%Busy SeoClerks Review%' OR question like '%Busy%' OR question like '%SeoClerks%' OR question like '%Review%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='18081' AND status='1' AND (question like '%Busy SeoClerks Review%' OR question like '%Busy%' OR question like '%SeoClerks%' OR question like '%Review%') -- ORDER BY RAND() LIMIT 15

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

    SELECT * FROM seoclerks.members WHERE USERID='1323' limit 11SELECT 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 seoclerks.members WHERE USERID='1490' limit 11SELECT 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='2921' limit 11SELECT 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='1643' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1643' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='750' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='750' 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=18081%' 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=18081%' 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='6160.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='6160.png'

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

    SELECT * FROM seoclerks.members WHERE USERID='2951.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.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='596028.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='596028.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='559372.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='559372.jpg'

    		/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