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