day-hour-performance-breakdown

--- name: day-hour-performance-breakdown description: Analyzes performance by day of week and hour of day across your campaigns. Identifies when your ads perform best and worst, recommends ad schedule adjustments with estimated savings, and tells you exactly what you'd give up by restricting hours. Platform: Google and Meta. metadata: platform: Google and Meta --- # 12/ Day/Hour Performance Breakdown — Google + Meta ## What it does Analyzes performance by day of week and hour of day across your campaigns. Identifies when your ads perform best and worst, recommends ad schedule adjustments with estimated savings, and tells you exactly what you'd give up by restricting hours. ## How it works Claude segments your performance data by day and hour, looking at CPA, CVR, CTR, and spend distribution. It identifies statistically meaningful patterns (not just noise from low-volume hours) and calculates the cost of running ads during underperforming windows vs the conversions you'd lose by turning them off. ## Practical example Your B2B SaaS campaigns show CPA of $31 during weekday business hours (8am-6pm) but $67 on weekends and $54 after 9pm. Weekend spend accounts for $4,200/month producing 63 leads at $67 each. Claude calculates that cutting weekends and nights saves $6,100/month in spend while losing only 89 conversions — but reallocating that budget to peak hours would generate an estimated 142 conversions at the lower CPA. Net gain: 53 additional conversions. ## What you get back - Heatmap of CPA/CVR by day and hour with statistical confidence levels - Specific schedule recommendations with exact hours and days to adjust - Financial impact: spend saved, conversions lost, and net effect of reallocation - Separate analysis for each campaign type (brand, prospecting, retargeting) since patterns differ - Seasonal comparison showing if day/hour patterns shift by month or quarter ## When to use it - When setting up ad schedules for new campaigns - Quarterly reviews to adjust schedules as behavior patterns shift - When budgets are tight and you need to maximize efficiency - For B2B accounts where business hours vs off-hours performance differs significantly ## Data access (Ryze MCP) This skill works best with live account data. Connect the free Ryze MCP once and Claude reads your Google Ads, Meta Ads, GA4 and Search Console directly: - claude.ai / Claude Desktop: Settings → Connectors → Add custom connector → `https://connector.get-ryze.ai/mcp` - Claude Code: `claude mcp add ryze --transport http https://connector.get-ryze.ai/mcp` - Cursor: Settings → MCP → add the same URL Setup guide: https://www.get-ryze.ai/how-to-connect-claude-to-google-meta-ads-mcp

1. **Gather Data:** Export your campaign performance report from [Google Ads](https://ads.google.com) or [Meta Ads Manager](https://www.facebook.com/adsmanager) for the desired date range. Include metrics like CTR, conversions, spend, and revenue. 2. **Customize the Prompt:** Replace [PLATFORM], [ACCOUNT_NAME], [START_DATE], [END_DATE], and [METRIC] in the prompt template with your specific details. 3. **Run the Analysis:** Paste the prompt into your AI tool (e.g., Claude, ChatGPT) and let it process the data. If the AI struggles with raw data, pre-format it into a table or CSV for easier parsing. 4. **Refine Recommendations:** Review the output’s suggested ad schedule adjustments. Adjust bid multipliers or day/hour restrictions in your ad platform based on the AI’s recommendations. 5. **Monitor Impact:** After implementing changes, re-run the analysis in 2–4 weeks to measure actual vs. predicted performance. Refine bids or schedules further as needed. **Tips:** - For granular insights, break down performance by **device type** (mobile vs. desktop) or **audience segments** (e.g., new vs. returning users). - Use the AI’s **estimated savings/lost opportunity** to prioritize changes—focus on high-impact, low-risk adjustments first. - If your account has seasonal trends, run this analysis monthly to adapt to shifting patterns.