Summarize New Users Daily
Automate daily summaries of new user sign-ups by extracting emails and names, and send concise notifications to Slack for easy tracking.
Last updated
October 1, 2025
Connectors used
Tags
Key Takeaways
- Daily automated signup reports - queries your database every morning for new user signups from the past 24 hours
- AI-powered analysis - identifies patterns, trends, and anomalies in signup data
- Multi-dimensional breakdown - covers signup sources, geography, device types, and user attributes
- Slack or email delivery - sends the daily report directly to your team
What This Workflow Does
This Needle workflow queries your database or analytics platform daily, analyzes new user signups from the past 24 hours, and generates a summary with trends and insights. The report is delivered to your team via Slack or email.
Use cases:
- SaaS companies tracking daily signup trends
- Product-led growth teams monitoring acquisition channels
- Marketplace platforms analyzing user registration patterns
How It Works
| Step | What Happens |
|---|---|
| 1. Scheduled trigger | Runs every morning |
| 2. Database query | Fetches new user records from the past 24 hours |
| 3. Data collection | Retrieves total signups, signup sources, geographic distribution, device types, and user attributes |
| 4. AI analysis | Compares daily signup count vs. 7-day average, identifies trending sources, geographic hotspots, and anomalies |
| 5. Report generation | Creates a summary with overview, top sources, geography, device breakdown, and AI-detected insights |
| 6. Notification | Posts the report to Slack or sends via email |
Data Points Analyzed
| Category | Details |
|---|---|
| Total signups | Count of new users in the past 24 hours |
| Signup sources | Organic, paid, referral breakdown |
| Geography | Top countries and cities |
| Devices | Mobile vs. desktop split |
| User attributes | Plan selected, company size, and other profile fields |
| Trend comparison | Daily count vs. 7-day average |
Setup Instructions
- Ensure you have database access (PostgreSQL, MySQL, MongoDB, or an analytics platform like Mixpanel, Amplitude, or Google Analytics)
- Import the workflow template in Needle
- Configure the database connection or analytics platform credentials
- Set up a Slack channel for daily reports (e.g., #product-metrics or #growth)
- Configure the trigger schedule for your preferred morning time
- Define your baseline metrics for comparison (e.g., average daily signups)
Customization
| What You Can Change | How |
|---|---|
| Data source | Swap the database query node for a different database or analytics platform |
| Report schedule | Edit the cron expression in the trigger node |
| Analysis dimensions | Modify the AI prompt to focus on specific data points (e.g., plan type, referral source) |
| Delivery channel | Switch between Slack and email, or send to both |
| Slack channel | Update the channel name in the notification node |
| Comparison window | Change the 7-day average comparison to a different time range |
FAQ
Q: What databases are supported? A: PostgreSQL, MySQL, MongoDB, and analytics platforms like Mixpanel, Amplitude, and Google Analytics.
Q: Can I send the report to email instead of Slack? A: Yes. The notification step supports both Slack and email delivery.
Q: What kind of anomalies does the AI detect? A: The AI flags unusual patterns such as unexpected spikes or drops in signups, shifts in geographic distribution, and changes in signup source mix.
Q: Do I need historical data for this to work? A: The workflow analyzes the past 24 hours of signups. Having baseline metrics (like average daily signups) improves the trend comparison, but is not strictly required.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
