CSV or report of views per author in a specific month

  • Resolved thenorman138

    (@thenorman138)


    2 years, 3 months ago

    We’ve been using jetpack since the site started, but we just started using a new plugin to pay our authors per post as well as per visit.

    The issue is that the payment plugin doesn’t work with jetpack, so we’ll be using it on a post counter going forward, but we now have to pay writers for the month of July.

    I’m a developer so I can use any PHP or SQL method in order to get this but I’m not finding the proper sources. I just need a list of all posts and authors for the month of july as well as the views for said post, so that I can put it into a CSV to manually pay the writers.

    Where can I easily obtain this?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Bruce (a11n)

    (@bruceallen)

    Happiness Engineer

    Hi @thenorman138

    You can download certain specific stats using Jetpack by going to the Stats dashboard link below and clicking on a feature:

    https://wordpress.com/stats/day/

    You can select a feature (such as Posts & Pages or Referrers), and you will be able to find a button that says **Download data as CSV**.

    You can find that illustrated in the FAQ section of our documentation:

    https://jetpack.com/support/wordpress-com-stats

    Also see:

    https://wordpress.com/support/stats/#downloading-stats

    Thread Starter thenorman138

    (@thenorman138)

    Thank you so much! That helped a ton. I got the CSV now of July’s posts and their views, do you know if there’s a way to get the author in that list too?

    Thread Starter thenorman138

    (@thenorman138)

    @bruceallen It seems like contributors and editors don’t show in the authors summary at all, but if I could just somehow get the author of the post in posts & pages to show that would give me what I need. https://public-api.wordpress.com/rest/v1.1/sites/{ID Redacted}/stats/top-posts?http_envelope=1&period=month&date=2022-07-31&max=0 This is the URL in the request, is there a param that can also send me the author of the post?

    Plugin Support MadHatter (a11n)

    (@madhattersez)

    Hello,

    As I just mentioned in your two other threads, I have closed them in favor of us focusing on this one thread here.

    That being said, I’m not exactly clear where you’re at on this one – Would you be able to let us know the most updated information here, as to what is still not working as you’d expect?

    Thanks!

    Plugin Support Jay

    (@bluejay77)

    Hi there,

    It has been more than one week since we have heard from you, so I’m marking this topic as resolved.

    But if you have any further questions or need some more help, you’re welcome to reply here or open another thread.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘CSV or report of views per author in a specific month’ is closed to new replies.