検索広告 360 レポートの変換（非推奨）

注意: このドキュメントは、従来の検索広告 360 レポート API について記述しています。 BigQuery では、2024 年 5 月 31 日に従来の検索広告 360 レポート API のサポートを終了する予定です。検索広告 360 移行ガイドに従い、検索広告 360 転送ワークフローを移行して新しいバージョンの検索広告 360 を使用してください。 検索広告 360 リニューアル版レポート API を使用する検索広告 360 の最新の転送ガイドについては、検索広告 360 の転送をご覧ください。 このページは 2024 年 5 月 31 日に非推奨となります。

ベータ版

このプロダクトには、サービス固有の利用規約の「一般的なサービス規約」の「pre-GA サービス規約」が適用されます。 一般提供前のプロダクトは「現状のまま」ご利用いただけますが、サポートが制限される場合があります。 詳しくは、リリース ステージの説明をご覧ください。

検索広告 360 レポートのテーブル マッピング

検索広告 360（旧称 Doubleclick Search）レポートが BigQuery に転送されると、レポートは次の BigQuery テーブルとビューに変換されます。

BigQuery でテーブルとビューを表示する場合、advertiser_id の値は、検索広告 360 の広告主 ID です。

Google 検索広告 360 レポート	BigQuery テーブル	BigQuery ビュー
account レポート	p_Account_advertiser_id p_AccountDeviceStats_advertiser_id p_AccountFloodlightAndDeviceStats_advertiser_id p_AccountStats_advertiser_id	Account_advertiser_id AccountDeviceStats_advertiser_id AccountFloodlightAndDeviceStats_advertiser_id AccountStats_advertiser_id
ad レポート	p_Ad_advertiser_id p_AdDeviceStats_advertiser_id p_AdFloodlightAndDeviceStats_advertiser_id	Ad_advertiser_id AdDeviceStats_advertiser_id AdFloodlightAndDeviceStats_advertiser_id
adGroup レポート	p_AdGroup_advertiser_id p_AdGroupDeviceStats_advertiser_id p_AdGroupFloodlightAndFeedItemStats_advertiser_id p_AdGroupFloodlightAndDeviceStats_advertiser_id p_AdGroupStats_advertiser_id p_AdGroupFeedItemStats_advertiser_id	AdGroup_advertiser_id AdGroupDeviceStats_advertiser_id AdGroupFloodlightAndFeedItemStats_advertiser_id AdGroupFloodlightAndDeviceStats_advertiser_id AdGroupStats_advertiser_id AdGroupFeedItemStats_advertiser_id
adGroupTarget レポート	p_AdGroupTarget_advertiser_id p_AdGroupTargetDeviceStats_advertiser_id p_AdGroupTargetFloodlightAndDeviceStats_advertiser_id	AdGroupTarget_advertiser_id AdGroupTargetDeviceStats_advertiser_id AdGroupTargetFloodlightAndDeviceStats_advertiser_id
bidStrategy レポート	p_BidStrategy_advertiser_id p_BidStrategyStats_advertiser_id	BidStrategy_advertiser_id BidStrategyStats_advertiser_id
campaign レポート	p_Campaign_advertiser_id p_CampaignDeviceStats_advertiser_id p_CampaignFloodlightAndFeedItemStats_advertiser_id p_CampaignFloodtlightAndDeviceStats_advertiser_id (Deprecating) p_CampaignFloodlightAndDeviceStats_advertiser_id p_CampaignStats_advertiser_id p_CampaignFeedItemStats_advertiser_id	Campaign_advertiser_id CampaignDeviceStats_advertiser_id CampaignFloodlightAndFeedItemStats_advertiser_id CampaignFloodtlightAndDeviceStats_advertiser_id (Deprecating) CampaignFloodlightAndDeviceStats_advertiser_id CampaignStats_advertiser_id CampaignFeedItemStats_advertiser_id
campaignTarget レポート	p_CampaignTarget_advertiser_id p_CampaignTargetDeviceStats_advertiser_id p_CampaignTargetFloodlightAndDeviceStats_advertiser_id	CampaignTarget_advertiser_id CampaignTargetDeviceStats_advertiser_id CampaignTargetFloodlightAndDeviceStats_advertiser_id
conversion レポート	p_Conversion_advertiser_id	Conversion_advertiser_id
feedItem レポート	p_FeedItem_advertiser_id p_FeedItemStats_advertiser_id p_FeedItemFloodlightStats_advertiser_id	FeedItem_advertiser_id FeedItemStats_advertiser_id FeedItemFloodlightStats_advertiser_id
floodlightActivity レポート	p_FloodlightActivity_advertiser_id	FloodlightActivity_advertiser_id
keyword レポート	p_Keyword_advertiser_id p_KeywordDeviceStats_advertiser_id p_KeywordFloodlightAndDeviceStats_advertiser_id p_KeywordStats_advertiser_id	Keyword_advertiser_id KeywordDeviceStats_advertiser_id KeywordFloodlightAndDeviceStats_advertiser_id KeywordStats_advertiser_id
negativeAdGroupKeyword レポート	p_NegativeAdGroupKeyword_advertiser_id	NegativeAdGroupKeyword_advertiser_id
negativeAdGroupTarget レポート	p_NegativeAdGroupTarget_advertiser_id	NegativeAdGroupTarget_advertiser_id
negativeCampaignKeyword レポート	p_NegativeCampaignKeyword_advertiser_id	NegativeCampaignKeyword_advertiser_id
negativeCampaignTarget レポート	p_NegativeCampaignTarget_advertiser_id	NegativeCampaignTarget_advertiser_id
productAdvertised レポート	p_ProductAdvertised_advertiser_id p_ProductAdvertisedDeviceStats_advertiser_id p_ProductAdvertisedFloodlightAndDeviceStats_advertiser_id	ProductAdvertised_advertiser_id ProductAdvertisedDeviceStats_advertiser_id ProductAdvertisedFloodlightAndDeviceStats_advertiser_id
productGroup レポート	p_ProductGroup_advertiser_id p_ProductGroupStats_advertiser_id	ProductGroup_advertiser_id ProductGroupStats_advertiser_id
productLeadAndCrossSell レポート	p_ProductLeadAndCrossSellFloodlightStats_advertiser_id	ProductLeadAndCrossSellFloodlightStats_advertiser_id
visit レポート	p_Visit_advertiser_id	Visit_advertiser_id

検索広告レポートの列マッピング

検索広告 360 の転送によって作成される BigQuery テーブルは、次の列（フィールド）で構成されます。

BigQuery テーブル	列
account レポート: Account テーブル	account accountCurrencyCode accountEngineId accountId accountTimeZone accountType advertiserId agencyId creationTimestamp lastModifiedTimestamp status
account レポート: AccountDeviceStats テーブル	accountEngineId accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks cost ctr date deviceSegment impr visits
account レポート: AccountFloodlightAndDeviceStats テーブル	accountEngineId accountId advertiserId agencyId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId
account レポート: AccountStats テーブル	accountEngineId accountId advertiserId agencyId date displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare qualityScoreAvg searchBudgetLostImpressionShare searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
ad レポート: Ad テーブル	accountId ad adDescription1 adDescription2 adDisplayUrl adEngineId adGroupId adHeadline adHeadline2 adId adLabels adLandingPage adPromotionLine adType advertiserId agencyId campaignId creationTimestamp effectiveLabels engineStatus isUnattributedAd lastModifiedTimestamp status
ad レポート: AdDeviceStats テーブル	accountId adEngineId adGroupId adId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment impr visits
ad レポート: AdFloodlightAndDeviceStats テーブル	accountId adEngineId adGroupId adId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId
adGroup レポート: AdGroup テーブル	accountId adGroup adGroupBroadMaxCpc adGroupContentMaxCpc adGroupEndDate adGroupEngineId adGroupExactMaxCpc adGroupId adGroupLabels adGroupMobileBidAdjustment adGroupPhraseMaxCpc adGroupSearchMaxCpc adGroupStartDate advertiserId agencyId bidStrategyInherited bingAdsAdDistributions bingAdsLanguage campaignId cityTargets countryTargets creationTimestamp deviceTargets effectiveBidStrategyId effectiveCityTargets effectiveCountryTargets effectiveDeviceTargets effectiveLabels effectiveMetroTargets effectiveProvinceTargets engineRemarketingListTargetAll engineStatus lastModifiedTimestamp metroTargets provinceTargets status
adGroup レポート: AdGroupDeviceStats テーブル	accountId adGroupEngineId adGroupId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment effectiveBidStrategyId impr visits
adGroup レポート: AdGroupFeedItemStats テーブル	accountId adGroupEngineId adGroupId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks clicksWithFeedItemShowing cost costWithFeedItemShowing ctr date effectiveBidStrategyId feedId feedItemId feedType impr visits
adGroup レポート: AdGroupFloodlightAndDeviceStats テーブル	accountId adGroupEngineId adGroupId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId
adGroup レポート: AdGroupFloodlightAndFeedItemStats テーブル	accountId adGroupEngineId adGroupId advertiserId agencyId campaignId date dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId feedId feedItemId feedType floodlightActivityId floodlightGroupId
adGroup レポート: AdGroupStats テーブル	accountId adGroupEngineId adGroupId advertiserId agencyId campaignId date displayImpressionShare displayRankLostImpressionShare effectiveBidStrategyId qualityScoreAvg searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
adGroupTarget レポート: AdGroupTarget テーブル	account accountId accountType adGroup adGroupId adGroupStatus adGroupTargetId advertiser advertiserId ageTargetAgeRange ageTargetBidModifier agency agencyId campaign campaignId campaignStatus creationTimestamp dynamicSearchAdsTargetConditions dynamicSearchAdsTargetCoverage dynamicSearchAdsTargetCpcBid dynamicSearchAdsTargetLandingPageUrl engineRemarketingList engineRemarketingListBidModifier genderTargetBidModifier genderTargetGenderType lastModifiedTimestamp locationTargetBidModifier locationTargetName status
adGroupTarget レポート: AdGroupTargetDeviceStats テーブル	accountId adGroupId adGroupTargetId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId ageTargetAgeRange ageTargetBidModifier agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment dynamicSearchAdsTargetConditions dynamicSearchAdsTargetCoverage dynamicSearchAdsTargetCpcBid dynamicSearchAdsTargetLandingPageUrl engineRemarketingList engineRemarketingListBidModifier genderTargetBidModifier genderTargetGenderType impr locationTargetBidModifier locationTargetName visits
adGroupTarget レポート: AdGroupTargetFloodlightAndDeviceStats テーブル	accountId adGroupId adGroupTargetId advertiserId ageTargetAgeRange ageTargetBidModifier agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions dynamicSearchAdsTargetConditions dynamicSearchAdsTargetCoverage dynamicSearchAdsTargetCpcBid dynamicSearchAdsTargetLandingPageUrl engineRemarketingList engineRemarketingListBidModifier floodlightActivityId floodlightGroupId genderTargetBidModifier genderTargetGenderType locationTargetBidModifier locationTargetName
advertiser レポート: Advertiser テーブル	advertiser advertiserCurrencyCode advertiserId agency agencyId creationTimestamp dfaAdvertiserId dfaNetworkId dfaNetworkTimeZone lastModifiedTimestamp status
advertiser レポート: AdvertiserDeviceStats テーブル	adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks cost ctr date deviceSegment dfaAdvertiserId dfaNetworkId impr visits
advertiser レポート: AdvertiserFloodlightAndDeviceStats テーブル	advertiserId agencyId date deviceSegment dfaActions dfaAdvertiserId dfaNetworkId dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId
advertiser レポート: AdvertiserStats テーブル	advertiserId agencyId date dfaAdvertiserId dfaNetworkId displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare qualityScoreAvg searchBudgetLostImpressionShare searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg
bidStrategy レポート: BidStrategy テーブル	advertiserId agencyId bidStrategy bidStrategyGoal bidStrategyId bidStrategyMaxBid bidStrategyMinBid cpaTarget creationTimestamp ersTarget floodlightActivityTargetIds floodlightOptimizationEnabled highPosition lastModifiedTimestamp lowPosition monthlySpendTarget roasTarget status
bidStrategy レポート: BidStrategyStats テーブル	adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos bidStrategyId clicks cost ctr date dfaActions dfaRevenue dfaTransactions dfaWeightedActions impr visits
campaign レポート: Campaign テーブル	accountId adRotation adWordsBidStrategy advertiserId agencyId bidStrategyInherited bingAdsBudgetType campaign campaignEndDate campaignEngineId campaignId campaignLabels campaignMobileBidAdjustment campaignStartDate campaignType cityTargets countryTargets creationTimestamp dailyBudget deliveryMethod deviceTargets effectiveBidStrategyId effectiveCityTargets effectiveCountryTargets effectiveDeviceTargets effectiveLabels effectiveMetroTargets effectiveProvinceTargets engineStatus excludedCityTargets excludedCountryTargets excludedMetroTargets excludedProvinceTargets keywordNearMatchEnabled languageTargets lastModifiedTimestamp metroTargets monthlyBudget networkTarget provinceTargets status yahooGeoTargets yahooJapanBidStrategy
campaign レポート: CampaignDeviceStats テーブル	accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignEngineId campaignId clicks cost ctr date deviceSegment effectiveBidStrategyId impr visits
campaign レポート: CampaignFeedItemStats テーブル	accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignEngineId campaignId clicks clicksWithFeedItemShowing cost costWithFeedItemShowing ctr date effectiveBidStrategyId feedId feedItemId feedType impr visits
campaign レポート: CampaignFloodlightAndDeviceStats テーブル	accountId advertiserId agencyId campaignEngineId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId
campaign レポート: CampaignFloodlightAndFeedItemStats テーブル	accountId advertiserId agencyId campaignEngineId campaignId date dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId feedId feedItemId feedType floodlightActivityId floodlightGroupId
campaign レポート: CampaignFloodtlightAndDeviceStats テーブル	accountId advertiserId agencyId campaignEngineId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId
campaign レポート: CampaignStats テーブル	accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignEngineId campaignId clicks cost ctr date displayBudgetLostImpressionShare displayImpressionShare displayRankLostImpressionShare effectiveBidStrategyId impr qualityScoreAvg searchBudgetLostImpressionShare searchImpressionShare searchRankLostImpressionShare topOfPageBidAvg visits
campaignTarget レポート: CampaignTarget テーブル	accountId advertiserId agencyId campaignId campaignTargetId creationTimestamp engineRemarketingList engineRemarketingListBidModifier lastModifiedTimestamp locationTargetBidModifier locationTargetName status
campaignTarget レポート: CampaignTargetDeviceStats テーブル	accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId campaignTargetId clicks cost ctr date deviceSegment impr visits
campaignTarget レポート: CampaignTargetFloodlightAndDeviceStats テーブル	accountId advertiserId agencyId campaignId campaignTargetId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId
conversion レポート: Conversion テーブル	account accountId accountType adGroupId adId advertiser advertiserConversionId advertiserId agency agencyId campaignId conversionAttributionType conversionDate conversionId conversionLastModifiedTimestamp conversionQuantity conversionRevenue conversionSearchTerm conversionTimestamp conversionType conversionVisitExternalClickId conversionVisitId conversionVisitTimestamp deviceSegment feedId feedItemId feedType floodlightActivity floodlightActivityId floodlightActivityTag floodlightEventRequestString floodlightGroup floodlightGroupConversionType floodlightGroupId floodlightGroupTag floodlightOrderId floodlightOriginalRevenue floodlightReferrer inventoryAccountId keywordId productChannel productCountry productGroupId productId productLanguage productStoreId productTargetId status
feedItem レポート: FeedItem テーブル	accountId advertiserId agencyId creationTimestamp engineStatus feedId feedItemId lastModifiedTimestamp locationBusinessName locationCategory locationDetails sitelinkClickserverUrl sitelinkDescription1 sitelinkDescription2 sitelinkDisplayText sitelinkLandingPageUrl status
feedItem レポート: FeedItemFloodlightStats テーブル	accountId advertiserId agencyId date dfaActions dfaRevenue dfaTransactions dfaWeightedActions feedId feedItemId floodlightActivityId floodlightGroupId
feedItem レポート: FeedItemStats テーブル	accountId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks clicksWithFeedItemShowing cost costWithFeedItemShowing ctr date dfaActions dfaRevenue dfaTransactions dfaWeightedActions feedId feedItemId impr visits
floodlightActivity レポート: FloodlightActivity テーブル	advertiserId agencyId creationTimestamp floodlightActivity floodlightActivityId floodlightActivityTag floodlightConfigurationId floodlightGroup floodlightGroupConversionType floodlightGroupId floodlightGroupTag lastModifiedTimestamp status
keyword レポート: Keyword テーブル	accountId adGroupId advertiserId agencyId bidStrategyInherited bingKeywordParam2 bingKeywordParam3 campaignId creationTimestamp effectiveBidStrategyId effectiveKeywordMaxCpc effectiveLabels engineStatus isDisplayKeyword keywordClickserverUrl keywordEngineId keywordId keywordLabels keywordLandingPage keywordMatchType keywordMaxBid keywordMaxCpc keywordMinBid keywordText keywordUrlParams lastModifiedTimestamp qualityScoreCurrent status topOfPageBidCurrent
keyword レポート: KeywordDeviceStats テーブル	accountId adGroupId adId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date deviceSegment effectiveBidStrategyId impr keywordEngineId keywordId visits
keyword レポート: KeywordFloodlightAndDeviceStats テーブル	accountId adGroupId adId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId floodlightActivityId floodlightGroupId keywordEngineId keywordId
keyword レポート: KeywordStats テーブル	accountId adGroupId advertiserId agencyId campaignId effectiveBidStrategyId keywordEngineId keywordId qualityScoreAvg topOfPageBidAvg
negativeAdGroupKeyword レポート: NegativeAdGroupKeyword テーブル	accountId adGroupId advertiserId agencyId campaignId creationTimestamp engineStatus lastModifiedTimestamp negativeAdGroupKeywordId negativeAdGroupKeywordMatchType negativeAdGroupKeywordText status
negativeAdGroupTarget レポート: NegativeAdGroupTarget テーブル	accountId adGroupId advertiserId ageTargetAgeRange agencyId campaignId creationTimestamp dynamicSearchAdsTargetConditions engineRemarketingList genderTargetGenderType lastModifiedTimestamp locationTargetName negativeAdGroupTargetId status
negativeCampaignKeyword レポート: NegativeCampaignKeyword テーブル	accountId advertiserId agencyId campaignId creationTimestamp engineStatus lastModifiedTimestamp negativeCampaignKeywordId negativeCampaignKeywordMatchType negativeCampaignKeywordText status
negativeCampaignTarget レポート: NegativeCampaignTarget テーブル	accountId advertiserId ageTargetAgeRange agencyId campaignId creationTimestamp dynamicSearchAdsTargetConditions engineRemarketingList genderTargetGenderType lastModifiedTimestamp locationTargetName negativeCampaignTargetId status
productAdvertised レポート: ProductAdvertised テーブル	advertiserId agencyId creationTimestamp lastModifiedTimestamp productAgeGroup productAvailability productBrand productCategory productCategoryLevel1 productCategoryLevel2 productCategoryLevel3 productCategoryLevel4 productCategoryLevel5 productChannel productChannelExclusivity productColor productCondition productCostOfGoodsSold productCountry productCustomLabel0 productCustomLabel1 productCustomLabel2 productCustomLabel3 productCustomLabel4 productGender productGtin productId productItemGroupId productLandingPageUrl productLanguage productMaterial productMpn productPattern productPrice productSalePrice productSize productStoreId productTitle productTypeLevel1 productTypeLevel2 productTypeLevel3 productTypeLevel4 productTypeLevel5 status
productAdvertised レポート: ProductAdvertisedDeviceStats テーブル	adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos clicks cost ctr date deviceSegment impr productId visits
productAdvertised レポート: ProductAdvertisedFloodlightAndDeviceStats テーブル	accountId adGroupId advertiserId agencyId campaignId date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId productId
productGroup レポート: ProductGroup テーブル	accountId adGroupId advertiserId agencyId bidStrategyInherited campaignId creationTimestamp effectiveBidStrategy effectiveBidStrategyId effectiveLabels effectiveProductGroupMaxCpc engineStatus lastModifiedTimestamp productGroup productGroupClickserverUrl productGroupId productGroupLandingPage productGroupMaxBid productGroupMaxCpc productGroupMinBid productGroupPartitionType status
productGroup レポート: ProductGroupStats テーブル	accountId adGroupId adWordsConversionValue adWordsConversions adWordsViewThroughConversions advertiserId agencyId avgCpc avgCpm avgPos campaignId clicks cost ctr date dfaActions dfaRevenue dfaTransactions dfaWeightedActions effectiveBidStrategyId impr productGroupId visits
productLeadAndCrossSell レポート: ProductLeadAndCrossSellFloodlightStats テーブル	accountId adGroupId advertiserId agencyId campaignId crossSellAverageUnitPrice crossSellCostOfGoodsSold crossSellGrossFromUnitsSold crossSellGrossProfitMargin crossSellRevenueFromUnitsSold crossSellUnitsSold date deviceSegment dfaActions dfaRevenue dfaTransactions dfaWeightedActions floodlightActivityId floodlightGroupId leadAverageUnitPrice leadCostOfGoodsSold leadGrossProfitFromUnitsSold leadGrossProfitMargin leadRevenueFromUnitsSold leadUnitsSold productAverageUnitPrice productIdSold productId productRevenueFromUnitsSold productUnitsSold
visit レポート: Visit テーブル	account accountId accountType adGroupId adId advertiser advertiserId agency agencyId campaignId deviceSegment feedId feedItemId feedType inventoryAccountId keywordId productChannel productCountry productGroupId productId productLanguage productStoreId productTargetId status visitDate visitExternalClickId visitId visitNetworkType visitReferrer visitSearchQuery visitTimestamp

検索広告 360 マッチテーブル

検索広告 360 マッチテーブルは、[属性] フィールド（設定やその他の修正済みデータを含むフィールド）のみを含む表であり、アカウントの構造情報をクエリできるように定義されています。

注: 更新ウィンドウを使用したり、バックフィルをスケジューリングしたりしても、マッチテーブルのスナップショットは更新されません。

検索広告 360 のマッチテーブルには、次のものが含まれます。

• Account
• Ad
• Advertiser
• AdGroup
• AdGroupTarget
• BidStrategy
• Campaign
• CampaignTarget
• FeedItem
• FloodlightActivity
• Keyword
• NegativeAdGroupKeyword
• NegativeAdGroupTarget
• NegativeCampaignKeyword
• NegativeCampaignTarget
• ProductAdvertised
• ProductGroup
• ProductLeadAndCrossSellFloodlightStats