{"id":727,"date":"2022-07-30T12:23:43","date_gmt":"2022-07-30T12:23:43","guid":{"rendered":"https:\/\/zettaflow.tech\/blog\/?p=727"},"modified":"2025-07-13T19:50:09","modified_gmt":"2025-07-13T19:50:09","slug":"visualize-wordpress-blog-data","status":"publish","type":"post","link":"https:\/\/tapegraph.io\/blog\/visualize-wordpress-blog-data\/","title":{"rendered":"Visualize WordPress Blog Data"},"content":{"rendered":"\n
\"Zettaflow.
Follow the link for the actual dashboard<\/a>. Use the full-screen mode of your browser.<\/em><\/figcaption><\/figure>\n\n\n\n\n\n\n\n

If you want to track your WordPress blog performance – collecting and visualizing data might be a great help. <\/p>\n\n\n\n

We have already described the benefits of Visual Dashboards for performance tracking in this article Why Your Business Needs Dashboards<\/a>.<\/p>\n\n\n\n

Unfortunately, WordPress does not offer native tools to create visual dashboards, and those few plugins supporting visualizations, normally are able to visualize only the focus data that they process. <\/p>\n\n\n\n

In this article, I will describe how you can build a dashboard based on the data stored in the database of your WordPress site. Some basic knowledge of SQL might be required. <\/p>\n\n\n\n

How to visualize<\/h2>\n\n\n\n

To begin with, you need to login into the tapegraph<\/a> platform with your Gmail or GitHub account (no charges).<\/p>\n\n\n\n

After that, you should add a new working space by clicking the \u2018New space\u2019 button. <\/p>\n\n\n\n

Then press \u2018New data source\u2019 to connect to the database of your site. Choose Type as MySQL and fill in the required data.<\/p>\n\n\n

\n
\"Zettaflow.<\/figure>\n<\/div>\n\n\n

After the database is connected, you may view it by selecting it from the menu on the left side. <\/p>\n\n\n\n

\"Zettaflow.
Database <\/figcaption><\/figure>\n\n\n\n

Now you are ready to write your SQL queries. Click \u2018New data\u2019 and go ahead. <\/p>\n\n\n\n

\"Zettaflow.<\/figure>\n\n\n\n

When you are satisfied with the result of your query, click \u2018New visualization\u2019, in the field Data you need to select created data, chose a type of visualization out of Bar, Histogram, Line, Pie, Scale-up Number, or Scatter, also to fill remaining fields. <\/p>\n\n\n\n

This way you may prepare desired visualizations and arrange them in a dashboard. Click \u2018New dashboard\u2019.<\/p>\n\n\n\n

Press the \u2018Add\u2019 button, choose the proper item, and adjust the position and size.  <\/p>\n\n\n\n

\"Zettaflow.<\/figure>\n\n\n\n

Your dashboard is ready. Now you may get and share the link with others (click the \u2018Share\u2019 button). <\/p>\n\n\n\n

WordPress blog dashboard<\/h2>\n\n\n\n

Using the same process I built a dashboard for this blog<\/a>.<\/p>\n\n\n\n

\"Zettaflow.
Follow the link for the actual dashboard<\/a>.<\/a> Use the full-screen mode of your browser.<\/em><\/figcaption><\/figure>\n\n\n\n

It shows the total number of posts <\/strong>(as well by authors<\/strong>) and media files<\/strong>, most viewed <\/strong>and commented posts<\/strong>, post views<\/strong>, number of registered users<\/strong>, and number of comments<\/strong>. The dashboard is real-time. <\/p>\n\n\n\n

Queries <\/h2>\n\n\n\n

Just sharing some SQL queries that might be helpful. <\/p>\n\n\n\n

To build the \u2018Total Posts\u2019 line chart I used the following query: <\/p>\n\n\n\n

<\/span><\/div>
WITH t AS (\n    SELECT\n        DATE_FORMAT(post_date, '%Y') * 12 +\n        DATE_FORMAT(post_date, '%m')\n        AS post_year_month,\n        COUNT(*) AS posts\n    FROM\n        wp_posts        \n    WHERE\n        post_status = 'publish' AND post_type = 'post'\n    GROUP BY\n        post_year_month\n)\nSELECT\n    post_year_month,\n    posts,\n    (\n        SELECT\n            SUM(t2.posts)\n        FROM\n            t as t2\n        WHERE\n            t2.post_year_month <= t.post_year_month\n    ) as posts2    \nFROM\n    t    \nORDER BY\n    post_year_month DESC    \nLIMIT 12<\/pre><\/div>\n\n\n\n
For the \u2018Most viewed in 90 days\u2019 visualization (having WordPress Popular Posts plugin installed) the query used is: <\/p>\n\n\n\n
<\/span><\/div>
SELECT\n    post_title,\n    COUNT(pageviews) AS views\nFROM wp_posts\nINNER JOIN wp_popularpostssummary\n    ON wp_popularpostssummary.postid = wp_posts.ID\nWHERE post_type = 'post'AND\n     view_date >= CURDATE() - INTERVAL 90 DAY\nGROUP BY post_title\nORDER BY views DESC\nLIMIT 5<\/pre><\/div>\n\n\n\n
If you are willing to fetch the data from your WordPress site to the spreadsheets you may check the following article: How to Build a Real-Time Dashboard with Google Sheets or Excel Using WordPress Data<\/a>.<\/p>\n\n\n\n
If any help is required – contact us via Discord<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"
Visualize WordPress data to track your site performance!<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[29,14,28],"tags":[40,6,42,39,7,3,8],"class_list":["post-727","post","type-post","status-publish","format-standard","hentry","category-dashboard-examples","category-visualization","category-how-to-guides","tag-dashboards","tag-googlesheets","tag-how-to","tag-intermediate","tag-sql","tag-visualization","tag-wp"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/tapegraph.io\/blog\/wp-json\/wp\/v2\/posts\/727","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tapegraph.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tapegraph.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tapegraph.io\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tapegraph.io\/blog\/wp-json\/wp\/v2\/comments?post=727"}],"version-history":[{"count":38,"href":"https:\/\/tapegraph.io\/blog\/wp-json\/wp\/v2\/posts\/727\/revisions"}],"predecessor-version":[{"id":1003,"href":"https:\/\/tapegraph.io\/blog\/wp-json\/wp\/v2\/posts\/727\/revisions\/1003"}],"wp:attachment":[{"href":"https:\/\/tapegraph.io\/blog\/wp-json\/wp\/v2\/media?parent=727"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tapegraph.io\/blog\/wp-json\/wp\/v2\/categories?post=727"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tapegraph.io\/blog\/wp-json\/wp\/v2\/tags?post=727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}