Google AdWords Report Transformation

When your Google AdWords reports are transferred to BigQuery, the reports are transformed into the following BigQuery tables:

Google AdWords report BigQuery table(s)
ACCOUNT_PERFORMANCE_REPORT

Customer

HourlyAccountConversionStats

AccountConversionStats

HourlyAccountStats

AccountNonClickStats

AccountBasicStats

AccountStats

AD_PERFORMANCE_REPORT

AdBasicStats

AdCrossDeviceStats

AdConversionStats

AdStats

AdCrossDeviceConversionStats

Ad

ADGROUP_PERFORMANCE_REPORT

AdGroupStats

AdGroupBasicStats

AdGroupCrossDeviceStats

HourlyAdGroupConversionStats

HourlyAdGroupStats

AdGroupConversionStats

AdGroupCrossDeviceConversionStats

AdGroup

AUDIENCE_PERFORMANCE_REPORT

Audience

AudienceConversionStats

AudienceNonClickStats

AudienceBasicStats

AudienceStats

CAMPAIGN_LOCATION_TARGET_REPORT

CampaignLocationTargetStats

LocationBasedCampaignCriterion

CAMPAIGN_PERFORMANCE_REPORT

Campaign

CampaignBasicStats

CampaignConversionStats

CampaignCrossDeviceStats

HourlyCampaignConversionStats

CampaignStats

HourlyCampaignStats

CampaignCrossDeviceConversionStats

CampaignCookieStats

CLICK_PERFORMANCE_REPORT ClickStats
GEO_PERFORMANCE_REPORT

GeoConversionStats

GeoStats

KEYWORDS_PERFORMANCE_REPORT

Keyword

KeywordBasicStats

KeywordCrossDeviceStats

KeywordStats

KeywordCrossDeviceConversionStats

KeywordConversionStats

PAID_ORGANIC_QUERY_REPORT PaidOrganicStats
PLACEMENT_PERFORMANCE_REPORT

PlacementBasicStats

PlacementNonClickStats

PlacementStats

Placement

PlacementConversionStats

SEARCH_QUERY_PERFORMANCE_REPORT

SearchQueryStats

SearchQueryConversionStats

SHOPPING_PERFORMANCE_REPORT

ShoppingProductConversionStats

ShoppingProductStats

VIDEO_PERFORMANCE_REPORT

VideoBasicStats

VideoConversionStats

VideoStats

Video

VideoNonClickStats

The BigQuery tables created by an AdWords transfer consist of the following fields:

BigQuery table(s) Fields
ACCOUNT_PERFORMANCE_REPORT: Customer table

source

AccountCurrencyCode

AccountDescriptiveName

AccountTimeZone

CanManageClients

CustomerDescriptiveName

ExternalCustomerId

IsAutoTaggingEnabled

IsTestAccount

ACCOUNT_PERFORMANCE_REPORT: AccountStats table

ActiveViewCpm

ActiveViewCtr

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdNetworkType1

AdNetworkType2

AverageCost

AverageCpc

AverageCpm

AveragePosition

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerConversion

Ctr

Date

DayOfWeek

Device

ExternalCustomerId

Impressions

InteractionRate

Interactions

InteractionTypes

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

Week

Year

ACCOUNT_PERFORMANCE_REPORT: AccountConversionStats table

AdNetworkType1

AdNetworkType2

ClickType

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerConversion

Date

DayOfWeek

Device

ExternalCustomerId

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

Week

Year

ACCOUNT_PERFORMANCE_REPORT: HourlyAccountStats table

ActiveViewCpm

ActiveViewCtr

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdNetworkType1

AdNetworkType2

AverageCost

AverageCpc

AverageCpm

AveragePosition

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerConversion

Ctr

Date

DayOfWeek

Device

ExternalCustomerId

HourOfDay

Impressions

InteractionRate

Interactions

InteractionTypes

Month

MonthOfYear

Quarter

ValuePerConversion

Week

Year

ACCOUNT_PERFORMANCE_REPORT: HourlyAccountConversionStats table

AdNetworkType1

AdNetworkType2

ClickType

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerConversion

Date

DayOfWeek

Device

ExternalCustomerId

HourOfDay

Month

MonthOfYear

Quarter

ValuePerConversion

Week

Year

ACCOUNT_PERFORMANCE_REPORT: AccountNonClickStats table

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

AverageCpe

AverageCpv

ContentBudgetLostImpressionShare

ContentImpressionShare

ContentRankLostImpressionShare

CostPerAllConversion

CrossDeviceConversions

Date

DayOfWeek

Device

EngagementRate

Engagements

ExternalCustomerId

InvalidClickRate

InvalidClicks

Month

MonthOfYear

Quarter

SearchBudgetLostImpressionShare

SearchExactMatchImpressionShare

SearchImpressionShare

SearchRankLostImpressionShare

ValuePerAllConversion

VideoViewRate

VideoViews

Week

Year

ACCOUNT_PERFORMANCE_REPORT: AccountBasicStats table

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdNetworkType1

AdNetworkType2

AveragePosition

Clicks

Conversions

ConversionValue

Cost

Date

Device

ExternalCustomerId

Impressions

Interactions

InteractionTypes

Slot

ViewThroughConversions

AD_PERFORMANCE_REPORT: Ad table

AdGroupId

AdType

BusinessName

CallOnlyPhoneNumber

CampaignId

CombinedApprovalStatus

CreativeDestinationUrl

CreativeFinalAppUrls

CreativeFinalMobileUrls

CreativeFinalUrls

CreativeTrackingUrlTemplate

CreativeUrlCustomParameters

Description

Description1

Description2

DevicePreference

DisplayUrl

EnhancedDisplayCreativeLogoImageMediaId

EnhancedDisplayCreativeMarketingImageMediaId

ExternalCustomerId

Headline

HeadlinePart1

HeadlinePart2

Id (changed from CreativeId)

ImageAdUrl

ImageCreativeImageHeight

ImageCreativeImageWidth

ImageCreativeMimeType

ImageCreativeName

LabelIds

Labels

LongHeadline

Path1

Path2

PolicySummary

ShortHeadline

Status

AD_PERFORMANCE_REPORT: AdStats table

ActiveViewCpm

ActiveViewCtr

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AverageCost

AverageCpc

AverageCpm

AveragePosition

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerConversion

CostPerCurrentModelAttributedConversion

CriterionId

CriterionType

Ctr

CurrentModelAttributedConversions

CurrentModelAttributedConversionValue

Date

DayOfWeek

Device

ExternalCustomerId

GmailForwards

GmailSaves

GmailSecondaryClicks

Id (changed from CreativeId)

Impressions

InteractionRate

Interactions

InteractionTypes

IsNegative

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

ValuePerCurrentModelAttributedConversion

Week

Year

AD_PERFORMANCE_REPORT: AdConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

BaseAdGroupId

BaseCampaignId

CampaignId

ClickType

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerConversion

CriterionId

CriterionType

Date

DayOfWeek

Device

ExternalCustomerId

Id (changed from CreativeId)

IsNegative

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

Week

Year

AD_PERFORMANCE_REPORT: AdCrossDeviceStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

AverageCpe

AverageCpv

AveragePageviews

AverageTimeOnSite

BaseAdGroupId

BaseCampaignId

BounceRate

CampaignId

ClickAssistedConversions

ClickAssistedConversionsOverLastClickConversions

ClickAssistedConversionValue

CostPerAllConversion

CriterionId

CriterionType

CrossDeviceConversions

Date

DayOfWeek

EngagementRate

Engagements

ExternalCustomerId

Id (changed from CreativeId)

ImpressionAssistedConversions

ImpressionAssistedConversionsOverLastClickConversions

ImpressionAssistedConversionValue

IsNegative

Month

MonthOfYear

PercentNewVisitors

Quarter

ValuePerAllConversion

VideoQuartile100Rate

VideoQuartile25Rate

VideoQuartile50Rate

VideoQuartile75Rate

VideoViewRate

VideoViews

Week

Year

AD_PERFORMANCE_REPORT: AdCrossDeviceConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

BaseAdGroupId

BaseCampaignId

CampaignId

ConversionCategoryName

ConversionTrackerId

ConversionTypeName

CostPerAllConversion

CriterionId

CriterionType

CrossDeviceConversions

Date

DayOfWeek

ExternalCustomerId

Id (changed from CreativeId)

IsNegative

Month

MonthOfYear

Quarter

ValuePerAllConversion

Week

Year

AD_PERFORMANCE_REPORT: AdBasicStats table

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AveragePosition

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

Conversions

ConversionValue

Cost

CriterionId

CriterionType

Date

Device

ExternalCustomerId

Id (changed from CreativeId)

Impressions

Interactions

InteractionTypes

IsNegative

Slot

ViewThroughConversions

ADGROUP_PERFORMANCE_REPORT: AdGroup table

AdGroupDesktopBidModifier

AdGroupId

AdGroupMobileBidModifier

AdGroupName

AdGroupStatus

AdGroupTabletBidModifier

AdGroupType

BiddingStrategyId

BiddingStrategyName

BiddingStrategySource

BiddingStrategyType

BidType

CampaignId

ContentBidCriterionTypeGroup

CpcBid

CpmBid

CpvBid

EffectiveTargetRoas

EffectiveTargetRoasSource

EnhancedCpcEnabled

EnhancedCpvEnabled

ExternalCustomerId

LabelIds

Labels

TargetCpa

TargetCpaBidSource

TrackingUrlTemplate

UrlCustomParameters

ADGROUP_PERFORMANCE_REPORT: AdGroupStats table

ActiveViewCpm

ActiveViewCtr

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AverageCost

AverageCpc

AverageCpm

AveragePosition

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerConversion

CostPerCurrentModelAttributedConversion

Ctr

CurrentModelAttributedConversions

CurrentModelAttributedConversionValue

Date

DayOfWeek

Device

ExternalCustomerId

GmailForwards

GmailSaves

GmailSecondaryClicks

Impressions

InteractionRate

Interactions

InteractionTypes

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

ValuePerCurrentModelAttributedConversion

Week

Year

ADGROUP_PERFORMANCE_REPORT: AdGroupConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

BaseAdGroupId

BaseCampaignId

CampaignId

ClickType

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerConversion

Date

DayOfWeek

Device

ExternalCustomerId

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

Week

Year

ADGROUP_PERFORMANCE_REPORT: AdGroupCrossDeviceStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

AverageCpe

AverageCpv

AveragePageviews

AverageTimeOnSite

BaseAdGroupId

BaseCampaignId

BounceRate

CampaignId

ClickAssistedConversions

ClickAssistedConversionsOverLastClickConversions

ClickAssistedConversionValue

ContentImpressionShare

ContentRankLostImpressionShare

CostPerAllConversion

CrossDeviceConversions

Date

DayOfWeek

EngagementRate

Engagements

ExternalCustomerId

ImpressionAssistedConversions

ImpressionAssistedConversionsOverLastClickConversions

ImpressionAssistedConversionValue

Month

MonthOfYear

NumOfflineImpressions

NumOfflineInteractions

OfflineInteractionRate

PercentNewVisitors

Quarter

RelativeCtr

SearchExactMatchImpressionShare

SearchImpressionShare

SearchRankLostImpressionShare

ValuePerAllConversion

VideoQuartile100Rate

VideoQuartile25Rate

VideoQuartile50Rate

VideoQuartile75Rate

VideoViewRate

VideoViews

Week

Year

ADGROUP_PERFORMANCE_REPORT: AdGroupCrossDeviceConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

BaseAdGroupId

BaseCampaignId

CampaignId

ConversionCategoryName

ConversionTrackerId

ConversionTypeName

CostPerAllConversion

CrossDeviceConversions

Date

DayOfWeek

ExternalCustomerId

Month

MonthOfYear

Quarter

ValuePerAllConversion

Week

Year

ADGROUP_PERFORMANCE_REPORT: HourlyAdGroupStats table

ActiveViewCpm

ActiveViewCtr

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AverageCost

AverageCpc

AverageCpm

AveragePosition

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerConversion

CostPerCurrentModelAttributedConversion

Ctr

CurrentModelAttributedConversions

CurrentModelAttributedConversionValue

Date

DayOfWeek

Device

ExternalCustomerId

GmailForwards

GmailSaves

GmailSecondaryClicks

HourOfDay

Impressions

InteractionRate

Interactions

InteractionTypes

Month

MonthOfYear

Quarter

ValuePerConversion

ValuePerCurrentModelAttributedConversion

Week

Year

ADGROUP_PERFORMANCE_REPORT: HourlyAdGroupConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

BaseAdGroupId

BaseCampaignId

CampaignId

ClickType

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerConversion

Date

DayOfWeek

Device

ExternalCustomerId

HourOfDay

Month

MonthOfYear

Quarter

ValuePerConversion

Week

Year

ADGROUP_PERFORMANCE_REPORT: AdGroupBasicStats table

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AveragePosition

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

Conversions

ConversionValue

Cost

Date

Device

ExternalCustomerId

Impressions

Interactions

InteractionTypes

Slot

ViewThroughConversions

AUDIENCE_PERFORMANCE_REPORT: Audience table

source

AdGroupId

BaseAdGroupId

BaseCampaignId

BidModifier

BidType

CampaignId

CpcBid

CpcBidSource

CpmBid

CpmBidSource

Criteria

CriteriaDestinationUrl

CriterionAttachmentLevel

ExternalCustomerId

FinalAppUrls

FinalMobileUrls

FinalUrls

Id (changed from CriterionId)

IsRestrict

Status

TrackingUrlTemplate

UrlCustomParameters

UserListName

AUDIENCE_PERFORMANCE_REPORT: AudienceStats table

ActiveViewCpm

ActiveViewCtr

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AverageCost

AverageCpc

AverageCpm

AveragePosition

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerConversion

Ctr

Date

DayOfWeek

Device

ExternalCustomerId

GmailForwards

GmailSaves

GmailSecondaryClicks

Id (changed from CriterionId)

Impressions

InteractionRate

Interactions

InteractionTypes

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

Week

Year

AUDIENCE_PERFORMANCE_REPORT: AudienceConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

BaseAdGroupId

BaseCampaignId

CampaignId

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerAllConversion

CostPerConversion

CrossDeviceConversions

Date

DayOfWeek

Device

ExternalCustomerId

GmailForwards

GmailSaves

GmailSecondaryClicks

Id (changed from CriterionId)

Month

MonthOfYear

Quarter

ValuePerAllConversion

ValuePerConversion

ViewThroughConversions

Week

Year

AUDIENCE_PERFORMANCE_REPORT: AudienceNonClickStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AverageCpe

AverageCpv

BaseAdGroupId

BaseCampaignId

CampaignId

Date

DayOfWeek

Device

EngagementRate

Engagements

ExternalCustomerId

Month

MonthOfYear

Quarter

Slot

VideoQuartile100Rate

VideoQuartile25Rate

VideoQuartile50Rate

VideoQuartile75Rate

VideoViewRate

VideoViews

Week

Year

AUDIENCE_PERFORMANCE_REPORT: AudienceBasicStats table

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AveragePosition

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

Conversions

ConversionValue

Cost

Date

Device

ExternalCustomerId

Id (changed from CriterionId)

Impressions

Interactions

InteractionTypes

Slot

ViewThroughConversions

CAMPAIGN_PERFORMANCE_REPORT: Campaign table

source

AdvertisingChannelSubType

AdvertisingChannelType

Amount

BiddingStrategyId

BiddingStrategyName

BiddingStrategyType

BidType

BudgetId

CampaignDesktopBidModifier

CampaignGroupId

CampaignId

CampaignMobileBidModifier

CampaignName

CampaignStatus

CampaignTabletBidModifier

CampaignTrialType

EndDate

EnhancedCpcEnabled

EnhancedCpvEnabled

ExternalCustomerId

IsBudgetExplicitlyShared

LabelIds

Labels

Period

ServingStatus

StartDate

TrackingUrlTemplate

UrlCustomParameters

CAMPAIGN_PERFORMANCE_REPORT: CampaignStats table

ActiveViewCpm

ActiveViewCtr

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdNetworkType1

AdNetworkType2

AverageCost

AverageCpc

AverageCpm

AveragePosition

BaseCampaignId

CampaignGroupId

CampaignId

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerConversion

CostPerCurrentModelAttributedConversion

Ctr

CurrentModelAttributedConversions

CurrentModelAttributedConversionValue

Date

DayOfWeek

Device

ExternalCustomerId

GmailForwards

GmailSaves

GmailSecondaryClicks

Impressions

InteractionRate

Interactions

InteractionTypes

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

ValuePerCurrentModelAttributedConversion

Week

Year

CAMPAIGN_PERFORMANCE_REPORT: CampaignConversionStats table

AdNetworkType1

AdNetworkType2

BaseCampaignId

CampaignGroupId

CampaignId

ClickType

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerConversion

Date

DayOfWeek

Device

ExternalCustomerId

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

Week

Year

CAMPAIGN_PERFORMANCE_REPORT: CampaignCrossDeviceStats table

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

AverageCpe

AverageCpv

AveragePageviews

AverageTimeOnSite

BaseCampaignId

BounceRate

CampaignGroupId

CampaignId

ClickAssistedConversions

ClickAssistedConversionsOverLastClickConversions

ClickAssistedConversionValue

ContentBudgetLostImpressionShare

ContentImpressionShare

ContentRankLostImpressionShare

CostPerAllConversion

CrossDeviceConversions

Date

DayOfWeek

EngagementRate

Engagements

ExternalCustomerId

ImpressionAssistedConversions

ImpressionAssistedConversionsOverLastClickConversions

ImpressionAssistedConversionValue

InvalidClickRate

InvalidClicks

Month

MonthOfYear

NumOfflineImpressions

NumOfflineInteractions

OfflineInteractionRate

PercentNewVisitors

Quarter

RelativeCtr

SearchBudgetLostImpressionShare

SearchExactMatchImpressionShare

SearchImpressionShare

SearchRankLostImpressionShare

ValuePerAllConversion

VideoQuartile100Rate

VideoQuartile25Rate

VideoQuartile50Rate

VideoQuartile75Rate

VideoViewRate

VideoViews

Week

Year

CAMPAIGN_PERFORMANCE_REPORT: CampaignCrossDeviceConversionStats table

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

BaseCampaignId

CampaignGroupId

CampaignId

ConversionCategoryName

ConversionTrackerId

ConversionTypeName

CostPerAllConversion

CrossDeviceConversions

Date

DayOfWeek

ExternalCustomerId

Month

MonthOfYear

Quarter

ValuePerAllConversion

Week

Year

CAMPAIGN_PERFORMANCE_REPORT: HourlyCampaignStats table

ActiveViewCpm

ActiveViewCtr

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdNetworkType1

AdNetworkType2

AverageCost

AverageCpc

AverageCpm

AveragePosition

BaseCampaignId

CampaignGroupId

CampaignId

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerConversion

CostPerCurrentModelAttributedConversion

Ctr

CurrentModelAttributedConversions

CurrentModelAttributedConversionValue

Date

DayOfWeek

Device

ExternalCustomerId

GmailForwards

GmailSaves

GmailSecondaryClicks

HourOfDay

Impressions

ImpressionRate

Interactions

InteractionTypes

Month

MonthOfYear

Quarter

ValuePerConversion

ValuePerCurrentModelAttributedConversion

Week

Year

CAMPAIGN_PERFORMANCE_REPORT: HourlyCampaignConversionStats table

AdNetworkType1

AdNetworkType2

BaseCampaignId

CampaignGroupId

CampaignId

ClickType

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerConversion

Date

DayOfWeek

Device

ExternalCustomerId

HourOfDay

Month

MonthOfYear

Quarter

ValuePerConversion

Week

Year

CAMPAIGN_PERFORMANCE_REPORT: CampaignCookieStats table

AdNetworkType1

AdNetworkType2

AverageFrequency

BaseCampaignId

CampaignGroupId

CampaignId

Date

ExternalCustomerId

ImpressionReach

Month

MonthOfYear

Week

CAMPAIGN_PERFORMANCE_REPORT: CampaignBasicStats table

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdNetworkType1

AdNetworkType2

AveragePosition

BaseCampaignId

CampaignGroupId

CampaignId

Clicks

Conversions

ConversionValue

Cost

Date

Device

ExternalCustomerId

Impressions

Interactions

InteractionTypes

Slot

ViewThroughConversions

CAMPAIGN_LOCATION_TARGET_REPORT: LocationBasedCampaignCriterion table

source

BidModifier

CampaignId

ExternalCustomerId

Id (changed from CriterionId)

IsNegative

CAMPAIGN_LOCATION_TARGET_REPORT: CampaignLocationTargetStats table

AllConversionRate

AllConversions

AllConversionValue

AverageCost

AverageCpc

AverageCpe

AverageCpm

AverageCpv

AveragePosition

CampaignId

Clicks

ConversionRate

Conversions

ConversionValue

Cost

CostPerAllConversion

CostPerConversion

CrossDeviceConversions

Ctr

Date

EngagementRate

Engagements

ExternalCustomerId

Id (changed from CriterionId)

Impressions

InteractionRate

Interactions

InteractionTypes

Month

MonthOfYear

Quarter

ValuePerAllConversion

ValuePerConversion

VideoViewRate

VideoViews

ViewThroughConversions

Week

Year

CLICK_PERFORMANCE_REPORT: ClickStats table

AccountDescriptiveName

AdFormat

AdGroupId

AdNetworkType1

AdNetworkType2

AoiCityCriteriaId

AoiCountryCriteriaId

AoiMetroCriteriaId

AoiMostSpecificTargetId

AoiRegionCriteriaId

CampaignId

CampaignLocationTargetId

Clicks

ClickType

CreativeId

CriteriaId

CriteriaParameters

Date

Device

ExternalCustomerId

GclId

KeywordMatchType

LopCityCriteriaId

LopCountryCriteriaId

LopMetroCriteriaId

LopMostSpecificTargetId

LopRegionCriteriaId

MonthOfYear

Page

Slot

UserListId

GEO_PERFORMANCE_REPORT: GeoStats table

AdFormat

AdGroupId

AdGroupName

AdGroupStatus

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

AverageCost

AverageCpc

AverageCpm

AverageCpv

AveragePosition

CampaignId

CityCriteriaId

Clicks

ConversionRate

Conversions

ConversionValue

Cost

CostPerAllConversion

CostPerConversion

CountryCriteriaId

CrossDeviceConversions

Ctr

Date

DayOfWeek

Device

ExternalCustomerId

Impressions

InteractionRate

Interactions

InteractionTypes

IsTargetingLocation

LocationType

MetroCriteriaId

Month

MonthOfYear

MostSpecificCriteriaId

Quarter

RegionCriteriaId

ValuePerAllConversion

ValuePerConversion

VideoViewRate

VideoViews

ViewThroughConversions

Week

Year

GEO_PERFORMANCE_REPORT: GeoConversionStats table

AdFormat

AdGroupId

AdGroupName

AdGroupStatus

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

CampaignId

CityCriteriaId

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerAllConversion

CostPerConversion

CountryCriteriaId

CrossDeviceConversions

Date

DayOfWeek

Device

ExternalCustomerId

IsTargetingLocation

LocationType

MetroCriteriaId

Month

MonthOfYear

MostSpecificCriteriaId

Quarter

RegionCriteriaId

ValuePerAllConversion

ValuePerConversion

ViewThroughConversions

Week

Year

KEYWORDS_PERFORMANCE_REPORT: Keyword table

AdGroupId

ApprovalStatus

BiddingStrategyId

BiddingStrategyName

BiddingStrategySource

BiddingStrategyType

BidType

CampaignId

CpcBid

CpcBidSource

CpmBid

CreativeQualityScore

Criteria

CriteriaDestinationUrl

EnhancedCpcEnabled

EstimatedAddClicksAtFirstPositionCpc

EstimatedAddCostAtFirstPositionCpc

ExternalCustomerId

FinalAppUrls

FinalMobileUrls

FinalUrls

FirstPageCpc

FirstPositionCpc

HasQualityScore

Id (changed from CriterionId)

IsNegative

KeywordMatchType

LabelIds

Labels

PostClickQualityScore

QualityScore

SearchPredictedCtr

Status

SystemServingStatus

TopOfPageCpc

TrackingUrlTemplate

UrlCustomParameters

KEYWORDS_PERFORMANCE_REPORT: KeywordStats table

ActiveViewCpm

ActiveViewCtr

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AverageCost

AverageCpc

AverageCpm

AveragePosition

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerConversion

CostPerCurrentModelAttributedConversion

Ctr

CurrentModelAttributedConversions

CurrentModelAttributedConversionValue

Date

DayOfWeek

Device

ExternalCustomerId

GmailForwards

GmailSaves

GmailSecondaryClicks

Id (changed from CriterionId)

Impressions

InteractionRate

Interactions

InteractionTypes

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

ValuePerCurrentModelAttributedConversion

Week

Year

KEYWORDS_PERFORMANCE_REPORT: KeywordConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

BaseAdGroupId

BaseCampaignId

CampaignId

ClickType

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerConversion

Date

DayOfWeek

Device

ExternalCustomerId

Id (changed from CriterionId)

Month

MonthOfYear

Quarter

Slot

ValuePerConversion

Week

Year

KEYWORDS_PERFORMANCE_REPORT: KeywordCrossDeviceStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

AverageCpe

AverageCpv

AveragePageviews

AverageTimeOnSite

BaseAdGroupId

BaseCampaignId

BounceRate

CampaignId

ClickAssistedConversions

ClickAssistedConversionsOverLastClickConversions

ClickAssistedConversionValue

CostPerAllConversion

CrossDeviceConversions

Date

DayOfWeek/p>

EngagementRate

Engagements

ExternalCustomerId

Id (changed from CriterionId)

ImpressionAssistedConversions

ImpressionAssistedConversionsOverLastClickConversions

ImpressionAssistedConversionValue

Month

MonthOfYear

PercentNewVisitors

Quarter

SearchExactMatchImpressionShare

SearchImpressionShare

SearchRankLostImpressionShare

ValuePerAllConversion

VideoQuartile100Rate

VideoQuartile25Rate

VideoQuartile50Rate

VideoQuartile75Rate

VideoViewRate

VideoViews

Week

Year

KEYWORDS_PERFORMANCE_REPORT: KeywordCrossDeviceConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

BaseAdGroupId

BaseCampaignId

CampaignId

ConversionCategoryName

ConversionTrackerId

ConversionTypeName

CostPerAllConversion

CrossDeviceConversions

Date

DayOfWeek

ExternalCustomerId

Id (changed from CriterionId)

Month

MonthOfYear

Quarter

ValuePerAllConversion

Week

Year

KEYWORDS_PERFORMANCE_REPORT: KeywordBasicStats table

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AveragePosition

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

Conversions

ConversionValue

Cost

Date

Device

ExternalCustomerId

Id (changed from CriterionId)

Impressions

Interactions

InteractionTypes

Slot

ViewThroughConversions

PAID_ORGANIC_QUERY_REPORT: PaidOrganicStats table

AdGroupId

AverageCpc

AveragePosition

CampaignId

Clicks

CombinedAdsOrganicClicks

CombinedAdsOrganicClicksPerQuery

CombinedAdsOrganicQueries

Ctr

Date

DayOfWeek

ExternalCustomerId

Impressions

KeywordId (changed from CriterionId)

Month

MonthOfYear

OrganicAveragePosition

OrganicClicks

OrganicClicksPerQuery

OrganicImpressions

OrganicImpressionsPerQuery

OrganicQueries

Quarter

QueryMatchType

SearchQuery

SerpType

Week

Year

PLACEMENT_PERFORMANCE_REPORT: Placement table

source

AdGroupId

BaseAdGroupId

BaseCampaignId

BidModifier

BidType

CampaignId

CpcBid

CpcBidSource

CpmBid

CpmBidSource

Criteria

CriteriaDestinationUrl

DisplayName

ExternalCustomerId

FinalAppUrls

FinalMobileUrls

FinalUrls

Id (changed from CriterionId)

IsNegative

IsRestrict

Status

TrackingUrlTemplate

UrlCustomParameters

PLACEMENT_PERFORMANCE_REPORT: PlacementStats table

ActiveViewCpm

ActiveViewCtr

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

AverageCost

AverageCpc

AverageCpm

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerAllConversion

CostPerConversion

CrossDeviceConversions

Ctr

Date

DayOfWeek

Device

ExternalCustomerId

GmailForwards

GmailSaves

GmailSecondaryClicks

Impressions

InteractionRate

Interactions

InteractionTypes

Month

MonthOfYear

Quarter

ValuePerAllConversion

ValuePerConversion

Week

Year

PLACEMENT_PERFORMANCE_REPORT: PlacementConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

BaseAdGroupId

BaseCampaignId

CampaignId

ClickType

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerAllConversion

CostPerConversion

CrossDeviceConversions

Date

DayOfWeek

Device

ExternalCustomerId

GmailForwards

GmailSaves

GmailSecondaryClicks

Month

MonthOfYear

Quarter

ValuePerAllConversion

ValuePerConversion

Week

Year

PLACEMENT_PERFORMANCE_REPORT: PlacementNonClickStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AverageCpe

AverageCpv

BaseAdGroupId

BaseCampaignId

CampaignId

Date

DayOfWeek

Device

EngagementRate

Engagements

ExternalCustomerId

Month

MonthOfYear

Quarter

VideoQuartile100Rate

VideoQuartile25Rate

VideoQuartile50Rate

VideoQuartile75Rate

VideoViewRate

VideoViews

Week

Year

PLACEMENT_PERFORMANCE_REPORT: PlacementBasicStats table

ActiveViewImpressions

ActiveViewMeasurability

ActiveViewMeasurableCost

ActiveViewMeasurableImpressions

ActiveViewViewability

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversions

AllConversionValue

BaseAdGroupId

BaseCampaignId

CampaignId

Clicks

Conversions

ConversionValue

Cost

CrossDeviceConversions

Date

Device

ExternalCustomerId

Impressions

Interactions

InteractionTypes

ViewThroughConversions

SEARCH_QUERY_PERFORMANCE_REPORT: SearchQueryStats table

AdFormat

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

AverageCost

AverageCpc

AverageCpe

AverageCpm

AverageCpv

AveragePosition

CampaignId

Clicks

ConversionRate

Conversions

ConversionValue

Cost

CostPerAllConversion

CostPerConversion

CreativeId

CrossDeviceConversions

Ctr

Date

DayOfWeek

Device

EngagementRate

Engagements

ExternalCustomerId

Impressions

InteractionRate

Interactions

InteractionTypes

KeywordId (changed from CriterionId)

Month

MonthOfYear

Quarter

Query

QueryMatchTypeWithVariant

ValuePerAllConversion

ValuePerConversion

VideoQuartile100Rate

VideoQuartile25Rate

VideoQuartile50Rate

VideoQuartile75Rate

VideoViewRate

VideoViews

ViewThroughConversions

Week

Year

SEARCH_QUERY_PERFORMANCE_REPORT: SearchQueryConversionStats table

AdFormat

AdGroupId

AdNetworkType1

AdNetworkType2

AllConversionRate

AllConversions

AllConversionValue

CampaignId

ConversionCategoryName

ConversionRate

Conversions

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerAllConversion

CostPerConversion

CreativeId

CrossDeviceConversions

Date

DayOfWeek

Device

ExternalCustomerId

KeywordId (changed from CriterionId)

Month

MonthOfYear

Quarter

Query

QueryMatchTypeWithVariant

ValuePerAllConversion

ValuePerConversion

ViewThroughConversions

Week

Year

SHOPPING_PERFORMANCE_REPORT: ShoppingProductStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AggregatorId

AllConversionRate

AllConversions

AllConversionValue

AverageCpc

Brand

CampaignId

CategoryL1

CategoryL2

CategoryL3

CategoryL4

CategoryL5

Channel

ChannelExclusivity

Clicks

ConversionRate

Conversions

ConversionValue

Cost

CostPerAllConversion

CostPerConversion

CountryCriteriaId

CrossDeviceConversions

Ctr

CustomAttribute0

CustomAttribute1

CustomAttribute2

CustomAttribute3

CustomAttribute4

Date

DayOfWeek

Device

ExternalCustomerId

Impressions

LanguageCriteriaId

MerchantId

Month

OfferId

ProductCondition

ProductTypeL1

ProductTypeL2

ProductTypeL3

ProductTypeL4

ProductTypeL5

Quarter

SearchClickShare

SearchImpressionShare

ValuePerAllConversion

ValuePerConversion

Week

Year

SHOPPING_PERFORMANCE_REPORT: ShoppingProductConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AggregatorId

AllConversionRate

AllConversions

AllConversionValue

Brand

CampaignId

CategoryL1

CategoryL2

CategoryL3

CategoryL4

CategoryL5

Channel

ChannelExclusivity

ClickType

ConversionCategoryName

ConversionTrackerId

ConversionTypeName

ConversionValue

CostPerAllConversion

CountryCriteriaId

CustomAttribute0

CustomAttribute1

CustomAttribute2

CustomAttribute3

CustomAttribute4

Date

DayOfWeek

Device

ExternalCustomerId

LanguageCriteriaId

MerchantId

Month

OfferId

ProductCondition

ProductTypeL1

ProductTypeL2

ProductTypeL3

ProductTypeL4

ProductTypeL5

Quarter

StoreId

ValuePerAllConversion

ValuePerConversion

Week

Year

VIDEO_PERFORMANCE_REPORT: Video table

AdGroupId

CampaignId

ExternalCustomerId

VideoDuration

VideoId

VideoTitle

VIDEO_PERFORMANCE_REPORT: VideoStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AverageCpm

CampaignId

Clicks

ClickType

ConversionRate

Conversions

ConversionValue

Cost

CostPerConversion

CreativeId

CreativeStatus

Ctr

Date

DayOfWeek

Device

ExternalCustomerId

Impressions

Month

MonthOfYear

Quarter

VideoChannelId

VideoId

Week

Year

VIDEO_PERFORMANCE_REPORT: VideoConversionStats table

AdGroupId

AdNetworkType1

AdNetworkType2

CampaignId

ClickType

ConversionCategoryName

ConversionTypeName

ConversionValue

CreativeId

CreativeStatus

Date

DayOfWeek

Device

ExternalCustomerId

Month

MonthOfYear

Quarter

VideoChannelId

VideoId

Week

Year

VIDEO_PERFORMANCE_REPORT: VideoNonClickStats table

AdGroupId

AdNetworkType1

AdNetworkType2

AverageCpv

CampaignId

CreativeId

Date

DayOfWeek

Device

EngagementRate

Engagements

ExternalCustomerId

Month

MonthOfYear

Quarter

VideoChannelId

VideoId

VideoQuartile100Rate

VideoQuartile25Rate

VideoQuartile50Rate

VideoQuartile75Rate

VideoViewRate

VideoViews

Week

Year

VIDEO_PERFORMANCE_REPORT: VideoBasicStats table

AdGroupId

AdNetworkType1

AdNetworkType2

CampaignId

Clicks

Conversions

ConversionValue

Cost

CreativeId

CreativeStatus

Date

Device

ExternalCustomerId

Impressions

VideoChannelId

VideoId

ViewThroughConversions

Send feedback about...