---
title: "Content Production Report: Export WordPress Posts per Author and per Month"
url: "https://wpimportexport.com/export-wordpress-posts-per-author-per-month/"
description: "Export published posts with author, date and word count, then build a per-author, per-month report in Excel or Google Sheets. Free."
type: post
published: 2026-11-08T21:22:06+00:00
modified: 2026-11-14T10:48:50+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["CSV import", "Import Export by RockStarLab", "WordPress export"]
docs_topics: ["Export guides"]
---

# Content Production Report: Export WordPress Posts per Author and per Month

How many posts did each author publish last quarter, and how long were they? WordPress does not show that, but the numbers are already in the posts. Export the published posts with their date, author and word count using [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/), and the file becomes a per-author, per-month report in Excel or Google Sheets. All of it works in the free version.

**Free:** exporting posts and pages with filters, Author Name, Word Count and Permalink columns, CSV and Excel files. **PRO:** custom post types, and transformations that change values during export.

## Short Answer

1. Go to **Import Export → Export** and choose **Blog Posts**.
2. Add filters: **Status** equals `publish`, **Date** greater or equal to the first day, **Date** less or equal to the last day.
3. Choose the columns **Title**, **Date**, **Author Name**, **Word Count** and **Permalink**.
4. Export to CSV and open it in a spreadsheet. A pivot table with authors in rows and months in columns gives the report.

An export only reads your content, so you don’t need a backup for it.

## The example

A store blog with four authors published 68 posts between January and June 2026. The editor wants to see who wrote how much each month, and how long the posts were.

## Step 1: Filter the posts

Go to **Import Export → Export**, choose **Blog Posts** and click **Next Step**. Click **Add Filter** three times:

- **Status**, **Equals**, `publish`. Drafts and scheduled posts stay out of the report.
- **Date**, **Greater or Equal**, 1 January 2026.
- **Date**, **Less or Equal**, 30 June 2026. The whole last day is included.

Click the refresh button on the counter. It showed 68 posts.

![Export Step 2 Filter Data: Status equals publish, Date greater or equal 01/01/2026, Date less or equal 30/06/2026, total items available 68](https://wpimportexport.com/wp-content/uploads/2026/11/01-filter-published-first-half-2026.webp)

_Published posts from January to June 2026: 68 posts._

For a report about one author, add **Author Name** equals the name. For one section of the blog, add a **Taxonomy Filter** with the category.

## Step 2: Choose the columns

Click **Next Step** and drag these fields into the **Export File Structure**:

- **Title** and **Permalink**, to find each post later.
- **Date**, for the month.
- **Author Name**, the display name of the author. **Author Email** is in the same **Author** group if two authors share a name.
- **Word Count**, the number of words in the post text. HTML tags and shortcodes are not counted.

![Export Step 3: Export File Structure with Title, Date, Author Name, Word Count and Permalink, Columns: 5](https://wpimportexport.com/wp-content/uploads/2026/11/02-columns-title-date-author-word-count.webp)

_Five columns are enough for the report._

The file uses field names such as `author_name` as column headers. To use friendlier names, click the pencil icon on a column and type, for example, _Author_.

Click **Next Step**, choose **CSV** (or Excel), name the file and click **Start Export**. When the export is complete, click **Download Export File**. The first rows of the file:

```
post_title,post_date,author_name,word_count,permalink
"Logo placement: a checklist","2026-06-19 10:07:00","Tom Becker",534,https://www.example-store.com/2026/06/19/logo-placement-a-checklist-3/
"Embroidery thread colors: a checklist","2026-05-25 10:06:00","Tom Becker",399,https://www.example-store.com/2026/05/25/embroidery-thread-colors-a-checklist-3/
```

## Step 3: Build the report in a spreadsheet

Open the CSV in Excel or import it into Google Sheets (**File → Import → Upload**). Then:

1. Add a column **Month** next to the date. In row 2, enter `=LEFT(B2,7)` if the dates stayed as text, or `=TEXT(B2,"yyyy-mm")` if the spreadsheet turned them into dates. Fill the formula down. Each row now has a month like `2026-06`.
2. Select the data and insert a pivot table (**Insert → PivotTable** in Excel, **Insert → Pivot table** in Google Sheets).
3. Put **author_name** in **Rows**, **Month** in **Columns**, and **post_title** in **Values** as COUNTA (Excel: Count).
4. For a second table with the words, use the same rows and columns with **word_count** as SUM. With AVERAGE you get the average post length.

The post count for our example:

| Author | Jan | Feb | Mar | Apr | May | Jun | Total |
| --- | --- | --- | --- | --- | --- | --- | --- |
| Lena Hart | 4 | 5 | 3 | 6 | 4 | 5 | 27 |
| Marco Diaz | 2 | 2 | 3 | 1 | 2 | 3 | 13 |
| Priya Nair | 0 | 1 | 3 | 4 | 5 | 6 | 19 |
| Tom Becker | 3 | 3 | 0 | 0 | 2 | 1 | 9 |
| **All authors** | 9 | 11 | 9 | 11 | 13 | 15 | 68 |

And the words:

| Author | Posts | Words | Average words per post |
| --- | --- | --- | --- |
| Lena Hart | 27 | 23,912 | 886 |
| Marco Diaz | 13 | 7,206 | 554 |
| Priya Nair | 19 | 23,926 | 1,259 |
| Tom Becker | 9 | 4,271 | 475 |

The report shows things a post list doesn’t: Lena Hart published the most posts, Priya Nair wrote as many words in fewer and longer posts and published more every month, and Tom Becker published nothing in March and April.

## Repeat it every month

To get a new report each month without setting it up again, open the **Schedules** page and choose this finished export as the source (see [scheduling repeated exports](https://wpimportexport.com/how-to-schedule-repeated-exports-in-wordpress/)). A scheduled export keeps the same filters. For a year-to-date report, leave out the **Less or Equal** date filter: each run then contains everything published since 1 January, and the pivot table shows every month so far.

The exported file is also a list of every published post with its address, which is useful for a [content inventory](https://wpimportexport.com/wordpress-content-inventory-export/).

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) can produce the same report. It uses `rsl-ie/export-count` to count posts for each author and month, and `rsl-ie/export-start` to create the file with the word counts. A prompt:

```
Count the published posts per author per month from January to June 2026
and show the result as a table. Then export the same posts with title,
date, author name and word count as a JSON file named
author-report-2026-h1.
```

In our run, the agent counted 68 published posts in the period, then counted each author per month with the filters `author_name`, `post_status` and two `post_date` conditions (for example, 6 posts by Lena Hart in April and 6 by Priya Nair in June, the same as the pivot table). The export job finished with 68 records, and the file was ready to download from **Jobs Log**.

## FAQ

### Can I export posts by one author only?

Yes. Add the filter **Author Name** equals the name, or **Author Email** equals the email. The export contains only that author’s posts.

### How is the word count calculated?

From the post content, without HTML tags and shortcodes. The title and excerpt are not counted. It can differ slightly from the count in the block editor.

### Does the Date filter include the last day?

Yes. **Less or Equal** with 30 June includes posts published at any time on 30 June.

### Can I include pages or WooCommerce products?

Pages: yes, choose **Pages** instead of **Blog Posts**. Products and other custom post types need PRO.

### Can I report on updated posts instead of new ones?

Yes. Filter by **Modified Date** instead of **Date** and add the **Modified Date** column.

## Related Guides

- [WordPress Content Inventory: Export All Pages with Dates, Authors and Status](https://wpimportexport.com/wordpress-content-inventory-export/)
- [WordPress CSV Posts Export: Export Blog Posts to CSV, Excel, JSON, XML, and ODS](https://wpimportexport.com/wordpress-csv-posts-export/)
- [WordPress Export Data Filters Examples: How to Use Them Effectively](https://wpimportexport.com/wordpress-export-data-filters-examples-how-to-use-them-effectively/)
- [How to Schedule Repeated Exports in WordPress](https://wpimportexport.com/how-to-schedule-repeated-exports-in-wordpress/)
- [Incremental WordPress Exports: Export Only What Changed Since Last Time](https://wpimportexport.com/incremental-wordpress-export-changed-since-last-time/)
- [Export Posts from One Category, Tag or Author to CSV](https://wpimportexport.com/export-posts-by-category-tag-author-csv/)
- [Schedule WordPress Posts from a CSV Content Calendar](https://wpimportexport.com/schedule-wordpress-posts-csv-publish-dates/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
