WordPress content report template

The current posts and pages visible to the connected WordPress user: titles, IDs, native publishing status, URLs, author IDs, GMT dates and taxonomy IDs. The dashboard adds counts and time-since-modification flags from those fields. It does not include traffic, rankings, conversions or a content quality score.

No. Each refresh reads the current inventory and replaces the same worksheets. The four worksheets are separate views of the same records; do not add their totals together. The date distribution describes native content dates in the current records, not a historical snapshot of the site. Publication dates apply to published items; a future item has its scheduled date and draft dates can be provisional.

An item must have publish status and a native modification timestamp at least 90 days before the read. The flag is a starting point for an editorial review. Age does not establish that a page is inaccurate, low quality or performing badly. Missing modification dates stay unavailable.

Add WordPress as a data source in the intended Datapipe project using the supported authorization for your site. Choose that site explicitly, create this dashboard and authorize Google Sheets separately. Datapipe prepares the current posts and pages in four worksheets, with a Data Studio copy link that replaces every source.

Yes, if the connected WordPress user can read it. Keep the workbook and Data Studio report Restricted.

Save a copy in Data Studio, then change the logo, titles, colors, charts and layout for your team or clients.

The editable Data Studio copy, PDF and CSV are free. A Google account is needed to save a copy. Datapipe plans apply to connecting and refreshing your own data.