sks66
Level 1
Write the reason you're deleting this FAQ
Hi. I would like to ask the community for help as Iam new to affiliate.
i have got access to give out free coupons and I have nearly 2million affiliate clicks but unfortunately no affiliates .
Can anyone share some strategy and how I can target the right audience.
my website is SeoZone.com and the traffic is good ???? but there is no conversion .
i should be able to gain affiliates with the coupons . If anyone can share how I can proceed with coupon and market them I would appreciate it.
thanks for your help in advance.
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?
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 `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='24320' | 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='24320' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='571662' | 1 | SELECT * FROM seoclerks.members WHERE USERID='571662' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='35' | 1 | SELECT 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=571662 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=571662 | /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=24320 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=24320
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='24320' 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='24320' 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=133640 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=133640
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=138214 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=138214
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=133678 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=133678
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=133721 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=133721
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=135738 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=135738
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=135988 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=135988
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=153934 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=153934
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='24320' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='24320' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='24320' AND status='1' AND (question like '%Affiliate strategy coupons.%' OR question like '%Affiliate%' OR question like '%strategy%' OR question like '%coupons.%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='24320' AND status='1'
AND (question like '%Affiliate strategy coupons.%' OR question like '%Affiliate%' OR question like '%strategy%' OR question like '%coupons.%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='672' limit 1 | 1 | SELECT 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='1576' limit 1 | 1 | SELECT 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='1490' limit 1 | 1 | SELECT 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='2255' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2255' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1364' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1364' 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=24320%' 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=24320%'
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='617077.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='617077.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='589438.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='589438.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='275652.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='275652.png' | /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 |
TommyCarey
First off, this is in your footer... SeoClerks Affiliate
That will need to be removed asap as it basically tells people they can just go right to SEOclerks instead of working with your website. It's a simple tweak to the footer code, any programmer or web designer can take that out for a dollar or two.
Your website has some ads on it, which seems like a good thing, but if you want to be taken serious as a marketplace then you'll need to remove them. I know they may make you some money, but removing the ads will make it so the users see you as the top dog and not someone peddling other peoples services and not making enough money from them so now you have to put adsense on your pages.
There could be a problem with your traffic sources. I would avoid traffic exchanges at all costs unless you set up a landing page on a different domain and have a simple "Click Here" button for people to actually go to your website. What you'll need to do is have the button set up to open in a new tab, not the current tab. This is because people who are on auto surfs will let it run for hours on end and never see your website in their browser. If you're on a manual traffic exchange, people might not see your website still because they've become blind to the sites they're viewing. So by putting a big "Click Here" button in front of them, they're enticed to click it. If the button opens in a new tab then it will not close when the traffic exchange has them move on to a new site. The traffic exchange will keep working and you now have someone on your website who is interested
Another good thing about this is that you don't waste your own bandwidth from the millions of page views coming through the traffic exchange. Set up your secondary landing page on a shared hosting account that has an unlimited plan and let it run. Your main hosting account won't take a hit because the landing page is catching all the pointless traffic but letting the real people go through to your main website
If you're using PPC ads, you need to fix your targeting. I try to avoid third world countries because I can get 3,000 clicks a day but have 0 conversions. If you want to make money with PPC, you need to get better at optimizing your campaigns for the best conversions possible.
You didn't give us much information, so hopefully I hit the right nail on the head lol
Thanks,
Razzy If you have over 2,000,000 clicks and no conversions, something is seriously wrong. First off, this is in your footer... SeoClerks Affiliate That will need to be removed asap as it basically tells people they can just go right to SEOclerks instead of working with your website. It's a simple tweak to the footer code, any programmer or web designer can take that out for a dollar or two. Your website has some ads on it, which seems like a good thing, but if you want to be taken serious as a marketplace then you'll need to remove them. I know they may make you some money, but removing the ads will make it so the users see you as the top dog and not someone peddling other peoples services and not making enough money from them so now you have to put adsense on your pages. There could be a problem with your traffic sources. I would avoid traffic exchanges at all costs unless you set up a landing page on a different domain and have a simple "Click Here" button for people to actually go to your website. What you'll need to do is have the button set up to open in a new tab, not the current tab. This is because people who are on auto surfs will let it run for hours on end and never see your website in their browser. If you're on a manual traffic exchange, people might not see your website still because they've become blind to the sites they're viewing. So by putting a big "Click Here" button in front of them, they're enticed to click it. If the button opens in a new tab then it will not close when the traffic exchange has them move on to a new site. The traffic exchange will keep working and you now have someone on your website who is interested :D Another good thing about this is that you don't waste your own bandwidth from the millions of page views coming through the traffic exchange. Set up your secondary landing page on a shared hosting account that has an unlimited plan and let it run. Your main hosting account won't take a hit because the landing page is catching all the pointless traffic but letting the real people go through to your main website :D If you're using PPC ads, you need to fix your targeting. I try to avoid third world countries because I can get 3,000 clicks a day but have 0 conversions. If you want to make money with PPC, you need to get better at optimizing your campaigns for the best conversions possible. You didn't give us much information, so hopefully I hit the right nail on the head lol :D Thanks, Razzy
Are you sure you want to delete this post?