/**
*
* Google Shopping Conversion Report Script
*
* This script creates a report for conversion and ROAS data
* segmented at the Product Group Level
* using data from the last 30 days
*
* The primary purpose of this script is to generate a report
* That can then be used for an ROAS-based, automated bidding script
* For use in your Google Shopping campaigns
* Find this full script at adventureppc.com/blog
*
* Version: 1.2
*
* Google AdWords Script maintained by adverntureppc.com
**/

function main() {


    //insert the name of your campaign(s) in between the quotes below
	var campaignNameContains = "YOUR CAMPAIGN NAME HERE";

	//insert the shareable URL of your new Google Spreadsheet between the quotes below
	//you may have to create a new Google Spreadsheet and enable sharing

	var url = 'YOUR URL HERE';
  	var ss = SpreadsheetApp.openByUrl(url);
  	var sheet = ss.getActiveSheet();
 	 var report = AdWordsApp.report(
   	 "SELECT CampaignName, ProductGroup, AdGroupId, Id, CpcBid, AverageCpc, Impressions, Clicks, Cost, Conversions, SearchImpressionShare, ConversionValue " +
   	 "FROM PRODUCT_PARTITION_REPORT " +
   	 "WHERE CampaignName CONTAINS_IGNORE_CASE '" + campaignNameContains + "' " +
   	 "DURING LAST_30_DAYS");

  	report.exportToSheet(sheet);
}