Back to blog
6 min read 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, 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
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
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). 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.

With an AI agent

An AI agent connected through the WordPress MCP Adapter (see connecting Claude Code to WordPress) 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.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

Have a question or a tip to share? Leave it below.

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE