Find Viral Photo from Facebook - FB FQL

15 replies
Hey Warriors!

I would like to share to you these techniques (I know others are selling this) how to search for a viral photo (could be very very useful for marketing).

When I was doing a search for some FB tools, I found this:


I told me self "I think I can create the same feature by using basic FQL codes and share it for free."

So here it is. Scroll down for screenshots.

Steps, Link and Codes you need:

Steps:

1. ) Go to Facebook Graph API Explorer

2.) Click FQL Query

3.) Click Get Token Access --> check user_about_me --> click "Get token Access" button.

Codes for First Step (Find viral pages with your own key words, mine is "dogs"):

Code:
SELECT name, page_id, fan_count, talking_about_count FROM page WHERE CONTAINS("dogs") 
ORDER BY talking_about_count desc LIMIT 50
Codes for Second Step (Sorting popular photo from selected page)

Code:
SELECT link, comment_info, like_info, pid, src_big FROM photo WHERE aid 
    IN (SELECT aid FROM album WHERE owner=41288731654)ORDER BY comment_info desc LIMIT 20

See these screenshots for step by step instructions:

1.) The search for pages to find viral photo (example: find FB pages "dogs" - change it to your targeted keyword search like fitness, cats, marketing, women, etc.)



2.) Sorting Process - Sort all images from your selected page from most popular images (comments and likes)



3.) Click the "Link"




So what do you think guys? Can anyone share how can this be helpful for marketing strategies?

Please click the "Thanks" button if you found this useful.

Have fun!
#facebook #find #fql #photo #viral
  • Profile picture of the author Rhiannon Beckham
    Wow you certainly know your stuff!

    Thanks for sharing
    Signature

    **I don't always make it back to check on threads, so if you'd like me to elaborate feel free to PM me, I try to make sure to check my inbox regularly and am happy to help..

    I wouldn't have pulled a $9k week w/Teespring etc without the help of others, so it's time to pay it forward.
    I can make a little room in my life for that. ;)

    {{ DiscussionBoard.errors[9118107].message }}
  • Profile picture of the author DrewStevens
    Surely there has to be an easier way to derive the same results without using SQL...I know SQL pretty well, but come on, how many others here do?! lol.. Or it just means we're the few who can benefit.
    {{ DiscussionBoard.errors[9122812].message }}
    • Profile picture of the author darkc0de1
      Originally Posted by DrewStevens View Post

      Surely there has to be an easier way to derive the same results without using SQL...I know SQL pretty well, but come on, how many others here do?! lol.. Or it just means we're the few who can benefit.
      They don't need to know SQL or FQL. The code is provided above. All the need is to see the images (results) to get it down and few instructions (copy paste).

      I hope someone here can share with the same results w/o using SQL or FQL.

      {{ DiscussionBoard.errors[9122999].message }}
      • Profile picture of the author DrewStevens
        Ahhh, what I meant was having such background can be very powerful for people like us.. But yes, this is very helpful.

        I've had a couple of these viral photos come across my newsfeed and was wondering how they correlated with the 1-2,000 tee sales these guys were getting.

        Thanks for sharing!

        Originally Posted by darkc0de1 View Post

        They don't need to know SQL or FQL. The code is provided above. All the need is to see the images (results) to get it down and few instructions (copy paste).

        I hope someone here can share with the same results w/o using SQL or FQL.

        {{ DiscussionBoard.errors[9123646].message }}
  • Profile picture of the author SFPro
    Excellent tool, thank you :-)
    {{ DiscussionBoard.errors[9123116].message }}
  • Profile picture of the author anferro
    thank you very much works great friend
    {{ DiscussionBoard.errors[9124426].message }}
  • Profile picture of the author darkc0de1
    This helps my fan page and post get more engagement.

    More share, more likes, more engagement = more potential customers (how about a cat product huh?)



    {{ DiscussionBoard.errors[9125260].message }}
  • Profile picture of the author wpbasit
    Wow great hack, thanks for sharing
    {{ DiscussionBoard.errors[9151705].message }}
  • Profile picture of the author technician27
    Brilliant tool man thanks for tip. Any idea if there is a way to grab fans email addresses too?
    {{ DiscussionBoard.errors[9151796].message }}
    • Profile picture of the author darkc0de1
      Originally Posted by technician27 View Post

      Brilliant tool man thanks for tip. Any idea if there is a way to grab fans email addresses too?
      You can't. That's impossible as for as I know.

      You can grab their FB user id's instead.
      {{ DiscussionBoard.errors[9152074].message }}
  • Profile picture of the author damiensuccess
    Awesome!
    I can assure you I will use this,,, Even for my own entertainment in finding the most entertaining things going.
    Giggle.

    Smart Stuff!
    Signature
    Damien Parsons
    Success Coach | Writer
    Join me on Successful Lifestyle Secrets
    {{ DiscussionBoard.errors[9152384].message }}
  • Profile picture of the author Rhiannon Beckham
    Seriously - just looked over this again. You're awesome for taking the time to hash this out for everyone!
    Signature

    **I don't always make it back to check on threads, so if you'd like me to elaborate feel free to PM me, I try to make sure to check my inbox regularly and am happy to help..

    I wouldn't have pulled a $9k week w/Teespring etc without the help of others, so it's time to pay it forward.
    I can make a little room in my life for that. ;)

    {{ DiscussionBoard.errors[9153111].message }}
  • Profile picture of the author jeffrufino
    You could also just use reddit.
    {{ DiscussionBoard.errors[9232258].message }}
  • Profile picture of the author darkc0de1
    Thanks guys. I hope you found this useful.

    Sharing viral images and posts can help your fan page to get more engagement and likes.
    {{ DiscussionBoard.errors[9232581].message }}

Trending Topics