topic Re: QVSource - How do I get Facebook Posts Metrics? in QlikView

QVSource - How do I get Facebook Posts Metrics?

Wed, 02 Sep 2015 02:29:23 GMT

Hello!

Is it possible to get the total number of likes, shares and comments for each post from my fan pages through QV Source?

From the start, I've try this using Facebook Insights Connector (v3), without results. But, using Facebook Fan Pages & Groups Conector (v2), I've get something near what I want: a column named "has_at_least_this_many_likes", with 25 as the maximum value. But it's not useful for me, because I have posts with more than 1.000 likes, for example.

Thanks in advanced!

Re: QVSource - How do I get Facebook Posts Metrics?

chrisbrain — Wed, 02 Sep 2015 19:59:07 GMT

Hi Marcelo,

If you have 25 likes you can then just use the:
LikeCountForItem

Table to get the number of likes, but if it's less than 25 then you can skip this step.

Re From the start, I've try this using Facebook Insights Connector (v3), without results.

If you like you can send a note to support@qvsource.com

And we will try to help.

Re: QVSource - How do I get Facebook Posts Metrics?

Wed, 02 Sep 2015 20:57:14 GMT

It worked.

But I've found yet another way to do this.

1 - Extracting one table through Facebook Fan Pages & Groups Conector (v2) with post's names and IDs

2 - Then, using an apply map (thanks to the same post ID) from Facebook Insights Connector (v3)'s in the table from the step 1.

For me is better this way, because the Facebook Insights Connector (v3) gives me more detailed metrics.

Thanks!