SEO leads
Track average position and visibility for priority sites.
Read & reportRead-only source
See your Nightwatch numbers in ClickHouse.
Follow average position, visibility and keyword positions for a tracked URL.
- Average position, visibility and keyword distribution for each tracked URL in a refreshing report
- Keyword positions with change and search volume, without exporting from Nightwatch
- A daily visibility trend for client reporting
ClickHouseUpdated November 2026
| Average position | Search visibility | Click potential |
|---|---|---|
| 1,240 | 1,240 | 860 |
| 640 | 640 | 410 |
| 210 | 210 | 155 |
- SetupPaste a key or token
- Reads27 report fields across 3 datasets
- ChangesNone, read-only
- RefreshDaily to every 15 minutes
Who uses Datapipe with Nightwatch
Agency analysts
Build weekly ranking reports for each tracked URL.
Local SEO specialists
Watch keyword positions by country and device.
What you can do with Nightwatch
Read and report
Read tracked URL summaries, keyword positions and daily trends with your Nightwatch API token.
- Tracked URL summary
- Tracked keywords
- Daily URL trend
Read-only source
Datapipe reads Nightwatch data for reports. It never changes anything in Nightwatch.
Examples for your team
Monitor keyword positions and visibility
Compare average position and visibility over your report dates with each keyword's current position.
- Scheduled refresh
- Latest Nightwatch data
- Updated report
Before you connect
What you need
An API key or token from your Nightwatch account.
Read-only
Read access only. Datapipe never changes anything in Nightwatch.
Limits and exclusions
Read-only.
Full details and limits
Read-only. Keyword rows show the latest daily check, and visibility and click potential are Nightwatch estimates.
Reports you can build
3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
- Tracked URL summary
- Tracked keywords
- Daily URL trend
What each dataset reports
- Tracked URL summary
Average position, visibility and keyword distribution for the tracked URL over the report dates, from Nightwatch keyword stats.
- Tracked keywords
Current position, change and search volume for every keyword tracked on the URL, as of Nightwatch's latest daily check.
- Daily URL trend
Daily average position and search visibility for the tracked URL within the report dates.
Metrics and dimensions
27 report fields across 3 datasets.
Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.
No fields match. Try another search or choose All.
Send Nightwatch data anywhere
Google SheetsA sheet that refreshes every morning.
Data StudioCharts that read the same numbers.
BigQueryA warehouse table for the same columns.ClickHousePush rows into ClickHouse over HTTPS with an API key.
AWS S3Write report files to your S3 bucket with IAM access keys.
Amazon RedshiftLoad rows into Redshift via the Data API with IAM keys.
FireboltPush rows into Firebolt over HTTPS with a Service Account.
PostgreSQLWrite report rows into PostgreSQL with database credentials.
MySQLWrite report rows into MySQL with database credentials.
SnowflakePush rows into Snowflake over HTTPS with a PAT token.
Databricks SQLLoad rows into Databricks SQL with a Personal Access Token.
Cloudflare R2Write report files to your R2 bucket with access keys.
Excel / CSVA Drive file you can open in Excel.
ClaudeAsk Claude about these numbers in a sentence.
ChatGPTAsk ChatGPT about these numbers in a sentence.
APIRead the same rows from your own tool.Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.Ask AI about your data
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
How did average position and visibility change for our tracked URL this month, and which keywords fell most?
Average position improved from 14.3 to 12.8 and visibility rose 6%, but 'emergency plumber austin' dropped five places to 11.
Better than exporting by hand
- It refreshes on its own, so nobody pastes in a new export.
- The same numbers can be split by who they came from.
- You can keep a row per day instead of one lump sum.
- See whether it ran on a phone, a feed, or another placement.
- Each search can show clicks and how high you ranked.
Start from a goal
Nightwatch rank tracking dashboard
Average position, keywords in the top 10 and top 3, every tracked keyword with its change and the biggest movers in a prepared dashboard.
Use this template →Tracked URL summary
Average position, visibility and keyword distribution for the tracked URL over the report dates, from Nightwatch keyword stats.
Use this template →Tracked keywords
Current position, change and search volume for every keyword tracked on the URL, as of Nightwatch's latest daily check.
Use this template →Daily URL trend
Daily average position and search visibility for the tracked URL within the report dates.
Use this template →How it works
Choose Nightwatch in your project’s Data sources.
Pick where it goes. This one sends the numbers to ClickHouse.
Pick where it goes: a sheet, a chart, BigQuery, Drive, a CSV file, or an AI assistant.
Sample report
| Average position | Search visibility | Click potential | Keywords in top 10 | Keyword | Position | Position change | Best position |
|---|---|---|---|---|---|---|---|
| 1,240 | 1,240 | 860 | 1,240 | 1,240 | 1,240 | 1,240 | 1,240 |
| 640 | 640 | 410 | 640 | 640 | 640 | 640 | 640 |
| 210 | 210 | 155 | 210 | 210 | 210 | 210 | 210 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Works well with Nightwatch
Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.
Nightwatch + Search Console“Do position gains show up as more clicks in Search Console?”See Search Console →
Nightwatch + Google Analytics“Which ranking pages bring engaged visits?”See Google Analytics →Nightwatch + Google Sheets“Compare keyword positions with the target list your team keeps.”See Google Sheets →Questions
Free to start. Paid plans add more data sources and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.
No. Name a project, add a data source, then choose a report and destination.
OAuth means you sign in with the service and grant access, without pasting an API key. Datapipe works with multiple partners to provide that sign-in. Some partners already provide it. Some integrations are API-only at present, so you paste a key or token. OAuth is coming soon for some. Some partners do not provide OAuth at all. The setup steps on each integration page say how that source connects. Signing in is only how the connection is made. It is not permission to change records. Where a source supports changes, those writes stay off until the workspace owner turns specific actions on and approves each one. We do not promise OAuth on every source, and we do not share dates.
This integration is read-only in Datapipe. You can report on Nightwatch, send the reports to your destinations and ask an AI assistant about them. Datapipe never changes anything in Nightwatch.
This page lists 27 report fields across 3 datasets. You pick the columns when you build the report.
Available rows depend on the connected account, selected report type, its date rules and provider limits. Current-inventory reports show current records rather than earlier historical states.
One for each Nightwatch account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
Try Nightwatch with sample data first
Build the report first, then add Nightwatch when you are ready.