FB Ad Creatives - Images in cards

Zimmerman_DP
Zimmerman_DP Member
in Magic ETL

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

  • GrantSmith
    GrantSmith Coach

    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!**
  • mcgeete
    mcgeete Member

    @DP_BA  any luck with this beast mode? I'm trying to create something similar for FB and LinkedIn ads.

  • Unknown
    Unknown

    @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. 

  • Unknown
    Unknown

    @mcgeete 

    The beastmode mentioned above will work, however we are still trying to find a way to link the creatives with our ad insights. 

  • GrantSmith
    GrantSmith Coach

    @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!**
  • Unknown
    Unknown

    @GrantSmith 

    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/

    example_pic_DOMO.JPG

    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
    ActionsOffsiteConv

    AdAccountCreativs 

    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_

     

  • Unknown
    Unknown

    @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. 

     

     

    image.png

Categories