Data Source - Yahoo! Search Ads
- 07 Dec 2022
- Print
- DarkLight
- PDF
Data Source - Yahoo! Search Ads
- Updated on 07 Dec 2022
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.
summary
This is a help page for setting up data transfer from Yahoo! Search Ads.
Use the Yahoo! JAPAN Ads API to acquire data.
constraint
- Limited transfer capacity
- For each report, there are fields that cannot be specified at the same time.
The official documentation lists the fields that cannot be specified at the same time for each report.
The fields listed in Column Combination Fields/Not compatible fields in the CSV file for each report cannot be specified at the same time.
Setting items
STEP1 Basic settings
| Item | namerequireddefault | valuecontent | |
|---|---|---|---|
| Yahoo! JAPAN Ads API connection information | Yes | - | Yahoo! Select the connection information for the API. |
| Account ID | Yes | - | Please register the account ID to be obtained from the account management screen of Sponsored Search. |
| Report Type | Yes | - | Select the report type. The items that can be retrieved for each report are different. |
| Data acquisition period | Yes | - | Enter the start and end dates of the filter range. Enter in YYYYYMMDD format (e.g. 20201119) |
| column | No | - | Please refer to the following for the items that can be set. |
| Filter settings | No | - | You can choose to forward only records with 1 or more impressions. |
column
The column names that can be entered for each report type are as follows.
Operation classification
The operation category column in each report table described in this section represents the type of filtering operation in Yahoo API.
- ATTRIBUTE: REPRESENTS AN ATTRIBUTE IN THE REPORT.
- SEGMENT: Represents the axis of the search.
- METRIC: Represents the number obtained by filtering.
Columns with no impressions and behavior category of SEGMENT
Columns with an action indicator of SEGMENT will not be retrieved if the number of impressions is 0, even if the filter setting is disabled.
1. Account Report
| Column name | content | recommended | type operation classification |
|---|---|---|---|
| ACCOUNT_ID | Account ID | LONG | ATTRIBUTE |
| ACCOUNT_NAME | Account name | STRING | ATTRIBUTE |
| COST | cost | LONG | METRIC |
| IMPS | Impressions | LONG | METRIC |
| CLICKS | Clicks | LONG | METRIC |
| CLICK_RATE | CTR | DOUBLE | METRIC |
| AVG_CPC | Average CPC | DOUBLE | METRIC |
| INVALID_CLICKS | Invalid clicks | LONG | METRIC |
| INVALID_CLICK_RATE | Invalid CTR | DOUBLE | METRIC |
| IMPRESSION_SHERE | Impression Share | DOUBLE | METRIC |
| EXACT_MATCH_IMPRESSION_SHERE | Exact impression share | DOUBLE | METRIC |
| BODGET_LOST_IMPRESSION_SHARE | Lost impression rate (budget) | DOUBLE | METRIC |
| QUALITY_LOST_IMPRESSION_SHARE | Lost impression rate (position) | DOUBLE | METRIC |
| TRACKING_URL | Tracking URL | STRING | ATTRIBUTE |
| CONVERSIONS | Conversions | DOUBLE | METRIC |
| CONV_RATE | Conversion rate | DOUBLE | METRIC |
| CONV_VALUE | The value of conversions | DOUBLE | METRIC |
| COST_PER_CONV | Cost/Conversions | DOUBLE | METRIC |
| VALUE_PER_CONV | Value/Conversions | DOUBLE | METRIC |
| ALL_CONV | All conversions | DOUBLE | METRIC |
| ALL_CONV_RATE | All conversion rates | DOUBLE | METRIC |
| ALL_CONV_VALUE | The value of every conversion | DOUBLE | METRIC |
| COST_PER_ALL_CONV | Cost/All conversions | DOUBLE | METRIC |
| VALUE_PER_ALL_CONV | Value/All Now Versions | DOUBLE | METRIC |
| CROSS_DEVICE_CONVERSIONS | Cross-device conversions | DOUBLE | METRIC |
| NETWORK | Search screen to display ads | STRING | SEGMENT |
| CLICK_TYPE | Click Type | STRING | SEGMENT |
| DEVICE | device | STRING | SEGMENT |
| DAY | sun | STRING | SEGMENT |
| DAY_OF_WEEK | Day | STRING | SEGMENT |
| QUARTER | quarter | STRING | SEGMENT |
| YEAR | year | STRING | SEGMENT |
| MONTH | every month | STRING | SEGMENT |
| MONTH_OF_YEAR | moon | STRING | SEGMENT |
| WEEK | every week | STRING | SEGMENT |
| HOUR_OF_DAY | time | LONG | SEGMENT |
| OBJECT_OF_CONVERSION_TRACKING | Conversion measurement objectives | STRING | SEGMENT |
| CONVERSION_NAME | Conversion name | STRING | SEEGMENT |
| CONV_VALUE_PER_COST | Conversion value/cost | DOUBLE | METRIC |
| ALL_CONV_VALUE_PER_COST | Value/cost of every conversion | DOUBLE | METRIC |
2. Campaign Reports
| Column name | content | recommended | type operation classification |
|---|---|---|---|
| ACCOUNT_ID | Account ID | LONG | ATTRIBUTE |
| ACCOUNT_NAME | Account name | STRING | ATTRIBUTE |
| CAMPAIGN_ID | Campaign ID | LONG | ATTRIBUTE |
| CAMPAIGN_NAME | Campaign name | STRING | ATTRIBUTE |
| CAMPAIGN_DISTRIBUTION_SETTINGS | Campaign delivery settings | STRING | ATTRIBUTE |
| CAMPAIGN_DISTRIBUTION_STATUS | Distribution Status | STRING | ATTRIBUTE |
| DAILY_SPENDING_LIMIT | 1 day budget | LONG | ATTRIBUTE |
| CAMPAIGN_START_DATE | start date | STRING | ATTRIBUTE |
| CAMPAIGN_END_DATE | End Date | STRING | ATTRIBUTE |
| COST | cost | LONG | METRIC |
| IMPS | Impressions | LONG | METRIC |
| CLICKS | Clicks | LONG | METRIC |
| CLIC_RATE | CTR | DOUBLE | METRIC |
| AVG_CPC | Average CPC | DOUBLE | METRIC |
| INVALID_CLICKS | Invalid clicks | LONG | METRIC |
| INVALID_CLICK_RATE | Invalid CTR | DOUBLE | METRIC |
| IMPRESSION_SHARE | Impression Share | DOUBLE | METRIC |
| EXACT_MATCH_IMPRESSION_SHARE | Exact impression share | DOUBLE | METRIC |
| BUDGET_LOST_IMPRESSION_SHARE | Lost impression rate (budget) | DOUBLE | METRIC |
| QUALITY_LOST_IMPRESSION_SHARE | Lost impression rate (position) | DOUBLE | METRIC |
| TRACKING_URL | Tracking URL | STRING | ATTRIBUTE |
| COSUTOM_PARAMETERES | Custom Parameters | STRING | ATTRIBUTE |
| CAMPAGIN_TRACKING_ID | Campaign Tracking ID | LONG | ATTRIBUTE |
| CONVERSIONS | Conversions | DOBULE | METRIC |
| CONV_RATE | Conversion rate | DOUBLE | METRIC |
| CONV_VALUE | The value of conversions | DOUBLE | METRIC |
| COST_PER_CONV | Cost/Conversions | DOUBLE | METRIC |
| VALUE_PER_CONV | Value/Conversions | DOUBLE | METRIC |
| ALL_CONV | All conversions | DOUBLE | METRIC |
| ALL_CONV_RATE | All conversion rates | DOUBLE | METRIC |
| ALL_CONV_VALUE | The value of every conversion | DOUBLE | METRIC |
| COST_PER_ALL_CONV | Cost/All conversions | DOUBLE | METRIC |
| VALUE_PER_ALL_CONV | Value/All conversions | DOUBLE | METRIC |
| CROSS_DEVICE_CONVERSIONS | Cross-device conversions | DOUBLE | METRIC |
| CAMPAGIN_MOBILE_BID_MODIFIER | Smartphone bid adjustment rate (%) | DOUBLE | METRIC |
| CAMPAIGN_DESKTOP_BID_MODIFIER | PC bid adjustment rate (%) | DOUBLE | METRIC |
| CAMPAIGN_TABLET_BID_MODIFIER | Tablet bid adjustment rate (%) | DOUBLE | METRIC |
| NETWORK | Search screen to display ads | STRING | SEGMENT |
| CLCIK_TYPE | Click Type | STRING | SEGMENT |
| DEVICE | device | STRING | SEGMENT |
| DAY | sun | STRING | SEGMENT |
| DAY_OF_WEEK | Day | STRING | SEGMENT |
| QUARTER | quarter | STRING | SEGMENT |
| YEAR | year | STRING | SEGMENT |
| MONTH | every month | STRING | SEGMENT |
| MONTH_OF_YEAR | moon | STRING | SEGMENT |
| WEEK | every week | STRING | SEGMENT |
| HOUR_OF_DAY | time | STRING | SEGMENT |
| OBJECT_OF_CONVERSION_TRACKING | Conversion measurement objectives | STRING | SEGMENT |
| CONVERSION_NAME | Conversion name | STRING | SEGMENT |
| CAMPAIGN_TYPE | Campaign Type | STRING | ATTRIBUTE |
| LABELS | label | STRING | ATTRIBUTE |
| LABELS_JSON | Label (JSON) | STRING | ATTRIBUTE |
| BID_STRATEGY_ID | Portfolio bid ID | LONG | ATTRIBUTE |
| BID_STRATEGY_NAME | Portfolio bid name | STRING | ATTRIBUTE |
| BID_STRATEGY_TYPE | Bid strategy | STRING | ATTRIBUTE |
| ENHANCED_CPC_ENABLED | Enhanced CPC bidding | STRING | ATTRIBUTE |
| ABSOLUTE_TOP_IMPRESSION_PERCENTAGE | Top of page impressions | DOUBLE | METRIC |
| TOP_IMPRESSION_PERCENTAGE | Top-of-page percentage of impressions | DOUBLE | METRIC |
| SEARCH_ABSOLUTE_TOP_IMPRESSION_SHARE | Impression share at the top of the page | DOUBLE | METRIC |
| SEARCH_TOP_IMPRESSION_SHARE | Impression share at the top of the page | DOUBLE | METRIC |
| SEARCH_BUDGET_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE | Lost impression rate (budget) at the top of the page | DOUBLE | METRIC |
| SEARCH_RANK_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE | Lost impression rate (position) at the top of the page | DOUBLE | METRIC |
| SEARCH_BUDGET_LOST_TOP_IMPRESSION_SHARE | Lost impression rate (budget) at the top of the page | DOUBLE | METRIC |
| SEARCH_RANK_LOST_TOP_IMPRESSION_SHARE | Lost impression rate (position) at the top of the page | DOUBLE | METRIC |
| CONV_VALUE_PER_COST | Conversion value/cost | DOUBLE | METRIC |
| ALL_CONV_VALUE_PER_COST | Value/cost of every conversion | DOUBLE | METRIC |
3. Ad group reports
| Column name | content | recommended | type operation classification |
|---|---|---|---|
| ACCOUNT_ID | Account ID | LONG | ATTRIBUTE |
| ACCOUNT_NAME | Account name | STRING | ATTRIBUTE |
| CAMPAIGN_ID | Campaign ID | LONG | ATTRIBUTE |
| ADGROUP_ID | Ad group ID | LONG | ATTRIBUTE |
| CAMPAIGN_NAME | Campaign name | STRING | ATTRIBUTE |
| ADGROUP_NAME | Ad group name | STRING | ATTRIBUTE |
| ADGROUP_DISTRIBUTION_SETTINGS | Delivery settings | STRING | ATTRIBUTE |
| ADGROUP_BID | Ad group bids | LONG | ATTRIBUTE |
| COST | cost | LONG | METRIC |
| IMPS | Impressions | LONG | METRIC |
| CLICKS | Clicks | LONG | METRIC |
| CLIC_RATE | CTR | DOUBLE | METRIC |
| AVG_CPC | Average CPC | DOUBLE | METRIC |
| IMPRESSION_SHARE | Impression Share | DOUBLE | METRIC |
| EXACT_MATCH_IMPRESSION_SHARE | Exact impression share | DOUBLE | METRIC |
| QUALITY_LOST_IMPRESSION_SHARE | Lost impression rate (position) | DOUBLE | METRIC |
| TRACKING_URL | Tracking URL | STRING | ATTRIBUTE |
| COSUTOM_PARAMETERES | Custom Parameters | STRING | ATTRIBUTE |
| CONVERSIONS | Conversions | DOBULE | METRIC |
| CONV_RATE | Conversion rate | DOUBLE | METRIC |
| CONV_VALUE | The value of conversions | DOUBLE | METRIC |
| COST_PER_CONV | Cost/Conversions | DOUBLE | METRIC |
| VALUE_PER_CONV | Value/Conversions | DOUBLE | METRIC |
| ALL_CONV | All conversions | DOUBLE | METRIC |
| ALL_CONV_RATE | All conversion rates | DOUBLE | METRIC |
| ALL_CONV_VALUE | The value of every conversion | DOUBLE | METRIC |
| COST_PER_ALL_CONV | Cost/All conversions | DOUBLE | METRIC |
| VALUE_PER_ALL_CONV | Value/All conversions | DOUBLE | METRIC |
| CROSS_DEVICE_CONVERSIONS | Cross-device conversions | DOUBLE | METRIC |
| CAMPAGIN_MOBILE_BID_MODIFIER | Smartphone bid adjustment rate (%) | DOUBLE | METRIC |
| CAMPAIGN_DESKTOP_BID_MODIFIER | PC bid adjustment rate (%) | DOUBLE | METRIC |
| CAMPAIGN_TABLET_BID_MODIFIER | Tablet bid adjustment rate (%) | DOUBLE | METRIC |
| CAMPAIGN_TRACKING_ID | Campaign Tracking ID | LONG | ATTRIBUTE |
| ADGROUP_TRACKING_ID | Ad group tracking ID | LONG | ATTRIBUTE |
| NETWORK | Search screen to display ads | STRING | SEGMENT |
| CLCIK_TYPE | Click Type | STRING | SEGMENT |
| DEVICE | device | STRING | SEGMENT |
| DAY | sun | STRING | SEGMENT |
| DAY_OF_WEEK | Day | STRING | SEGMENT |
| QUARTER | quarter | STRING | SEGMENT |
| YEAR | year | STRING | SEGMENT |
| MONTH | every month | STRING | SEGMENT |
| MONTH_OF_YEAR | moon | STRING | SEGMENT |
| WEEK | every week | STRING | SEGMENT |
| HOUR_OF_DAY | time | STRING | SEGMENT |
| OBJECT_OF_CONVERSION_TRACKING | Conversion measurement objectives | STRING | SEGMENT |
| CONVERSION_NAME | Conversion name | STRING | SEGMENT |
| CAMPAIGN_TYPE | Campaign Type | STRING | ATTRIBUTE |
| LABELS | label | STRING | ATTRIBUTE |
| LABELS_JSON | Label (JSON) | STRING | ATTRIBUTE |
| ABSOLUTE_TOP_IMPRESSION_PERCENTAGE | Top of page impressions | DOUBLE | METRIC |
| TOP_IMPRESSION_PERCENTAGE | Top-of-page percentage of impressions | DOUBLE | METRIC |
| SEARCH_ABSOLUTE_TOP_IMPRESSION_SHARE | Impression share at the top of the page | DOUBLE | METRIC |
| SEARCH_TOP_IMPRESSION_SHARE | Impression share at the top of the page | DOUBLE | METRIC |
| SEARCH_BUDGET_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE | Lost impression rate (budget) at the top of the page | DOUBLE | METRIC |
| SEARCH_RANK_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE | Lost impression rate (position) at the top of the page | DOUBLE | METRIC |
| SEARCH_BUDGET_LOST_TOP_IMPRESSION_SHARE | Lost impression rate (budget) at the top of the page | DOUBLE | METRIC |
| SEARCH_RANK_LOST_TOP_IMPRESSION_SHARE | Lost impression rate (position) at the top of the page | DOUBLE | METRIC |
| CONV_VALUE_PER_COST | Conversion value/cost | DOUBLE | METRIC |
| ALL_CONV_VALUE_PER_COST | Value/cost of every conversion | DOUBLE | METRIC |
4. Ads Reporting
| Column name | content | recommended | type operation classification |
|---|---|---|---|
| ACCOUNT_ID | Account ID | LONG | ATTRIBUTE |
| ACCOUNT_NAME | Account name | STRING | ATTRIBUTE |
| CAMPAIGN_ID | Campaign ID | LONG | ATTRIBUTE |
| ADGROUP_ID | Ad group ID | LONG | ATTRIBUTE |
| AD_ID | Advertising ID | LONG | ATTRIBUTE |
| CAMPAIGN_NAME | Campaign name | STRING | ATTRIBUTE |
| ADGROUP_NAME | Ad group name | STRING | ATTRIBUTE |
| AD_NAME | Ad name | STRING | ATTRIBUTE |
| TITLE | title | STRING | ATTRIBUTE |
| DESCRIPTION1 | Description 1 | STRING | ATTRIBUTE |
| DISPLAY_URL | Display URL | STRING | ATTRIBUTE |
| DESTINATION_URL | Destination URL | STRING | ATTRIBUTE |
| AD_TYPE | Ad type | STRING | ATTRIBUTE |
| AD_DISTRIBUTION_SETTINGS | Delivery settings | STRING | ATTRIBUTE |
| AD_EDITORIAL_STATUS | Judging Status | STRING | ATTRIBUTE |
| COST | cost | LONG | METRIC |
| IMPS | Impressions | LONG | METRIC |
| CLICKS | Clicks | LONG | METRIC |
| CLIC_RATE | CTR | DOUBLE | METRIC |
| AVG_CPC | Average CPC | DOUBLE | METRIC |
| DESCRIPTION2 | Description 2 | STRING | ATTRIBUTE |
| DEVICE_PREFERENCE | Preferred devices | STRING | ATTRIBUTE |
| TRACKING_URL | Tracking URL | STRING | ATTRIBUTE |
| COSUTOM_PARAMETERES | Custom Parameters | STRING | ATTRIBUTE |
| LANDING_PAGE_URL | Final destination URL | STRING | ATTRIBUTE |
| LANDING_PAGE_URL_SMARTPHONE | Final link destination URL (smartphone) | STRING | LONG |
| CAMPAIGN_TRACKING_ID | Campaign Tracking ID | LONG | ATTRIBUTE |
| AD_TRACKING_ID | Ad Tracking ID | LONG | ATTRIBUTE |
| CONVERSIONS | Conversions | DOBULE | METRIC |
| CONV_RATE | Conversion rate | DOUBLE | METRIC |
| CONV_VALUE | The value of conversions | DOUBLE | METRIC |
| COST_PER_CONV | Cost/Conversions | DOUBLE | METRIC |
| VALUE_PER_CONV | Value/Conversions | DOUBLE | METRIC |
| ALL_CONV | All conversions | DOUBLE | METRIC |
| ALL_CONV_RATE | All conversion rates | DOUBLE | METRIC |
| ALL_CONV_VALUE | The value of every conversion | DOUBLE | METRIC |
| COST_PER_ALL_CONV | Cost/All conversions | DOUBLE | METRIC |
| VALUE_PER_ALL_CONV | Value/All conversions | DOUBLE | METRIC |
| CROSS_DEVICE_CONVERSIONS | Cross-device conversions | DOUBLE | METRIC |
| ADGROUP_TRACKING_ID | Ad group tracking ID | LONG | ATTRIBUTE |
| NETWORK | Search screen to display ads | STRING | SEGMENT |
| CLCIK_TYPE | Click Type | STRING | SEGMENT |
| DEVICE | device | STRING | SEGMENT |
| DAY | sun | STRING | SEGMENT |
| DAY_OF_WEEK | Day | STRING | SEGMENT |
| QUARTER | quarter | STRING | SEGMENT |
| YEAR | year | STRING | SEGMENT |
| MONTH | every month | STRING | SEGMENT |
| MONTH_OF_YEAR | moon | STRING | SEGMENT |
| WEEK | every week | STRING | SEGMENT |
| HOUR_OF_DAY | time | STRING | SEGMENT |
| OBJECT_OF_CONVERSION_TRACKING | Conversion measurement objectives | STRING | SEGMENT |
| CONVERSION_NAME | Conversion name | STRING | SEGMENT |
| AD_KEYWORD_ID2 | Keyword ID | LONG | SEGMENT |
| TITLE1 | Title 1 | STRING | ATTRIBUTE |
| TITLE2 | Title 2 | STRING | ATTRIBUTE |
| DESC | Description | STRING | ATTRIBUTE |
| DIRECTORY1 | Directory 1 | STRING | ATTRIBUTE |
| DIRECTORY2 | Directory 2 | STRING | ATTRIBUTE |
| LABELS | label | STRING | ATTRIBUTE |
| LABELS_JSON | Label (JSON) | STRING | ATTRIBUTE |
| ABSOLUTE_TOP_IMPRESSION_PERCENTAGE | Top of page impressions | DOUBLE | METRIC |
| TOP_IMPRESSION_PERCENTAGE | Top-of-page percentage of impressions | DOUBLE | METRIC |
| CONV_VALUE_PER_COST | Conversion value/cost | DOUBLE | METRIC |
| ALL_CONV_VALUE_PER_COST | Value/cost of every conversion | DOUBLE | METRIC |
5. Keyword Report
| Column name | content | recommended | type operation classification |
|---|---|---|---|
| ACCOUNT_ID | Account ID | LONG | ATTRIBUTE |
| ACCOUNT_NAME | Account name | STRING | ATTRIBUTE |
| CAMPAIGN_ID | Campaign ID | LONG | ATTRIBUTE |
| ADGROUP_ID | Ad group ID | LONG | ATTRIBUTE |
| KEYWORD_ID | Keyword ID | LONG | ATTRIBUTE |
| CAMPAIGN_NAME | Campaign name | STRING | ATTRIBUTE |
| ADGROUP_NAME | Ad group name | STRING | ATTRIBUTE |
| CUSTOM_URL | Custom URL | STRING | ATTRIBUTE |
| KEYWORD | keyword | STRING | ATTRIBUTE |
| KEYTWORD_DISTRIBUTION_SETTINGS | Delivery settings | STRING | ATTRIBUTE |
| KEYWORD_EDITORIAL_STATUS | Judging Status | STRING | ATTRIBUTE |
| ADGROUP_BID | Ad group bids | LONG | ATTRIBUTE |
| BID | Bid price | LONG | ATTRIBUTE |
| NEGATIVE_KEYWORD | Ineligible keywords | STRING | ATTRIBUTE |
| QUALITY_INDEX | Quality Index | LONG | ATTRIBUTE |
| FIRST_PAGE_BID_ESTIMATE | Bid price required for one page listing | LONG | ATTRIBUTE |
| KEYWORD_MATCH_TYPE | Match Type | ENUM | ATTRIBUTE |
| COST | cost | LONG | METRIC |
| IMPS | Impressions | LONG | METRIC |
| CLICKS | Clicks | LONG | METRIC |
| CLIC_RATE | CTR | DOUBLE | METRIC |
| AVG_CPC | Average CPC | DOUBLE | METRIC |
| IMPRESSION_SHARE | Impression Share | DOUBLE | METRIC |
| EXACT_MATCH_IMPRESSION_SHARE | Exact impression share | DOUBLE | METRIC |
| QUALITY_LOST_IMPRESSION_SHARE | Lost impression rate (position) | DOUBLE | METRIC |
| TOP_OF_PAGE_BID_ESTIMATE | Bid price required to list at the top of page 1 | LONG | ATTRIBUTE |
| TRACKING_URL | Tracking URL | STRING | ATTRIBUTE |
| COSUTOM_PARAMETERES | Custom Parameters | STRING | ATTRIBUTE |
| LANDING_PAGE_URL | Final destination URL | STRING | ATTRIBUTE |
| LANDING_PAGE_URL_SMARTPHONE | Final link destination URL (smartphone) | STRING | LONG |
| CONVERSIONS | Conversions | DOBULE | METRIC |
| CONV_RATE | Conversion rate | DOUBLE | METRIC |
| CONV_VALUE | The value of conversions | DOUBLE | METRIC |
| COST_PER_CONV | Cost/Conversions | DOUBLE | METRIC |
| VALUE_PER_CONV | Value/Conversions | DOUBLE | METRIC |
| ALL_CONV | All conversions | DOUBLE | METRIC |
| ALL_CONV_RATE | All conversion rates | DOUBLE | METRIC |
| ALL_CONV_VALUE | The value of every conversion | DOUBLE | METRIC |
| COST_PER_ALL_CONV | Cost/All conversions | DOUBLE | METRIC |
| VALUE_PER_ALL_CONV | Value/All conversions | DOUBLE | METRIC |
| CROSS_DEVICE_CONVERSIONS | Cross-device conversions | DOUBLE | METRIC |
| CAMPAIGN_TRACKING_ID | Campaign Tracking ID | LONG | ATTRIBUTE |
| ADGROUP_TRACKING_ID | Ad group tracking ID | LONG | ATTRIBUTE |
| KEYWORD_TRACKING_ID | Keyword Tracking ID | LONG | ATTRIBUTE |
| NETWORK | Search screen to display ads | STRING | SEGMENT |
| CLCIK_TYPE | Click Type | STRING | SEGMENT |
| DEVICE | device | STRING | SEGMENT |
| DAY | sun | STRING | SEGMENT |
| DAY_OF_WEEK | Day | STRING | SEGMENT |
| QUARTER | quarter | STRING | SEGMENT |
| YEAR | year | STRING | SEGMENT |
| MONTH | every month | STRING | SEGMENT |
| MONTH_OF_YEAR | moon | STRING | SEGMENT |
| WEEK | every week | STRING | SEGMENT |
| HOUR_OF_DAY | time | STRING | SEGMENT |
| OBJECT_OF_CONVERSION_TRACKING | Conversion measurement objectives | STRING | SEGMENT |
| CONVERSION_NAME | Conversion name | STRING | SEGMENT |
| LABELS | label | STRING | ATTRIBUTE |
| LABELS_JSON | Label (JSON) | STRING | ATTRIBUTE |
| ABSOLUTE_TOP_IMPRESSION_PERCENTAGE | Top of page impressions | DOUBLE | METRIC |
| TOP_IMPRESSION_PERCENTAGE | Top-of-page percentage of impressions | DOUBLE | METRIC |
| SEARCH_ABSOLUTE_TOP_IMPRESSION_SHARE | Impression share at the top of the page | DOUBLE | METRIC |
| SEARCH_TOP_IMPRESSION_SHARE | Impression share at the top of the page | DOUBLE | METRIC |
| SEARCH_BUDGET_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE | Lost impression rate (budget) at the top of the page | DOUBLE | METRIC |
| SEARCH_RANK_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE | Lost impression rate (position) at the top of the page | DOUBLE | METRIC |
| SEARCH_BUDGET_LOST_TOP_IMPRESSION_SHARE | Lost impression rate (budget) at the top of the page | DOUBLE | METRIC |
| SEARCH_RANK_LOST_TOP_IMPRESSION_SHARE | Lost impression rate (position) at the top of the page | DOUBLE | METRIC |
| SYSTEM_SERVING_STATUS | Keyword Status | ENUM | ATTRIBUTE |
| CONV_VALUE_PER_COST | Conversion value/cost | DOUBLE | METRIC |
| ALL_CONV_VALUE_PER_COST | Value/cost of every conversion | DOUBLE | METRIC |
6. Responsive Search Ads Asset Report
| Column name | content | recommended | type operation classification |
|---|---|---|---|
| ACCOUNT_ID | Account ID | STRING | ATTRIBUTE |
| ACCOUNT_NAME | Account name | STRING | ATTRIBUTE |
| CAMPAIGN_ID | Campaign ID | LONG | ATTRIBUTE |
| ADGROUP_ID | Ad group ID | LONG | ATTRIBUTE |
| AD_ID | Advertising ID | LONG | ATTRIBUTE |
| CAMPAIGN_NAME | Campaign name | STRING | ATTRIBUTE |
| ADGROUP_NAME | Ad group name | STRING | ATTRIBUTE |
| AD_NAME | Ad name | STRING | ATTRIBUTE |
| ASSET_TEXT | Asset | STRING | ATTRIBUTE |
| ASSET_TYPE | Asset Type | ENUM | ATTRIBUTE |
| PINNED_FIELD | Fixing the display position | ENUM | ATTRIBUTE |
| PERFORMANCE | Rating | ENUM | ATTRIBUTE |
| IMPS | Impressions | LONG | METRIC |
| DAY | sun | STRING | SEGMENT |
| WEEK | every week | STRING | SEGMENT |
| MONTH | every month | STRING | SEGMENT |
| QUARTER | quarter | STRING | SEGMENT |
| YEAR | year | STRING | SEGMENT |
| DAY_OF_WEEK | Day | ENUM | SEGMENT |
| NETWORK | Search screen to display ads | ENUM | SEGMENT |
Was this article helpful?