掌握競爭局勢

競爭曝光率報表有助於你掌握產品類別層級的競爭情況，並依據購物廣告和自然產品資訊的曝光次數採取行動，提高曝光率。如要瞭解特定產品和品牌的相關資訊，請參閱暢銷商品報表。

你的帳戶必須符合基本資格規定，而且你必須確定，你或任何第三方以符合《Merchant Center 條款及細則》的方式，使用競爭曝光度資料。

查看 Merchant API 提供哪些報表資料表和欄位。

競爭曝光率資料

競爭曝光資料會依國家/地區、Google 產品類別和流量來源分組。

您必須在所有競爭曝光率查詢的 WHERE 子句中指定國家/地區和類別值。您可以變更 WHERE 子句中的值，自訂日期、流量來源、國家/地區和類別的報表。

包含多個國家/地區和類別值的查詢可能需要較長的執行時間，或會逾時。

查看曝光率相近的商家

您可以查詢 competitive_visibility_competitor_view，查看與自家商家曝光次數相近的其他商家。

以下是範例。如要提出要求，請將下列 Merchant Center 查詢語言陳述式傳遞至 accounts.reports.search 方法：

SELECT
  report_country_code,
  report_category_id,
  traffic_source,
  domain,
  is_your_domain,
  rank,
  ads_organic_ratio,
  page_overlap_rate,
  higher_position_rate,
  relative_visibility
FROM competitive_visibility_competitor_view
WHERE date BETWEEN '2023-06-02' AND '2023-06-27'
  AND report_country_code = 'US'
  AND report_category_id = 536
  AND traffic_source = 'ADS'
ORDER BY rank

您可以變更 WHERE 子句中的值，為其他日期、流量來源、國家/地區和類別自訂報表。

以下是上述查詢的回應範例：

{
  "results": [
    {
      "competitiveVisibilityCompetitorView": {
        "reportCountryCode": "US",
        "reportCategoryId": "536",
        "trafficSource": "ADS",
        "domain": "examplepetstore.com",
        "isYourDomain": false,
        "rank": "4",
        "adsOrganicRatio": 8,
        "pageOverlapRate": 0.19,
        "higherPositionRate": 0.46,
        "relativeVisibility": 0.5
      }
    },
    {
      "competitiveVisibilityCompetitorView": {
        "reportCountryCode": "US",
        "reportCategoryId": "536",
        "trafficSource": "ADS",
        "domain": "example.com",
        "isYourDomain": true,
        "rank": "5",
        "adsOrganicRatio": 30,
        "pageOverlapRate": 1,
        "higherPositionRate": 0,
        "relativeVisibility": 0
      }
    },
  ]
}

如要進一步瞭解可供查詢的欄位，請參閱「competitiveVisibilityCompetitorView 資料表中的欄位」。

查看曝光率最高的商家

您可以查詢 competitive_visibility_top_merchant_view，瞭解哪些商家在特定類別中獲得最多 Google 曝光次數，以及貴商家的表現如何。

以下是範例。如要提出要求，請將下列 Merchant Center Query Language 陳述式傳遞至 accounts.reports.search 方法：

SELECT
  report_country_code,
  report_category_id,
  traffic_source,
  domain,
  is_your_domain,
  rank,
  ads_organic_ratio,
  page_overlap_rate,
  higher_position_rate
FROM competitive_visibility_top_merchant_view
WHERE date BETWEEN '2022-08-01' AND '2022-09-01'
  AND report_country_code = 'US'
  AND report_category_id = 100
  AND traffic_source = 'ORGANIC'
ORDER BY rank

以下是上述查詢的回應範例：

{
  "results": [
    {
      "competitiveVisibilityTopMerchantView": {
        "reportCountryCode": "US",
        "reportCategoryId": "100",
        "trafficSource": "ORGANIC",
        "domain": "examplepetstore.com",
        "isYourDomain": false,
        "rank": "1",
        "adsOrganicRatio": 0.2,
        "pageOverlapRate": 0.3,
        "higherPositionRate": 0.45
      }
    },
    {
      "competitiveVisibilityTopMerchantView": {
        "reportCountryCode": "US",
        "reportCategoryId": "100",
        "trafficSource": "ORGANIC",
        "domain": "example.com",
        "isYourDomain": false,
        "rank": "2",
        "adsOrganicRatio": 5,
        "pageOverlapRate": 0.67,
        "higherPositionRate": 0.89
      }
    },
  ]
}

如要進一步瞭解可供查詢的欄位，請參閱「competitiveVisibilityTopMerchantView 資料表中的欄位」。

比較曝光度與類別基準

您可以查詢 competitive_visibility_benchmark_view，瞭解曝光次數的趨勢與其他賣家的平均趨勢有何差異。

以下是範例。如要提出要求，請將下列 Merchant Center 查詢語言陳述式傳遞至 accounts.reports.search 方法：

SELECT
  report_country_code,
  report_category_id,
  traffic_source,
  date,
  your_domain_visibility_trend,
  category_benchmark_visibility_trend
FROM competitive_visibility_benchmark_view
WHERE date BETWEEN '2022-09-01' AND '2022-09-07'
  AND report_country_code = 'US'
  AND report_category_id = 100
  AND traffic_source = 'ORGANIC'
ORDER BY date

以下是上述查詢的回應範例：

{
  "results": [
    {
      "competitiveVisibilityBenchmarkView": {
        "date": {
          "year": 2022,
          "month": 9,
          "day": 1
        },
        "reportCountryCode": "US",
        "reportCategoryId": "100",
        "trafficSource": "ORGANIC",
        "yourDomainVisibilityTrend": 0,
        "categoryBenchmarkVisibilityTrend": 0
      }
    },
    {
      "competitiveVisibilityBenchmarkView": {
        "date": {
          "year": 2022,
          "month": 9,
          "day": 2
        },
        "reportCountryCode": "US",
        "reportCategoryId": "100",
        "trafficSource": "ORGANIC",
        "yourDomainVisibilityTrend": 0.3,
        "categoryBenchmarkVisibilityTrend": -0.15
      }
    },
  ]
}

如要進一步瞭解可供查詢的欄位，請參閱「competitiveVisibilityBenchmarkView 資料表中的欄位」。