Library / Reports, Analytics & Dashboards
Reports, Analytics & Dashboards
Email weekly B2B campaign reports from Webmetic visits via OpenAI and Outlook
Every Monday, collects companies that first visited the website last week, groups them by campaign, drafts a summary with OpenAI and emails it through Outlook.
What it does
## Show which campaigns bring which companies Which campaign brought which companies? Every Monday, this workflow collects the companies that visited your website for the first time last week, groups them by source and campaign, lets OpenAI write a short report and e-mails it to marketing and sales with Microsoft Outlook. ### Who's it for B2B marketing teams who want to show which campaigns bring real companies, not just clicks. ### How it works 1. Get new visits returns the companies Webmetic identified for the first time in the last 7 days. 2. Each company gets the source and campaign of its first visit, from the UTM parameters. 3. Companies are counted per source and campaign, best lead scores first. 4. OpenAI writes the report: summary, table, notable companies per paid campaign and a budget tip. 5. Outlook sends it to the recipients in Settings. ### Setup 1. Copy the Visitor Intelligence API key from Webmetic API keys. 2. Fill in Settings: domain, recipients and report language. 3. Connect OpenAI and Microsoft Outlook. About 5 minutes. ### Requirements - A Webmetic account. This workflow uses no credits. - The Webmetic node, verified by n8n, on n8n Cloud or self-hosted. - OpenAI and an e-mail account. ### Customize Change day and time in Every Monday at 8, or swap Outlook for Gmail or Teams. Campaign names come from the UTM parameters of your ads. More Webmetic workflows
The steps
- Every Monday at 8
- Settings
- Get new visits
- Add source and campaign
- Sort by lead score
- Count per source and campaign
- Collect into one list
- Write the report
- OpenAI Chat Model
- Send the report
Similar automations
Lead Generation & EnrichmentFind B2B Leads with Apollo and Groq12 stepsLead Generation & EnrichmentGenerate B2B Leads with Scrapeless and Claude10 stepsReports, Analytics & DashboardsTrack Email Campaign Performance and Send Daily AI Reports11 stepsReports, Analytics & DashboardsGenerate Corporate Campaign Research Reports for Animal Advocates9 steps