FB Ad Creatives - Images in cards
Hey all,
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:
https://developers.facebook.com/docs/marketing-api/reference/ad-image
Thank you!
Comments
-
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.
*additional edit
The Creative report below just feels like a rushed enhancement to the FB Ad Advanced conector.
https://developers.facebook.com/docs/marketing-api/reference/ad-creative/
Ad Insights
DateStart
DateStop
Impressions
Clicks
Spend
ActionsPostEngagement
ActionsOffsiteConversion.fbPixelAddToCart28dayClick
ActionsOffsiteConversion.fbPixelAddToCart28dayView
ActionsOffsiteConversion.fbPixelPurchase28dayView
ActionsOffsiteConversion.fbPixelPurchase28dayClick
ActionsOffsiteConversion.fbPixelViewContent28dayClick
ActionsOffsiteConversion.fbPixelViewContent28dayView
Store_Visits_28dayClick
Store_Visits_28dayView
Store_Visits
AdId
AdName
AccountName
AccountId
AdsetName
AdsetId
CampaignName
CampaignId
ActionsLike
AccountCurrency
InlinePostEngagement
ActionsComment
ActionsComment28dayClick
ActionsLinkClick
ActionsLinkClick28dayClick
DoNotUse-1
DoNotUse-2
DoNotUse-3
DoNotUse-4
DoNotUse-5
DoNotUse-6
ActionsOffsiteConversion.fbPixelCustom28dayClick
ActionsOffsiteConversion.fbPixelCustom28dayView
ActionsOffsiteConversion.fbPixelCustom
Objective
Reach
ActionsPostEngagement28dayClick
ActionsPostEngagement28dayView
ActionsOffsiteConversion.fbPixelAddToCart
ActionsOffsiteConversion.fbPixelPurchase
ActionsOffsiteConversion.fbPixelViewContent
Connector_Source
ConversionsDonateTotal28dayClick
ConversionsDonateTotal28dayView
ActionsOffsiteConversion.fbPixelLead28dayClick
ActionsOffsiteConvAdAccountCreativs
id
instagram_actor_id
instagram_permalink_url
name
object_type
url_tags
account_id
run_status
instagram_story_id
body
call_to_action_type
thumbnail_url
title
image_url
product_set_id
applink_treatment
_BATCH_ID_
_BATCH_LAST_RUN_0 -
@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
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 708 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive