Connector Improvement: Possibility of tracking conversion detail (order id, order revenue) for Facebook source
Answered
Hi, we are currently built Fivetran connector to Facebook and bring data Databricks. Is it possible to track conversion for campaign, ad group or ad, we'd like to information like order id, order revenue, etc...
I found ad_tracking and ad_conversion in the data model page:
https://docs.google.com/presentation/d/1asDqJrnanE-QTuUOLhe2WyaxxbfJc1GDDIbKCFJieBQ/embed?start=false&loop=false&delayms=3000&slide=id.g2fb4d351d9f_15_0.
Not sure if that's the relevant to our request, if not, any other recommendation?
Could you please prioritize the ticket, we'd like to understand the feasibility.
Thanks. 
-
Official comment
Hi Sherry,
Facebook doesn't provide information like order ID, order revenue, etc. in their insights API. They only surface aggregated conversion data. You can get the number of conversions and the value of conversions for each ad using our Quickstart data model for Facebook Ads: https://fivetran.com/docs/transformations/data-models/facebook-ads-data-model/facebook-ads-transform-model.
I think it is by design that Facebook doesn't expose click-level logs to tie an ad click to a specific order ID.
Hope that helps,
Luke
Please sign in to leave a comment.
Comments
1 comment