Using stats_get_csv to return a list of popular posts by views with thumbnails

The API returns the following columns when you query the postviews table:

  • date
  • post_id
  • post_title
  • post_permalink
  • views

For my blog the post_id column was either empty or 0 (for the homepage). So unless you have good values there, you will have to work from the post_permalink value and determine whether it is a page or a post (via a query on the database or a regex on the URL?), and then query your database for the post thumbnail, because the WordPress.com stats API does not collect info on that.

Related Posts:

  1. Jetpack – stats_get_csv period parameter
  2. How to disable Jetpack modules such as Stats?
  3. What does this number represent in JetPack stats? [closed]
  4. I have a self hosted blog but now the WordPress.com stats plugin has stopped working
  5. How do I remove quantcast from my sites?
  6. Jetpack: Access visitor stats in templete
  7. Cannot activate Jetpack on my server
  8. Jetpack Infinite Scrolling For Multiple Columns On Same Page?
  9. Popular posts by view with Jetpack
  10. Gravatar Hovercards (Jetpack) jQuery error
  11. How do I update the site URL used by Jetpack subscribe widget [closed]
  12. Isotope with Infinite Scroll
  13. Jetpack infinite scroll not working on Twenty Twelve [closed]
  14. Can’t connect to my WordPress website using Windows 8 app?
  15. stats_get_csv (WordPress Stats) to only display top posts (not pages)
  16. jetpack suddendly stopped working [closed]
  17. Jetpack social icons in other places on site
  18. Why I can’t modified jetpack default blank.jpg on og:image?
  19. How to remove WordPress’ Jetpack plugin completely? [duplicate]
  20. Customizing JetPack Publicize Sharing
  21. Jetpack infinite scroll not working on twentysixteen custom theme
  22. Change $content_width based on screen size (functions.php)
  23. Jetpack button location buffering [closed]
  24. Does Jetpack conflicts with load_template()?
  25. Is it possible to remove subscription box from Jetpack stats page? [closed]
  26. Hide Jetpack for Contributor [closed]
  27. How do i import email addresses into WordPress.com subscriptions? [closed]
  28. Hiding Jetpack Ads from users who are signed in?
  29. Jetpack Infinite Scroll – changing number of posts
  30. How to allow users to write jetpack custom post types? [closed]
  31. Missing Jetpack Contact Form button when running locally [closed]
  32. Why does Jetpack insert it’s script outside the tag?
  33. Updating shortlinks from staging [closed]
  34. Jetpack Publicize and Android
  35. How can I get the Jetpack Image plugin to open links in a new window? [closed]
  36. Infinite Scroll on Self-hosted WordPress [closed]
  37. How to remove Stats by jetpack dashboard widget?
  38. Publicize in Jetpack stopped working on Custom Post Type it works in Blog Posts
  39. What is the difference between `Home page / Archieves` and the page set as homepage?
  40. Jetpack Top post widget (display post views)
  41. Unable to setup jetpack on my site
  42. Where does Jetpack store markdown?
  43. The plugin jetpack/jetpack.php has been deactivated due to an error: Plugin file does not exist
  44. Jetpack URL shortening, fixing after website URL change
  45. Infinite scroll function for Twenty Seventeen
  46. how to disable jetpack for non admins?
  47. Popular posts – based on pageviews
  48. Implementing backbone.js to retrieve category posts using JSON API
  49. Jetpack email sharing button to include image on email sent
  50. Is there a way to enable a Jetpack module via `functions.php`
  51. Pageview confusion [closed]
  52. Jetpack Infinite Scroll, Isotope and ImagesLoaded
  53. Delete old JetPack Site Stats? encrypted_search_terms in top search terms [closed]
  54. Force Jetpack to not use og:image tag for favicon / Site Icon [closed]
  55. Using Jetpack to track an Ajax powered blog [closed]
  56. IndexError: too many indices for array
  57. ValueError : I/O operation on closed file
  58. Python Error io.UnsupportedOperation: not readable
  59. Is there a way to include commas in CSV columns without breaking the formatting?
  60. Convert XML to CSV file
  61. ValueError: x and y must be the same size
  62. How to concatenate text from multiple rows into a single text string in SQL Server
  63. Python CSV error: line contains NULL byte
  64. Compute a confidence interval from sample data
  65. convert csv file to list of dictionaries
  66. How to import CSV into Custom Post Type custom fields?
  67. Get ‘page’ number with infinite scroll
  68. What are the most used WordPress localization?
  69. Export User Info to CSV from Front End
  70. Setting Login with User Name and Password default option for Jetpack Admin Login
  71. WordPress Stats keeps showing non-existent post as a top post?
  72. How to get the “stats” plugin that comes with a .wordpress.com blog?
  73. Compatibility of MathJax extension and JetPack [closed]
  74. Counting number of visits to my website
  75. Jetpack API for WordPress Network
  76. Jetpack’s photon causes local site to try and serve images from WordPress CDN [closed]
  77. Importing CSV into database table not working?
  78. Track usernames with piwik [closed]
  79. How to display number of page views on a post?
  80. Looking for simple and lightweight plugin for post reading stats
  81. WordPress stats API key
  82. Cropping images from top center using Jetpack Photon
  83. Fail to get the total number of posts
  84. Migrating stats from WordPress.com blog to self-hosted WordPress.org blog
  85. Jetpack stats and caching strategy [closed]
  86. Jetpack: Subscribe via e-mail [closed]
  87. Exporting a form to a CSV file does not work in WordPress but it does in PHP
  88. How to add CSV upload functionality on the edit page of a Custom Post Type
  89. Query a custom taxonomy in a function to create an csv file
  90. multiple string replace of post’s content for large data
  91. the_content filter not working when Jetpack activated. Any idea?
  92. Using WordPress to create a simple web app (SaaS) [closed]
  93. Creating connections programmatically with common fields on CPT’s
  94. Jetpack Mobile Theme: when on smartphone on categories the theme suddenly changes to jetpack mobile theme even though it’s deactivated
  95. Visual Editor not working when Jetpack plugin is active
  96. Admin bar stats widget plugin image broken
  97. Reading CSV values and showing them in PHP
  98. Plugin to show how far users are reading? [closed]
  99. Exporting CSV of users with custom user taxonomies out of WordPress
  100. Creating posts with php-script + csv

Leave a Comment