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

Community

Connector Improvement: Facebook Pages Page History

Answered
Avishua Stein User

Right now the FACEBOOK_PAGES.PAGE table contains a single record per page, showing the lifetime metrics for that page. This means that we can only see total page followers as of the last sync date and not historically. Instead of merging/ overwriting the data in this table, appending new records from the sync would be more useful. Then we could e.g. track page followers over time without needing to set up any other infra to snapshot the page table

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Avishua,

    Luke from the Product team here. Thanks for submitting this feature request!

    We have another table called DAILY_PAGE_METRICS_BY_TOTAL, which provides daily metrics for pages. I think it would be better to include the daily followers count there. In Facebook's documentation, it says there is a field available from the page insights endpoint, which we use to populate DAILY_PAGE_METRICS_BY_TOTAL, called page_follows. I added an improvement to our backlog to add that field to the table.

    I think that will solve your use case, but let me know if I've misunderstood. 

    Thanks,
    Luke