以下查詢範例
ProductPerformanceView
敬上
可傳回最近 30 天內的帳戶成效,並按
marketingMethod
和offerId
。您可以試試這個簡短範例
熟悉 Merchant Reports API。
您需要有成效和洞察資訊 角色,以便擷取這份報表。 詳情請參閱 需求條件 瞭解詳情
如要提出要求,請傳送下列 Merchant Center 查詢
Language 陳述式
accounts.reports.search
敬上
方法:
SELECT
marketingMethod,
offerId,
impressions,
clicks,
clickThroughRate
FROM ProductPerformanceView
WHERE date BETWEEN '2020-11-01' AND '2020-11-30'
HTTP 要求網址
這個要求會包含 HTTP POST 至 下列網址:
https://merchantapi.googleapis.com/reports/v1beta/accounts/parent/reports:search
完成 HTTP 要求範例
以下提供完整範例,顯示 HTTP POST 要求:
POST /reports/v1beta/accounts/parent/reports:search HTTP/1.1 Host: merchantapi.googleapis.com User-Agent: curl Content-Type: application/json Accept: application/json Authorization: Bearer Parameters: { "query" : "SELECT marketingMethod, offerId, impressions, clicks, clickThroughRate FROM ProductPerformanceView WHERE date BETWEEN '2020-11-01' AND '2020-11-30'" }
回應範例如下:
{
"results": [
{
"productPerformanceView": {
"marketingMethod": "ADS",
"offerId": "12345",
"clicks": "38",
"impressions": "1038",
"clickThroughRate": "0.3661"
}
},
{
"productPerformanceView": {
"marketingMethod": "ADS",
"offerId": "12346",
"clicks": "126",
"impressions": "1126",
"clickThroughRate": "0.1119"
}
},
{
"productPerformanceView": {
"marketingMethod": "ORGANIC",
"offerId": "12346",
"clicks": "26",
"impressions": "526",
"clickThroughRate": "0.0494"
}
},
{
"productPerformanceView": {
"marketingMethod": "ADS",
"offerId": "12347",
"clicks": "227",
"impressions": "1227",
"clickThroughRate": "0.1850"
}
},
{
"productPerformanceView": {
"marketingMethod": "ORGANIC",
"offerId": "12347",
"clicks": "12",
"impressions": "512",
"clickThroughRate": "0.0234"
}
}
]
}