Title: Import Data from WordPress Popular Posts
Last modified: December 25, 2018

---

# Import Data from WordPress Popular Posts

 *  [freemason](https://wordpress.org/support/users/freemason/)
 * (@freemason)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/import-data-from-wordpress-popular-posts/)
 * Hello,
 * Is it possible to import my popular data from the WordPress Popular Posts plugin?
 * Thanks,
 * A Jorge

Viewing 1 replies (of 1 total)

 *  Plugin Author [Ajay](https://wordpress.org/support/users/ajay/)
 * (@ajay)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/import-data-from-wordpress-popular-posts/#post-11027123)
 * From what I can see WPP has two tables summary and data. I don’t have the exact
   data that the plugin stores, but you could try the following query to track the
   overall posts. You’ll need Top 10 to track the daily views.
 * Please backup your database before you try anything. This is to be run after 
   Top 10 was activated.
 *     ```
       INSERT INTO wp_top_ten (postnumber,cntaccess,blog_id) 
           SELECT postid,pageviews,1 FROM wp_popularpostsdata
       ```
   
 * and this might work for daily
 *     ```
       INSERT INTO wp_top_ten_daily (postnumber,cntaccess,dp_date,blog_id) 
           SELECT postid,pageviews,view_datetime,1 FROM wp_popularpostssummary
       ```
   

Viewing 1 replies (of 1 total)

The topic ‘Import Data from WordPress Popular Posts’ is closed to new replies.

 * ![](https://ps.w.org/top-10/assets/icon-256x256.png?rev=2986432)
 * [WebberZone Top 10 — Popular Posts](https://wordpress.org/plugins/top-10/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/top-10/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/top-10/)
 * [Active Topics](https://wordpress.org/support/plugin/top-10/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/top-10/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/top-10/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Ajay](https://wordpress.org/support/users/ajay/)
 * Last activity: [7 years, 5 months ago](https://wordpress.org/support/topic/import-data-from-wordpress-popular-posts/#post-11027123)
 * Status: not resolved