Umami Analytics Automation

Target Audience

• Website Owners: Those who want to analyze their website traffic and improve SEO performance.
• Digital Marketers: Professionals looking to leverage data insights for better marketing strategies.
• Content Creators: Individuals who need to understand audience behavior to create engaging content.
• Data Analysts: Experts who want to automate data gathering and reporting processes.

Problem Solved

This workflow automates the process of gathering website analytics from Umami, analyzing the data with AI, and storing the insights in Baserow. It addresses the challenge of manual data collection and analysis, allowing users to focus on improving their website's performance based on actionable insights.

Workflow Steps

1. Trigger: The workflow can be initiated manually or scheduled to run every Thursday.
2. Data Retrieval: It fetches view statistics from Umami for the last 7 days and page-specific data for comparison between this week and last week.
3. Data Parsing: The retrieved data is processed to create a simplified structure containing key metrics such as pageviews, visitors, visits, bounces, and total time.
4. AI Analysis: The processed data is sent to an AI service (Openrouter) for generating insights and suggestions based on the analytics.
5. Data Comparison: The AI compares this week's data with last week's, providing a markdown table summary and improvement suggestions.
6. Storage: The results, including insights and analysis, are saved into a Baserow database for easy access and future reference.