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

Community

Connector Improvement: Facebook Ads API - add more metrics

Answered
Ran Tian User

Hi Team,

We are using Facebook Ads API and looking for add some new metrics: 

  • For Reminder Ads campaigns: metrics should show the action result as "reminder"
  • For Audio Campaign: metrics should show a video/sound breakdown, then could be identify the "Video sound on" metrics

Thank you!

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Ran,

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

    I expect that the “reminder” metric is returned as a specific action_type string (e.g., “Reminders Set”). Facebook returns these as part of an actions array that looks like this:

    "actions": [

      {"action_type":"reminders_set","value":"123"},

      ...

    ]

    We parse this array and store the values in a secondary table, as described here: https://fivetran.com/docs/connectors/applications/facebook-ads#secondarytables. 

    So I would assume the "reminders" data you're looking for could be found in our standard basic_ad_actions table, where the action_type = "%reminder%". The value column in that table would provide the metric value. You could also create a custom report in the connector's setup form and select the action_type action breakdown and include "actions" as a metric.

    Similarly, action_video_sound is an action breakdown. So you could create a custom report with this action breakdown, and the values in the secondary table would correspond to the results in your screenshot.

    Let me know if this does not address your request.

    Cheers,
    Luke

  • Ran Tian User

    Hi Lucas,

    Thanks so much for looking into this!

    We already tried what you suggested, but unfortunately these fields don’t seem to be available to us in Fivetran when generating custom reports. We weren’t able to find any fields related to 'reminders' or 'sound' when searching through the breakdown list. Could you please give us some additional guidance/hints on how we might be able to access these two metrics?

    Thanks!