Skip to main content

Community

Connector Improvement: Facebook Pages | Add Reel Comment History and Reel Metrics by Action Type Tables - Add Post Saves Metric to Action Type Table

Answered

Please sign in to leave a comment.

Comments

3 comments

  • Official comment

    Hi Damen,

    Luke from the Product team here. Thanks for submitting this feature request and helping us to improve our product.

    To summarize, I think we can support #1 for Facebook reels (reel_comment_history table). I've added this to our backlog for the team to investigate and prioritize, and I'll share updates here. I don't think the others are feasible given the current Facebook APIs. If you think I'm mistaken, please share links to the API documentation explaining how we could retrieve this data.

    I've written more detailed responses to each of your points below.

    Cheers,
    Luke

    For Facebook reels:

    1. We use this endpoint to retrieve data for post_comment_history: https://developers.facebook.com/docs/graph-api/reference/v24.0/comment. We request data for each comment that we find when syncing POST_HISTORY. It looks like this endpoint can also be used to retrieve the reels' comments, so we could implement a REEL_COMMENT_HISTORY table similarly.
    2. We use this endpoint to retrieve metrics for posts: /insights. That endpoint supports the metrics named post_activity_by_action_type*. We use those metrics to populate the lifetime_post_metrics_by_action_type. We use this endpoint to populate the lifetime_reel_metrics_by_action_type table: video/video_insights. Unfortunately, that endpoint doesn't include the equivalent by_action_type* metrics. 
    3. (see above)

    For Facebook posts:

    1. To sync the lifetime_post_metrics_by_action_type table, we request data for the metric post_activity_by_action_type. The API returns the data as a collection of values. It looks like the snippet below. Therefore, it is up to Facebook to determine which action_types are returned. So if Saves are missing, it is because Facebook doesn't provide that data via the API. Unfortunately, we cannot support this request until they update the API to provide Saves as an action type.
    "values": [
            {
              "value": {
                "share": 5,
                "like": 32,
                "comment": 1
              }
            }
          ]

    Hi Lucas,

    I am also very interested in having the reels comment, is there more visibility to provide about such reel_comment_history in the future ?

    Many thanks

    Hi Hugo,

    Thanks for checking in. I've confirmed that adding a reel_comment_history table is feasible on the connector's side. The Meta Graph API's Video node exposes a /comments edge that returns comments for any video object, and reels are represented as Video objects in the Graph API. That means the connector can retrieve reel comments using the reel IDs it already collects while syncing reel_history, the same way it retrieves post comments today via the comment endpoint. No new Facebook permissions are required beyond what the connector already requests for post_comment_history.

    This is confirmed and tracked internally as a feature improvement for the Facebook Pages connector. I don't have a release date to share yet, but I'll post an update here as it moves forward.

    Cheers,
    Luke