SEOClerks

Clear
Sign In Join

Contact affiliates

  • hitmeasap Level X5
    • 4

    Write the reason you're deleting this FAQ

    Contact affiliates

    Hello,
    I'm sorry if this is mentioned already. I couldn't find anything similar too this topic.

    Here goes:
    I've been looking for ways to contact my affiliates. The people who signed up using my affiliate id. I can't say that this goes for everyone but I personally feel that I have a "connection" with most of my affiliates. In some way.

    That means, at least in my book, that some of them are trusting me. (the ones who remembers me from the time when they signed up etc. That'll obviously depend on how you got them in the first place.) So, that said, I'd love some kind of option to send them a message to their inbox. I know this can be done already by visiting their profiles one by one, but it involves tons of manual work and I'm looking for an option to send all of them, or some of them a message with the click of a button.

    Best Regards,
    hitmeasap

    # Suggestions & Feedback
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    Topseoservice

    Topseoservice

    Is this the SeoClerks affiliate or something else. Let us know.
    11 years ago

    Are you sure you want to delete this post?

    Beverly

    Beverly

    I like this idea and being able to train and communicate with one's own affiliates would be so beneficial especially since many affiliates sign up with no idea of how to use the site or how to earn money, or even place an order. What are some of your ideas for how to implement this suggestion? There will be concern on how some bad users will use it to spam endlessly if it was just a one click option. We want to hear any ideas you have for making this work.
    11 years ago

    Are you sure you want to delete this post?

    hitmeasap

    hitmeasap

    Is this the SeoClerks affiliate or something else. Let us know.


    Yes, SEOClerks affiliates.


    I like this idea and being able to train and communicate with one's own affiliates would be so beneficial especially since many affiliates sign up with no idea of how to use the site or how to earn money, or even place an order. What are some of your ideas for how to implement this suggestion? There will be concern on how some bad users will use it to spam endlessly if it was just a one click option. We want to hear any ideas you have for making this work.



    Well.. My first thought was simply having a feature within your inbox. I'll show you with these examples.

    #1

    Contact affiliates


    #2
    Contact affiliates

    Having this feature would allow you to send instant messages for all your affiliates. Which in my opinion could be great to promote a special discount offer for your affiliates only, sharing useful tips & tricks, Etc.

    One of the risks with this, would be the spam. Just like you stated. One way to minimize that, could be by having a "block messages" option.

    When your affiliates receives the message there could be a "button" simply stating. "Block messages from this person? - CLICK HERE!" and any future messages using the "affiliate messages" would automatically become blocked. See below picture.

    #3
    Contact affiliates

    You could even make this feature earned by some requirements. Like the userlevels.

    Example in case you'd have this within userlevels:


    Requirements
    • You must be an affiliate

    • Login Very Often (once per X days)
    • Have no Infractions (follow the rules)

    • Must have X unique affiliate sales


    Benefits
    • All benefits of level x-x
    • Ability to send messages to your affiliates.



    Another way to minimize spam would be by having a limit on how many messages you can send. 1 message per 7 days or something like that. This should lead to quality messages & minimize the risk of spam.


    Well, that's about everything I've come up with so far.

    Best Regards,
    hitmeasap
    11 years ago

    Are you sure you want to delete this post?

    siddydv29

    siddydv29

    Thanks friends texttwist.online
    7 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.68101096153259

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=61601SELECT googleplus_profile FROM seoclerks.members WHERE USERID=6160

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12300' 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='12300' 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=58235 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=58235 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=58236 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=58236 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=58237 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=58237 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=188212 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=188212 LIMIT 5

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='147.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='147.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 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
    0.5752551SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (62) AND gtags like'%seoSquareSpace%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.5752550.575255
    0.1494781SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 7300 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%senukex spinner article%' ) LIMIT 40.1494780.149478