SEOClerks

Clear
Sign In Join

Affiliate Clicks - (Just Real Visitors? or All Views)

  • Sean101 Level 1
    • 12

    Write the reason you're deleting this FAQ

    Affiliate Clicks - (Just Real Visitors? or All Views)

    Affiliate Clicks: xxxxx
    Affiliate Members: xxxxx

    Where it says the above stats on our affiliates account page, does the "Affiliate Clicks" only count real clicks by people? or Does it also count in bots, crawls, etc.. ?

    # Affiliate Marketing
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    robertman11

    robertman11

    It counts everything. Users, bots, etc.
    13 years ago

    Are you sure you want to delete this post?

    Sean101

    Sean101

    It counts everything. Users, bots, etc.

    Ok, no problem, thanks for letting me know Affiliate Clicks - (Just Real Visitors? or All Views)
    13 years ago

    Are you sure you want to delete this post?

    jakemadness

    jakemadness

    Affiliate Clicks: xxxxx
    Affiliate Members: xxxxx

    Where it says the above stats on our affiliates account page, does the "Affiliate Clicks" only count real clicks by people? or Does it also count in bots, crawls, etc.. ?

    I know it counts bot clicks with real people and crawlers it counts anything that requests the link Affiliate Clicks - (Just Real Visitors? or All Views)
    13 years ago

    Are you sure you want to delete this post?

    Shahid

    Shahid

    It was obvious for me, when I saw somebody sharing there statistics which shows more than 10k clicks for a affiliate Affiliate Clicks - (Just Real Visitors? or All Views)
    13 years ago

    Are you sure you want to delete this post?

    LukasMGK

    LukasMGK

    It counts everything. Users, bots, etc.


    I hope SEOClerks will not count every clicks from bot or traffic exchange.

    cheers!
    13 years ago

    Are you sure you want to delete this post?

    jakemadness

    jakemadness

    I have had nearly 22,000 clicks on my affiliate link but only 12 affiliate members so my affiliate link has clearly been crawled a lot by search engines, crawlers, spiders etc
    ~Jake
    13 years ago

    Are you sure you want to delete this post?

    Sean101

    Sean101

    I currently have 85,264 Clicks with 121 Affiliates that have made 208 Sales. Affiliate Clicks - (Just Real Visitors? or All Views)
    13 years ago

    Are you sure you want to delete this post?

    jakemadness

    jakemadness

    I currently have 85,264 Clicks with 121 Affiliates that have made 208 Sales. Affiliate Clicks - (Just Real Visitors? or All Views)

    This is a lot of clicks :eek:
    13 years ago

    Are you sure you want to delete this post?

    Sean101

    Sean101

    This is a lot of clicks :eek:

    Clicks rom my affiliate store and also from some Facebook ad campaigns I have done Affiliate Clicks - (Just Real Visitors? or All Views)
    13 years ago

    Are you sure you want to delete this post?

    jakemadness

    jakemadness

    I might make a Facebook & Twitter page promoting my stores once my new version is complete and use the websites api's to auto post good services for them Affiliate Clicks - (Just Real Visitors? or All Views)
    13 years ago

    Are you sure you want to delete this post?

    Sean101

    Sean101

    Yeah, auto posting is good a saves a lot of time Affiliate Clicks - (Just Real Visitors? or All Views)
    Just be sure that you don't auto post the same message across lots of pages on the one social network. For example, auto posting "Hello Everyone" to 1 facebook page, 1 twitter profile, 1 plus one page, 1 linkedin, etc.. at the same time is fine, but auto posting it to 5 facbook pages at once, or twitter profiles at once, etc.. is a grey area. Although I have not had any warnings, bans or even came close to getting one, a lot of people on forums, etc.. are saying they have, so just don't overdo the auto posting for lots of profiles across the one network. Affiliate Clicks - (Just Real Visitors? or All Views)

    PS: Talking of auto posting, check out this topic: https://www.seoclerks.com/forum/th...pting-gigs.3842/
    13 years ago

    Are you sure you want to delete this post?

    jakemadness

    jakemadness

    I will create a small DB with the service id so if it comes up again it won't post, but if it isn't in the DB then it will post that should solve the problem
    13 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 1.7263350486755

    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='13716'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='13716'

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

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

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

    SELECT * FROM categories_faq WHERE CATID='35'1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='35'

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

    SELECT * FROM seoclerks.members WHERE USERID=18561SELECT googleplus_profile FROM seoclerks.members WHERE USERID=1856

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13716' 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='13716' 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=70502 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=70502 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=70503 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=70503 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=70504 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=70504 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=70505 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=70505 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=70506 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=70506 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=70507 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=70507 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=70508 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=70508 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=70509 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=70509 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=70510 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=70510 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=70511 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=70511 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=70512 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=70512 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=70513 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=70513 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='13716' AND status='1' AND (question like '%Affiliate Clicks - (Just Real Visitors? Views)%' OR question like '%Affiliate%' OR question like '%Clicks%' OR question like '%(Just%' OR question like '%Real%' OR question like '%Visitors?%' OR question like '%Views)%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='13716' AND status='1' AND (question like '%Affiliate Clicks - (Just Real Visitors? Views)%' OR question like '%Affiliate%' OR question like '%Clicks%' OR question like '%(Just%' OR question like '%Real%' OR question like '%Visitors?%' OR question like '%Views)%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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