adgroup performance report

[Yaniv Lev-Ari]

Hi,

I would like to get a report of all my adgroups,

during the last 12 months,

segmented by month,

segmented by conversion name.

I thought I can use the adgroup report,

but asking for conversion name segment create a report without clicks and impression,

So I hope it can be done with a script.

Is there such an option?

[Tyler Sidell (AdWords Scripts Team)]

Hi Yaniv,

Using ConversionName you won't be able to combine it with Clicks and Impressions.  What information are you trying to pull exactly?  You can use this guide as a reference as to which columns are involved in each report.  Then you can make the decision from there as to which report will best fit your needs.  Once you have your report picked out you can set up something similar to:

function main() {
  var spreadsheet = SpreadsheetApp.openByUrl('REPLACE_WITH_YOUR_SPREADSHEET_URL');
  var query = 'SELECT AllConversions, AdGroupName, Clicks, Impressions, Month from ' +
      'ADGROUP_PERFORMANCE_REPORT ' +
      'DURING 20140101, 20141231';    
  var report = AdWordsApp.report(query);
  var sheet = spreadsheet.getActiveSheet();
  report.exportToSheet(sheet);  
}

There is no last year option for DURING. The only ones that are supported are:
TODAY, YESTERDAY, LAST_7_DAYS, THIS_WEEK_SUN_TODAY, THIS_WEEK_MON_TODAY, LAST_WEEK, LAST_14_DAYS, LAST_30_DAYS, LAST_WEEK, LAST_BUSINESS_WEEK, LAST_WEEK_SUN_SAT, THIS_MONTH, LAST_MONTH 

You could use a custom date instead.

Thanks,
Tyler Sidell
AdWords Scripts Team

[Yaniv Lev-Ari]

Hi Tyler,

About the dates - I know I can only use custom date.

I want to create a report, 

showing the changes of the conversion price changes, segmented by months

problem is, It has 5 different types of conversions, but I only need two of them

I also need to show the CTR, the conversion rate and the conversion cost

for some campaigns - for each adgroup,

and for some campaign - to the campaign

I could show CTR by one report and conversion details by another report,

but I hope there is a way to combine them

בתאריך יום שני, 26 באוקטובר 2015 בשעה 16:43:21 UTC+2, מאת Tyler Sidell (AdWords Scripts Team):

[Tyler Sidell (AdWords Scripts Team)]

Hi Yaniv,

The solution to segment different conversions would be to run a report that uses the ConversionTrackerId and ConversionTypeName columns. However, keep in mind that ConversionTypeName is not compatible with non-conversion stats such as Ctr and Clicks so you would have to run two separate reports.

Thanks,
Tyler Sidell
AdWords Scripts Team