Community

Connector Improvement: Facebook Ads - Add Currency into the connector

Answered

Russell McAthy User

We have spend in the dataset - however it doesnt have a currency attached - so you cant aggregate multiple accounts.

There is a currency field available (https://developers.facebook.com/docs/marketing-api/reference/ads-insights/) so hopefully is a quick addition to the current table

Please sign in to leave a comment.

3 comments

Official comment

Drew Fivetranner
- May 10, 2021 22:15
Hi Russell McAthy, Drew from the Product Team here!

Thanks for this suggestion. I was curious whether this is a general request or specific to a pre-built report or metadata table.

Could you elaborate on the specific need?
Russell McAthy User
- May 11, 2021 10:36
Hey Drew

This is a general request.

There is a "spend" field but no currency - when the connector can pull multiple accounts with `100` it could be USD, GBP, EUR, ZAR etc.

Therefore the spend field (one of the most important values in the dataset) is partially "useless" without the context of currency
Drew Fivetranner
- June 29, 2021 21:44
Hi Russell McAthy, I was taking a peek at the Facebook Ads connector and the Facebook API documentation. We do support the currency field in the ACCOUNT_HISTORY table. Does this work as a solution for you or are you looking for currency to be available in another location?