Windsor brings all your Dragonmetrics data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Dragonmetrics Field Reference
Sample
A sample URL on how to query data:
https://connectors.windsor.ai/dragonmetrics?=[API_KEY]&date_preset=last_7d&fields=date,campaign,campaign_name,campaign_competitors_site,campaign_ranking_summary_traffic_index
Fields
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | Account ID |
| account_name | TEXT | Account Name | Account Name |
| campaign | TEXT | Campaign | The Campaign Name (same as campaign_name) |
| campaign_alternate_seed_url | TEXT | Campaign Alternate Seed URL | Site crawls start from the homepage of the URL entered in the'site' property. To add another URL to begin crawling from, you may optionally enter it as an alternate seed URL. |
| campaign_competitors_site | TEXT | Campaign Competitors Site | URL of this competitor site |
| campaign_competitors_site_scope | TEXT | Campaign Competitors Site Scope | Defines the scope of which URLs will be included in this site. Enum: "root domain" "subdomain subfolder" "exact url" "root domain only" |
| campaign_crawl_limit | NUMERIC | Campaign Crawl Limit | The maximum number of URLs available for this crawl. |
| campaign_crawl_site | BOOLEAN | Campaign Crawl Site | Boolean value of whether crawling should be enabled for this site or not. |
| campaign_crawl_speed | TEXT | Campaign Crawl Speed | The speed of the crawler. Four potential options include 'Slow', 'Normal' (default), 'Fast', and 'Extreme'. Crawls finish faster with higher speeds, but may result in a higher load on the site'sservers. Lower speeds are recommended if the server returns many 5xx errors. |
| campaign_domain_authority | NUMERIC | Campaign Domain Authority | The Domain Authority of the tracking URL for this campaign. Data comes from Moz. |
| campaign_id | TEXT | Campaign ID | Campaign ID |
| campaign_keyword_credit_usage | NUMERIC | Campaign Keyword Credit Usage | The number of keyword credits currently utilized by this campaign. |
| campaign_keyword_level_search_engine_tracking | BOOLEAN | Campaign Keyword Level Search Engine Tracking | By default, this value is set to false, which means that tracking search engines will be set at the campaign level for all keywords in the campaign. If set to true, tracking search engine will be defined at the keyword level, and the search_engines object will not be included in the campaign object. |
| campaign_keyword_limit | NUMERIC | Campaign Keyword Limit | Keywords credits are shared across all campaigns in your account. If desired, you can set an optional limit on the number of credits available for this campaign to use. |
| campaign_name | TEXT | Campaign Name | The name of the campaign. Must be unique. |
| campaign_ranking_summary_all_keywords | NUMERIC | Campaign Ranking Summary All Keywords | The total number of keywords in this set |
| campaign_ranking_summary_all_keywords_declined | NUMERIC | Campaign Ranking Summary All Keywords Declined | Number of keywords whose ranking declined during the selected period |
| campaign_ranking_summary_all_keywords_improved | NUMERIC | Campaign Ranking Summary All Keywords Improved | Number of keywords whose ranking improved during the selected period |
| campaign_ranking_summary_average_position | NUMERIC | Campaign Ranking Summary Average Position | The mean position of all keywords in the selected set |
| campaign_ranking_summary_average_position_change | NUMERIC | Campaign Ranking Summary Average Position Change | Difference between the selected begin date and end date for this metric |
| campaign_ranking_summary_organic_visibility | NUMERIC | Campaign Ranking Summary Organic Visibility | A value between 0-100 measuring the share of organic search visibility. Roughly equates to the average expected click-through rate of all keywords tracked in the current set. |
| campaign_ranking_summary_organic_visibility_change | NUMERIC | Campaign Ranking Summary Organic Visibility Change | Difference between the selected begin date and end date for this metric |
| campaign_ranking_summary_position_1 | NUMERIC | Campaign Ranking Summary Position 1 | Number of keywords with a ranking position of 1 |
| campaign_ranking_summary_position_11_20 | NUMERIC | Campaign Ranking Summary Position 11-20 | Number of keywords with a ranking position between 11 and 20 |
| campaign_ranking_summary_position_11_20_change | NUMERIC | Campaign Ranking Summary Position 11-20 Change | Difference between the selected begin date and end date for this metric |
| campaign_ranking_summary_position_11_20_entered | NUMERIC | Campaign Ranking Summary Position 11-20 Entered | Number of keywords with a ranking position between 11 and 20 on the end date that were not in this position on the begin date of the selected range |
| campaign_ranking_summary_position_11_20_left | NUMERIC | Campaign Ranking Summary Position 11-20 Left | Number of keywords with a ranking position between 11 and 20 on the begin date that were not in this position on the end date of the selected range |
| campaign_ranking_summary_position_1_change | NUMERIC | Campaign Ranking Summary Position 1 Change | Difference between the selected begin date and end date for this metric |
| campaign_ranking_summary_position_1_entered | NUMERIC | Campaign Ranking Summary Position 1 Entered | Number of keywords with a ranking position of 1 on the end date that were not at position 1 on the begin date of the selected range |
| campaign_ranking_summary_position_1_left | NUMERIC | Campaign Ranking Summary Position 1 Left | Number of keywords with a ranking position of 1 on the begin date that were not at position 1 on the end date of the selected range |
| campaign_ranking_summary_position_21_50 | NUMERIC | Campaign Ranking Summary Position 21-50 | Number of keywords with a ranking position between 21 and 50 |
| campaign_ranking_summary_position_21_50_change | NUMERIC | Campaign Ranking Summary Position 21-50 Change | Difference between the selected begin date and end date for this metric |
| campaign_ranking_summary_position_21_50_entered | NUMERIC | Campaign Ranking Summary Position 21-50 Entered | Number of keywords with a ranking position between 21 and 50 on the end date that were not in this position on the begin date of the selected range |
| campaign_ranking_summary_position_21_50_left | NUMERIC | Campaign Ranking Summary Position 21-50 Left | Number of keywords with a ranking position between 21 and 50 on the begin date that were not in this position on the end date of the selected range |
| campaign_ranking_summary_position_2_5 | NUMERIC | Campaign Ranking Summary Position 2-5 | Number of keywords with a ranking position between 2 and 5 |
| campaign_ranking_summary_position_2_5_change | NUMERIC | Campaign Ranking Summary Position 2-5 Change | Difference between the selected begin date and end date for this metric |
| campaign_ranking_summary_position_2_5_entered | NUMERIC | Campaign Ranking Summary Position 2-5 Entered | Number of keywords with a ranking position between 2 and 5 on the end date that were not in this position on the begin date of the selected range |
| campaign_ranking_summary_position_2_5_left | NUMERIC | Campaign Ranking Summary Position 2-5 Left | Number of keywords with a ranking position between 2 and 5 on the begin date that were not in this position on the end date of the selected range |
| campaign_ranking_summary_position_51+ | NUMERIC | Campaign Ranking Summary Position 51+ | Number of keywords with a ranking position that were not found in the top 50 results |
| campaign_ranking_summary_position_51+_change | NUMERIC | Campaign Ranking Summary Position 51+ Change | Difference between the selected begin date and end date for this metric |
| campaign_ranking_summary_position_51+_entered | NUMERIC | Campaign Ranking Summary Position 51+ Entered | Number of keywords with a ranking position that were not found in the top 50 results on the end date that were found in the top 50 results on the begin date of the selected range |
| campaign_ranking_summary_position_51+_left | NUMERIC | Campaign Ranking Summary Position 51-100 Left | Number of keywords with a ranking position that were not found in the top 50 results on the begin date that were found in the top 50 results on the end date of the selected range |
| campaign_ranking_summary_position_6_10 | NUMERIC | Campaign Ranking Summary Position 6-10 | Number of keywords with a ranking position between 6 and 10 |
| campaign_ranking_summary_position_6_10_change | NUMERIC | Campaign Ranking Summary Position 6-10 Change | Difference between the selected begin date and end date for this metric |
| campaign_ranking_summary_position_6_10_entered | NUMERIC | Campaign Ranking Summary Position 6-10 Entered | Number of keywords with a ranking position between 6 and 10 on the end date that were not in this position on the begin date of the selected range |
| campaign_ranking_summary_position_6_10_left | NUMERIC | Campaign Ranking Summary Position 6-10 Left | Number of keywords with a ranking position between 6 and 10 on the begin date that were not in this position on the end date of the selected range |
| campaign_ranking_summary_search_engine | TEXT | Campaign Ranking Summary Search Engine | The search engine code for this search engine. Search engine codes are in the following format: {SEARCH ENGINE NAME}|{COUNTRY CODE}|{LANGUAGE CODE}|{DEVICE}|{LOCATION} For example: google|us|en|desktop. |
| campaign_ranking_summary_top_10 | NUMERIC | Campaign Ranking Summary Top 10 | Number of keywords with a ranking position in the top 10 results |
| campaign_ranking_summary_top_10_entered | NUMERIC | Campaign Ranking Summary Top 10 Entered | Number of keywords with a ranking position in the top 10 results on the end date that were not in the top 10 results on the begin date of the selected range |
| campaign_ranking_summary_top_10_left | NUMERIC | Campaign Ranking Summary Top 10 Left | Number of keywords with a ranking position in the top 10 results on the begin date that were not in the top 10 results on the end date of the selected range |
| campaign_ranking_summary_top_50 | NUMERIC | Campaign Ranking Summary Top 50 | Number of keywords with a ranking position in the top 50 results |
| campaign_ranking_summary_top_50_entered | NUMERIC | Campaign Ranking Summary Top 50 Entered | Number of keywords with a ranking position in the top 50 results on the end date that were not in the top 50 results on the begin date of the selected range |
| campaign_ranking_summary_top_50_left | NUMERIC | Campaign Ranking Summary Top 50 Left | Number of keywords with a ranking position in the top 50 results on the begin date that were not in the top 50 results on the end date of the selected range |
| campaign_ranking_summary_traffic_index | NUMERIC | Campaign Ranking Summary Traffic Index | An estimate of the site's monthly organic traffic from the tracked keywords in this set. |
| campaign_ranking_summary_traffic_index_change | NUMERIC | Campaign Ranking Summary Traffic Index Change | Difference between the selected begin date and end date for this metric |
| campaign_search_engines_id | TEXT | Campaign Search Engines ID | The search engine code for this search engine. Search engine codes are in the following format: {SEARCH ENGINE NAME}|{COUNTRY CODE}|{LANGUAGE CODE}|{DEVICE}|{LOCATION} For example: google|us|en|desktop |
| campaign_search_engines_name | TEXT | Campaign Search Engines Name | Plain English name of the search engine (e.g. Google us-EN (desktop)) |
| campaign_site | TEXT | Campaign Site | The site URL for this campaign. |
| campaign_site_scope | TEXT | Campaign Site Scope | Defines the scope of which URLs will be included in this site. Enum: "root domain" "subdomain subfolder" "exact url" "root domain only" |
| campaign_status | TEXT | Campaign Status | Whether the campaign is active or paused. Enum: "active" "paused" |
| campaign_tags | TEXT | Campaign Tags | A list of all tags in the campaign |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
| date | DATE | Date | The Date |
| day_of_month | TEXT | Day of month | Day of the month |
| month | TEXT | Month | Number of the month |
| source | TEXT | Source | The name of the Windsor connector returning the row |
| today | DATE | Today | Today's date |
| week | TEXT | Week | Week (Sun-Sat). |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). |
| year | TEXT | Year | Year |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |