FB Ad Creatives - Images in cards
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.**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
@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.0
@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?**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
No AdID won't work. That would be the obvious choice, we tried it first. The `Id` field in AdCreatives is a unique id for each creative, it does not match up with the custom insights.
Here is a list of the fields in each table that we are working with.
- First our custom ad insights by day on ad level with a ton of columns.
- The general Ad Creatives table that pulls in from the FB Ads Advanced connector.
The Creative report below just feels like a rushed enhancement to the FB Ad Advanced conector.
@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.0
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 78 Cards, Dashboards, Stories
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive