Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QVSource - How do I get Facebook Posts Metrics?

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!

1 Solution

Accepted Solutions
chrisbrain
Partner - Specialist II
Partner - Specialist II

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.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense

View solution in original post

2 Replies
chrisbrain
Partner - Specialist II
Partner - Specialist II

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.

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
Not applicable
Author

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!