Usage statistics section on marketing page

[raae]

It would be cool to pull in the number of unfollowed across users and the number of users for a little statistics section on the marketing page.

• [x] Create a Gatsby node inside sourceNodes with fields "unfollowedCount" and "userCount" - hard coded to a random number - @olavea
• [x] Ask xata for the numbers and swap the hard coded numbers for those - @olavea (but @raae will give you the xata query)
• [x] Create the marketing section - @raae
• [x] Hook the marketing section to the Gatsby data node - @olavea

[raae]

For reference, something like this, but with our numbers!

[olavea]

  const { actions, reporter, createContentDigest, createNodeId } = gatsbyUtils;
  const { createNode } = actions;

  createNode({
    id: createNodeId("statistics"),
    unfollowedCount: 10,
    userCount: 10,
    internal: {
      type: "statistics",
      contentDigest: createContentDigest(10),
    },
  });

[raae]

To get the number from Xata (in localhost these will be very small):

const xata = getXataClient();

const result = await xata.db.accounts.aggregate({
  unfollowsTotal: {
    count: {
      filter: {
        unfollowed: { $ge: new Date("2022-11-03") },
      },
    },
  },
  usersTotal: {
    uniqueCount: {
      column: "followed_by",
    },
  },
});

const unfollowsTotal = result.aggs.unfollowsTotal
const usersTotal = result.aggs.usersTotal

// Use unfollowsTotal and usersTotal when creating the node