Want daily insights into new user signups? This tutorial shows how to build a daily new users analysis workflow in Needle that tracks signups and delivers actionable insights.

Overview

The workflow queries your database or analytics platform daily, analyzes new user signups, and generates a summary with trends and insights—transforming raw signup data into strategic intelligence.

Key Actions

1. Scheduled Daily Trigger – Runs every morning to analyze yesterday's signups
2. Database Query – Fetches new user records from the past 24 hours
3. AI Analysis – Identifies patterns, trends, and anomalies in signup data
4. Insight Generation – Creates a summary with key metrics and observations
5. Slack/Email Notification – Sends the daily report to your team

What You'll Need

• Database Access – Connection to your user database (PostgreSQL, MySQL, MongoDB, etc.) Tip: Or connect to analytics platforms like Mixpanel, Amplitude, or Google Analytics
• Slack Channel – For daily reports (e.g., #product-metrics, #growth)
• Baseline Metrics – Historical averages for comparison (e.g., avg. 50 signups/day)

How It Works

Every morning:

1. The workflow queries your database for users who signed up in the past 24 hours
2. Data retrieved includes:
   • Total signups
   • Signup sources (organic, paid, referral)
   • Geographic distribution
   • Device types (mobile, desktop)
   • User attributes (plan selected, company size, etc.)
3. AI analyzes the data to identify:
   • Daily signup count vs. 7-day average
   • Trending signup sources
   • Geographic hotspots
   • Unusual patterns or anomalies
4. A summary is generated with sections:
   • 📊 Overview: Total signups, % change from average
   • 🚀 Top Sources: Which channels drove the most signups
   • 🌍 Geography: Top countries/cities
   • 📱 Devices: Mobile vs. Desktop breakdown
   • 💡 Insights: AI-detected trends (e.g., "Spike in signups from Germany, likely due to recent blog post")
5. The report is posted to Slack with visualizations and actionable insights

Wrap-up

With this Needle workflow, your product and growth teams get daily signup intelligence without manual queries or spreadsheet wrangling—perfect for SaaS companies, marketplace platforms, and any product-led growth team.