时间戳

首页 > 解决方案 > AdWordsApp.report 失败但未显示错误

google-apps-script - AdWordsApp.report 失败但未显示错误

问题描述

我尝试从我的广告词脚本编辑器运行以下广告词。

我的最终目标是能够运行 query1 或 query2

//conversion_action    
var query1 = "SELECT conversion_action.app_id, conversion_action.attribution_model_settings.attribution_model, conversion_action.attribution_model_settings.data_driven_model_status, conversion_action.category, conversion_action.click_through_lookback_window_days, conversion_action.counting_type, conversion_action.firebase_settings.event_name, conversion_action.firebase_settings.project_id, conversion_action.id, conversion_action.include_in_conversions_metric,  conversion_action.name, conversion_action.owner_customer,  conversion_action.resource_name, conversion_action.status, conversion_action.tag_snippets, conversion_action.third_party_app_analytics_settings.event_name, conversion_action.third_party_app_analytics_settings.provider_name, conversion_action.type, conversion_action.value_settings.always_use_default_value, conversion_action.value_settings.default_currency_code, conversion_action.value_settings.default_value, conversion_action.view_through_lookback_window_days,  metrics.conversion_last_conversion_date FROM conversion_action WHERE metrics.conversion_last_conversion_date > '2020-01-01'";
var TimeFrame = spreadsheet.getRangeByName("Last_x_days").getValue();
var now = new Date();
var from = new Date(now.getTime() - 10 * MILLIS_PER_DAY);
var query2 = "SELECT conversion_action.firebase_settings.event_name,  conversion_action.type, conversion_action.name,conversion_action.resource_name, conversion_action.third_party_app_analytics_settings.event_name, metrics.conversion_last_conversion_date FROM conversion_action WHERE metrics.conversion_last_conversion_date > '" + Utilities.formatDate(from, AdsApp.currentAccount().getTimeZone(), 'yyyy-MM-dd') + "'";

var report = AdWordsApp.report(query2, { apiVersion: 'v8' });

但我得到一个模糊的错误：

We're sorry, a server error occurred. Please wait a bit and try again. (file code.gs, line 25)这是这里的最后一行代码

会是什么？

标签： google-apps-scriptgoogle-ads-apigoogle-ads-script

解决方案

推荐阅读