Export post & author data from MYSQL ?

by 1 replies
2
I would like to export a given set of posts data for example a CSV (or similar) that shows me for each Wordpress post over say the past 3 months:
  • post name
    author
    URL
    # words (ideally)
    # comments (ideally)
so I can then merge with Google Analytics data for comparison. Any ideas how to do this? I know how to access Phpmyadmin but not aware of commands and how exactly to execute.

My plan is to take the aforementioned export and then merge with Google Analytics data to review author performance. Bonus points if someone knows an Excel function that could match up the data export and Google Analytics content data.
#programming #author #data #export #mysql #post
  • The SQL query would look something like this:

    SELECT * FROM `posts` WHERE `post_date` BETWEEN '2011-03-05 09:00:00' AND '2012-03-05 09:34:34'

    You'll have to change the dates, and I'm not sure if you're looking for a specific author but this should get you in the ball park.

    I'm not sure about the excel part.
Join the discussion

Next Topics on Trending Feed