New Connector Alert - Facebook Pages

New Connector Alert 🚨

Want to get the best overview of your Facebook Page metrics? With our new ETL connector, you can seamlessly integrate your Facebook Pages data with all your other data sources. Create a comprehensive view of your business metrics, enhance your analytics, and make more informed decisions with ease!

What data can I get from Facebook Pages?

• page
• page_daily_insights
• page_lifetime_insights
• post
• post_comment
• post_reaction
• post_lifetime_insights
• post_daily_insights
• video
• video_lifetime_insights

How can I set up the Facebook Pages connector in Weld?

1. Authorize the Connector

   • Click on 'New Connector' and select 'Facebook Pages' from the list.
   • Allow access to your Facebook Pages account.
   • Select the page(s) you would like to sync with Weld.

2. Select the desired tables

   • Choose the tables you would like to sync with Weld.
   • Alternatively, click 'Select all tables' to include them all.

3. Set Sync Schedule

   • Set the frequency at which new data should be synced from Facebook Pages to your destination.

How does Weld work?

After setting up the Facebook Pages connector, Weld extracts data from Facebook on a set schedule and then syncs it directly into your data warehouse.

What Metrics can I create from my Facebook Pages Data?

• Page Engagement and Growth
• Post Metrics
• Audience and Location Metrics
• Video Metrics
• Response and Interaction Metrics
• ... and so much more!

How can I use my Facebook Pages Data?

You can for example see how your audience interacts with your content by checking the Response and Interaction Metrics:

1select
2    page.id as page_id
3  , page.name as page_name
4  , page.displayed_message_response_time
5  , page.unread_message_count
6  , page.unseen_message_count
7  , page.unread_notif_count
8  , count(distinct post_comment.id) as total_comments
9  , sum(post_comment.like_count) as total_comment_likes
10from
11    {{raw.facebook_pages.page}} as page
12    left join {{raw.facebook_pages.post}} as post on post.page_id = page.id
13    left join {{raw.facebook_pages.post_comment}} as post_comment on post.id = post_comment.post_id
14where
15    page.is_published = true
16group by
17    page.id
18  , page.name
19  , page.displayed_message_response_time
20  , page.unread_message_count
21  , page.unseen_message_count
22  , page.unread_notif_count
23order by
24    page.displayed_message_response_time asc;

Output:

Or you can look at your Post Metrics and see how your content is performing:

1select
2    post.id as post_id
3  , post.message as post_message
4  , post.created_time as post_created_time
5  , post.shares_count as total_shares
6  , count(post_reaction.id) as total_reactions
7  , count(post_comment.id) as total_comments
8  , post_lifetime_insights.value as lifetime_insights
9  , post_daily_insights.value as daily_insights
10from
11    {{raw.facebook_pages.post}} as post
12    left join {{raw.facebook_pages.post_reaction}} as post_reaction on post.id = post_reaction.post_id
13    left join {{raw.facebook_pages.post_comment}} as post_comment on post.id = post_comment.post_id
14    left join {{raw.facebook_pages.post_lifetime_insights}} as post_lifetime_insights on post.id = post_lifetime_insights.post_id
15    left join {{raw.facebook_pages.post_daily_insights}} as post_daily_insights on post.id = post_daily_insights.post_id
16where
17    post.is_published = true
18group by
19    post.id
20  , post.message
21  , post.created_time
22  , post.shares_count
23  , post_lifetime_insights.value
24  , post_daily_insights.value
25order by
26    total_reactions desc;

Output:

Why use Weld to sync my Facebook Pages data?

• Get insights into core business logic using Ed, our AI SQL assistant.
• Join with your other data sources in our SQL Editor.
• Visualize in any BI Tool.
• Create custom dashboards and reports.