Datapipe
SEO agencies
Drop rankings into every client report on schedule.
Read & reportOwner-approved writesBeta
Connect Semrush domain visibility and keyword rankings to your reports.
Track organic search traffic, keyword ranking shifts, and technical audit health in one workspace.
- Rankings and audit results in your client reports automatically
- Track keyword movement without exporting from Semrush
- Rankings and real search clicks in the same project
Sheets
Looker Studio
BigQuery
Drive
CSV
Claude
ChatGPTUpdated November 2026
| Tracked search keyword | Ranking position | Search volume |
|---|---|---|
| 1,240 | 1,240 | 12,500 |
| 640 | 640 | 640 |
| 210 | 210 | 210 |
- SetupPaste a key or token
- Reads16 metrics and 4 ways to split them
- Changes1 owner-approved action
- RefreshDaily to every 15 minutes
Who uses Datapipe with Semrush
Local marketers
Track local visibility next to calls and leads.
In-house SEO leads
Show leadership ranking trends without building slides.
What you can do with Semrush
Read and report
Read domain visibility estimates, keyword ranking positions, and technical audit scores using your Semrush API key.
- Domain search overview
- Tracked keyword positions
- Technical site audit
Change with owner approval
- Add or update tracked keyword in project
The owner reviews the exact values and approves every proposed change before it is applied to Semrush.
Full read details
Metrics reflect search engine results.
Examples for your team
Track daily organic keyword ranking changes
Monitor keyword ranking movements across Google and Bing alongside monthly search volume trends.
- Scheduled refresh
- Latest Semrush data
- Updated report
Add or update tracked keyword in project
A team member proposes tracking a high-intent commercial keyword or updating its landing page mapping.
- Proposed
- Owner approves
- Applied and logged
Limit: The owner reviews the target query before approving.
Fix things in Semrush without opening it
Spot it, fix it
See the problem in your report, then propose the fix in Datapipe instead of opening Semrush, finding the record and retyping it.
More people can help
Teammates and AI tools can suggest changes without getting edit access to Semrush.
Nothing changes without your yes
You see the current and proposed value side by side, and every change is logged.
Jobs you can stop doing by hand in Semrush
Add or update tracked keyword in project
Add new commercial search query to project position tracking
TodayLog in to Semrush console, open Position Tracking project, click Add Keywords, enter query, and submit.
With DatapipeDiscover rising keyword opportunities in your weekly search report, propose tracking the query, and agency SEO director approves after review.
Update target landing page mapping for declining keyword
TodayOpen Semrush tracking settings, locate keyword row, and manually edit the mapped target URL.
With DatapipeDetect ranking drop on a commercial query, propose pointing tracking to the updated product page, and account lead approves after review.
Exactly what this can change
Tracks a new search keyword or updates the target landing page URL in a Semrush position tracking project. Historical tracking data is preserved. Every change requires owner approval.
Supported fields: Tracked search keyword, Target landing page URL.
Add or update tracked keyword in projectTracked Keyword · b2b crm software (#kw_882) · proposed by Jordan Blake
| Field | Current value | Proposed value |
|---|---|---|
| Target URL | https://example.com/blog/crm | https://example.com/solutions/crm |
Every team member's change needs owner approval
- Owner turns on an action
- A teammate or AI tool proposes
- Check the current and proposed values, then approve that individual change
- Applied once and logged
Source changes use the separate Actions & approvals workflow in Datapipe. AI tools such as ChatGPT can propose changes but never approve them. Who can turn this on?
Provider rules and limits
Provider permissions still apply, and automations in Semrush may react to approved changes.
Only fields supported by an enabled action can be proposed; some actions also support individual owner-selected writable fields.
Before you connect
What you need
Enter your Semrush account key.
Read and write
Read access for reports. The change action needs edit access in Semrush and stays off until the owner turns it on.
Limits and exclusions
Anything your connected account cannot see in Semrush.
Full details and limits
Domain search visibility estimates, tracked keyword ranking positions, and technical crawl health scores.
Reporting reads search performance and keyword rankings. Adding or updating tracked queries requires owner approval.
Reports you can build
3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
- Domain search overview
- Tracked keyword positions
- Technical site audit
What each dataset reports
- Domain search overview
Organic search traffic estimates, paid traffic, keyword counts, and backlink totals.
- Tracked keyword positions
Daily search engine ranking positions, search volumes, and ranking destination URLs.
- Technical site audit
Technical crawl health scores, errors, warnings, and issue breakdowns.
Metrics and dimensions
16 metrics and 4 ways to split them.
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 Semrush data anywhere
Google SheetsA sheet that refreshes every morning.Looker StudioCharts that read the same numbers.BigQueryA warehouse table for the same columns.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.
AI tools can also propose a Semrush change. Only the owner can approve it.
Which tracked commercial search keywords in Semrush dropped more than two ranking positions this week?
The query 'b2b crm software' dropped from position 2 to position 4, while 'workflow automation' rose from position 5 to position 3.
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.
- Each search can show clicks and how high you ranked.
Start from a goal
Domain search overview
Organic search traffic estimates, paid traffic, keyword counts, and backlink totals.
Use this template →Tracked keyword positions
Daily search engine ranking positions, search volumes, and ranking destination URLs.
Use this template →Technical site audit
Technical crawl health scores, errors, warnings, and issue breakdowns.
Use this template →How it works
Create a project and choose Semrush in Data sources.
Enter your Semrush account key.
Pick where it goes. Choose domain overview, rankings, or site audit and a destination.
Sample report
| Tracked search keyword | Ranking position | Search volume | Landing page URL | Domain name | Organic search traffic | Total backlinks | Organic search cost |
|---|---|---|---|---|---|---|---|
| 1,240 | 1,240 | 12,500 | 1,240 | northwind.example | 1,240 | 1,240 | $80.00 |
| 640 | 640 | 640 | 640 | harbor.example | 640 | 640 | $125.50 |
| 210 | 210 | 210 | 210 | acme.example | 210 | 210 | $42.00 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Works well with Semrush
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.
Semrush + Search Console“Do ranking gains show up as real clicks in Search Console?”See Search Console →
Semrush + Google Analytics“Did ranking gains bring more visits?”See Google Analytics →
Semrush + CallRail“Did better local rankings bring more calls?”See CallRail →
Semrush + WordPress“Which ranking pages are due for a content refresh?”See WordPress →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.
Only the workspace owner. Writes start disabled. The owner enables permitted actions and eligible teammates: owner only, all project operators and managers, or selected teammates. The owner can change this at any time, and saving new settings cancels pending proposals.
No. Teammates propose in Datapipe, and approved changes are applied through the connected Semrush account. Nobody else gets a Semrush login from this.
They can propose a change through Datapipe, the same way a teammate can. They can never approve it. Only the owner approves, in Actions & approvals.
Datapipe sends each approved change once and logs the result. If it cannot confirm that Semrush received it, the request is marked Uncertain and is never retried automatically, so you can check Semrush first.
Yes. Datapipe reads the reports on this page and can make one kind of change: add or update tracked keyword in project. Each one stays off until the owner turns it on, and every proposed change needs the owner's approval. Provider permissions still apply.
This page lists 16 metrics and 4 ways to split them. You pick the columns when you build the report.
Domain search visibility estimates, tracked keyword ranking positions, and technical crawl health scores. Account permissions and the records available from the provider determine which rows can be read.
One for each Semrush 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 Semrush with sample data first
Build the report first, then add Semrush when you are ready.