WTF is up with Facebook? Anyone know?

ericplotz1 Level X⁵

May 15, 2014, 10:19 pm

Write the reason you're deleting this FAQ

WTF is up with Facebook? Anyone know?

Now I've been trying to figure out a way to run a campaign on FB to gain affiliates, but it seems FB has something against the aff code. I see that SEOclerks advertises on FB with sclrk.com and I can pst that fine, but as soon as I add the /linkin/?????? it denys it. ????????? Is there a way around this?

Comments

Please login or sign up to leave a comment

Join

Asmodeus

Create an affiliate store on your own domain and drop that link anywhere you like, including on FB and Twitter, which also doesn't allow direct SC aff links.

12 years ago

Are you sure you want to delete this post?

NaturalWriter

Create an affiliate store on your own domain and drop that link anywhere you like, including on FB and Twitter, which also doesn't allow direct SC aff links.

Exactly! We haven't had any issues doing this at all, and between the two of us we have four stores, with our own domains

12 years ago

Are you sure you want to delete this post?

kuti101

Facebook and Twitter and killing it. Has anyone try posting on youtube nowdays?

12 years ago

Are you sure you want to delete this post?

Asmodeus

Facebook and Twitter and killing it. Has anyone try posting on youtube nowdays?

I have links to my affiliate stores on YT. It's not as effective as it used to be, but still important.

I've created Facebook pages for my stores as well. Good social linkage

12 years ago

Are you sure you want to delete this post?

ericplotz1

I have links to my affiliate stores on YT. It's not as effective as it used to be, but still important.

I've created Facebook pages for my stores as well. Good social linkage

Are you still seeing conversions with FB? I have FB Lead Chef and target specific groups in FB campaigns. When I don't use FB Lead Chef I've noticed a ton of fake clicks and likes and there is actually quite a bit of info on FB scamming people lately. I did a like campaign and more then half of the likes were from new accounts that had likd 1000's of other pages across FB and all likes were different niches or different companies within a niche. I mean who likes, toyota, Chevy, Hyundai, Honda, Ford, BMW, and other car companies from one profile, has minimal friends, and barely any posts. Looks fake if you ask me.

12 years ago

Are you sure you want to delete this post?

Asmodeus

Are you still seeing conversions with FB? I have FB Lead Chef and target specific groups in FB campaigns. When I don't use FB Lead Chef I've noticed a ton of fake clicks and likes and there is actually quite a bit of info on FB scamming people lately. I did a like campaign and more then half of the likes were from new accounts that had likd 1000's of other pages across FB and all likes were different niches or different companies within a niche. I mean who likes, toyota, Chevy, Hyundai, Honda, Ford, BMW, and other car companies from one profile, has minimal friends, and barely any posts. Looks fake if you ask me.

I only use FB for the social buzz these days, as I don't find the campaigns as effective as they were, say, 2-3 years ago. I do agree with your speculation on the fake accounts though. Do you even get a decent ROI with it anymore, or has that train left the station long ago??

12 years ago

Are you sure you want to delete this post?

ericplotz1

I only use FB for the social buzz these days, as I don't find the campaigns as effective as they were, say, 2-3 years ago. I do agree with your speculation on the fake accounts though. Do you even get a decent ROI with it anymore, or has that train left the station long ago??

I am testing the waters now. I ran a campaign for about a week last month and during that week I didn't see any ROI. So I paused the campaign and quit running it. I ran a campaign for a FB fan page for my site, which is an Amazon affiliate site. Well i quit focusing on the site and decided to work on something else with lesser competition. A month went by and I checked my Amazon affiliate earnings and had made $800 sales and $44.00 commissions. I only spent $7.00 in advertising on FB. I tracked the conversions to yahoo organic search. I know that FB is teamed up with Bing so I am running another campaign to see if it works again. I will definitely let you know how it goes.

12 years ago

Are you sure you want to delete this post?

Asmodeus

Sounds like there is potential with the Amazon campaign. I just wish the percentages were higher there. Thanks for keeping me posted!

12 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.180243	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	0.180243	0.180243

SEOClerks

WTF is up with Facebook? Anyone know?

WTF is up with Facebook? Anyone know?

Comments

Please login or sign up to leave a comment

Asmodeus

NaturalWriter

kuti101

Asmodeus

ericplotz1

Asmodeus

ericplotz1

Asmodeus

Invalid SQL

Expensive SQL

Suspicious SQL

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='13804'	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='13804'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='121814'	1	SELECT * FROM seoclerks.members WHERE USERID='121814'	/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=121814	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=121814	/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=13804 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=13804 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13804' 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='13804' 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=71030 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=71030 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=71031 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=71031 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=71032 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=71032 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=71033 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=71033 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=71034 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=71034 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=71035 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=71035 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=71036 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=71036 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=71037 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=71037 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='13804'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='13804'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='13804' AND status='1' AND (question like '%WTF Facebook? know?%' OR question like '%Facebook?%' OR question like '%know?%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='13804' AND status='1' AND (question like '%WTF Facebook? know?%' OR question like '%Facebook?%' OR question like '%know?%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='498' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='498' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='45782' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='45782' 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='17457' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17457' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='17847' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17847' 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=13804%' 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=13804%' 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='167023.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='167023.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='168430.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='168430.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='12847.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='12847.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='121814.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='121814.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()