KeywordlessCategory
The Keywordless Category Performance report includes keywordless ads (dynamic search ads) statistics aggregated by category.
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 KeywordlessCategory report. |
AccountDescriptiveName | String | Attribute | Account | Account for the KeywordlessCategory report. |
AccountTimeZone | String | Attribute | Time Zone | Time Zone for the KeywordlessCategory report. |
AdGroupId | Long | Attribute | Ad Group ID | Ad Group ID for the KeywordlessCategory report. |
AdGroupName | String | Attribute | Ad Group | Ad Group for the KeywordlessCategory report. |
AdGroupStatus | String | Attribute | Ad Group State | Ad Group State for the KeywordlessCategory report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
CampaignId | Long | Attribute | Campaign ID | Campaign ID for the KeywordlessCategory report. |
CampaignName | String | Attribute | Campaign | Campaign for the KeywordlessCategory report. |
CampaignStatus | String | Attribute | Campaign State | Campaign State for the KeywordlessCategory report. The allowed values are UNKNOWN, ENABLED, PAUSED, REMOVED. |
Category0 | String | Attribute | Top Level Categories | Top Level Categories for the KeywordlessCategory report. |
Category1 | String | Attribute | First Level Sub-categories | First Level Sub-categories for the KeywordlessCategory report. |
Category2 | String | Attribute | Second Level Sub-categories | Second Level Sub-categories for the KeywordlessCategory report. |
CriterionId | Long | Attribute | Keyword ID | Keyword ID for the KeywordlessCategory report. |
CustomerDescriptiveName | String | Attribute | Client Name | Client Name for the KeywordlessCategory report. |
Domain | String | Attribute | Domain | Domain for the KeywordlessCategory report. |
ExternalCustomerId | Long | Attribute | Customer ID | Customer ID for the KeywordlessCategory report. |
ConversionCategoryName | String | Segment | Conversion Category | Conversion Category for the KeywordlessCategory report. |
ConversionTrackerId | Long | Segment | Conversion Tracker Id | Conversion Tracker Id for the KeywordlessCategory report. |
ConversionTypeName | String | Segment | Conversion Name | Conversion Name for the KeywordlessCategory report. |
Date | Date | Segment | Day | Day for the KeywordlessCategory report. |
DayOfWeek | String | Segment | Day Of Week | Day Of Week for the KeywordlessCategory report. The allowed values are MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, SUNDAY. |
ExternalConversionSource | String | Segment | Conversion Source | Conversion Source for the KeywordlessCategory 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 KeywordlessCategory report. |
MonthOfYear | String | Segment | Month Of Year | Month Of Year for the KeywordlessCategory report. The allowed values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER. |
Quarter | String | Segment | Quarter | Quarter for the KeywordlessCategory report. |
Week | String | Segment | Week | Week for the KeywordlessCategory report. |
Year | Integer | Segment | Year | Year for the KeywordlessCategory report. |
AllConversionRate | Double | Metric | All Conv Rate | All Conv Rate for the KeywordlessCategory report. |
AllConversions | Double | Metric | All Conv | All Conv for the KeywordlessCategory report. |
AllConversionValue | Double | Metric | All Conv Value | All Conv Value for the KeywordlessCategory report. |
AverageCpc | Decimal | Metric | Avg CPC | Avg CPC for the KeywordlessCategory report. |
AverageCpm | Decimal | Metric | Avg CPM | Avg CPM for the KeywordlessCategory report. |
Clicks | Long | Metric | Clicks | Clicks for the KeywordlessCategory report. |
ConversionRate | Double | Metric | Conv Rate | Conv Rate for the KeywordlessCategory report. |
Conversions | Double | Metric | Conversions | Conversions for the KeywordlessCategory report. |
ConversionValue | Double | Metric | Total Conv Value | Total Conv Value for the KeywordlessCategory report. |
Cost | Decimal | Metric | Cost | Cost for the KeywordlessCategory report. |
CostPerAllConversion | Decimal | Metric | Cost Per All Conv | Cost Per All Conv for the KeywordlessCategory report. |
CostPerConversion | Decimal | Metric | Cost Per Conv | Cost Per Conv for the KeywordlessCategory report. |
CrossDeviceConversions | Double | Metric | Cross-device Conv | Cross-device Conv for the KeywordlessCategory report. |
Ctr | Double | Metric | CTR | CTR for the KeywordlessCategory report. |
Impressions | Long | Metric | Impressions | Impressions for the KeywordlessCategory report. |
ValuePerAllConversion | Double | Metric | Value Per All Conv | Value Per All Conv for the KeywordlessCategory report. |
ValuePerConversion | Double | Metric | Value Per Conv | Value Per Conv for the KeywordlessCategory 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