How to link Google Display Ads to Domo?

What is the best way to show Google Display Campaigns in Domo? Is there a way to show the images we are running as Ads in a campaign along with results? I'm basically looking to recreate the attached AdWords report in Domo.

Comments

  • Hi,

     

    Is anyone able to help with this request?

     

    Thanks,

  • Thor
    Thor Domo Employee

    Hi @user06033,

     

    I am not familiar with a Google Display Campaign, but here is a Knowledge Base article I found on how to make the Google AdWords data come into Domo: https://knowledge.domo.com/?cid=googleadwords

     

    As well, here is an article that goes over how to put an image inside of a Table Chart using a BeastMode: http://knowledge.domo.com?cid=samplebeastmode and you are looking for the section, "Showing Different Pictures in a Table Based on Changing Values".

     

    Best of luck!


    **Say 'Thanks' by clicking the heart in the post that helped you**
    **Please mark the post that solves your question as 'Accepted Solution’**
  • Great! Thanks!

     

    So I'm trying to make the Image linking dynamic based on the Ad. My Data set is pulling in the "Image URL" from AdWords as "https://tpc.googlesyndication.com/simgad/14512382066467618576". I set up a beast mode as follows:

     

    CONCAT('<div style="text-align:center"><img alt="DOWN" height="20px" src=`Image URL`>','</div>')

     

    I was hoping that the src would dynamically pull in the image url, but it keeps giving me a broken image.

     

    When I set up the beast mode as a static image, it will work:

     

    CONCAT('<div style="text-align:center"><img alt="DOWN" height="20px" src="https://tpc.googlesyndication.com/simgad/14512382066467618576">','</div>')

     

    Is there anyway I can set it up so that the html coding will pull in the url from the data set?

  • Thor
    Thor Domo Employee

    You could try putting the Ad infomration of the URL into a DataSet, so you would have something like:

     

    CONCAT('<div style="text-align:center"><img alt="DOWN" height="20px" src="https://tpc.googlesyndication.com/simgad/",`dynamic_column_id`,>','</div>')

     

    And then have a column in your DataSet named `dynamic_column_id` where you put each Ad campaign. 

     

    Give that a try.


    **Say 'Thanks' by clicking the heart in the post that helped you**
    **Please mark the post that solves your question as 'Accepted Solution’**