Audit historického výkonu PLA kampaní

function main(){

var to = lynt_get_date(1,1);
var from = lynt_get_date(30,1);
var reportArray = [ "OfferId; CampaignName; AdGroupName; Cost; AllConversions; AllConversionValue; ProductTypeL1; ProductTypeL2; ProductTypeL3; CategoryL1; CategoryL2; CategoryL3; CategoryL4; Impressions; Brand; CustomAttribute0; CustomAttribute1; CustomAttribute2; CustomAttribute3; Clicks"];
var report = AdWordsApp.report("SELECT Month, OfferId, Clicks, CampaignName, AdGroupName, Cost, AllConversions, AllConversionValue, ProductTypeL1, ProductTypeL2, ProductTypeL3, CategoryL1, CategoryL2, CategoryL3, CategoryL4, Impressions, Brand, CustomAttribute0, CustomAttribute1, CustomAttribute2, CustomAttribute3 FROM SHOPPING_PERFORMANCE_REPORT DURING "+from+","+to+"");
var iterator = report.rows();
while(iterator.hasNext()) {
var oneRow = iterator.next();
var oneRowString = lynt_json_to_array(oneRow);
reportArray.push(oneRowString);
}

doCSV(reportArray,"PLA report");

}

function doCSV(input,name) {
var data = input.join("\n");
var file = DriveApp.createFile(name, data);
Logger.log(file.getUrl());
}

function lynt_json_to_array(json) {
var OfferId = json.OfferId;
var Clicks = json.Clicks.replace(","," ").replace(".",",");
var CampaignName = json.CampaignName;
var AdGroupName = json.AdGroupName;
var Cost = json.Cost.replace(","," ").replace(".",",");
var AllConversions = json.AllConversions.replace(","," ").replace(".",",");
var AllConversionValue = json.AllConversionValue.replace(","," ").replace(".",",");
var ProductTypeL1 = json.ProductTypeL1;
var ProductTypeL2 = json.ProductTypeL2;
var ProductTypeL3 = json.ProductTypeL3;
var CategoryL1 = json.CategoryL1;
var CategoryL2 = json.CategoryL2;
var CategoryL3 = json.CategoryL3;
var CategoryL4 = json.CategoryL4;
var Impressions = json.Impressions.replace(","," ").replace(".",",");
var Brand = json.Brand;
var CustomAttribute0 = json.CustomAttribute0;
var CustomAttribute1 = json.CustomAttribute1;
var CustomAttribute2 = json.CustomAttribute2;
var CustomAttribute3 = json.CustomAttribute3;
var string =
OfferId + ";'" +
CampaignName + ";'" +
AdGroupName + ";" +
Cost + ";" +
AllConversions + ";" +
AllConversionValue + ";" +
ProductTypeL1 + ";" +
ProductTypeL2 + ";" +
ProductTypeL3 + ";" +
CategoryL1 + ";" +
CategoryL2 + ";" +
CategoryL3 + ";" +
CategoryL4 + ";" +
Impressions + ";" +
Brand + ";" +
CustomAttribute0 + ";" +
CustomAttribute1 + ";" +
CustomAttribute2 + ";" +
CustomAttribute3 + ";" +
Clicks;
return string;
}

function lynt_format_awql_date(datum){
return datum.getUTCFullYear()+("0"+(datum.getUTCMonth()+1)).slice(-2)+("0"+datum.getUTCDate()).slice(-2);
}

//Daylight saving time correction
function lynt_DST(datum, offset){
var yr = datum.getFullYear();
var dst_start = new Date("March 14, " + yr +" 02:00:00");
var dst_end = new Date("November 07, " + yr +" 02:00:00");
var day = dst_start.getDay();
dst_start.setDate(14-day);
day = dst_end.getDay();
dst_end.setDate(7-day);
if (datum >= dst_start && datum < dst_end){
return offset+1;
} else {
return offset;
}
}

//Getting data for x days back in right format for AWQL query
function lynt_get_date(pocet_dni, zona) {
var minule = new Date();
//kdyz je letni cas, tak o hodinu dele (GMT+1)
var offset = lynt_DST(minule, zona);
minule.setTime(minule.getTime() - (1000 * 60 * 60 * (24) * pocet_dni) + offset);
return lynt_format_awql_date(minule);
}