How to link Google Display Ads to Domo?

user06033

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.

laura_igl

Hi,

 

Is anyone able to help with this request?

 

Thanks,

Thor

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!

user06033

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

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.