Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Facebook Pages - Add support for weekly, 28 day metrics

Answered
Michael Won User

The Facebook Pages connector only supports 'date aggregations'.  The Facebook API has supported day, week, and 28 day aggregation for years.  

Can we update the connector to support aggregations by day, week and 28 day periods.

I believe this older post is asking a similar question but was responded to as if it was asking for Facebook Ads

https://support.fivetran.com/hc/en-us/community/posts/9029872320535-Connector-Improvement-Aggregate-Facebook-reach-on-a-daily-and-monthly-level?page=1#community_comment_17290183419543

The Facebook API shows measures available at day, week, and days_28

https://developers.facebook.com/docs/graph-api/reference/v17.0/insights

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Lucas Alexander Fivetranner
    • Edited

    Hi Michael, Luke from the Product team here!

    Thanks for submitting this feature request. Are you requesting that we provide weekly and 28_day versions of the following daily tables? Do you need different aggregations for these tables in your schema simultaneously (e.g. a DAILY and a WEEKLY version of PAGE_METRICS_BY_[CATEGORY])?

    • UNIQUE_DAILY_PAGE_METRICS_BY_[CATEGORY]
    • DAILY_PAGE_METRICS_BY_[CATEGORY]
    • UNIQUE_LIFETIME_POST_METRICS_BY_[CATEGORY]
    • LIFETIME_POST_METRICS_BY_[CATEGORY]
    • UNIQUE_DAILY_POST_METRICS_BY_[CATEGORY]
    • DAILY_POST_METRICS_BY_[CATEGORY]

    Here's our ERD for reference: link.