Hippocampus's Garden

Under the sea, in the hippocampus's garden...

    Search by

    Count Page Views & Show Popular Posts in Gatsby Blog

    June 21, 2020  |  6 min read  |  626 views

    • このエントリーをはてなブックマークに追加

    Blogs built with WordPress and such have a feature to count page views and show popular posts. It helps visitors look around the web site and improves the average dwell time. Unfortunately, Gatsby does not support such features by default (remember that Gatsby is a Single Page App generator).

    In this post, I show how I implemented the page view counter and the “popular posts” sidebar to this blog using Google Analytics API. Specifically, as you see in the sidebar, I made two boxes: “Trending” to show the most popular posts in the last 30 days from the build and “Most Read” to show the most popular posts since the first build.

    2020 06 21 16 02 17

    Count Page Views

    One of the easiest ways to count page views is to use Google Analytics. It won’t bother you to think about databases and APIs, and it’s free! I don’t explain it in detail, but it’s set up in a few minutes by following the official document of Google Analytics and gatsby-plugin-google-analytics. Once you set up everything, you will be able to see reports of access logs at Google Analytics.

    Get Page Views

    I guess counting page views itself was pretty easy, but in order to show the view counts in the blog posts, you need to get them from Google Analytics API.

    Here is already a great tutorial for getting page views from Google Analytics API [1], so please follow it and complete the procedure.

    • Enable Google Analytics API
    • Create a service account
    • Download a JSON file including the service account email address and the private key to access the API

    To manage the private key, I used dotenv module and created a file like this:

    PRIVATE_KEY="-----BEGIN PRIVATE KEY-----\nfuga\n-----END PRIVATE KEY-----\n"

    Also, since I host this blog by Netlify, I set the same variables for the production environment at https://app.netlify.com/sites/my-project/settings/deploys .

    After setting up environment variables, write some lines of code to read them at gatsby-node.js.

    const path = require(`path`)
    const { createFilePath } = require(`gatsby-source-filesystem`)
    const crypto = require('crypto')
    const { google } = require('googleapis')
    const moment = require('moment');
    const activeEnv =
      process.env.GATSBY_ACTIVE_ENV || process.env.NODE_ENV || 'development';
      path: `.env.${activeEnv}`,
    const key = process.env.PRIVATE_KEY.replace(new RegExp('\\\\n', '\g'), '\n')

    The expression .replace(new RegExp('\\\\n', '\g'), '\n') was important for my environment. Without it, it throws an error like:

    error "gatsby-source-google-analytics-reporting-api" threw an error while running the sourceNodes lifecycle:
    error:0909006C:PEM routines:get_name:no start line
      Error: error:0909006C:PEM routines:get_name:no start line

    Visit here for more discussion.

    And add the following to get results from Google Analytics API (getGA()) and create nodes that have information about view counts (createNodes()). I call them twice with different start dates to make two sections: “Trending” and “Most Read”.

    exports.sourceNodes = async ({ actions }) => {
      const { createNode } = actions
      const email = process.env.CLIENT_EMAIL
      const viewId = `<Your ViewId>`
      const scopes = 'https://www.googleapis.com/auth/analytics.readonly'
      const jwt = new google.auth.JWT(email, null, key, scopes)
      await jwt.authorize()
      function getGA(date) {
        return google.analytics('v3').data.ga.get({
          'auth': jwt,
          'ids': 'ga:' + viewId,
          'start-date': date,
          'end-date': 'today',
          'dimensions': 'ga:pagePath',
          'metrics': 'ga:pageviews',
          'sort': '-ga:pageviews',
      function createNodes(GAResult, nodeName) {
        for (let [path, count] of GAResult.data.rows) {
            count: Number(count),
            id: path,
            internal: {
              type: nodeName,
              contentDigest: crypto.createHash(`md5`).update(JSON.stringify({ nodeName, path, count })).digest(`hex`),
              mediaType: `text/plain`,
              description: `Page views per path`,
      const recentResult = await getGA(moment().add(-30, 'days').format('YYYY-MM-DD'))
      createNodes(recentResult, `RecentPageViews`)
      const totalResult = await getGA(`2020-02-21`)
      createNodes(totalResult, `TotalPageViews`)

    Note that contentDigest should be unique because it is used for caching [3].

    Now you should have new nodes that look like:

    "allTotalPageViews": {
        "nodes": [
                "count": XXX,
                "path": "/"
                "count": YYY,
                "path": "/hoge/"
                "count": ZZZ,
                "path": "/fuga/"

    I created the PopularPost component to query recentPageViews and totalPageViews with GraphQL and show popular posts in a sidebar. The function chooseTop5() selects the five most popular posts that belong to markdownRemark and the component TrendBox shows the result in a formatted style.

    import React from 'react'
    import { graphql, useStaticQuery, Link } from 'gatsby'
    import Image from "../components/image"
    import { rhythm } from "../utils/typography"
    const PopularPost = () => {
      const data = useStaticQuery(graphql`
          query allPagesAndViews {
              allMarkdownRemark(limit: 1000, sort: {order: DESC, fields: frontmatter___date}) {
                  edges {
                    node {
                      frontmatter {
                      fields {
              allTotalPageViews(limit: 10, sort: {fields: count, order: DESC}) {
                  edges {
                      node {
              allRecentPageViews(limit: 10, sort: {fields: count, order: DESC}) {
                edges {
                    node {
      function chooseTop5(allPosts, popularPosts) {
        const results = [];
        for (const a of popularPosts) {
          const popularPost = allPosts.find(b => b.node.fields.slug === a.node.id);
          if (popularPost == null) {
          } else {
              count: a.node.count,
          if (results.length >= 5) {
        return results;
      const TrendBox = ({ results }) => (
        results.map(result => (
          <article key={result.fields.slug} >
            <Link style={{ boxShadow: `none`, textDecoration: `none`, color: `inherit`, }} to={result.fields.slug}>
              <div style={{
                display: "flex", flexFlow: "row",
                marginTop: rhythm(0.5)
                <div style={{ width: "120px", paddingRight: rhythm(0.5) }}>
                  <Image filename={result.frontmatter.featuredImage} />
                <small style={{ width: "150px", }}>
      const allPosts = data.allMarkdownRemark.edges;
      const totalResults = chooseTop5(allPosts, data.allTotalPageViews.edges);
      const recentResults = chooseTop5(allPosts, data.allRecentPageViews.edges);
      return (
          <div style={{ width: "300px", marginBottom: rhythm(0.5), backgroundColor: "white", padding: rhythm(0.5) }}>
            <TrendBox results={recentResults} />
          <div style={{ width: "300px", marginBottom: rhythm(0.5), backgroundColor: "white", padding: rhythm(0.5) }}>
            <h3>Most Read</h3>
            <TrendBox results={totalResults} />
    export default PopularPost


    [1] De Code Natura | How to add a trending section to your gatsby blog
    [2] antonmedv/gatsby-source-google-analytics-reporting-api: Gatsby source for Google Anatytics Reporting API
    [3] Node Interface | GatsbyJS
    [4] Creating your own nodes with Gatsby | Dimitri’s tutorials
    [5] Gatsby でも人気記事を表示したい!(その1) | Blog

    • このエントリーをはてなブックマークに追加
    [object Object]

    Written by Shion Honda. If you like this, please share!

    Shion Honda

    Hippocampus's Garden © 2021, Shion Honda. Built with Gatsby