Connector Improvement: Facebook Ads to include Product Catalogue tables, provides significant business value
AnsweredHi FiveTran,
I had been through your documentation in search of our data requirements, looking for the following information and unclear which Facebook/Meta connector would best but select factebook_ads as a default.
(https://fivetran.com/docs/applications/)
Product catalog tables. These are needed to track the products that are advertised in catalog based Carousel advertisements. The specific sections of the graph API that is of interest is:
-
Graph API Reference v17.0: Product Set - Documentation - Meta for Developers
(https://developers.facebook.com/docs/graph-api/reference/product-set/) -
Graph API Reference v16.0: Product Set Products - Documentation - Meta for Developers
(https://developers.facebook.com/docs/marketing-api/reference/product-set/products/) -
Graph API Reference v16.0: Product Catalog - Documentation - Meta for Developers
(https://developers.facebook.com/docs/marketing-api/reference/product-catalog/) -
Graph API Reference v17.0: Product Item - Documentation - Meta for Developers
(https://developers.facebook.com/docs/marketing-api/reference/product-item/)
Specific requirements:
Product_catalog:
-
Capture all fields
-
Capture the edges product sets, products, categories, product_groups to link to the tables below
Product Set:
-
Capture all fields
-
Capture the edges products
Product Item:
-
Capture all parameters
-
Select fields:
-
id
-
name
-
all image url fields
-
custom data
-
description
-
category
-
color
-
expiration_date
-
fb_product_category -
images -
importer_name -
manufacture_* -
product_catalog -
product_group -
product_type
-
product_feed
-
price
-
retailer_id
-
retailer_product_group_id -
visibility
-
short description
-
size
-
-
Official comment
Hi Zeshan,
Luke from the Product team here. Thanks for submitting this feature request and for providing all the details on where we can find this data.I've added a request to our backlog for the team to review. We'll prioritize this based on the other requests in our backlog, based on customer demand. So far, it looks like you're the only one who has requested this data.
I'm curious what your use case is for this data?
Thanks again,
Luke -
Any update on when we might be able to get this feature actualised?
Please sign in to leave a comment.
Comments
2 comments