google-analytics

What This Skill Does

The google-analytics skill empowers your OpenClaw agent to interact directly with the Google Analytics Data API (GA4). By bypassing third-party proxies, it maintains high security and data integrity while allowing you to query your website's performance metrics in real-time. Whether you need to monitor traffic spikes, identify top-performing content, or analyze user conversion funnels, this skill provides a direct pipeline to your property's underlying data using the official Google infrastructure.

Installation

Follow these steps to configure the skill:

1. Create a Google Cloud project and navigate to the OAuth consent screen. Ensure the user type is 'Internal' for seamless access, or 'External' with appropriate scopes if using a personal account.
2. Add the https://www.googleapis.com/auth/analytics.readonly scope.
3. Enable the 'Google Analytics Data API' in the Google Cloud Library.
4. Create 'Desktop app' OAuth 2.0 credentials and store your Client ID and Client Secret securely.
5. Obtain your GA4 Property ID from the Google Analytics Admin dashboard.
6. Generate a refresh token using the provided Python script, ensuring you have google-auth-oauthlib installed.
7. Finally, export these as environment variables: GA4_PROPERTY_ID, GOOGLE_CLIENT_ID, GOOGLE_CLIENT_SECRET, and GOOGLE_REFRESH_TOKEN.

Use Cases

• Performance Reporting: Automate the generation of weekly executive summaries showing traffic growth and conversion rates.
• Content Strategy: Identify which blog posts or landing pages have the highest engagement or bounce rates to inform future content creation.
• Audience Insights: Analyze traffic sources to determine which channels (organic search, social media, paid ads) drive the most qualified leads.
• Anomaly Detection: Set up periodic checks to alert you if sessions or events deviate significantly from historical norms.

Example Prompts

• "Pull the top 10 pages by session count for the last 30 days and summarize the user engagement trends."
• "What is the conversion rate for our primary signup goal, and how does it compare to the previous month?"
• "Show me the breakdown of traffic sources for our e-commerce landing page over the past week."

Tips & Limitations

• Data Freshness: Note that GA4 data can have a processing latency of 24-48 hours.
• Rate Limits: Be mindful of Google's API quota limits when running intensive, multi-metric queries across large date ranges.
• Workspace Requirement: Using an Internal OAuth application requires a Google Workspace account; personal Gmail accounts will require additional verification steps if you change the scope or audience settings.