Does your Webflow site utilize Webflow's CMS and multi-referenced or single referenced items for blog authors or creators? Maybe these authors or creators have posts in a number of different collections on your site and you wanted to combine the views from all of these elements into a single pageview metric? In this example we'll outline how to combine views from two separate collections (Blog posts & Articles) to create a pageview sum total of all the views that a single author has received.
With the power of Flowmonk's pageview sync and our Webflow to Airtable syncing you can now add real-time, combined sum pageview counts to your creators pages, author pages or internal dashboard pages. We're going to deep dive into how to add this flow to your Webflow site and walk you through the potential use cases.
The first step to enable this is to setup your Airtable and Webflow real-time sync with Flowmonk Airtable to Webflow sync. This allows the data between Airtable and Webflow to be in sync at all times and in near real-time.
After setting up your real-time sync between Airtable and Webflow you'll need to setup our Pageview flow add-on. This will enable you to capture views from your Webflow site and update those views in real time to Webflow's CMS and Airtable. This is where we are able to utilize Airtable to perform rollups or counts of your data that will then be pushed back to your Webflow site.
Did you know that you can utilize our Google Analytics import tool to sync legacy pageviews that your site has received to your Webflow collection?
Using the Airtable Rollup field type
The Airtable Rollup field allows you to you aggregate the values from specific records that are linked from another field within your table. With this field type we're now able to create a combined sum of all of the Blog post pageviews for your each of your authors. To do this add a new field to your Authors table/collection with Rollup, below is the image of the settings including the addition of the Aggregation formula.
This will create a new field in your Authors table of all of the pageviews that the Blog posts for that author has received. You'll now do the same with your second table/collection within your Authors table/collection for the Article pageviews.
At this point you will have two rollup fields created in your Authors table/collection for both the Articles and the Blog post views. At this point we're looking to generate the sum total of all of the pageviews which we can generate using Airtable's formula field type.
Using Airtable formula field type
The Airtable formula field type is helpful for adding sophistication to your Airtable bases by allowing you to output numbers, strings, dates and more in your record based on static or dynamic information. In this example we'll be creating a simple sum calculation for both of the views Rollups we created in the previous step.
Create a new Airtable formula field as shown in the image below, take note of the simple formula in the formula portion of the Airtable field.
We've now created three new fields in your Authors table/collection that can now be setup to sync back to your Webflow site in real time. This allows you to create dynamic elements within your Webflow site based on pageviews of your Authors. This theory can be applied to any type of site and in a number of different ways. You can now create top 10 pages for your best performing authors or create individual author pages which have collections that can be sorted by the authors top blog posts or articles. Internal dashboards can be created to easily manage your blog writers performance, identifying which writers are creating the best articles and which writers need help improving.