Datapipe
Marketers
See which channels and pages bring visitors who convert.
Read & reportOwner-approved writesBeta
See your Whitespark numbers in BigQuery.
Monitor Google Maps rankings, local citation coverage, and competitor positions.
- Traffic, sources and conversions in a sheet or dashboard, refreshed for you
- A weekly traffic report nobody has to rebuild
- Ask ChatGPT or Claude what changed, using live Whitespark numbers
BigQueryUpdated November 2026
| Tracked search query | Local 3-Pack rank | Organic search rank |
|---|---|---|
| winter coats | 1,240 | 1,240 |
| canvas tote | 640 | 640 |
| brand name | 210 | 210 |
- SetupPaste a key or token
- Reads6 metrics and 3 ways to split them
- Changes1 owner-approved action
- RefreshDaily to every 15 minutes
Who uses Datapipe with Whitespark
Founders
Get a weekly traffic summary without opening another dashboard.
Agencies
Send each client the same clean traffic report every month.
What you can do with Whitespark
Read and report
Read Google Maps Local 3-Pack rankings, citation audit consistency scores, and local competitor benchmarks using your Whitespark credentials.
- Local 3-Pack rank positions
- Local citation audit
- Local competitor benchmark
Change with owner approval
- Add local keyword to rank tracker
The owner reviews the exact values and approves every proposed change before it is applied to Whitespark.
Examples for your team
Track Google Local 3-Pack rank and citation audits
Monitor map pack rankings for target queries and audit citation consistency across business directories.
- Scheduled refresh
- Latest Whitespark data
- Updated report
Add localized search query to rank tracker
An account lead queues a new neighborhood query and postal area in Local Rank Tracker.
- Proposed
- Owner approves
- Applied and logged
Limit: The project manager verifies the target area before initiating tracking.
Fix things in Whitespark without opening it
Spot it, fix it
See the problem in your report, then propose the fix in Datapipe instead of opening Whitespark, finding the record and retyping it.
More people can help
Teammates and AI tools can suggest changes without getting edit access to Whitespark.
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 Whitespark
Add local keyword to rank tracker
Add neighborhood search query to Whitespark Local 3-Pack rank tracker
TodayLog in to Whitespark Local Rank Tracker, select campaign, click Add Keywords, enter query and postal code, and save.
With DatapipeIdentify high-value service query, propose tracking Google Local 3-Pack positions, and local SEO manager approves after review.
Track competitor map pack rank for newly targeted service area
TodayOpen Whitespark campaign, enter target zip code and search term, and save settings.
With DatapipeSubmit localized search query for map pack monitoring, and agency lead approves before position tracking begins.
Exactly what this can change
Adds a localized search keyword and geographic postal area to a Whitespark Local Rank Tracker project. Historical 3-Pack rank data is preserved. Every change requires owner approval.
Supported fields: Target local query, Target postal or zip code.
Add local keyword to rank trackerRank Tracker Query · cosmetic dentist downtown (#ws_1102) · proposed by Jordan Blake
| Field | Current value | Proposed value |
|---|---|---|
| Tracked query | cosmetic dentist downtown (Zip: 78701) |
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 Whitespark 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
An API key or token from your Whitespark account.
Read and write
Read access for reports. The change action needs edit access in Whitespark and stays off until the owner turns it on.
Limits and exclusions
Anything your connected account cannot see in Whitespark.
Full details and limits
Local search rank positions, Google Local 3-Pack placement, citation audits, and local competitor search benchmarks.
Reporting reads local rank tracker positions and citation audits. Refreshing campaign rankings requires owner approval.
Reports you can build
3 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
- Local 3-Pack rank positions
- Local citation audit
- Local competitor benchmark
What each dataset reports
- Local 3-Pack rank positions
Google Maps Local 3-Pack ranks, localized organic ranks, and search engine variants.
- Local citation audit
Structured directory citations count, NAP consistency scores, and potential citations.
- Local competitor benchmark
Top local competitor pack ranks, local search share of voice, and visibility index.
Metrics and dimensions
6 metrics and 3 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 Whitespark data anywhere
Google SheetsA sheet that refreshes every morning.
Data 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 Whitespark change. Only the owner can approve it.
Where does our clinic rank in the Google Local 3-Pack for our primary service queries in Whitespark?
Your clinic ranks position 2 in the Google Local 3-Pack for 'cosmetic dentist downtown' in postal code 78701, while organic rank is position 4.
Better than exporting by hand
- It refreshes on its own, so nobody pastes in a new export.
- Each search can show clicks and how high you ranked.
Start from a goal
Local 3-Pack rank positions
Google Maps Local 3-Pack ranks, localized organic ranks, and search engine variants.
Use this template →Local citation audit
Structured directory citations count, NAP consistency scores, and potential citations.
Use this template →Local competitor benchmark
Top local competitor pack ranks, local search share of voice, and visibility index.
Use this template →How it works
Create a project and select Whitespark in Data sources.
Pick where it goes. This one sends the numbers to BigQuery.
Pick where it goes. Choose local rank tracker or citation audit and a destination.
Sample report
| Tracked search query | Local 3-Pack rank | Organic search rank | Competitor rank | Directory name | Citation status | Listing URL | Domain authority |
|---|---|---|---|---|---|---|---|
| winter coats | 1,240 | 1,240 | 1 | 1,240 | Paid | 1,240 | northwind.example |
| canvas tote | 640 | 640 | 640 | 640 | Pending | 640 | harbor.example |
| brand name | 210 | 210 | 210 | 210 | Refunded | 210 | acme.example |
Sample numbers, so you can see the shape. Your report uses your accounts.
Works well with Whitespark
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.
Whitespark + Search Console“Are search clicks and site visits moving together?”See Search Console →
Whitespark + Shopify“Did more visits mean more orders this week?”See Shopify →
Whitespark + Stripe“Did the traffic spike bring new paying customers?”See Stripe →
Whitespark + HubSpot“Which weeks with more traffic also brought more deals?”See HubSpot →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 Whitespark account. Nobody else gets a Whitespark 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 Whitespark received it, the request is marked Uncertain and is never retried automatically, so you can check Whitespark first.
Yes. Datapipe reads the reports on this page and can make one kind of change: add local keyword to rank tracker. 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 6 metrics and 3 ways to split them. You pick the columns when you build the report.
Local search rank positions, Google Local 3-Pack placement, citation audits, and local competitor search benchmarks. Account permissions and the records available from the provider determine which rows can be read.
One for each Whitespark 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 Whitespark with sample data first
Build the report first, then add Whitespark when you are ready.