Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Serpstat data to
Serpstat Connector Reference
57 metrics20 dimensions
The Serpstat connector exposes 77 fields (57 metrics, 20 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Serpstat Fields
Serpstat Domain competitors fields
The Domain competitors report of the Serpstat connector includes 21 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| domaincompetitors__ad_keywords | NUMERIC | Domain competitors.ad_keywords | Domain competitors.ad_keywords |
| domaincompetitors__ads | NUMERIC | Domain competitors.ads | Domain competitors.ads |
| domaincompetitors__ads_dynamic | NUMERIC | Domain competitors.ads_dynamic | Domain competitors.ads_dynamic |
| domaincompetitors__common | NUMERIC | Domain competitors.common | Domain competitors.common |
| domaincompetitors__domain | TEXT | Domain competitors.domain | Domain competitors.domain |
| domaincompetitors__down_keywords | NUMERIC | Domain competitors.down_keywords | Domain competitors.down_keywords |
| domaincompetitors__intersected | NUMERIC | Domain competitors.intersected | Domain competitors.intersected |
| domaincompetitors__keywords | NUMERIC | Domain competitors.keywords | Domain competitors.keywords |
| domaincompetitors__keywords_dynamic | NUMERIC | Domain competitors.keywords_dynamic | Domain competitors.keywords_dynamic |
| domaincompetitors__missing | NUMERIC | Domain competitors.missing | Domain competitors.missing |
| domaincompetitors__new_keywords | NUMERIC | Domain competitors.new_keywords | Domain competitors.new_keywords |
| domaincompetitors__new_relevance | NUMERIC | Domain competitors.new_relevance | Domain competitors.new_relevance |
| domaincompetitors__not_intersected | NUMERIC | Domain competitors.not_intersected | Domain competitors.not_intersected |
| domaincompetitors__our_relevance | NUMERIC | Domain competitors.our_relevance | Domain competitors.our_relevance |
| domaincompetitors__out_keywords | NUMERIC | Domain competitors.out_keywords | Domain competitors.out_keywords |
| domaincompetitors__relevance | NUMERIC | Domain competitors.relevance | Domain competitors.relevance |
| domaincompetitors__rised_keywords | NUMERIC | Domain competitors.rised_keywords | Domain competitors.rised_keywords |
| domaincompetitors__traff | NUMERIC | Domain competitors.traff | Domain competitors.traff |
| domaincompetitors__traff_dynamic | NUMERIC | Domain competitors.traff_dynamic | Domain competitors.traff_dynamic |
| domaincompetitors__visible | NUMERIC | Domain competitors.visible | Domain competitors.visible |
| domaincompetitors__visible_dynamic | NUMERIC | Domain competitors.visible_dynamic | Domain competitors.visible_dynamic |
Serpstat Domain history fields
The Domain history report of the Serpstat connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| domainhistory__ad_keywords | NUMERIC | Domain history.ad_keywords | Domain history.ad_keywords |
| domainhistory__ads | NUMERIC | Domain history.ads | Domain history.ads |
| domainhistory__date | TEXT | Domain history.date | Domain history.date |
| domainhistory__domain | TEXT | Domain history.domain | Domain history.domain |
| domainhistory__down_keywords | NUMERIC | Domain history.down_keywords | Domain history.down_keywords |
| domainhistory__keywords | NUMERIC | Domain history.keywords | Domain history.keywords |
| domainhistory__new_keywords | NUMERIC | Domain history.new_keywords | Domain history.new_keywords |
| domainhistory__out_keywords | NUMERIC | Domain history.out_keywords | Domain history.out_keywords |
| domainhistory__rised_keywords | NUMERIC | Domain history.rised_keywords | Domain history.rised_keywords |
| domainhistory__traff | NUMERIC | Domain history.traff | Domain history.traff |
| domainhistory__visible | NUMERIC | Domain history.visible | Domain history.visible |
| domainhistory__visible_static | NUMERIC | Domain history.visible_static | Domain history.visible_static |
Serpstat Domain keywords fields
The Domain keywords report of the Serpstat connector includes 16 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| domainkeywords__concurrency | NUMERIC | Domain keywords.concurrency | Domain keywords.concurrency |
| domainkeywords__cost | NUMERIC | Domain keywords.cost | Domain keywords.cost |
| domainkeywords__difficulty | NUMERIC | Domain keywords.difficulty | Domain keywords.difficulty |
| domainkeywords__domain | TEXT | Domain keywords.domain | Domain keywords.domain |
| domainkeywords__dynamic | NUMERIC | Domain keywords.dynamic | Domain keywords.dynamic |
| domainkeywords__found_results | NUMERIC | Domain keywords.found_results | Domain keywords.found_results |
| domainkeywords__geo_names | OBJECT | Domain keywords.geo_names | Domain keywords.geo_names |
| domainkeywords__keyword | TEXT | Domain keywords.keyword | Domain keywords.keyword |
| domainkeywords__keyword_length | NUMERIC | Domain keywords.keyword_length | Domain keywords.keyword_length |
| domainkeywords__position | NUMERIC | Domain keywords.position | Domain keywords.position |
| domainkeywords__region_queries_count | NUMERIC | Domain keywords.region_queries_count | Domain keywords.region_queries_count |
| domainkeywords__region_queries_count_wide | NUMERIC | Domain keywords.region_queries_count_wide | Domain keywords.region_queries_count_wide |
| domainkeywords__subdomain | TEXT | Domain keywords.subdomain | Domain keywords.subdomain |
| domainkeywords__traff | NUMERIC | Domain keywords.traff | Domain keywords.traff |
| domainkeywords__types | OBJECT | Domain keywords.types | Domain keywords.types |
| domainkeywords__url | TEXT | Domain keywords.url | Domain keywords.url |
Serpstat Domain keywords by region fields
The Domain keywords by region report of the Serpstat connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| domainkeywordsbyregion__country_name_en | TEXT | Domain keywords by region.country_name_en | Domain keywords by region.country_name_en |
| domainkeywordsbyregion__db_name | TEXT | Domain keywords by region.db_name | Domain keywords by region.db_name |
| domainkeywordsbyregion__domain | TEXT | Domain keywords by region.domain | Domain keywords by region.domain |
| domainkeywordsbyregion__keywords_count | NUMERIC | Domain keywords by region.keywords_count | Domain keywords by region.keywords_count |
Serpstat Domain top pages fields
The Domain top pages report of the Serpstat connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| domaintoppages__facebook_shares | NUMERIC | Domain top pages.facebook_shares | Domain top pages.facebook_shares |
| domaintoppages__organic_keywords | NUMERIC | Domain top pages.organic_keywords | Domain top pages.organic_keywords |
| domaintoppages__potencial_traff | NUMERIC | Domain top pages.potencial_traff | Domain top pages.potencial_traff |
| domaintoppages__url | TEXT | Domain top pages.url | Domain top pages.url |
Serpstat Domains summary fields
The Domains summary report of the Serpstat connector includes 15 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| domainssummary__ad_keywords | NUMERIC | Domains summary.ad_keywords | Domains summary.ad_keywords |
| domainssummary__ads | NUMERIC | Domains summary.ads | Domains summary.ads |
| domainssummary__ads_dynamic | NUMERIC | Domains summary.ads_dynamic | Domains summary.ads_dynamic |
| domainssummary__domain | TEXT | Domains summary.domain | Domains summary.domain |
| domainssummary__down_keywords | NUMERIC | Domains summary.down_keywords | Domains summary.down_keywords |
| domainssummary__keywords | NUMERIC | Domains summary.keywords | Domains summary.keywords |
| domainssummary__keywords_dynamic | NUMERIC | Domains summary.keywords_dynamic | Domains summary.keywords_dynamic |
| domainssummary__new_keywords | NUMERIC | Domains summary.new_keywords | Domains summary.new_keywords |
| domainssummary__out_keywords | NUMERIC | Domains summary.out_keywords | Domains summary.out_keywords |
| domainssummary__prev_date | TEXT | Domains summary.prev_date | Domains summary.prev_date |
| domainssummary__rised_keywords | NUMERIC | Domains summary.rised_keywords | Domains summary.rised_keywords |
| domainssummary__traff | NUMERIC | Domains summary.traff | Domains summary.traff |
| domainssummary__traff_dynamic | NUMERIC | Domains summary.traff_dynamic | Domains summary.traff_dynamic |
| domainssummary__visible | NUMERIC | Domains summary.visible | Domains summary.visible |
| domainssummary__visible_dynamic | NUMERIC | Domains summary.visible_dynamic | Domains summary.visible_dynamic |
Serpstat other fields
The Serpstat connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| data_fetched_at | 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 | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date |