Search Ads 360 보고서 변환(지원 중단됨)
Search Ads 360 보고서의 테이블 매핑
Search Ads 360(이전 명칭: Doubleclick Search) 보고서가 BigQuery로 전송될 때 보고서는 다음과 같은 BigQuery 테이블 및 뷰로 변환됩니다.
BigQuery에서 테이블과 뷰를 볼 때 advertiser_id 값은 Search Ads 360 광고주 ID입니다.
Google Search Ads 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 (지원 중단됨) p_CampaignFloodlightAndDeviceStats_advertiser_id p_CampaignStats_advertiser_id p_CampaignFeedItemStats_advertiser_id |
Campaign_advertiser_id CampaignDeviceStats_advertiser_id CampaignFloodlightAndFeedItemStats_advertiser_id CampaignFloodtlightAndDeviceStats_advertiser_id (지원 중단됨) 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 |
Search Ads 보고서의 열 매핑
Search Ads 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 |
Search Ads 360 데이터 이동 색인
Search Ads 360 데이터 이동 색인은 속성 필드(설정 또는 다른 수정 데이터를 포함하는 필드)만 포함하는 테이블이며, 사용자가 계정 구조 정보를 쿼리할 수 있도록 정의됩니다.
Search Ads 360 데이터 이동 색인에는 다음이 포함됩니다.
- 계정
- 광고
- 광고주
- AdGroup
- AdGroupTarget
- BidStrategy
- 캠페인
- CampaignTarget
- FeedItem
- FloodlightActivity
- 키워드
- NegativeAdGroupKeyword
- NegativeAdGroupTarget
- NegativeCampaignKeyword
- NegativeCampaignTarget
- ProductAdvertised
- ProductGroup
- ProductLeadAndCrossSellFloodlightStats