KeywordsPerformance

The Keywords Performance report includes all statistics aggregated at the keyword level, one row per keyword.

Table Specific Information

Select

Google AdWords does not allow every column to be selected in a single query as some data will conflict if selected together. Therefore, when issuing a query that selects all columns, only the default metrics, segments, and attributes will be returned. In general, these defaults are the same fields that are exposed through the AdWords console.

To use the nondefault fields, explicitly select them in your query.

Filters can also be used in the WHERE clause. The supported operators are the =, !=, >, >=, <, <=, LIKE, NOT LIKE, IN, and NOT IN operators. All filters must be joined by the AND keyword as OR is not supported by the AdWords API.

Columns

Name

Type

Behavior

DisplayName

Description

AccountCurrencyCode

String

Attribute

Currency

Currency for the KeywordsPerformance report.

AccountDescriptiveName

String

Attribute

Account

Account for the KeywordsPerformance report.

AccountTimeZone

String

Attribute

Time Zone

Time Zone for the KeywordsPerformance report.

AdGroupId

Long

Attribute

Ad Group ID

Ad Group ID for the KeywordsPerformance report.

AdGroupName

String

Attribute

Ad Group

Ad Group for the KeywordsPerformance report.

AdGroupStatus

String

Attribute

Ad Group State

Ad Group State for the KeywordsPerformance report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

ApprovalStatus

String

Attribute

Approval Status

Approval Status for the KeywordsPerformance report.

The allowed values are APPROVED, PENDING_REVIEW, UNDER_REVIEW, DISAPPROVED.

BaseAdGroupId

Long

Attribute

Base Ad Group ID

Base Ad Group ID for the KeywordsPerformance report.

BaseCampaignId

Long

Attribute

Base Campaign ID

Base Campaign ID for the KeywordsPerformance report.

BiddingStrategyId

Long

Attribute

Bid Strategy ID

Bid Strategy ID for the KeywordsPerformance report.

BiddingStrategyName

String

Attribute

Bid Strategy Name

Bid Strategy Name for the KeywordsPerformance report.

BiddingStrategySource

String

Attribute

Bidding Strategy Source

Bidding Strategy Source for the KeywordsPerformance report.

The allowed values are CAMPAIGN, ADGROUP, CRITERION.

BiddingStrategyType

String

Attribute

Bid Strategy Type

Bid Strategy Type for the KeywordsPerformance report.

The allowed values are MANUAL_CPC, MANUAL_CPV, MANUAL_CPM, PAGE_ONE_PROMOTED, TARGET_SPEND, TARGET_CPA, TARGET_ROAS, MAXIMIZE_CONVERSIONS, MAXIMIZE_CONVERSION_VALUE, TARGET_OUTRANK_SHARE, NONE, UNKNOWN.

CampaignId

Long

Attribute

Campaign ID

Campaign ID for the KeywordsPerformance report.

CampaignName

String

Attribute

Campaign

Campaign for the KeywordsPerformance report.

CampaignStatus

String

Attribute

Campaign State

Campaign State for the KeywordsPerformance report.

The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED.

ConversionAdjustment

String

Attribute

Conversion Adjustment

Conversion Adjustment for the KeywordsPerformance report.

The allowed values are TRUE, FALSE.

CpcBid

Decimal

Attribute

Max CPC

Max CPC for the KeywordsPerformance report.

CpcBidSource

String

Attribute

Max CPC Source

Max CPC Source for the KeywordsPerformance report.

The allowed values are ADGROUP, CRITERION, ADGROUP_BIDDING_STRATEGY, CAMPAIGN_BIDDING_STRATEGY.

CpmBid

Decimal

Attribute

Max CPM

Max CPM for the KeywordsPerformance report.

CreativeQualityScore

String

Attribute

Ad Relevance

Ad Relevance for the KeywordsPerformance report.

The allowed values are UNKNOWN, BELOW_AVERAGE, AVERAGE, ABOVE_AVERAGE.

Criteria

String

Attribute

Keyword

Keyword for the KeywordsPerformance report.

CriteriaDestinationUrl

String

Attribute

Destination URL

Destination URL for the KeywordsPerformance report.

CustomerDescriptiveName

String

Attribute

Client Name

Client Name for the KeywordsPerformance report.

EnhancedCpcEnabled

String

Attribute

Enhanced CPC Enabled

Enhanced CPC Enabled for the KeywordsPerformance report.

The allowed values are TRUE, FALSE.

EstimatedAddClicksAtFirstPositionCpc

Long

Attribute

Est Add Clicks Per wk (first Position Bid)

Est Add Clicks Per wk (first Position Bid) for the KeywordsPerformance report.

EstimatedAddCostAtFirstPositionCpc

Decimal

Attribute

Est Add Cost Per wk (first Position Bid)

Est Add Cost Per wk (first Position Bid) for the KeywordsPerformance report.

ExternalCustomerId

Long

Attribute

Customer ID

Customer ID for the KeywordsPerformance report.

FinalAppUrls

String

Attribute

App Final URL

App Final URL for the KeywordsPerformance report.

FinalMobileUrls

String

Attribute

Mobile Final URL

Mobile Final URL for the KeywordsPerformance report.

FinalUrls

String

Attribute

Final URL

Final URL for the KeywordsPerformance report.

FinalUrlSuffix

String

Attribute

Final URL Suffix

Final URL Suffix for the KeywordsPerformance report.

FirstPageCpc

String

Attribute

First Page CPC

First Page CPC for the KeywordsPerformance report.

FirstPositionCpc

String

Attribute

First Position CPC

First Position CPC for the KeywordsPerformance report.

HasQualityScore

String

Attribute

Has Quality Score

Has Quality Score for the KeywordsPerformance report.

The allowed values are TRUE, FALSE.

Id

Long

Attribute

Keyword ID

Keyword ID for the KeywordsPerformance report.

IsNegative

String

Attribute

Is Negative

Is Negative for the KeywordsPerformance report.

The allowed values are TRUE, FALSE.

KeywordMatchType

String

Attribute

Match Type

Match Type for the KeywordsPerformance report.

The allowed values are EXACT, PHRASE, BROAD.

LabelIds

String

Attribute

Label IDs

Label IDs for the KeywordsPerformance report.

Labels

String

Attribute

Labels

Labels for the KeywordsPerformance report.

PostClickQualityScore

String

Attribute

Landing Page Experience

Landing Page Experience for the KeywordsPerformance report.

The allowed values are UNKNOWN, BELOW_AVERAGE, AVERAGE, ABOVE_AVERAGE.

QualityScore

Integer

Attribute

Quality Score

Quality Score for the KeywordsPerformance report.

SearchPredictedCtr

String

Attribute

Expected Clickthrough Rate

Expected Clickthrough Rate for the KeywordsPerformance report.

The allowed values are UNKNOWN, BELOW_AVERAGE, AVERAGE, ABOVE_AVERAGE.

Status

String

Attribute

Keyword State

Keyword State for the KeywordsPerformance report.

The allowed values are ENABLED, REMOVED, PAUSED.

SystemServingStatus

String

Attribute

Criterion Serving Status

Criterion Serving Status for the KeywordsPerformance report.

The allowed values are ELIGIBLE, RARELY_SERVED.

TopOfPageCpc

String

Attribute

Top Of Page CPC

Top Of Page CPC for the KeywordsPerformance report.

TrackingUrlTemplate

String

Attribute

Tracking Template

Tracking Template for the KeywordsPerformance report.

UrlCustomParameters

String

Attribute

Custom Parameter

Custom Parameter for the KeywordsPerformance report.

VerticalId

Long

Attribute

Vertical ID

Vertical ID for the KeywordsPerformance report.

AdNetworkType1

String

Segment

Network

Network for the KeywordsPerformance report.

The allowed values are UNKNOWN, SEARCH, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.

AdNetworkType2

String

Segment

Network (with Search Partners)

Network (with Search Partners) for the KeywordsPerformance report.

The allowed values are UNKNOWN, SEARCH, SEARCH_PARTNERS, CONTENT, YOUTUBE_SEARCH, YOUTUBE_WATCH, MIXED.

ClickType

String

Segment

Click Type

Click Type for the KeywordsPerformance report.

The allowed values are URL_CLICKS, CALLS, OTHER, PRODUCT_EXTENSION_CLICKS, SITELINKS, PRODUCT_LISTING_AD_CLICKS, GET_DIRECTIONS, OFFER_PRINTS, BREADCRUMBS, CALL_TRACKING, MOBILE_CALL_TRACKING, LOCATION_EXPANSION, STORE_LOCATOR, PRODUCT_LISTING_AD_LOCAL, APP_DEEPLINK, PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL, PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE, PRODUCT_LISTING_ADS_COUPON, PRODUCT_LISTING_AD_TRANSACTABLE, PRODUCT_AD_APP_DEEPLINK, SHOWCASE_AD_CATEGORY_LINK, SHOWCASE_AD_LOCAL_STOREFRONT_LINK, SHOWCASE_AD_ONLINE_PRODUCT_LINK, SHOWCASE_AD_LOCAL_PRODUCT_LINK, PRICE_EXTENSION, VIDEO_WEBSITE_CLICKS, VIDEO_CALL_TO_ACTION_CLICKS, VIDEO_APP_STORE_CLICKS, VIDEO_CARD_ACTION_HEADLINE_CLICKS, VIDEO_END_CAP_CLICKS, CLICK_ON_ENGAGEMENT_AD, LOCATION_FORMAT_MAP, LOCATION_FORMAT_LANDING_PAGE, LOCATION_FORMAT_STORE_INFO, LOCATION_FORMAT_DIRECTIONS, LOCATION_FORMAT_CALL, LOCATION_FORMAT_TEXT, LOCATION_FORMAT_IMAGE, BROADBAND_PLAN, WIRELESS_PLAN, VISUAL_SITELINKS, PROMOTION_EXTENSION, SWIPEABLE_GALLERY_AD_HEADLINE, SWIPEABLE_GALLERY_AD_SWIPES, SWIPEABLE_GALLERY_AD_SEE_MORE, SWIPEABLE_GALLERY_AD_SITELINK_ONE, SWIPEABLE_GALLERY_AD_SITELINK_TWO, SWIPEABLE_GALLERY_AD_SITELINK_THREE, SWIPEABLE_GALLERY_AD_SITELINK_FOUR, SWIPEABLE_GALLERY_AD_SITELINK_FIVE, UNKNOWN.

ConversionAdjustmentLagBucket

String

Segment

Days To Conversion Or Adjustment

Days To Conversion Or Adjustment for the KeywordsPerformance report.

The allowed values are UNKNOWN, CONVERSION_0_TO_1_DAY, CONVERSION_1_TO_2_DAYS, CONVERSION_2_TO_3_DAYS, CONVERSION_3_TO_4_DAYS, CONVERSION_4_TO_5_DAYS, CONVERSION_5_TO_6_DAYS, CONVERSION_6_TO_7_DAYS, CONVERSION_7_TO_8_DAYS, CONVERSION_8_TO_9_DAYS, CONVERSION_9_TO_10_DAYS, CONVERSION_10_TO_11_DAYS, CONVERSION_11_TO_12_DAYS, CONVERSION_12_TO_13_DAYS, CONVERSION_13_TO_14_DAYS, CONVERSION_14_TO_21_DAYS, CONVERSION_21_TO_30_DAYS, CONVERSION_30_TO_45_DAYS, CONVERSION_45_TO_60_DAYS, CONVERSION_60_TO_90_DAYS, ADJUSTMENT_0_TO_1_DAY, ADJUSTMENT_1_TO_2_DAYS, ADJUSTMENT_2_TO_3_DAYS, ADJUSTMENT_3_TO_4_DAYS, ADJUSTMENT_4_TO_5_DAYS, ADJUSTMENT_5_TO_6_DAYS, ADJUSTMENT_6_TO_7_DAYS, ADJUSTMENT_7_TO_8_DAYS, ADJUSTMENT_8_TO_9_DAYS, ADJUSTMENT_9_TO_10_DAYS, ADJUSTMENT_10_TO_11_DAYS, ADJUSTMENT_11_TO_12_DAYS, ADJUSTMENT_12_TO_13_DAYS, ADJUSTMENT_13_TO_14_DAYS, ADJUSTMENT_14_TO_21_DAYS, ADJUSTMENT_21_TO_30_DAYS, ADJUSTMENT_30_TO_45_DAYS, ADJUSTMENT_45_TO_60_DAYS, ADJUSTMENT_60_TO_90_DAYS, ADJUSTMENT_90_TO_145_DAY, CONVERSION_UNKNOWN, ADJUSTMENT_UNKNOWN.

ConversionCategoryName

String

Segment

Conversion Category

Conversion Category for the KeywordsPerformance report.

ConversionLagBucket

String

Segment

Days To Conversion

Days To Conversion for the KeywordsPerformance report.

The allowed values are UNKNOWN, CONVERSION_0_TO_1_DAY, CONVERSION_1_TO_2_DAYS, CONVERSION_2_TO_3_DAYS, CONVERSION_3_TO_4_DAYS, CONVERSION_4_TO_5_DAYS, CONVERSION_5_TO_6_DAYS, CONVERSION_6_TO_7_DAYS, CONVERSION_7_TO_8_DAYS, CONVERSION_8_TO_9_DAYS, CONVERSION_9_TO_10_DAYS, CONVERSION_10_TO_11_DAYS, CONVERSION_11_TO_12_DAYS, CONVERSION_12_TO_13_DAYS, CONVERSION_13_TO_14_DAYS, CONVERSION_14_TO_21_DAYS, CONVERSION_21_TO_30_DAYS, CONVERSION_30_TO_45_DAYS, CONVERSION_45_TO_60_DAYS, CONVERSION_60_TO_90_DAYS.

ConversionTrackerId

Long

Segment

Conversion Tracker Id

Conversion Tracker Id for the KeywordsPerformance report.

ConversionTypeName

String

Segment

Conversion Name

Conversion Name for the KeywordsPerformance report.

Date

Date

Segment

Day

Day for the KeywordsPerformance report.

DayOfWeek

String

Segment

Day Of Week

Day Of Week for the KeywordsPerformance report.

The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY.

Device

String

Segment

Device

Device for the KeywordsPerformance report.

The allowed values are UNKNOWN, DESKTOP, HIGH_END_MOBILE, TABLET.

ExternalConversionSource

String

Segment

Conversion Source

Conversion Source for the KeywordsPerformance report.

The allowed values are UNKNOWN, WEBPAGE, ANALYTICS, UPLOAD, AD_CALL_METRICS, OFFERS, ENGAGEMENT, WEBSITE_CALL_METRICS, STORE_VISITS, ANDROID_IN_APP, ANDROID_DOWNLOAD, IOS_IN_APP, IOS_FIRST_OPEN, APP_UNSPECIFIED, ANDROID_FIRST_OPEN, UPLOAD_CALLS, FIREBASE, CLICK_TO_CALL, SALESFORCE, STORE_SALES_CRM, STORE_SALES_PAYMENT_NETWORK, GOOGLE_PLAY, THIRD_PARTY_APP_ANALYTICS, GOOGLE_ATTRIBUTION, STORE_SALES_DIRECT.

Month

String

Segment

Month

Month for the KeywordsPerformance report.

MonthOfYear

String

Segment

Month Of Year

Month Of Year for the KeywordsPerformance report.

The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER.

Quarter

String

Segment

Quarter

Quarter for the KeywordsPerformance report.

Slot

String

Segment

Top Vs Other

Top Vs Other for the KeywordsPerformance report.

The allowed values are SEARCHRHS, SEARCHTOP, SEARCHOTHER, CONTENT, AFSTOP, AFSOTHER, MIXED, UNKNOWN.

Week

String

Segment

Week

Week for the KeywordsPerformance report.

Year

Integer

Segment

Year

Year for the KeywordsPerformance report.

AbsoluteTopImpressionPercentage

Double

Metric

Impr Abs Top

The percent of add impressions shown as the very first ad.

ActiveViewCpm

Decimal

Metric

Active View Avg CPM

Active View Avg CPM for the KeywordsPerformance report.

ActiveViewCtr

Double

Metric

Active View Viewable CTR

Active View Viewable CTR for the KeywordsPerformance report.

ActiveViewImpressions

Long

Metric

Active View Viewable Impressions

Active View Viewable Impressions for the KeywordsPerformance report.

ActiveViewMeasurability

Double

Metric

Active View Measurable Impr Per Impr

Active View Measurable Impr Per Impr for the KeywordsPerformance report.

ActiveViewMeasurableCost

Decimal

Metric

Active View Measurable Cost

Active View Measurable Cost for the KeywordsPerformance report.

ActiveViewMeasurableImpressions

Long

Metric

Active View Measurable Impr

Active View Measurable Impr for the KeywordsPerformance report.

ActiveViewViewability

Double

Metric

Active View Viewable Impr Per Measurable Impr

Active View Viewable Impr Per Measurable Impr for the KeywordsPerformance report.

AllConversionRate

Double

Metric

All Conv Rate

All Conv Rate for the KeywordsPerformance report.

AllConversions

Double

Metric

All Conv

All Conv for the KeywordsPerformance report.

AllConversionValue

Double

Metric

All Conv Value

All Conv Value for the KeywordsPerformance report.

AverageCost

Decimal

Metric

Avg Cost

Avg Cost for the KeywordsPerformance report.

AverageCpc

Decimal

Metric

Avg CPC

Avg CPC for the KeywordsPerformance report.

AverageCpe

Double

Metric

Avg CPE

Avg CPE for the KeywordsPerformance report.

AverageCpm

Decimal

Metric

Avg CPM

Avg CPM for the KeywordsPerformance report.

AverageCpv

Double

Metric

Avg CPV

Avg CPV for the KeywordsPerformance report.

AveragePageviews

Double

Metric

Pages Per Session

Pages Per Session for the KeywordsPerformance report.

AveragePosition

Double

Metric

Avg Position

Avg Position for the KeywordsPerformance report.

AverageTimeOnSite

Double

Metric

Avg Session Duration (seconds)

Avg Session Duration (seconds) for the KeywordsPerformance report.

BounceRate

Double

Metric

Bounce Rate

Bounce Rate for the KeywordsPerformance report.

ClickAssistedConversions

Long

Metric

Click Assisted Conv

Click Assisted Conv for the KeywordsPerformance report.

ClickAssistedConversionsOverLastClickConversions

Double

Metric

Click Assisted Conv Per Last Click Conv

Click Assisted Conv Per Last Click Conv for the KeywordsPerformance report.

ClickAssistedConversionValue

Double

Metric

Click Assisted Conv Value

Click Assisted Conv Value for the KeywordsPerformance report.

Clicks

Long

Metric

Clicks

Clicks for the KeywordsPerformance report.

ConversionRate

Double

Metric

Conv Rate

Conv Rate for the KeywordsPerformance report.

Conversions

Double

Metric

Conversions

Conversions for the KeywordsPerformance report.

ConversionValue

Double

Metric

Total Conv Value

Total Conv Value for the KeywordsPerformance report.

Cost

Decimal

Metric

Cost

Cost for the KeywordsPerformance report.

CostPerAllConversion

Decimal

Metric

Cost Per All Conv

Cost Per All Conv for the KeywordsPerformance report.

CostPerConversion

Decimal

Metric

Cost Per Conv

Cost Per Conv for the KeywordsPerformance report.

CostPerCurrentModelAttributedConversion

Double

Metric

Cost Per Conv (current Model)

Cost Per Conv (current Model) for the KeywordsPerformance report.

CrossDeviceConversions

Double

Metric

Cross-device Conv

Cross-device Conv for the KeywordsPerformance report.

Ctr

Double

Metric

CTR

CTR for the KeywordsPerformance report.

CurrentModelAttributedConversions

Double

Metric

Conversions (current Model)

Conversions (current Model) for the KeywordsPerformance report.

CurrentModelAttributedConversionValue

Double

Metric

Conv Value (current Model)

Conv Value (current Model) for the KeywordsPerformance report.

EngagementRate

Double

Metric

Engagement Rate

Engagement Rate for the KeywordsPerformance report.

Engagements

Long

Metric

Engagements

Engagements for the KeywordsPerformance report.

GmailForwards

Long

Metric

Gmail Forwards

Gmail Forwards for the KeywordsPerformance report.

GmailSaves

Long

Metric

Gmail Saves

Gmail Saves for the KeywordsPerformance report.

GmailSecondaryClicks

Long

Metric

Gmail Clicks To Website

Gmail Clicks To Website for the KeywordsPerformance report.

HistoricalCreativeQualityScore

String

Metric

Ad Relevance (hist)

Ad Relevance (hist) for the KeywordsPerformance report.

The allowed values are UNKNOWN, BELOW_AVERAGE, AVERAGE, ABOVE_AVERAGE.

HistoricalLandingPageQualityScore

String

Metric

Landing Page Experience (hist)

Landing Page Experience (hist) for the KeywordsPerformance report.

The allowed values are UNKNOWN, BELOW_AVERAGE, AVERAGE, ABOVE_AVERAGE.

HistoricalQualityScore

Integer

Metric

Qual Score (hist)

Qual Score (hist) for the KeywordsPerformance report.

HistoricalSearchPredictedCtr

String

Metric

Expected Clickthrough Rate (hist)

Expected Clickthrough Rate (hist) for the KeywordsPerformance report.

The allowed values are UNKNOWN, BELOW_AVERAGE, AVERAGE, ABOVE_AVERAGE.

ImpressionAssistedConversions

Long

Metric

Impr Assisted Conv

Impr Assisted Conv for the KeywordsPerformance report.

ImpressionAssistedConversionsOverLastClickConversions

Double

Metric

Impr Assisted Conv Per Last Click Conv

Impr Assisted Conv Per Last Click Conv for the KeywordsPerformance report.

ImpressionAssistedConversionValue

Double

Metric

Impr Assisted Conv Value

Impr Assisted Conv Value for the KeywordsPerformance report.

Impressions

Long

Metric

Impressions

Impressions for the KeywordsPerformance report.

InteractionRate

Double

Metric

Interaction Rate

Interaction Rate for the KeywordsPerformance report.

Interactions

Long

Metric

Interactions

Interactions for the KeywordsPerformance report.

InteractionTypes

String

Metric

Interaction Types

Interaction Types for the KeywordsPerformance report.

PercentNewVisitors

Double

Metric

Percent New Sessions

Percent New Sessions for the KeywordsPerformance report.

SearchAbsoluteTopImpressionShare

Double

Metric

Search Abs Top IS

Search Abs Top IS for the KeywordsPerformance report.

SearchExactMatchImpressionShare

Double

Metric

Search Exact Match IS

Search Exact Match IS for the KeywordsPerformance report.

SearchImpressionShare

Double

Metric

Search Impr Share

Search Impr Share for the KeywordsPerformance report.

SearchRankLostImpressionShare

Double

Metric

Search Lost IS (rank)

Search Lost IS (rank) for the KeywordsPerformance report.

SearchTopImpressionShare

Double

Metric

Search top IS

Search Top IS for the KeywordsPerformance report.

TopImpressionPercentage

Double

Metric

Impr Top

The percent of add impressions that are shown anywhere above the organic search results.

ValuePerAllConversion

Double

Metric

Value Per All Conv

Value Per All Conv for the KeywordsPerformance report.

ValuePerConversion

Double

Metric

Value Per Conv

Value Per Conv for the KeywordsPerformance report.

ValuePerCurrentModelAttributedConversion

Double

Metric

Value Per Conv (current Model)

Value Per Conv (current Model) for the KeywordsPerformance report.

VideoQuartile100Rate

Double

Metric

Video Played To 100Percent

Video Played To 100Percent for the KeywordsPerformance report.

VideoQuartile25Rate

Double

Metric

Video Played To 25Percent

Video Played To 25Percent for the KeywordsPerformance report.

VideoQuartile50Rate

Double

Metric

Video Played To 50Percent

Video Played To 50Percent for the KeywordsPerformance report.

VideoQuartile75Rate

Double

Metric

Video Played To 75Percent

Video Played To 75Percent for the KeywordsPerformance report.

VideoViewRate

Double

Metric

View Rate

View Rate for the KeywordsPerformance report.

VideoViews

Long

Metric

Views

Views for the KeywordsPerformance report.

ViewThroughConversions

Long

Metric

View-through Conv

View-through Conv for the KeywordsPerformance report.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

StartDate

String

Start date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.

EndDate

String

End date for fetching AdWords data. Both StartDate and EndDate must be set to specify a custom date range. The default range in the last seven days.

Last updated