Read & reportOwner-approved writes

Read WordPress content and approve draft corrections.

Keep current content inventory and individually approved draft edits in the same project.

Sheets

Looker Studio

BigQuery

Drive

CSV

Claude

ChatGPT

Start free Connect WordPress

Updated November 2026

What you can do with WordPress

Read and report

Read current posts and pages, including draft publication state, native IDs, titles, excerpts and content. Report dates do not filter inventory.

Explore metrics and dimensions

Write with owner approval

Eligible teammates can propose the supported changes listed below. The owner reviews the exact values and approves every proposed change before it is applied to WordPress.

See supported write actions

Examples for your team

Illustrative workflows using the supported capabilities. Connect your own account to work with your data.

Read & report

Prepare a client content review

Refresh content IDs, publication states and timestamps in your reporting destination. These are current content records rather than pageview or conversion analytics.

Owner-approved write

Review a draft correction before handoff

A teammate proposes a clearer draft title or plain-text excerpt. The owner reviews the exact replacement before it reaches WordPress. Outside edits or publishing can race the final check because WordPress has no atomic draft/version lock.

Supported WordPress write actions

Writes start disabled. The owner enables permitted actions and eligible teammates. Only fields supported by an enabled action can be proposed; some actions also support individual owner-selected writable fields.

Update draft post title or excerpt

Updates only owner-selected title/excerpt fields on an existing draft. Plain text replaces formatting in edited excerpts. Native permissions are required. WordPress has no atomic version/status lock: outside edits or publishing can race the final draft check. No publish, schedule, body, page, slug, creation or deletion action is offered. Every teammate proposal requires individual owner approval; uncertain requests never retry automatically.

The owner selects supported writable fields for this action before teammates can propose changes.

Every team member's change needs owner approval

The owner sets access
Choose the connection, permitted actions and eligible teammates. Select individual writable fields where the action supports it.
A teammate proposes a change
Choose an existing record and propose specific supported values. A proposal does not apply the change.
The owner reviews the difference
Check the current and proposed values, then approve that individual change. Changed records or permissions require a fresh review.
Datapipe records the result
View the result in the audit history. An uncertain write is not automatically retried.

Provider permissions and workflows still apply. Source automations or notifications may react to approved changes.

Connected assistants can read available reports. Source changes use the separate Actions & approvals workflow in Datapipe.

Start with a controlled connection

Reports you can build

2 reporting datasets with their own fields. Choose a dataset in the app, then select the columns you need.

See included datasets and what they report

WordPress posts
Current accessible content inventory; report dates do not filter creation or reconstruct historical state. Native text and missing values are retained. Incomplete pagination fails visibly. Includes publish, future, draft, pending and private posts accessible with edit context; trash, custom post types and analytics are excluded.
WordPress pages
Current accessible content inventory; report dates do not filter creation or reconstruct historical state. Native text and missing values are retained. Incomplete pagination fails visibly. Includes publish, future, draft, pending and private pages. Page writes are excluded.

Current inventory is separate from dated performance reporting. Only supported owner-selected draft text can be changed, with individual approval for every teammate proposal.

Metrics and dimensions

24 report fields across 2 datasets.

Browse the documented fields below. In the app, choose your project connection to load its field list. Availability depends on API permissions, report type, and compatible field combinations. Property-specific custom fields appear after connecting.

Send WordPress 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.

Use an assistant to understand the reports. Propose source changes separately in Datapipe, where the owner reviews and approves every change.

Better than exporting by hand

You can keep a row per day instead of one lump sum.

Start from a goal

WordPress posts

Current accessible content inventory; report dates do not filter creation or reconstruct historical state. Native text and missing values are retained. Incomplete pagination fails visibly. Includes publish, future, draft, pending and private posts accessible with edit context; trash, custom post types and analytics are excluded.

Use this

WordPress pages

Use this

How it works

Create a project and choose WordPress in Connections.
Enter the installation address, dedicated username and revocable application password.
Pick where it goes. Choose the content report and destination. Optional draft writes stay disabled until the owner selects fields and permissions in Actions.

Sample report

Sample

Post ID	Title (raw)	Excerpt (raw)	Content (raw)	Status	Slug	URL	Author ID
1,240	1,240	1,240	1,240	Paid	1,240	1,240	1,240
640	640	640	640	Pending	640	640	640
210	210	210	210	Refunded	210	210	210

Sample numbers, so you can see the shape. Your report uses your accounts.

Read current accessible posts and pages from the connected WordPress installation, including raw titles, excerpts, body content, status, URL, author, timestamps and native category/tag IDs. Publish, future, draft, pending and private states require edit-context access. Report dates do not filter inventory. Custom types, trash and web analytics are excluded.

Questions

How much does it cost?

Free to start. Paid plans add more connections and refresh faster.

How fresh is the data?

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 connections.

Do I need to code?

No. Name a project, add a connection, then choose a report and destination.

Can Datapipe read and write WordPress data?

Datapipe reads the supported reports listed on this page and offers the write actions shown above. Writes start disabled. The owner enables permitted actions and eligible teammates; individual writable-field selection is available on supported actions. Every team member's proposed change needs a separate owner review and approval. Provider permissions still apply.

Which numbers can I use?

This page lists 24 report fields across 2 datasets. You pick the columns when you build the report.

Why is a row missing?

Can I send this to more than one place?

Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.

Related sources

Start free