Automated Daily Real Estate Marketing Report

Tier 3 Β· Daily Automation Class Β· Claude Code for Real Estate Agents

You’re pouring your heart and soul into your real estate content. You’re posting on Instagram, Facebook, maybe even trying out TikTok. You’re publishing blog posts and YouTube videos, just like Victoria and I do. But if I’m being honest, do you *really* know what’s working? Or are you just flying blind, hoping something sticks?

For years, before we built out our own systems, I felt that exact same frustration. We were doing all the things, paying for zip codes on Realtor.com, trying a Zillow contract for six months that gave us zero conversions, and just generally guessing. The numbers lived in five different dashboards, and honestly, who has time to open all of them every single morning before the market wakes up?

That’s why building an automation to wake up to your numbers every morning isn’t just a tech hack; it’s a game-changer. It’s what allowed us to eventually walk away from all paid lead platforms, because we finally understood what *our* content was actually doing. We stopped renting our lead gen and started owning our data. This isn’t about being a data scientist; it’s about being a CEO of your own business, making informed decisions that actually move the needle.

Episode 18 β€” Watch the Walkthrough

Watch the full walkthrough above, then book a call and we’ll help you put it to work.

What You’ll Learn in This Episode

  • Set up automated scripts to pull daily performance data from Google Analytics 4.
  • Schedule weekly data pulls for social media engagement metrics across multiple platforms.
  • Consolidate disparate data sources into one unified performance snapshot for brand-specific KPIs.
  • Detect anomalies in your content’s performance and identify trends that require immediate action.
  • Build a daily digest that delivers actionable insights directly to you, eliminating manual dashboard checks.

What Your Daily Performance Digest Does Every Morning

Imagine waking up to a concise report that tells you exactly how your content is performing. This is the automated workflow that makes it happen, without you lifting a finger after the initial setup:

  • Execute `ga4_analytics.py` script daily: This script leverages the GA4 Data API to pull a comprehensive daily snapshot of your website’s performance. It captures critical metrics like page views, user sessions, unique users, top-performing landing pages, and a breakdown of traffic sources and device usage. This snapshot is saved, ready for the next step.
  • Execute `metricool_analytics.py` script weekly (Monday mornings): While GA4 runs daily, social media engagement often needs a slightly longer view. This script connects to Metricool’s API to pull post-level engagement data across Instagram, Facebook, TikTok, Pinterest, and YouTube, capturing likes, comments, shares, reach, impressions, and saves. This weekly roll-up gives you a pulse on your social channels.
  • Execute `agent12_analytics.py` script daily: This is the brain of the operation. It reads the daily GA4 snapshot and the latest Metricool data. It then computes your brand-specific Key Performance Indicators (KPIs). This script is designed to understand what *you* care about.
  • Detect anomalies and trends: The `agent12_analytics.py` script doesn’t just present numbers; it’s built to detect significant shifts. Did a particular landing page tank overnight? Did one of your YouTube Shorts suddenly go viral? This script flags these anomalies so you don’t miss crucial opportunities or problems.
  • Generate canonical performance snapshot: After processing, `agent12_analytics.py` writes one single, unified performance snapshot. This means all your key data points, from website traffic to social engagement and calculated KPIs, are in one place, consistently formatted.
  • Deliver your daily digest: The final output is formatted into an easy-to-read digest that lands in your inbox every morning. You’re not guessing how the week went; you’re reading a roll-up of real numbers, allowing you to quickly identify what moved and why.
  • Escalate critical insights: If an anomaly is severe enough (e.g., a traffic drop, a drop in search visibility, or a drop in engagement), the system can be configured to send an immediate alert, ensuring you’re always ahead of potential issues.

The Math

The true ROI of a daily performance digest isn’t just about saving time; it’s about making *smarter* decisions. Instead of logging into a half-dozen platforms and trying to piece together a coherent picture, you get a consolidated view that highlights what truly matters. This leverage allows you to double down on content strategies that are working and quickly pivot away from those that aren’t, ensuring your time and effort are always optimized. It compounds your authority and trust by allowing you to create more of what your audience actually wants. This system frees you up to focus on client relationships, negotiate deals, and build a business that serves your life, rather than constantly chasing data across disparate dashboards. You move from flying blind to being an informed CEO, building a legacy that’s data-driven and sustainable.

Run This Stack With Us

If you’re an agent who wants to run this on YOUR business β€” not just watch it on YouTube β€” we offer a free 15-minute strategy call. We are Al & Victoria Pinder, husband-wife ICON agents at eXp Realty in Eastern NC. We actually run this skill in our own business. We will show you what fits yours and what doesn’t.

Book a Free 15-Minute Call β†’

Get the Skill on GitHub

The full skill is free, open-source, and runs on your own machine. Clone the repo or copy the SKILL.md into your Claude Code:

https://github.com/TheProsperityAgent/prosperity-real-estate-skills

Before the call, more context if you want it

A note on this skill. The skill behind this build is now one of our private, partner-only skills. It is the automatic version that runs on a schedule for the agents who connect with us, so it works without you at the keyboard. The free starter skills are in the repo linked above, and you can book a call to get the automatic one set up in your business.

The Daily Performance Digest automation pulls your numbers from Google Analytics 4 and Metricool, computes your brand KPIs, flags anomalies, and delivers one unified morning report so you stop flying blind across five dashboards.

Frequently Asked Questions

What is Google Analytics used for in this digest?

The ga4_analytics.py script uses the GA4 Data API to pull a daily snapshot of website performance β€” page views, user sessions, unique users, top-performing landing pages, and a breakdown of traffic sources and device usage. This snapshot is saved as the raw data for the digest.

How do you use Google Analytics to track website traffic automatically?

ga4_analytics.py runs daily to capture the GA4 snapshot, metricool_analytics.py runs weekly on Monday mornings for social engagement, and agent12_analytics.py reads both daily, computes your brand-specific KPIs, and writes one unified performance snapshot delivered as a morning digest.

What are marketing KPIs / what is a marketing dashboard?

The agent12_analytics.py script is the brain of the operation β€” it reads the GA4 snapshot and latest Metricool data, then computes your brand-specific Key Performance Indicators, designed to understand what you actually care about, and consolidates everything into one digest instead of a half-dozen platforms.

Can Google Analytics track social media engagement too?

Social engagement is pulled separately by metricool_analytics.py, which connects to Metricool's API weekly to capture post-level data across Instagram, Facebook, TikTok, Pinterest, and YouTube β€” likes, comments, shares, reach, impressions, and saves β€” then unified with the GA4 data into one snapshot.

What does a marketing dashboard provide / what do the anomaly alerts do?

Beyond presenting numbers, agent12_analytics.py detects significant shifts β€” a landing page that tanked overnight or a YouTube Short that went viral β€” and flags them. If an anomaly is severe enough, such as a traffic or engagement drop, the system can send an immediate alert so you stay ahead of problems.