We are trying to make a table card and display the ad creatives for our FB ads, images in the table card. I have brought images into DOMO before however we are trying to find a configuration of the FB ads advanced connector that can do this. Is there any way to bring in the URL with the existing connectors?
Something like this:
Have you looked into the Ads Report with the Ad Creative Edge using the Facebook Ads Advanced Connector?
It returns a field `thumbnail_url` which you can then utilize an HTML IMG tag using a BeastMode
CONCAT('<IMG src="', `thumbnail_url`, "/>')
Using this BeastMode in a table card will display the image.
@GrantSmith Yes that is the idea, but the solution is more complicated.
We are tying to find a way to link that table with our by Ad Custom Insights. The problem is, there dosen't seem to be any columns avaiable for a join.
@DP_BA - Can you utilize the ad_id or are you pulling your facebook data on a different dimension?
What Reports do you have selected and what are the report edge / level are being utilized?
@GrantSmith we are using FB Ads Advanced Connector and have a large custom insights report brokendown by Ad, and day.
The Ad Creatives are being pulled into DOMO with the Advanced Connector. Configured on the AdAccount level, with ad creative as the edge.
There are no columns in this creative dataset we are able to pull from the connector that would link the tables. AdId isn't available, and CreativeId is unique to each creative.
We have been on a call with support and our success manager, AdId is everyone's first guess. It's puzzling why AdId isn't in the AdCreative edge report in the first place.
I have been told by two peole at DOMO there is a way to connect these two datasets with the use of a third dataset (excel export from FB business manager) as an intermediary that will serve as the mapping for each AdID to CreativeID.
Below is a screenshot of how to configure the Ads Advanced connector to pull in the URLs and creatives data.