Who’s this for?

If you own a website and need to analyze your Google Analytics data,
If you need to create an SEO report on which pages are getting the most traffic or how your Google search terms are performing,
If you want to grow your site based on suggestions from data.

Use case

Instead of hiring an SEO expert, I run this report weekly. It checks and compares the data from this week to the week before:

– Views based on countries
– The top performing pages
– Google Search Console performance

How it works

The workflow gathers Google Analytics data for the past 7 days, then it gathers the data for the week before for comparison.
It does this 3 times to get: views per country, engagement per page, and Google Search Console results for organic search results.
The Google Analytics nodes have already chosen the correct dimensions and metrics.
At the end, it passes the data to Openrouter.ai for A.I. analysis.
Finally, it saves to Baserow.

How to use this

– Input your Google Analytics credentials
– Input your property ID
– Input your Openrouter.ai credentials
– Input your Baserow credentials

You will need to create a Baserow database with columns: Name, Country Views, Page Views, Search Report, Blog (name of your blog).

Created by Rumjahn.