crokservices
Level 3
Write the reason you're deleting this FAQ
We want to start affiliate marketing
So you can tell us how to achieve this
1 - Get 10 affiliates to join
2- Affiliate Sales
Please explain to me what to do affiliate link
Are you sure you want to delete this post?
Hey there,
If you share that link on websites, blogs, social media platforms, etc. and get clicks through it you will be one step closer to getting affiliate sales.
If someone clicks on that link, registers an account, and makes a sale on this marketplace it will be considered an affiliate sale. You will be able to boost your user level, create a passive income stream from all the referrals who continue to purchase, and it will help you out in the long run :)
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT 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='29291' | 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='29291' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='794011' | 1 | SELECT * FROM seoclerks.members WHERE USERID='794011' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=794011 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=794011 | /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=29291 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=29291
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29291' 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='29291' 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=188624 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=188624
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=188625 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=188625
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=188627 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=188627
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=188626 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=188626
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=192916 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=192916
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29291' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29291' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29291' AND status='1' AND (question like '%We start affiliate marketing%' OR question like '%start%' OR question like '%affiliate%' OR question like '%marketing%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29291' AND status='1'
AND (question like '%We start affiliate marketing%' OR question like '%start%' OR question like '%affiliate%' OR question like '%marketing%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='5392' limit 1 | 1 | SELECT 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 seoclerks.members WHERE USERID='1643' limit 1 | 1 | SELECT 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='2875' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2875' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3861' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3861' 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=29291%' 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=29291%'
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='4298.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4298.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 |
| Avg Time | Count | SQL | Max | Min |
| 0.096820 | 1 | SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Fapping%') ORDER BY total_recommendations desc LIMIT 0,40 | 0.096820 | 0.096820 |
TommyCarey
Affiliate marketing can be tricky if you're just starting to work with it. There are many ways to bring in affiliates, some good and some bad, but there are always the sure-fire ways that will help you build your referrals and affiliate sales.
1. Get 10 Affiliates to Join
What you'll want to do is go to Facebook groups and communities related to SEO and online marketing then post a comment on anyone's question regarding the niche. If someone is asking where they can get backlinks, post your affiliate link to the backlink category here. If they need article writing service, post your affiliate link to a specific article writing service here.
If you do this enough, you will get plenty of referrals and likely increase your profile level. One of the best things about this is that you're not spamming, you're sending them to pages they're asking for, and the administrators of the groups and communities probably won't delete your affiliate link
2. Getting Affiliate Sales
This is a tougher thing to do from what I've experienced, and it's likely because generating sales isn't the easiest thing to do. Have you ever heard the saying "You can lead a horse to water, but you can't make it drink"? Well, that's the same in affiliate marketing. You can bring people to specific pages, services they're requesting, but they might not purchase right away. It takes time to generate a sale and they may not come back for a few months, but as long as you get them to sign up through your affiliate link you will get credit whenever they do decide to make a purchase
I hope that covers everything you were thinking of
- Tommy Hey Crokservices, Affiliate marketing can be tricky if you're just starting to work with it. There are many ways to bring in affiliates, some good and some bad, but there are always the sure-fire ways that will help you build your referrals and affiliate sales. [size=100][b]1. Get 10 Affiliates to Join[/b][/size] What you'll want to do is go to Facebook groups and communities related to SEO and online marketing then post a comment on anyone's question regarding the niche. If someone is asking where they can get backlinks, post your affiliate link to the backlink category here. If they need article writing service, post your affiliate link to a specific article writing service here. If you do this enough, you will get plenty of referrals and likely increase your profile level. One of the best things about this is that you're not spamming, you're sending them to pages they're asking for, and the administrators of the groups and communities probably won't delete your affiliate link :D [size=100][b]2. Getting Affiliate Sales[/b][/size] This is a tougher thing to do from what I've experienced, and it's likely because generating sales isn't the easiest thing to do. Have you ever heard the saying "You can lead a horse to water, but you can't make it drink"? Well, that's the same in affiliate marketing. You can bring people to specific pages, services they're requesting, but they might not purchase right away. It takes time to generate a sale and they may not come back for a few months, but as long as you get them to sign up through your affiliate link you will get credit whenever they do decide to make a purchase :D I hope that covers everything you were thinking of :) - Tommy
Are you sure you want to delete this post?