Google 會運用 AI 技術將內容翻譯成你偏好的語言，但可能會出錯。

飯店廣告報表

您可以使用 Google Ads API 設計查詢，取得所需的飯店廣告報表。接著，您就可以將這些查詢併入用戶端應用程式。

必要條件

瞭解一般報表和查詢的運作方式。
瞭解如何查詢不同資源。

飯店廣告的基本查詢

請參閱這些查詢範例，熟悉如何使用 Google Ads API 取得飯店廣告報表。

取得點擊指標

下列範例查詢會從飯店成效檢視畫面傳回點擊次數。

SELECT metrics.clicks
FROM hotel_performance_view

查詢結果會與下列 JSON 回應類似：

{
  "results": [
    {
      "metrics": {
        "clicks": "78090"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      }
    }
  ],
  "totalResultsCount": "1",
  "fieldMask": "metrics.clicks"
}

取得廣告群組指標

下列廣告群組的範例查詢會取得過去 30 天的曝光次數和點擊次數，並按日期區隔。

SELECT
  campaign.name,
  campaign.status,
  ad_group.name,
  segments.date,
  metrics.impressions,
  metrics.clicks
FROM ad_group
WHERE ad_group.type = HOTEL_ADS
  AND segments.date DURING LAST_30_DAYS

查詢結果類似於下列 JSON 回應。系統會篩選回應，只顯示符合 WHERE 子句條件的指標。由於選取了 segments.date，查詢會在 30 天的期間內，每天傳回一列資料。

{
  "results": [
    {
      "campaign": {
        "resourceName": "customers/1234567890/campaigns/23456789",
        "name": "test campaign",
        "status": "ENABLED"
      },
      "adGroup": {
        "resourceName": "customers/1234567890/adGroups/11111111",
        "name": "test adgroup"
      },
      "metrics": {
        "clicks": "91",
        "impressions": "5145"
      },
      "segments": {
        "date": "2020-05-10"
      }
    }
  ]
}

取得已啟用的廣告群組廣告

下列廣告群組廣告的範例查詢會取得將放送的廣告群組。如要放送廣告群組廣告，廣告群組廣告、廣告群組和廣告活動都必須啟用。

SELECT
  ad_group.id,
  ad_group.name,
  ad_group.status,
  campaign.name,
  campaign.status,
  ad_group_ad.status
FROM ad_group_ad
WHERE ad_group_ad.status = ENABLED
  AND campaign.status = ENABLED
  AND ad_group.status = ENABLED

查詢結果會與下列 JSON 回應類似：

{
  "results": [
    {
      "campaign": {
        "resourceName": "customers/1234567890/campaigns/23456789",
        "name": "test campaign",
        "status": "ENABLED"
      },
      "adGroup": {
        "resourceName": "customers/1234567890/adGroups/11111111",
        "id": "11111111",
        "name": "test adgroup",
        "status": "ENABLED"
      },
      "adGroupAd": {
        "resourceName": "customers/1234567890/adGroupAds/11111111~33333333",
        "status": "ENABLED",
        "ad": {
          "resourceName": "customers/1234567890/ads/77777777"
        }
      }
    }
  ]
}

飯店廣告報表的實用檢視畫面

在先前的飯店廣告報表 API 中，您可以擷取特定報表，例如成效報表。在 Google Ads API 中，這類資料會以個別的 *_view 資源表示，例如 hotel_performance_view 和 hotel_group_view。本節說明有助於飯店廣告報表的 *_view 資源，並提供查詢範例。

飯店群組檢視畫面

飯店群組檢視畫面是條件檢視畫面，因此可用於擷取飯店群組特定條件類型的指標。

以下飯店群組檢視查詢範例會取得整個飯店產品資訊群組樹狀結構中，每個飯店的點擊次數，包括根節點 (「所有飯店」)。

SELECT
  metrics.clicks,
  ad_group_criterion.listing_group.case_value.hotel_id.value
FROM hotel_group_view

查詢結果類似於下列 JSON 回應。由於根節點 (「所有飯店」) 的 case_value 未定義，因此第一列代表「所有飯店」商家資訊群組的指標，第二列則代表「其他」的子項商家資訊群組指標。

{
  "results": [
    {
      "metrics": {
        "clicks": "5"
      },
      "adGroupCriterion": {
        "resourceName": "customers/1234567890/adGroupCriteria/2222222~1111111"
      },
      "hotelGroupView": {
        "resourceName": "customers/1234567890/hotelGroupViews/2222222~1111111"
      }
    },
    {
      "metrics": {
        "clicks": "0"
      },
      "adGroupCriterion": {
        "resourceName": "customers/1234567890/adGroupCriteria/2222222~1111112",
        "listingGroup": {
          "caseValue": {
            "hotelId": {}
          }
        }
      },
      "hotelGroupView": {
        "resourceName": "customers/1234567890/hotelGroupViews/2222222~1111112"
      }
    },
    {
      "metrics": {
        "clicks": "3"
      },
      "adGroupCriterion": {
        "resourceName": "customers/1234567890/adGroupCriteria/2222222~1111113",
        "listingGroup": {
          "caseValue": {
            "hotelId": {
              "value": "11111111111111111"
            }
          }
        }
      },
      "hotelGroupView": {
        "resourceName": "customers/1234567890/hotelGroupViews/2222222~1111113"
      }
    },
    {
      "metrics": {
        "clicks": "2"
      },
      "adGroupCriterion": {
        "resourceName": "customers/1234567890/adGroupCriteria/2222222~1111114",
        "listingGroup": {
          "caseValue": {
            "hotelId": {
              "value": "11111111111111112"
            }
          }
        }
      },
      "hotelGroupView": {
        "resourceName": "customers/1234567890/hotelGroupViews/2222222~1111114"
      }
    }
  ]
}

飯店成效檢視畫面

如果您想使用非飯店群組的資料，擷取飯店的成效指標，即使您有以飯店 ID 為依據的細分項目，飯店成效檢視畫面也很有用。

以下是飯店成效檢視畫面的查詢範例，可取得點擊次數，並依飯店 ID 細分結果。

SELECT
  segments.partner_hotel_id,
  metrics.clicks
FROM hotel_performance_view

查詢結果類似於下列 JSON 回應。點擊次數會依 partner_hotel_id (REST JSON 中的 partnerHotelId) 分段，因此同一個 hotel_performance_view 可能會傳回兩個以上的物件。

{
  "results": [
    {
      "metrics": {
        "clicks": "7055"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "partnerHotelId": "1111"
      }
    },
    {
      "metrics": {
        "clicks": "3047"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "partnerHotelId": "1112"
      }
    }
  ]
}

廣告群組目標對象檢視畫面

如要擷取在廣告群組層級附加的目標對象成效指標，廣告群組目標對象檢視畫面就非常實用。

下列查詢會針對每個 ad_group_criterion.user_list.user_list 傳回一列。

SELECT
  ad_group.id,
  campaign.id,
  ad_group_criterion.user_list.user_list,
  segments.device,
  segments.hotel_date_selection_type,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.conversions,
  metrics.all_conversions_value
FROM ad_group_audience_view

查詢結果會與下列 JSON 回應類似：

{
  "results": [
    {
      "campaign": {
        "resourceName": "customers/1234567890/campaigns/23456789",
        "id": "23456789"
      },
      "metrics": {
        "clicks": "0",
        "conversions": "0",
        "costMicros": "0",
        "impressions": "3",
        "allConversionsValue": "0"
      },
      "adGroupCriterion": {
        "resourceName": "customers/1234567890/adGroupCriteria/23456789~789456",
        "userList": {
          "userList": "customers/1234567890/userLists/456789"
        }
      },
      "adGroupAudienceView": {
        "resourceName":
          "customers/1234567890/adGroupAudienceViews/23456789~789456"
      },
      "segments": {
        "device": "TABLET",
        "hotelDateSelectionType": "USER_SELECTED"
      }
    }
  ]
}

廣告活動目標對象檢視畫面

如果您想擷取廣告活動層級目標對象的成效指標，廣告活動目標對象檢視畫面就非常實用。

下列查詢會針對每個 campaign_criterion.user_list.user_list 傳回一列。

SELECT
  campaign.id,
  campaign_criterion.user_list.user_list,
  segments.device,
  segments.hotel_date_selection_type,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.conversions,
  metrics.all_conversions_value
FROM campaign_audience_view

查詢結果會與下列 JSON 回應類似：

{
  "results": [
    {
      "campaign": {
        "resourceName": "customers/1234567890/campaigns/23456789",
        "id": "23456789"
      },
      "metrics": {
        "clicks": "0",
        "conversions": "0",
        "costMicros": "0",
        "impressions": "3",
        "allConversionsValue": "0"
      },
      "campaignCriterion": {
        "resourceName": "customers/1234567890/campaignCriteria/23456789~789456",
        "userList": {
          "userList": "customers/1234567890/userLists/456789"
        }
      },
      "campaignAudienceView": {
        "resourceName":
          "customers/1234567890/campaignAudienceViews/23456789~789456"
      },
      "segments": {
        "device": "TABLET",
        "hotelDateSelectionType": "USER_SELECTED"
      }
    }
  ]
}

實用的飯店廣告報表

本節提供幾份實用的報表，專為飯店廣告設計。

成效報表

這些查詢會使用飯店成效檢視畫面取得成效資料。

hotel_performance_view 可讓您使用 campaign 資源區隔指標。舉例來說，您可以使用 campaign.id 欄位，依廣告活動取得成效指標。

效能

查詢範例：

SELECT
  segments.hotel_center_id,
  segments.device,
  segments.partner_hotel_id,
  segments.hotel_check_in_day_of_week,
  segments.hotel_date_selection_type,
  segments.hotel_length_of_stay,
  segments.hotel_booking_window_days,
  metrics.search_top_impression_share,
  metrics.search_absolute_top_impression_share,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.conversions,
  metrics.all_conversions_value,
  metrics.search_impression_share
FROM hotel_performance_view

JSON 回應範例：

{
  "results": [
    {
      "campaign": {
        "resourceName": "customers/1234567890/campaigns/23456789"
      },
      "metrics": {
        "clicks": "0",
        "conversions": "0.0",
        "costMicros": "0",
        "impressions": "0",
        "searchImpressionShare": "0.0999",
        "searchAbsoluteTopImpressionShare": "0.0999",
        "searchTopImpressionShare": "0.0999",
        "allConversionsValue": "1"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "device": "DESKTOP",
        "hotelBookingWindowDays": "3",
        "hotelCenterId": "1234",
        "hotelCheckInDayOfWeek": "MONDAY",
        "hotelDateSelectionType": "USER_SELECTED",
        "hotelLengthOfStay": "4",
        "partnerHotelId": "123"
      }
    },
    {
      "campaign": {
        "resourceName": "customers/1234567890/campaigns/23456789"
      },
      "metrics": {
        "clicks": "0",
        "conversions": "0.0",
        "costMicros": "0",
        "impressions": "1",
        "searchImpressionShare": "1.0",
        "searchAbsoluteTopImpressionShare": "0.0999",
        "searchTopImpressionShare": "1.0",
        "allConversionsValue": "1"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "device": "DESKTOP",
        "hotelBookingWindowDays": "3",
        "hotelCenterId": "1234",
        "hotelCheckInDayOfWeek": "MONDAY",
        "hotelDateSelectionType": "USER_SELECTED",
        "hotelLengthOfStay": "4",
        "partnerHotelId": "123"
      }
    }
  ]
}

按點擊類型顯示成效

查詢範例：

SELECT
  segments.click_type,
  segments.hotel_center_id,
  segments.device,
  segments.partner_hotel_id,
  segments.hotel_check_in_day_of_week,
  segments.hotel_date_selection_type,
  segments.hotel_length_of_stay,
  segments.hotel_booking_window_days,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.conversions,
  metrics.all_conversions_value
FROM hotel_performance_view

JSON 回應範例：

{
  "results": [
    {
      "campaign": {
        "resourceName": "customers/1234567890/campaigns/23456789"
      },
      "metrics": {
        "clicks": "0",
        "conversions": "0.0",
        "costMicros": "0",
        "impressions": "1",
        "allConversionsValue": "0.0"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "device": "DESKTOP",
        "hotelBookingWindowDays": "0",
        "hotelCenterId": "1234",
        "hotelCheckInDayOfWeek": "TUESDAY",
        "hotelDateSelectionType": "USER_SELECTED",
        "hotelLengthOfStay": "4",
        "partnerHotelId": "123",
        "clickType": "HOTEL_PRICE"
      }
    },
    {
      "campaign": {
        "resourceName": "customers/1234567890/campaigns/23456789"
      },
      "metrics": {
        "clicks": "1",
        "conversions": "0.0",
        "costMicros": "0",
        "impressions": "1",
        "allConversionsValue": "0.0"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "device": "DESKTOP",
        "hotelBookingWindowDays": "0",
        "hotelCenterId": "1234",
        "hotelCheckInDayOfWeek": "TUESDAY",
        "hotelDateSelectionType": "USER_SELECTED",
        "hotelLengthOfStay": "4",
        "partnerHotelId": "12345",
        "clickType": "HOTEL_PRICE"
      }
    }
  ]
}

條件式費率成效報表

下列查詢會取得依下列項目區隔的成效指標：

campaign
hotel_center_id
hotel_country
hotel_rate_rule_id
hotel_rate_type
device
partner_hotel_id

如需類型說明，請參閱 HotelRateType。

查詢中可以包含多個區隔，但隨著區隔增加，傳回的資料列數量可能會大幅增加。

SELECT
  campaign.id,
  segments.hotel_center_id,
  segments.hotel_country,
  segments.hotel_rate_rule_id,
  segments.hotel_rate_type,
  segments.device,
  segments.partner_hotel_id,
  metrics.search_top_impression_share,
  metrics.search_absolute_top_impression_share,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.conversions
FROM hotel_performance_view

查詢結果會與下列 JSON 回應類似：

{
  "results": [
    {
      "campaign": {
        "resourceName": "customers/1234567890/campaigns/23456789",
        "id": "23456789"
      },
      "metrics": {
        "clicks": "1",
        "conversions": "0.0",
        "costMicros": "0",
        "impressions": "24",
        "searchAbsoluteTopImpressionShare": "0.0999",
        "searchTopImpressionShare": "0.17073170731707318"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "device": "TABLET",
        "hotelCenterId": "1234",
        "partnerHotelId": "123",
        "hotelRateRuleId": "desktop",
        "hotelRateType": "PUBLIC_RATE"
      }
    },
    {
      "campaign": {
        "resourceName": "customers/1234567890/campaigns/23456789",
        "id": "23456789"
      },
      "metrics": {
        "clicks": "107",
        "conversions": "0.0",
        "costMicros": "0",
        "impressions": "1668",
        "searchAbsoluteTopImpressionShare": "0.0999",
        "searchTopImpressionShare": "0.3581201665675193"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "device": "TABLET",
        "hotelCenterId": "1234",
        "partnerHotelId": "1235",
        "hotelRateRuleId": "desktop",
        "hotelRateType": "PUBLIC_RATE"
      }
    }
  ]
}

價格競爭力報表

你可以深入瞭解自家飯店的價格與競爭對手在相同飯店行程中的價格相比，

查詢範例：

SELECT
  segments.hotel_center_id,
  segments.partner_hotel_id,
  segments.hotel_price_bucket,
  metrics.hotel_average_lead_value_micros,
  metrics.hotel_price_difference_percentage
FROM hotel_performance_view

JSON 回應範例：

{
  "results": [
    {
      "metrics": {
        "hotelAverageLeadValueMicros": "96416341.829268292",
        "hotelPriceDifferencePercentage": "-0.014627310872986811"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "hotelCenterId": "1234",
        "partnerHotelId": "123",
        "hotelPriceBucket": "LOWEST_TIED"
      }
    }
  ]
}

平均預訂價格報表

你可以取得計算飯店平均預訂價格所需的資料 (all_conversions_value 除以 conversions)。

查詢範例：

SELECT
  segments.hotel_center_id,
  segments.partner_hotel_id,
  segments.hotel_price_bucket,
  metrics.all_conversions_value,
  metrics.conversions
FROM hotel_performance_view

JSON 回應範例：

{
  "results": [
    {
      "metrics": {
        "allConversionsValue": "123.5",
        "conversions": "1"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "hotelCenterId": "1234",
        "partnerHotelId": "123",
        "hotelPriceBucket": "LOWEST_TIED"
      }
    }
  ]
}

轉換和費用成效報表

以下查詢會取得飯店廣告的整體轉換和費用成效，有助於評估財務成效和廣告投資報酬率。

查詢範例：

SELECT
  segments.date,
  segments.partner_hotel_id,
  metrics.all_conversions_value,
  metrics.cost_micros,
  metrics.conversions
FROM hotel_performance_view
WHERE segments.date DURING LAST_30_DAYS

JSON 回應範例：

{
  "results": [
    {
      "metrics": {
        "allConversionsValue": "250.0",
        "costMicros": "15000000",
        "conversions": "2.0"
      },
      "hotelPerformanceView": {
        "resourceName": "customers/1234567890/hotelPerformanceView"
      },
      "segments": {
        "date": "2026-03-24",
        "partnerHotelId": "123"
      }
    }
  ]
}

目標對象報表

目標對象報表會顯示 Google Ads 目標對象名單的競價倍數成效。如需目標對象報表示例，請參閱「廣告群組目標對象檢視」和「廣告活動目標對象檢視」中的查詢範例。

調整出價

搜尋廣告旅遊動態饋給

飯店廣告報表 透過集合功能整理內容 你可以依據偏好儲存及分類內容。

必要條件

飯店廣告的基本查詢

取得點擊指標

取得廣告群組指標

取得已啟用的廣告群組廣告

飯店廣告報表的實用檢視畫面

飯店群組檢視畫面

飯店成效檢視畫面

廣告群組目標對象檢視畫面

廣告活動目標對象檢視畫面

實用的飯店廣告報表

成效報表

效能

按點擊類型顯示成效

條件式費率成效報表

價格競爭力報表

平均預訂價格報表

轉換和費用成效報表

目標對象報表

飯店廣告報表