Hello we also want to be able to access creative level data via Fivetran reports specifically for the following reports available in facebooks UI

These are the endpoints URLS we use:

1. fb_daily_ad_export: https://adsmanager.facebook.com/adsmanager/reporting/view?act=1807707056113848&business_id=1537787309772492&event_source=CLICK_REPORTS_FROM_SIDE_NAV&selected_report_id=23855183018690757
2. fb_daily_creative_export: https://adsmanager.facebook.com/adsmanager/reporting/view?act=1807707056113848&business_id=1537787309772492&event_source=CLICK_REPORTS_FROM_SIDE_NAV&selected_report_id=23854906861550757
3. fb_daily_campaign_placement_export: https://adsmanager.facebook.com/adsmanager/reporting/view?act=1807707056113848&business_id=1537787309772492&event_source=CLICK_REPORTS_FROM_SIDE_NAV&selected_report_id=120209859363590758

Hi Oswald,

Thanks for following up with the URLs. We looked into this again, and we cannot find a way to recreate the reports using the API. We came across several posts in the Facebook developer forum asking for the same thing that are unanswered, suggesting there isn't a known solution for building a report broken down by creative:

1. https://developers.facebook.com/community/threads/334011254872570/
2. https://developers.facebook.com/community/threads/267768978679678/

However, I think you can create this using the FK relationship between AD_HISTORY and CREATIVE_HISTORY in our schema for ads with a 1:1 relationship between Ad and Creative. Using the BASIC_AD report as an example, you can join it to AD_HISTORY using the BASIC_AD.ad_id = AD_HISTORY.id. Then you can join CREATIVE_HISTORY using AD_HISTORY.creative_id = CREATIVE_HISTORY.id. This should work for ads with a single creative.

I think the image_asset and video_asset breakdowns can be used for dynamic creative ads to break down the insights data by the asset, either images or videos (source). We are in the process of rolling out new tables corresponding to the Asset Feed Spec, which stores data related to dynamic creatives. You can create a custom report using the image_asset and/or video_asset breakdowns. That would provide the image_asset hash and video_asset id. I assume you could join those to CREATIVE_HISTORY by joining your report with AD_ASSET_FEED_SPEC_IMAGE.hash and AD_ASSET_FEED_SPEC_VIDEO.video_id. Both of those AD_ASSET_FEED_SPEC tables have FK references to CREATIVE_HISTORY. 

If you're using dynamic creatives and would like early access to the AD_ASSET_FEED_SPEC tables, I can add you to a feature flag. Otherwise, we plan to roll these out to all customers soon.

Please let me know if the joins I described for non-dynamic ads above solve your use case. 

Cheers,
Luke

Thank you Luke, please add us to the AD_ASSET_FEED_SPEC feature flag group

We still find we are missing many of the metrics listed in these reports and I have received the following feedback from our DS regarding the recommendations from using current data:

 

On the topic of the recommendation from Fivetran where we utilize existing tables for ads that map 1:1 to a creative, we see that 2.5% of ads and 6.4% of spend within campaigns we’ve run in the last year have had more than one creative per ad. Obviously this is not a large proportion but in the case of spend at least it’s non-trivial.

More notably absent, however, is our inability to get things like installs (very important) and video watch metrics (starting to be useful to the creative team with watch/hook rate derivative metrics). 

Hi Oswald,

We started rolling out the asset_feed_spec tables to all customers. They should be added to your connection soon. We use a cohort rollout strategy to minimize risk, so I can't give you an exact timeline. 

Regarding installs and video metrics, these should already be available to you.

Installs should be available via Facebook's action_type action breakdown. We include this in our prebuilt report, BASIC_AD. The relevant table in your schema would be called BASIC_AD_ACTIONS. You'll see a column called action_type in that table and one called value. The value columns for rows where action_type contains "install" should contain what you're looking for. Meta doesn't publish the complete list of possible action_types, and they vary by business. The action_type for your account may be something like "mobile_app_install", as an example. Similarly, there is a video_view action_type. It should appear in the same prebuilt report table. 

In addition to our prebuilt reports, you can build custom reports with these breakdowns and other metrics in the connector's setup form.

Cheers,
Luke