Transformasi laporan Search Ads 360 (Tidak digunakan lagi)

Pemetaan tabel untuk laporan Search Ads 360

Saat laporan Search Ads 360 (sebelumnya disebut Doubleclick Search) ditransfer ke BigQuery, laporan tersebut akan diubah menjadi tabel dan tampilan BigQuery berikut.

Saat Anda melihat tabel dan tampilan di BigQuery, nilai untuk advertiser_id adalah ID Pengiklan Search Ads 360 Anda.

Laporan Google Search Ads 360 Tabel BigQuery Tampilan BigQuery
Laporan akun 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
Laporan iklan p_Ad_advertiser_id
p_AdDeviceStats_advertiser_id
p_AdFloodlightAndDeviceStats_advertiser_id
Ad_advertiser_id
AdDeviceStats_advertiser_id
AdFloodlightAndDeviceStats_advertiser_id
Laporan 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
Laporan adGroupTarget p_AdGroupTarget_advertiser_id
p_AdGroupTargetDeviceStats_advertiser_id
p_AdGroupTargetFloodlightAndDeviceStats_advertiser_id
AdGroupTarget_advertiser_id
AdGroupTargetDeviceStats_advertiser_id
AdGroupTargetFloodlightAndDeviceStats_advertiser_id
Laporan bidStrategy p_BidStrategy_advertiser_id
p_BidStrategyStats_advertiser_id
BidStrategy_advertiser_id
BidStrategyStats_advertiser_id
Laporan kampanye 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
Laporan campaignTarget p_CampaignTarget_advertiser_id
p_CampaignTargetDeviceStats_advertiser_id
p_CampaignTargetFloodlightAndDeviceStats_advertiser_id
CampaignTarget_advertiser_id
CampaignTargetDeviceStats_advertiser_id
CampaignTargetFloodlightAndDeviceStats_advertiser_id
Laporan konversi p_Conversion_advertiser_id
Conversion_advertiser_id
Laporan feedItem p_FeedItem_advertiser_id
p_FeedItemStats_advertiser_id
p_FeedItemFloodlightStats_advertiser_id
FeedItem_advertiser_id
FeedItemStats_advertiser_id
FeedItemFloodlightStats_advertiser_id
Laporan floodlightActivity p_FloodlightActivity_advertiser_id
FloodlightActivity_advertiser_id
Laporan kata kunci 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
Laporan negativeAdGroupKeyword p_NegativeAdGroupKeyword_advertiser_id
NegativeAdGroupKeyword_advertiser_id
Laporan negativeAdGroupTarget p_NegativeAdGroupTarget_advertiser_id
NegativeAdGroupTarget_advertiser_id
Laporan negativeCampaignKeyword p_NegativeCampaignKeyword_advertiser_id
NegativeCampaignKeyword_advertiser_id
Laporan negativeCampaignTarget p_NegativeCampaignTarget_advertiser_id
NegativeCampaignTarget_advertiser_id
Laporan productAdvertised p_ProductAdvertised_advertiser_id
p_ProductAdvertisedDeviceStats_advertiser_id
p_ProductAdvertisedFloodlightAndDeviceStats_advertiser_id
ProductAdvertised_advertiser_id
ProductAdvertisedDeviceStats_advertiser_id
ProductAdvertisedFloodlightAndDeviceStats_advertiser_id
Laporan productGroup p_ProductGroup_advertiser_id
p_ProductGroupStats_advertiser_id
ProductGroup_advertiser_id
ProductGroupStats_advertiser_id
Laporan productLeadAndCrossSell p_ProductLeadAndCrossSellFloodlightStats_advertiser_id
ProductLeadAndCrossSellFloodlightStats_advertiser_id
Laporan kunjungan p_Visit_advertiser_id
Visit_advertiser_id

Pemetaan kolom untuk laporan Search Ads

Tabel BigQuery yang dibuat oleh transfer Search Ads 360 terdiri dari kolom berikut:

Tabel BigQuery Kolom
Laporan akun: Tabel Account account
accountCurrencyCode
accountEngineId
accountId
accountTimeZone
accountType
advertiserId
agencyId
creationTimestamp
lastModifiedTimestamp
status
Laporan akun: Tabel AccountDeviceStats accountEngineId
accountId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
clicks
cost
ctr
date
deviceSegment
impr
visits
Laporan akun: Tabel AccountFloodlightAndDeviceStats accountEngineId
accountId
advertiserId
agencyId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
floodlightActivityId
floodlightGroupId
Laporan akun: Tabel AccountStats accountEngineId
accountId
advertiserId
agencyId
date
displayBudgetLostImpressionShare
displayImpressionShare
displayRankLostImpressionShare
qualityScoreAvg
searchBudgetLostImpressionShare
searchImpressionShare
searchRankLostImpressionShare
topOfPageBidAvg
Laporan iklan: Tabel Ad accountId
ad
adDescription1
adDescription2
adDisplayUrl
adEngineId
adGroupId
adHeadline
adHeadline2
adId
adLabels
adLandingPage
adPromotionLine
adType
advertiserId
agencyId
campaignId
creationTimestamp
effectiveLabels
engineStatus
isUnattributedAd
lastModifiedTimestamp
status
Laporan iklan: Tabel AdDeviceStats accountId
adEngineId
adGroupId
adId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignId
clicks
cost
ctr
date
deviceSegment
impr
visits
Laporan iklan: Tabel AdFloodlightAndDeviceStats accountId
adEngineId
adGroupId
adId
advertiserId
agencyId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
floodlightActivityId
floodlightGroupId
Laporan adGroup: Tabel 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
Laporan adGroup: Tabel AdGroupDeviceStats accountId
adGroupEngineId
adGroupId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignId
clicks
cost
ctr
date
deviceSegment
effectiveBidStrategyId
impr
visits
Laporan adGroup: Tabel 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
Laporan adGroup: Tabel AdGroupFloodlightAndDeviceStats accountId
adGroupEngineId
adGroupId
advertiserId
agencyId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
floodlightActivityId
floodlightGroupId
Laporan adGroup: Tabel AdGroupFloodlightAndFeedItemStats accountId
adGroupEngineId
adGroupId
advertiserId
agencyId
campaignId
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
feedId
feedItemId
feedType
floodlightActivityId
floodlightGroupId
Laporan adGroup: Tabel AdGroupStats accountId
adGroupEngineId
adGroupId
advertiserId
agencyId
campaignId
date
displayImpressionShare
displayRankLostImpressionShare
effectiveBidStrategyId
qualityScoreAvg
searchImpressionShare
searchRankLostImpressionShare
topOfPageBidAvg
Laporan adGroupTarget: Tabel 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
Laporan adGroupTarget: Tabel 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
Laporan adGroupTarget: Tabel 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
Laporan pengiklan: Tabel Advertiser advertiser
advertiserCurrencyCode
advertiserId
agency
agencyId
creationTimestamp
dfaAdvertiserId
dfaNetworkId
dfaNetworkTimeZone
lastModifiedTimestamp
status
Laporan pengiklan: Tabel AdvertiserDeviceStats adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
clicks
cost
ctr
date
deviceSegment
dfaAdvertiserId
dfaNetworkId
impr
visits
Laporan pengiklan: Tabel AdvertiserFloodlightAndDeviceStats advertiserId
agencyId
date
deviceSegment
dfaActions
dfaAdvertiserId
dfaNetworkId
dfaRevenue
dfaTransactions
dfaWeightedActions
floodlightActivityId
floodlightGroupId
Laporan pengiklan: Tabel AdvertiserStats advertiserId
agencyId
date
dfaAdvertiserId
dfaNetworkId
displayBudgetLostImpressionShare
displayImpressionShare
displayRankLostImpressionShare
qualityScoreAvg
searchBudgetLostImpressionShare
searchImpressionShare
searchRankLostImpressionShare
topOfPageBidAvg
Laporan bidStrategy: Tabel BidStrategy advertiserId
agencyId
bidStrategy
bidStrategyGoal
bidStrategyId
bidStrategyMaxBid
bidStrategyMinBid
cpaTarget
creationTimestamp
ersTarget
floodlightActivityTargetIds
floodlightOptimizationEnabled
highPosition
lastModifiedTimestamp
lowPosition
monthlySpendTarget
roasTarget
status
Laporan bidStrategy: Tabel BidStrategyStats adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
bidStrategyId
clicks
cost
ctr
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
impr
visits
Laporan kampanye: Tabel 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
Laporan kampanye: Tabel CampaignDeviceStats accountId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignEngineId
campaignId
clicks
cost
ctr
date
deviceSegment
effectiveBidStrategyId
impr
visits
Laporan kampanye: Tabel CampaignFeedItemStats accountId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignEngineId
campaignId
clicks
clicksWithFeedItemShowing
cost
costWithFeedItemShowing
ctr
date
effectiveBidStrategyId
feedId
feedItemId
feedType
impr
visits
Laporan kampanye: Tabel CampaignFloodlightAndDeviceStats accountId
advertiserId
agencyId
campaignEngineId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
floodlightActivityId
floodlightGroupId
Laporan kampanye: Tabel CampaignFloodlightAndFeedItemStats accountId
advertiserId
agencyId
campaignEngineId
campaignId
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
feedId
feedItemId
feedType
floodlightActivityId
floodlightGroupId
Laporan kampanye: Tabel CampaignFloodtlightAndDeviceStats accountId
advertiserId
agencyId
campaignEngineId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
floodlightActivityId
floodlightGroupId
Laporan kampanye: Tabel 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
Laporan campaignTarget: Tabel CampaignTarget accountId
advertiserId
agencyId
campaignId
campaignTargetId
creationTimestamp
engineRemarketingList
engineRemarketingListBidModifier
lastModifiedTimestamp
locationTargetBidModifier
locationTargetName
status
Laporan campaignTarget: Tabel CampaignTargetDeviceStats accountId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignId
campaignTargetId
clicks
cost
ctr
date
deviceSegment
impr
visits
LaporanTarget campaign: Tabel CampaignTargetFloodlightAndDeviceStats accountId
advertiserId
agencyId
campaignId
campaignTargetId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
floodlightActivityId
floodlightGroupId
Laporan konversi: Tabel 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
Laporan feedItem: Tabel FeedItem accountId
advertiserId
agencyId
creationTimestamp
engineStatus
feedId
feedItemId
lastModifiedTimestamp
locationBusinessName
locationCategory
locationDetails
sitelinkClickserverUrl
sitelinkDescription1
sitelinkDescription2
sitelinkDisplayText
sitelinkLandingPageUrl
status
Laporan feedItem: Tabel FeedItemFloodlightStats accountId
advertiserId
agencyId
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
feedId
feedItemId
floodlightActivityId
floodlightGroupId
Laporan feedItem: Tabel FeedItemStats accountId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
clicks
clicksWithFeedItemShowing
cost
costWithFeedItemShowing
ctr
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
feedId
feedItemId
impr
visits
Laporan floodlightActivity: Tabel FloodlightActivity advertiserId
agencyId
creationTimestamp
floodlightActivity
floodlightActivityId
floodlightActivityTag
floodlightConfigurationId
floodlightGroup
floodlightGroupConversionType
floodlightGroupId
floodlightGroupTag
lastModifiedTimestamp
status
Laporan kata kunci: Tabel 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
Laporan kata kunci: Tabel KeywordDeviceStats accountId
adGroupId
adId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignId
clicks
cost
ctr
date
deviceSegment
effectiveBidStrategyId
impr
keywordEngineId
keywordId
visits
Laporan kata kunci: Tabel KeywordFloodlightAndDeviceStats accountId
adGroupId
adId
advertiserId
agencyId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
floodlightActivityId
floodlightGroupId
keywordEngineId
keywordId
Laporan kata kunci: Tabel KeywordStats accountId
adGroupId
advertiserId
agencyId
campaignId
effectiveBidStrategyId
keywordEngineId
keywordId
qualityScoreAvg
topOfPageBidAvg
Laporan negativeAdGroupKeyword : Tabel NegativeAdGroupKeyword accountId
adGroupId
advertiserId
agencyId
campaignId
creationTimestamp
engineStatus
lastModifiedTimestamp
negativeAdGroupKeywordId
negativeAdGroupKeywordMatchType
negativeAdGroupKeywordText
status
Laporan negatifAdGroupTarget: Tabel NegativeAdGroupTarget accountId
adGroupId
advertiserId
ageTargetAgeRange
agencyId
campaignId
creationTimestamp
dynamicSearchAdsTargetConditions
engineRemarketingList
genderTargetGenderType
lastModifiedTimestamp
locationTargetName
negativeAdGroupTargetId
status
Laporan negativeCampaignKeyword: Tabel NegativeCampaignKeyword accountId
advertiserId
agencyId
campaignId
creationTimestamp
engineStatus
lastModifiedTimestamp
negativeCampaignKeywordId
negativeCampaignKeywordMatchType
negativeCampaignKeywordText
status
Laporan negatifCampaignTarget: Tabel NegativeCampaignTarget accountId
advertiserId
ageTargetAgeRange
agencyId
campaignId
creationTimestamp
dynamicSearchAdsTargetConditions
engineRemarketingList
genderTargetGenderType
lastModifiedTimestamp
locationTargetName
negativeCampaignTargetId
status
Laporan productAdvertised: Tabel 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
Laporan productAdvertised: Tabel ProductAdvertisedDeviceStats adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
clicks
cost
ctr
date
deviceSegment
impr
productId
visits
Laporan productAdvertised: Tabel ProductAdvertisedFloodlightAndDeviceStats accountId
adGroupId
advertiserId
agencyId
campaignId
date
deviceSegment
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
floodlightActivityId
floodlightGroupId
productId
Laporan productGroup: Tabel ProductGroup accountId
adGroupId
advertiserId
agencyId
bidStrategyInherited
campaignId
creationTimestamp
effectiveBidStrategy
effectiveBidStrategyId
effectiveLabels
effectiveProductGroupMaxCpc
engineStatus
lastModifiedTimestamp
productGroup
productGroupClickserverUrl
productGroupId
productGroupLandingPage
productGroupMaxBid
productGroupMaxCpc
productGroupMinBid
productGroupPartitionType
status
Laporan productGroup: Tabel ProductGroupStats accountId
adGroupId
adWordsConversionValue
adWordsConversions
adWordsViewThroughConversions
advertiserId
agencyId
avgCpc
avgCpm
avgPos
campaignId
clicks
cost
ctr
date
dfaActions
dfaRevenue
dfaTransactions
dfaWeightedActions
effectiveBidStrategyId
impr
productGroupId
visits
Laporan productLeadAndCrossSell: Tabel 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
Laporan kunjungan: Tabel 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

Tabel Pencocokan Search Ads 360

Tabel Pencocokan Search Ads 360 adalah tabel yang hanya berisi kolom Atribut (kolom yang berisi setelan atau data tetap lainnya), dan ditentukan bagi pengguna untuk mengkueri informasi struktur akun.

Tabel Pencocokan Search Ads 360 mencakup hal berikut:

  • Akun
  • Iklan
  • Pengiklan
  • AdGroup
  • AdGroupTarget
  • BidStrategy
  • Kampanye
  • CampaignTarget
  • FeedItem
  • FloodlightActivity
  • Kata kunci
  • NegativeAdGroupKeyword
  • NegativeAdGroupTarget
  • NegativeCampaignKeyword
  • NegativeCampaignTarget
  • ProductAdvertised
  • ProductGroup
  • ProductLeadAndCrossSellFloodlightStats