Visitors that convert

robertman11 Level 2

October 23, 2012, 7:24 am

10

Write the reason you're deleting this FAQ

Visitors that convert

What is the best way to get visitors that convert on seoclerks? I've tried some website exchange sites and they bring traffic, but not purchases..

Comments

Please login or sign up to leave a comment

Join

exjordanary

Actually, I found that Posting a Sponsored Offer on Facebook Pages work great (for example a Gig of yours with your Affiliate Link in it) or simply creating FB Ads in general too. Especially since I can get Targeted Ad Clicks for $0.03 Cents and under. I have NEVER paid more that 3 cents per Click on FB Ads. No matter what Niche.

You should see the Tutorials of mine that I just posted HERE

Thanks!!

Visitors that convert

Visitors that convert

14 years ago

Are you sure you want to delete this post?

Beverly

What is the best way to get visitors that convert on seoclerks? I've tried some website exchange sites and they bring traffic, but not purchases..

Do you mean purchases of your SEO Clerks packages/services?

14 years ago

Are you sure you want to delete this post?

robertman11

Cool, thanks!

@beverly visitors from outside the buy seoclerks services:

14 years ago

Are you sure you want to delete this post?

ionicware

I got a lot of traffic but only 3 affiliates. One of which spent quite a good amount. So far I've tried several methods, don't know exactly which worked best since I did them all in the same period of time.

This is my fault, I haven't provided you with the tools and reports to determine what converts and what doesn't. I am aware of this shortcoming and it will be fixed.

14 years ago

Are you sure you want to delete this post?

exjordanary

Actually, I think there may be a fairly simple way Track which Affiliates are Converting for now. Google offers a couple things. One called "Conversion Tracking" (which is only functional with Adwords at the time being I think) where you would simply paste their Conversion Tracking Code onto whatever Page your Affiliate would land on if/when they Signup (but since I'm not sure what Page that is, it couldn't hurt to at least put it on the Signup Page (https://www.seoclerks.com/signup) for now.

(obviously, this would have to be something done by Admin. - I think only Level X Users can have this done, I'm not sure)

The other option that is offered in Google Analytics (not Adwords) - Is a thing called a "Goal Funnel" where you can set a Page as your "Goal" (in this case, it would again be the Page your Affiliate would ultimately Land on if/when they Signup - but I just Set the Signup Page as my Goal URL for now - at least I'll now if they made it that far).
Then you can set "Goal Funnel Steps" that lead up to your Goal URL (in this case, it would be your Affiliate URL WITHOUT the Domain - So if your Affiliate URL is : https://www.seoclerks.com/linkin/3764 , you would only include : /linkin/3764as your Goal Funnel Step.

14 years ago

Are you sure you want to delete this post?

ionicware

Yeah, that works and a better option is to use the URL Builder that Google offers and make a campaign. This is what we do for all advertisements we create and we are able to track which converts into purchases, registrations, etc.

The problem here is that a regular user can't do this for their affiliate link because they don't have foot code installed not to mention, Level X only has it on their own pages so they would lose this data if their referral navigates to another page. All of this data is actually stored in the database already, I just need to develop a report for it.

Visitors that convert

I've added a "Ref." tab to the affiliate report: https://www.seoclerks.com/balance?tab=affiliate

14 years ago

Are you sure you want to delete this post?

exjordanary

Yes. I saw that. Thanks!! Very nice. It was true. Most of my Affiliates came from Facebook. But the ones who are actually spending anything are from Countries such as Australia, Rwanda, Sweden, India, Indonesia, Slovakia, Egypt, and Cyprus.
Who would've thunk?

14 years ago

Are you sure you want to delete this post?

Corzhens

One of the hardest part in marketing is not the getting of traffic but the conversion. You can get 1,000 visitors to your e-commerce site who would roam around to check on the products but getting a sale is another story. I guess it would depend on the products that you are selling and on the kind of visitors that your site is getting. They should always have a matching niche so the interest would be the same with a higher conversion rate.

7 years ago

Are you sure you want to delete this post?

Process Time: 0.93858289718628

Possible Duplicate queries found!

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='13639'	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='13639'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='9'	1	SELECT * FROM seoclerks.members WHERE USERID='9'	/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=9	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=9	/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=13639 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=13639 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13639' 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='13639' 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=70098 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=70098 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=70099 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=70099 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=70100 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=70100 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=70102 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=70102 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=70104 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=70104 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=70105 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=70105 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=70106 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=70106 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=184596 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=184596 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='13639'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='13639'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='13639' AND status='1' AND (question like '%Visitors convert%' OR question like '%Visitors%' OR question like '%convert%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='13639' AND status='1' AND (question like '%Visitors convert%' OR question like '%Visitors%' OR question like '%convert%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='1697' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1697' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='18155' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='18155' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='44410' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='44410' 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=13639%' 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=13639%' 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='3764.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3764.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='147.jpg'	1	SELECT 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='9.png'	1	SELECT 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='1.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.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()

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time	Count	SQL	Max	Min
0.155864	1	SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Htmlexpert%' OR A.skills LIKE '%Htmlexpert%') ORDER BY A.lastgigedit desc LIMIT 0,40	0.155864	0.155864
0.114747	1	SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Htmlexpert%' OR A.skills LIKE '%Htmlexpert%')	0.114747	0.114747