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

Community

Connector Improvement: Adding the field <AdsInsightsResult> to facebook_ads_auxiliary connector.

Answered
Amandeep Khakh User

Hi there,

As discussed with Suhas, we would like the <AdsInsightsResult> "results" field added to the facebook_ads_auxiliary connector to help us understand the results/ purchases from our marketing campaigns (something we've never been able to do in Snowflake).

It can be found here: https://developers.facebook.com/docs/marketing-api/reference/ad-campaign-group/insights#fields

Best,

Aman

 

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Lucas Alexander Fivetranner
    • Edited

    Hi Amandeep,

    Luke from the product team, thanks for reaching out.

    Good news: this is already supported by the Facebook Ads connector. The field you're looking for is called objective_results in the connector's field selection, which maps to the Meta Marketing API's results field. When selected, this creates a results child table with the columns indicator, attribution_window, and value. We create a child table because the API response returns a list (type list<AdsInsightsResult>).

    Additionally, the related fields objective_result_rate (mapped to result_rate) and cost_per_result are also available.

    I assume facebook_ads_auxiliary is your existing connection's name. You should be able to add a new custom report with the objective_results field included:

    1. Go to your Facebook Ads connector in the Fivetran dashboard
    2. Navigate to the Setup tab and click Edit connection
    3. Click + Custom report
    4. Build a custom report and include the field objective_results
    5. Save the changes
    6. Enable the new table on your connection's Schema tab. 

    Let us know if you have any other questions.

    Cheers,
    Luke

  • Amandeep Khakh User

    Hi Lucas!

    Thank you for your patience on this whilst I've been playing around with the outputs! I'm pleased to say that this works great and matches with the Meta platform results I've been looking for. I am just awaiting a response from the Marketing team to ensure it has everything they need within this as I know there were a couple of other results they needed. Once they respond I will go ahead and close the ticket.

    I'm also impressed with the simplicity of the step-by-step process and the explanation below it was very clear, thank you.

    Aman