Dragonmetrics Connector Reference

43 metrics37 dimensions

Fields

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

The Dragonmetrics connector exposes 80 fields (43 metrics, 37 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Dragonmetrics Fields

Dragonmetrics General fields

The General report of the Dragonmetrics connector includes 62 fields.

Dragonmetrics General fields (account_id to campaign_ranking_summary_position_51+_change)

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

Dragonmetrics General fields (campaign_ranking_summary_position_51+_entered to date)

ID	Type	Name	Description
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
date	DATE	Date	The Date

Dragonmetrics other fields

The Dragonmetrics connector has 18 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
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_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
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