How to link Google Display Ads to Domo?

user06033
user06033 Member
in Archive

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

  • laura_igl
    laura_igl Member

    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’**
  • user06033
    user06033 Member

    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’**

Categories