3 Replies Latest reply on Dec 1, 2018 2:27 AM by Chris Chalmers

    Facebook data visualization for marketing?

    Gabriele Daukintyte

      Hello,

       

      I have fetched Facebook data that has a number of posts, likes, shares, comments for the duration of 3 years and I am not sure how to use filters that I could see which post had the most likes. Also, is it possible to see the topic (phrase) which was the most popular in people's comments for a certain post? I am trying to see how you can use such data for marketing purposes so if you have any more insights, I am looking forward to hear it from you Thanks in advance!

        • 1. Re: Facebook data visualization for marketing?
          Peter Fakan

          Hi Gabriele,

           

          Please upload a sample dataset.

           

          My initial thoughts are you should be able to identify posts, put that on columns or rows and the number of likes on the opposite column or row. I'm not sure how you would extract the most common phrase out of your data, but I'd probably take the approach of splitting each word into a new column and then doing some kind of 'most common first word, most common second word' approach.

           

          HTH

           

          Peter

          • 2. Re: Facebook data visualization for marketing?
            Gabriele Daukintyte

            Hi Peter, thanks for your help. I uploaded the small sample with filters. I don't know how to split post, postlike and comment as they are under the same filter section. If the postlike or comment is related to the post, they share the same ID. Maybe I could somehow do a union or something that I would filter the post with they ids and then in other file filter comments and their parentids as well and then eventually see how many ids are used per a particular post. I have the idea how it should be but I do not know how to make it work. Maybe you have any suggestions?

            • 3. Re: Facebook data visualization for marketing?
              Chris Chalmers

              Hey Gabriele,

               

              Is this roughly what you're looking for? Also find the workbook attached.

               

              FacebookLikes.PNG

               

              Topic modeling is a huge and complex field, so you may have more luck asking that question as a separate post. I've never seen phrase-based topic modeling done solely in Tableau. It's more common to see topic modeling done outside of Tableau, and the results brought into Tableau for analysis.

               

              -Chris Chalmers