STAT | Bulk Rank Keyword Standard Dataset

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
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.