STAT | Bulk Rank Keyword Standard Dataset
Jared Sloan
Below are the fields that Alight Analytics considers standard for the STAT | Bulk Rank Keyword dataset. This report is refreshed once a day with a two day lag i.e. today we would update the data from two days ago.
This dataset can be automatically activated without a ticket through Dataset Activation.
| Field | Field Type | Description |
| created_date | DATE | Keyword creation date |
| keyword_id | BIGINT | ID of Keyword |
| keyword | STRING | Keyword Text |
| keyword_categories | STRING | Deprecated (always empty) |
| keyword_device | STRING | Default is Desktop. Only other option is Smartphone. |
| keyword_location | STRING | Location where keyword is tracked. Can be a city name, a state, or a postal code. IE: Boston, 90210, California, etc. When a keyword is not tracked at a local level, the value is blank. |
| keyword_market | STRING | Global market where keyword is tracked. Formatted as US-en, CA-en, DE-de, etc. |
| keyword_stats_advertiser_competition | FLOAT | Value between 0 and 1 (inclusive). When unavailable, value will be -1.0 |
| keyword_stats_cpc | FLOAT | The cost-per-click for this keyword. |
| keyword_stats_global_search_volume | INTEGER | When unavailable, value will be -1 |
| keyword_stats_local_search_trends_by_month_apr | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_aug | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_dec | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_feb | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_jan | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_jul | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_jun | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_mar | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_may | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_nov | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_oct | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_local_search_trends_by_month_sep | INTEGER | Targeted Search Volume numbers for previous 12 months |
| keyword_stats_targeted_search_volume | INTEGER | Targeted to KeywordMarket. When unavailable, value will be -1 |
| keyword_tags | STRING | Tags applied to keyword. When tags are unavailable, value will be “none”. |
| report_date | DATE | The date the keyword was ranked |
| ranking_type | STRING | |
| base_rank | INTEGER | Value only shows up when looking at Google results. Defaults to blank when non-ranking. It is what the rank would be if Google Universal results were not in the SERP. |
| browser_type | STRING | |
| rank | INTEGER | SERP Result Number (between 1 – 120 inclusive, or custom value set in site settings). A blank value indicates that the site is not ranking in the SERP. |
| url | STRING | Request URL for ranking |
| response_project_create_date | DATE | The date the project was created |
| response_project_id | INTEGER | The ID of the project |
| response_project_name | STRING | The name of the project |
| response_project_site_create_date | DATE | The date the site was created |
| response_project_site_id | INTEGER | The ID of the site |
| response_project_site_keyword | STRING | The site keyword |
| response_project_site_total_keywords | INTEGER | |
| response_project_site_url | STRING | |
| response_project_total_sites | INTEGER | |
| response_response_code | INTEGER | |
| response_project_site_name | STRING | |
| insert_date | TIMESTAMP | The date the data was inserted into ChannelMix |
| channelmix_profile | STRING | Specific to the STAT site linked to the ChannelMix Profile |