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]
- Generate Sitemap after removing JetPack
- Writing a pandas DataFrame to CSV file
- Pandas: ValueError: cannot convert float NaN to integer
- Python – Reading and writing csv files with utf-8 encoding
- ValueError: cannot index with vector containing NA / NaN values
- Create mysql table directly from CSV file using the CSV Storage engine?
- Python Pandas Error tokenizing data
- Writing a dictionary to a csv file with one line for every ‘key: value’
- AttributeError: ‘float’ object has no attribute ‘split’4
- How to add pandas data to an existing csv file?
- Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
- How to tell if Jetpack’s Photon is active?
- Woocommerce – Hide “add to cart” on free products
- Track advertisement earnings per blog post and page in wordpress?
- Moving sharedaddy buttons (in Jetpack) to the top of a post?
- file_exists() acting weird
- Customise Jetpack Publicize text
- How can I show the Jetpack Subscriptions form in a page? [closed]
- Best practice for adding posts in bulk
- Facebook Like Button in Jetpack [closed]
- How to change the position of Jetpack sharing icons? [closed]
- Exporting table to csv works in the admin but exports HTML data when used on the front end
- code is working properly in Core PHP but writing coding in WordPress
- How to export custom database data to excel file
- how to get jetpack’s infinite scroll to work with woocommerce?
- Change description of my Jetpack facebook shared links [closed]
- get csv of users with user_meta
- Edit / Change Jetpack Mobile Theme [closed]
- Moving Jetpack buttons to appear below the first H2 title on all project/post pages [closed]
- Can’t upload CSV file to plugin directory using custom upload form in admin panel
- See some statistics about the comments
- After installing JetPack, can I delete the WordPress stats plugin?
- Show Homepage (only) Hits Count
- Custom database table and custom search
- Solved – Inserting content inside the WordPress loop
- How to map data on CSV to web pages?
- Increase load-out-page speed
- Force CSV download with template_redirect
- Jetpack Comments Change Placeholder Text
- Featured posts and the loop
- How to cdv from a custom CMS to WP
- CSV file header
- How to create a cumulative posts and members count
- Make Jetpack CDN to filter/ignore images based on SRC [closed]
- Why is there a bunch of WordPress HTML code in my browser CSV download?