How do you get Google Adwords data into Domo to use with the Google Adwords Keywords Performance App

@gwsv-it - is correct. Going through and using a script to push said data into Google Sheets and then pulling it into Domo is how we bring the data in currently. It does require a little scripting knowledge / skill, but it isn't that bad.

 

 

 

Here is a "base" script I have found much success with - 

 

 

function main() {
var REPORT_NAME = '[report name]';
var REPORT_TYPE = '[report type value]';
var FILTER = '[filter condition]';
var DATE_RANGE = '[predefined date range]';
var COLUMN_NAMES = [
[column names]
];
var COLUMNS = COLUMN_NAMES.join(',');  
var REPORT = AdWordsApp.report(
'SELECT ' + COLUMNS +
' FROM ' + REPORT_TYPE +
' WHERE Status IN [[status values]]' +
' AND ' + FILTER + 
' DURING ' + DATE_RANGE
);
if(DriveApp.getFilesByName(REPORT_NAME).hasNext()){
Logger.log("Overwriting the existing report");
var file = DriveApp.getFilesByName(REPORT_NAME).next();
var spreadsheet = SpreadsheetApp.openByUrl(file.getUrl());
} else {
Logger.log("Creating a new report");
var spreadsheet = SpreadsheetApp.create(REPORT_NAME);
}
var sheet = spreadsheet.getActiveSheet();
REPORT.exportToSheet(sheet);
}

 

 

I tried to highlight the parts in RED you are going to need to change.

 

I also want to point out a couple other points -

 

 

var REPORT = AdWordsApp.report(
'SELECT ' + COLUMNS +
' FROM ' + REPORT_TYPE +
' WHERE Status IN [[status values]]' +
' AND ' + FILTER + 
' DURING ' + DATE_RANGE
);

 This is a common QL statement that you can edit. Perhaps you want want that WHERE clause and you want to remove the filter you are using, etc.

 

This script will generate said report and push it into Google Sheets for you. You will find it there under the name you gave for the REPORT_NAME.

 

This is also going to overwrite the file that is in there the next time it runs. Why? So your Drive doesn't get filled up by a new report each day.

 

 

NOTE - This is for Google Adwords accounts, some changes may need to be made to use this with an MCC account as there are different functions there.

 

NOTE 2 - Your mileage may very. This is just something I have found success with.

Where are you appending this data in Domo? I have my AdWords script all ready to go but I'm not sure how to aggregate the data in Domo. 

@Bulloko Thanks for your help. I think I am almost there. I have my scripts setup in AdWords. The Google Sheets are updated each morning at 7AM with data from the prior day. I am building a dataflow in AdWords to combine the cost from several AdWords accounts into one dataflow. It ran successfully both today and yesterday but when it ran today, the data from yesterday was replaced.  What is my next step? See attached for my ETL setup. 

 

 

 

 

@Bulloko

 

Not as far as I can tell. I've checked the Google Sheets data source in datacenter and I don't see any option for append.

@Zach_Shearer, I am working on a guide/walk-through for this. I will send it your way shortly.

@Zach_Shearer,

Your DataFlow looks great. Let me explain at a high-level what you want to do now:

1. Add another input dataset tile.
2. Pick the output dataset from this same DataFlow to be the new input dataset.
3. Delete the rows/records from the recurisve (DataFlow output data) dataset where the dates match those of the new input sheets.
   Let me explain: If your sheets are pulling in data for the last week and we append that data every day, on the second day, the last six days of data will be duplicated. Eventually every row of data would be there 7x. So, we use a join to compare the dates, then delete the overlapping data from the data already in Domo, giving preference to the newly incoming data--in case AdWords made any retroactive corrections.
4. Combine the new data with the data already in Domo.

You can see how this is done on steps 8 and 9 of this guide: https://domo.box.com/s/yafm7j1df8v29wed78dbt7ch7abokjw2 

 

The guide is still being perfected, so let me know if it is at all confusing. If you find that this is a little to convoluted over text, open a support ticket and ask for Tony. Then we can do it together over a screen-share.

@Togna_Bologna

 

I'm really sorry about all of the trouble. I'm afraid that, without the document in the Box.com folder, I'm finding this setup a little confusing. How does one open a support ticket?

 

Zach Shearer

I have this setup and working. Thanks for working through this with me. The next thing I need to figure out how to do is create calculated attributes, e.g. =Year(day), =Month(day), etc. I'll start looking into that. If you have a recommendation, please send it my way via PM.

You guys have been a great help!

This worked well. I had to add a "column type" transform but the reports are working as expected!

Also see this thread on the same topic.

Hi,

Yes the date range.

We are scheduling the daily report every day, yet the data range is 7 days.

Should we be adding a remove duplicate ETL to the flow?

 

its ok i figure this out.

 

Rgds,

K.