客户报告自动化代理
高级
这是一个Document Extraction, AI Summarization领域的自动化工作流，包含 16 个节点。主要使用 Set, Code, Gmail, Aggregate, HttpRequest 等节点。 每周Facebook广告表现报告，含AI驱动分析与Gmail发送
前置要求
- •Google 账号和 Gmail API 凭证
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "69fCeA2DKyEPBdgz",
"meta": {
"instanceId": "65ec47be00b0ac600ad20c40dd4664274304bcd19e969a4326853865046a0fae"
},
"name": "客户报告自动化代理",
"tags": [],
"nodes": [
{
"id": "090a0d29-5926-4266-b42b-cc5d5fbb502a",
"name": "格式化数据",
"type": "n8n-nodes-base.code",
"position": [
-784,
784
],
"parameters": {
"jsCode": "return items.map(item => {\n const data = item.json;\n\n const flattened = {\n campaign_name: data.campaign_name,\n impressions: Number(data.impressions),\n clicks: Number(data.clicks),\n spend: Number(data.spend),\n date_start: data.date_start,\n date_stop: data.date_stop\n };\n\n // Flatten all action types\n if (Array.isArray(data.actions)) {\n data.actions.forEach(action => {\n flattened[action.action_type] = Number(action.value);\n });\n }\n\n return { json: flattened };\n});\n"
},
"typeVersion": 2
},
{
"id": "366ea06c-4986-4c0d-9d6a-ffa85a346ff0",
"name": "获取 FB 数据",
"type": "n8n-nodes-base.httpRequest",
"position": [
-976,
784
],
"parameters": {
"url": "https://graph.facebook.com/v20.0/act_{{Your_Ad_Account_ID}}/insights?fields=campaign_name,impressions,clicks,spend,actions&date_preset=last_7d&access_token={{Your_FB_Access_Token}}",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Auth",
"value": "={{FACEBOOK_ACCESS_TOKEN}}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "d0fb8976-c2ab-435b-bb8c-73d495e443be",
"name": "每周触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1152,
784
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtDay": [
1
],
"triggerAtHour": 8,
"triggerAtMinute": 30
}
]
}
},
"typeVersion": 1.2
},
{
"id": "348d4484-5ccd-40f1-8cff-1f7e623c7ee6",
"name": "合并报告",
"type": "n8n-nodes-base.aggregate",
"position": [
-960,
1024
],
"parameters": {
"options": {},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "output"
}
]
}
},
"typeVersion": 1
},
{
"id": "6d7c6e2f-2400-4e4e-b7ef-dce6aba9df45",
"name": "生成 PDF",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1152,
1264
],
"parameters": {
"url": "https://api.pdfcrowd.com/convert/24.04",
"method": "POST",
"options": {
"response": {
"response": {
"responseFormat": "file",
"outputPropertyName": "Facebook_Ads_Report_Week_of_Aug_12_2025.pdf"
}
}
},
"sendBody": true,
"contentType": "form-urlencoded",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "content_viewport_width",
"value": "balanced"
},
{
"name": "text",
"value": "={{ $json.html }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "authorization",
"value": "Basic {{PDFCROWD_API_KEY}}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "0a9ff2f7-075a-415a-a1f5-5e3b579ea057",
"name": "发送邮件",
"type": "n8n-nodes-base.gmail",
"position": [
-944,
1264
],
"webhookId": "83b24fe7-f85b-4aec-bd38-7afacb8b166e",
"parameters": {
"message": "📩 𝗪𝗲𝗲𝗸𝗹𝘆 𝗙𝗮𝗰𝗲𝗯𝗼𝗼𝗸 𝗔𝗱𝘀 𝗣𝗲𝗿𝗳𝗼𝗿𝗺𝗮𝗻𝗰𝗲 𝗥𝗲𝗽𝗼𝗿𝘁\n\nI hope you had a refreshing weekend! 🌞\n\n📊 𝗤𝘂𝗶𝗰𝗸 𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝘀:\n✅ 𝗧𝗼𝗽 𝗰𝗮𝗺𝗽𝗮𝗶𝗴𝗻: New Product Launch\n⚠️ 𝗨𝗻𝗱𝗲𝗿𝗽𝗲𝗿𝗳𝗼𝗿𝗺𝗶𝗻𝗴 𝗰𝗮𝗺𝗽𝗮𝗶𝗴𝗻: Retargeting Campaign\n💡 𝗞𝗲𝘆 𝗿𝗲𝗰𝗼𝗺𝗺𝗲𝗻𝗱𝗮𝘁𝗶𝗼𝗻: Optimize landing pages with better user experience and persuasive elements to boost conversions from clicks to purchases.\n\nThe 𝗱𝗲𝘁𝗮𝗶𝗹𝗲𝗱 𝗣𝗗𝗙 𝗿𝗲𝗽𝗼𝗿𝘁 𝗶𝘀 𝗮𝘁𝘁𝗮𝗰𝗵𝗲𝗱 𝗳𝗼𝗿 𝗿𝗲𝘃𝗶𝗲𝘄. Wishing you a productive and successful week ahead! 🚀\n\nBest regards,\nMuhammad Ali Zubair\nAI Automation Expert",
"options": {
"attachmentsUi": {
"attachmentsBinary": [
{
"property": "Facebook_Ads_Report_Week_of_Aug_12_2025.pdf"
}
]
},
"appendAttribution": false
},
"subject": "Weekly Facebook Ads Report | Aug 12 – Aug 18, 2025",
"emailType": "text"
},
"typeVersion": 2.1
},
{
"id": "1ea42b59-b07d-427f-8592-d62b4bfbc7bb",
"name": "AI 报告编写器",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-752,
1024
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": {},
"messages": {
"values": [
{
"content": "=Summary of All Compaigns: {{ $json.output }} "
},
{
"role": "system",
"content": "=You are a senior performance marketing analyst. Analyze multiple Facebook Ads campaign summaries and produce one concise, insight-rich HTML report.\n\nInput: JSON array of campaigns. Each item may include: campaign_name, date_start, date_stop, impressions, clicks, spend, action metrics (link_click, purchase), and a short per-campaign summary from another agent.\n\nOutput rules:\n\nOutput valid HTML5 only. No Markdown. No code fences. No scripts. No styles.\n\nUse this heading structure:\n\n<h1> Weekly Facebook Ads Performance Report\n\n<h2> Campaign Analysis\n\nFor each campaign: <h3> [Campaign Name]\n\nFor each campaign block:\n\nShow a <p> line for Date Range.\n\nAdd an Insights list as <ul><li>...</li></ul>. Use simple words. Show rates with a % sign when possible. If a metric is missing, write unavailable.\n\nAdd a Recommendations list as <ul><li>...</li></ul> with 3 to 5 specific next steps about audience, creative, budget, bidding, placements, or experiments.\n\nAfter listing all campaigns, add:\n\n<h2> Summary and Recommendations\n\nThree sections in plain English using <p> and <ul>:\n\nWhich campaigns performed best and why\n\nWhich campaigns underperformed and why\n\nRecommendations to improve results next week\n\nBe objective. Do not invent data. If you infer, say that you inferred it.\n\nKeep language simple and client friendly. Use short sentences. Avoid difficult terms. Avoid hyphens and long dashes.\n\nFormatting requirements:\n\nStart the response with <!DOCTYPE html><html lang=\"en\"><head><meta charset=\"UTF-8\"><title>Weekly Facebook Ads Performance Report</title></head><body> and end with </body></html>.\n\nUse only <h1>, <h2>, <h3>, <p>, <ul>, <li>, <strong>, <em>, and <table>/<tr>/<th>/<td> if needed for compact numbers.\n\nKeep paragraphs short. Prefer bullet points for clarity.\n\nAlways include the % sign for rates when shown."
}
]
}
},
"typeVersion": 1.8
},
{
"id": "e942ddc4-7ed3-4bd5-90a6-ca8c4eb96dc3",
"name": "设置节点",
"type": "n8n-nodes-base.set",
"position": [
-448,
1024
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "f3f3f52d-210f-4646-b011-d3be9af6c1f5",
"name": "html",
"type": "string",
"value": "={{ $json[\"message\"][\"content\"] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "d9f04e45-24c3-4f5a-ac01-6d007d571558",
"name": "OpenAI",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-1168,
1040
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"typeVersion": 1.2
},
{
"id": "5776dd7f-4d53-42f7-87c7-f5ec254099bd",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
704
],
"parameters": {
"color": 4,
"width": 576,
"height": 224,
"content": "## 获取和格式化数据"
},
"typeVersion": 1
},
{
"id": "485d88f1-b0e8-4087-ad2e-d3e4d46cff5b",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
976
],
"parameters": {
"color": 3,
"width": 160,
"height": 192,
"content": "### 聊天模型"
},
"typeVersion": 1
},
{
"id": "c6e90a0b-f30f-4d3d-a70f-b7d491e42cb9",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1008,
976
],
"parameters": {
"color": 3,
"width": 704,
"height": 192,
"content": "## 生成最终性能报告"
},
"typeVersion": 1
},
{
"id": "806c115a-94de-4b9d-8887-8e99c5501812",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-608,
704
],
"parameters": {
"color": 5,
"width": 304,
"height": 224,
"content": "## 总结广告活动表现"
},
"typeVersion": 1
},
{
"id": "acb9c4a7-f07f-4a91-863d-53a09c4e70cd",
"name": "AI 总结器",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-576,
784
],
"parameters": {
"text": "=Here is Detail TO analyze\nCampaign_name: {{ $json.campaign_name }}\nImpressions: {{ $json.impressions }}\nclicks: {{ $json.clicks }}\nspend: {{ $json.spend }}\ndate_start :{{ $json.date_start }}\ndate_END {{ $json.date_stop }}\nPurchase:{{ $json.purchase }}\nlink_click: {{ $json.link_click }}",
"options": {
"systemMessage": "You are a marketing analyst specializing in Facebook Ads reporting. \nYour task is to analyze a single campaign's performance and generate a clear, actionable summary. \n\nYou will receive the following campaign data for the week: \n- Campaign Name \n- Date Range (date_start – date_stop) \n- Impressions \n- Clicks (all ad interactions) \n- Spend \n- Actions (e.g., link_click, purchase, etc.) \n\nYour output must include: \n\n1. Campaign Name \n2. Date Range \n3. Insights \n - Engagement: impressions, CTR, cost per click, engagement trends. \n - Traffic: link clicks, landing page visits, efficiency of driving traffic. \n - Conversions: purchases or other key actions, cost per purchase, ROAS if possible. \n - Highlight strengths and weaknesses clearly. \n\n4. Recommendations \n - Provide 3–5 **specific, actionable next steps** to improve this campaign’s performance next week (e.g., optimize targeting, adjust creative, retargeting, budget allocation, testing strategies). \n\nRules: \n- Focus only on this campaign. Do not compare it to other campaigns. \n- Keep the tone concise, professional, and client-friendly (plain English, no heavy jargon). \n- If some metrics are missing, state they are unavailable and infer cautiously. \n- Output in clear sections with headings and short paragraphs or bullet points. \n"
},
"promptType": "define"
},
"typeVersion": 2.2
},
{
"id": "a362c4cb-ed71-4449-b099-e9a72e99a064",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
1200
],
"parameters": {
"width": 464,
"height": 224,
"content": "## 生成和分享 PDF"
},
"typeVersion": 1
},
{
"id": "60efabe6-53fc-421f-a33d-6dfbb952eaaf",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1728,
704
],
"parameters": {
"width": 432,
"height": 752,
"content": "## Facebook 广告每周性能报告生成器"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Set Node": [
{
"json": {
"html": "<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n<meta charset=\"UTF-8\">\n<title>Weekly Facebook Ads Performance Report</title>\n</head>\n<body>\n\n<h1>Weekly Facebook Ads Performance Report</h1>\n\n<h2>Campaign Analysis</h2>\n\n<h3>Summer Sale Campaign</h3>\n<p>Date Range: 2025-08-12 – 2025-08-18</p>\n<ul>\n <li>Impressions: 15,342</li>\n <li>Clicks: 456 with a Click-Through Rate (CTR) of 2.97%</li>\n <li>Cost Per Click (CPC): $0.27</li>\n <li>Link Clicks: 400 with Cost Per Link Click of $0.31</li>\n <li>Purchases: 12 with Cost Per Purchase (CPP) of $10.29</li>\n <li>Conversion Rate from Link Clicks to Purchases: 3.00%</li>\n <li>Return on Ad Spend (ROAS): unavailable</li>\n <li>Post-click behavior data: unavailable</li>\n</ul>\n<ul>\n <li>Increase budget gradually and test Lookalike Audiences from purchasers or high-value visitors.</li>\n <li>Review and improve the landing page experience, focusing on speed, clarity, and mobile optimization.</li>\n <li>Create a retargeting campaign for users who clicked but did not purchase, using urgency and incentives.</li>\n <li>Run A/B tests on ad creatives, headlines, and messages to further improve engagement and reduce CPP.</li>\n</ul>\n\n<h3>Retargeting Campaign</h3>\n<p>Date Range: 2025-08-12 – 2025-08-18</p>\n<ul>\n <li>Impressions: 8,421</li>\n <li>Clicks: 198 with CTR of 2.35%</li>\n <li>CPC: $0.34</li>\n <li>Link Clicks: 170 at Cost Per Link Click of $0.40</li>\n <li>Purchases: 5 with CPP of $13.56</li>\n <li>ROAS: unavailable</li>\n</ul>\n<ul>\n <li>Set up conversion value tracking for better profitability insight and ROAS calculation.</li>\n <li>Test new creatives and offers like discount codes or free shipping to increase conversions.</li>\n <li>Segment retargeting audiences by behavior (cart abandoners, page visitors) and tailor ads accordingly.</li>\n <li>Consider Dynamic Product Ads to show users products they viewed to boost conversions.</li>\n</ul>\n\n<h3>New Product Launch</h3>\n<p>Date Range: 2025-08-12 – 2025-08-18</p>\n<ul>\n <li>Impressions: 20,345</li>\n <li>Clicks: 512 with CTR of 2.51%</li>\n <li>CPC: $0.39</li>\n <li>Link Clicks: 480 with Cost Per Link Click of $0.42</li>\n <li>Purchases: 20 with CPP of $10.03</li>\n <li>Conversion Rate from Link Clicks to Purchases: 4.17%</li>\n <li>ROAS: unavailable</li>\n</ul>\n<ul>\n <li>Increase budget by 10-20% and watch performance closely to maintain good CPP.</li>\n <li>Optimize campaign for purchase conversions to help Facebook find better buyers.</li>\n <li>Launch retargeting ads for visitors who did not buy, focusing on testimonials or limited offers.</li>\n <li>Continue A/B testing creatives and ad copy to find higher-performing combinations.</li>\n</ul>\n\n<h3>Holiday Promo</h3>\n<p>Date Range: 2025-08-12 – 2025-08-18</p>\n<ul>\n <li>Impressions: 11,230</li>\n <li>Clicks: 250 with CTR of 2.23%</li>\n <li>CPC: $0.38</li>\n <li>Link Clicks: 230</li>\n <li>Purchases: 8 with CPP of $11.88</li>\n <li>ROAS: unavailable</li>\n</ul>\n<ul>\n <li>Implement purchase value tracking to calculate ROAS and measure profitability.</li>\n <li>Test landing page elements and offer details to improve conversion rate.</li>\n <li>Create retargeting for users who clicked but did not buy, with new creatives or exclusive offers.</li>\n <li>Try small creative changes to increase CTR and lower cost per purchase.</li>\n <li>Plan budget increases only after confirming positive ROAS.</li>\n</ul>\n\n<h3>Retargeting High-Intent</h3>\n<p>Date Range: 2025-08-12 – 2025-08-18</p>\n<ul>\n <li>Impressions: 9,320</li>\n <li>Clicks: 220 with CTR of 2.36%</li>\n <li>CPC: $0.40</li>\n <li>Link Clicks: 200 at Cost Per Link Click of $0.44</li>\n <li>Purchases: 7 with CPP of $12.68</li>\n <li>Conversion Rate from Link Clicks to Purchases: 3.5%</li>\n <li>ROAS: unavailable</li>\n</ul>\n<ul>\n <li>Consider modest budget increase to reach more high-intent users if audience size allows.</li>\n <li>Test different ad creatives and offers like discounts or free shipping to raise conversion rates.</li>\n <li>Exclude recent purchasers from this audience to avoid wasted spend on repeat ads.</li>\n <li>Monitor ad frequency to prevent ad fatigue and keep performance stable.</li>\n</ul>\n\n<h2>Summary and Recommendations</h2>\n\n<p><strong>Which campaigns performed best and why:</strong></p>\n<ul>\n <li><em>New Product Launch</em> had the highest number of purchases (20), a strong 4.17% conversion rate, and a low Cost Per Purchase ($10.03), showing efficient traffic and good product appeal.</li>\n <li><em>Summer Sale Campaign</em> delivered strong engagement with a 2.97% CTR and low CPC ($0.27), plus 12 purchases, indicating good audience targeting and creative.</li>\n <li><em>Retargeting High-Intent</em> showed solid conversion efficiency with a 3.5% purchase rate from link clicks and good CPC ($0.40), proving the value of focused retargeting on high-intent users.</li>\n</ul>\n\n<p><strong>Which campaigns underperformed and why:</strong></p>\n<ul>\n <li><em>Retargeting Campaign</em> had fewer purchases (5) and a slightly higher Cost Per Purchase ($13.56), suggesting room for better audience segmentation or creative improvement.</li>\n <li><em>Holiday Promo</em> generated only 8 purchases with a relatively higher CPP ($11.88) and had the lowest CTR (2.23%), indicating opportunity to optimize ad creative and landing page experience.</li>\n <li>All campaigns lacked ROAS data, limiting insight into true profitability and making it hard to prioritize budget confidently.</li>\n</ul>\n\n<p><strong>Recommendations to improve results next week:</strong></p>\n<ul>\n <li>Set up conversion value tracking for all campaigns to calculate ROAS and guide budget allocation effectively.</li>\n <li>Increase budgets carefully on top-performing campaigns like New Product Launch and Summer Sale, monitoring to preserve cost efficiency.</li>\n <li>Expand retargeting efforts by segmenting audiences by behavior and using tailored creative and offers to boost conversions.</li>\n <li>Continuously A/B test ad creatives, headlines, and calls to action to improve CTR and conversion rates across all campaigns.</li>\n <li>Optimize landing pages focusing on user experience and persuasion to increase conversion rates from link clicks to purchases.</li>\n</ul>\n\n</body>\n</html>"
}
}
],
"Format Data": [
{
"json": {
"spend": 123.45,
"clicks": 456,
"purchase": 12,
"date_stop": "2025-08-18",
"date_start": "2025-08-12",
"link_click": 400,
"impressions": 15342,
"campaign_name": "Summer Sale Campaign"
}
},
{
"json": {
"spend": 67.8,
"clicks": 198,
"purchase": 5,
"date_stop": "2025-08-18",
"date_start": "2025-08-12",
"link_click": 170,
"impressions": 8421,
"campaign_name": "Retargeting Campaign"
}
},
{
"json": {
"spend": 200.5,
"clicks": 512,
"purchase": 20,
"date_stop": "2025-08-18",
"date_start": "2025-08-12",
"link_click": 480,
"impressions": 20345,
"campaign_name": "New Product Launch"
}
},
{
"json": {
"spend": 95,
"clicks": 250,
"purchase": 8,
"date_stop": "2025-08-18",
"date_start": "2025-08-12",
"link_click": 230,
"impressions": 11230,
"campaign_name": "Holiday Promo"
}
},
{
"json": {
"spend": 88.75,
"clicks": 220,
"purchase": 7,
"date_stop": "2025-08-18",
"date_start": "2025-08-12",
"link_click": 200,
"impressions": 9320,
"campaign_name": "Retargeting High-Intent"
}
}
],
"Fetch FB Data": [
{
"json": {
"spend": "123.45",
"clicks": "456",
"actions": [
{
"value": "400",
"action_type": "link_click"
},
{
"value": "12",
"action_type": "purchase"
}
],
"date_stop": "2025-08-18",
"date_start": "2025-08-12",
"campaign_id": "120220709929980111",
"impressions": "15342",
"campaign_name": "Summer Sale Campaign"
}
},
{
"json": {
"spend": "67.80",
"clicks": "198",
"actions": [
{
"value": "170",
"action_type": "link_click"
},
{
"value": "5",
"action_type": "purchase"
}
],
"date_stop": "2025-08-18",
"date_start": "2025-08-12",
"campaign_id": "120220709929980112",
"impressions": "8421",
"campaign_name": "Retargeting Campaign"
}
},
{
"json": {
"spend": "200.50",
"clicks": "512",
"actions": [
{
"value": "480",
"action_type": "link_click"
},
{
"value": "20",
"action_type": "purchase"
}
],
"date_stop": "2025-08-18",
"date_start": "2025-08-12",
"campaign_id": "120220709929980113",
"impressions": "20345",
"campaign_name": "New Product Launch"
}
},
{
"json": {
"spend": "95.00",
"clicks": "250",
"actions": [
{
"value": "230",
"action_type": "link_click"
},
{
"value": "8",
"action_type": "purchase"
}
],
"date_stop": "2025-08-18",
"date_start": "2025-08-12",
"campaign_id": "120220709929980114",
"impressions": "11230",
"campaign_name": "Holiday Promo"
}
},
{
"json": {
"spend": "88.75",
"clicks": "220",
"actions": [
{
"value": "200",
"action_type": "link_click"
},
{
"value": "7",
"action_type": "purchase"
}
],
"date_stop": "2025-08-18",
"date_start": "2025-08-12",
"campaign_id": "120220709929980115",
"impressions": "9320",
"campaign_name": "Retargeting High-Intent"
}
}
],
"Merge Reports": [
{
"json": {
"output": [
"Here's an analysis of your \"Summer Sale Campaign\" performance for the specified week:\n\n---\n\n## Facebook Ads Campaign Performance Report: Summer Sale Campaign\n\n**1. Campaign Name:** Summer Sale Campaign\n\n**2. Date Range:** 2025-08-12 – 2025-08-18\n\n**3. Insights**\n\n* **Engagement:**\n * The campaign achieved **15,342 impressions**, indicating good reach within your target audience.\n * With **456 total clicks**, the Click-Through Rate (CTR) was a healthy **2.97%**. This suggests that your ad creative and messaging were highly engaging and resonated well with viewers.\n * The Cost Per Click (CPC) was very efficient at **$0.27**, demonstrating excellent value for the engagement generated.\n\n* **Traffic:**\n * Out of the total clicks, **400 were link clicks**, successfully driving interested users to your website or landing page.\n * The Cost Per Link Click (CPDLC) was **$0.31**, which is also a very competitive rate for acquiring website traffic. The campaign is effectively driving a good volume of potentially qualified traffic.\n\n* **Conversions:**\n * The campaign generated **12 purchases**, which is the primary conversion goal for a sales campaign.\n * The Cost Per Purchase (CPP) was **$10.29**. This cost appears reasonable, though its ultimate profitability depends on the average order value and your product margins (Return on Ad Spend, or ROAS, cannot be calculated without revenue data).\n * The conversion rate from link clicks to purchases was **3.00%**, indicating that a decent percentage of those who visited your site converted.\n\n* **Strengths & Weaknesses:**\n * **Strengths:** The campaign excels at attracting attention and driving cost-effective traffic, evidenced by its strong CTR and low CPC. It successfully generated sales, demonstrating an effective funnel from ad to purchase.\n * **Weaknesses:** While generating purchases, the overall volume (12) is relatively low for a week-long sale campaign. Without ROAS, the direct profitability is unknown. We also lack data on post-click behavior (e.g., bounce rate, time on site) which could offer further insights into traffic quality.\n\n**4. Recommendations**\n\n1. **Increase Budget & Explore Lookalikes:** Given the excellent engagement (high CTR, low CPC) and efficient traffic, consider a gradual increase in your daily budget. This will allow the campaign to reach a larger audience and potentially drive more conversions. Simultaneously, explore creating Lookalike Audiences based on your existing purchasers or high-value website visitors to expand reach to similar high-potential users.\n2. **Optimize Landing Page Experience:** Review the \"Summer Sale\" landing page for any potential areas of friction. Ensure it's fully optimized for mobile devices, loads quickly, clearly highlights sale items/discounts, and has prominent calls-to-action. Small improvements here could further boost your 3.00% conversion rate.\n3. **Implement Retargeting Funnel:** Create a dedicated retargeting campaign targeting the 400 users who clicked your ad but did not complete a purchase. Use specific creatives highlighting the urgency of the sale, popular items, or offering additional incentives to encourage them to return and convert.\n4. **A/B Test Creative Variations:** While current creatives are performing well, continuously test new ad visuals (images, videos), headlines, and ad copy. Experiment with highlighting different sale benefits or product categories to see if you can further improve CTR and reduce Cost Per Purchase.",
"Here's an analysis of your \"Retargeting Campaign\" performance for the specified week:\n\n### 1. Campaign Name\nRetargeting Campaign\n\n### 2. Date Range\n2025-08-12 – 2025-08-18\n\n### 3. Insights\n\n* **Engagement:**\n * The campaign generated **8,421 impressions** and **198 total clicks**, resulting in a strong **Click-Through Rate (CTR) of 2.35%**. This is a healthy CTR for a retargeting campaign, indicating the ads were relevant and captured audience attention.\n * The **Cost Per Click (CPC) was $0.34**, which is highly efficient and suggests good ad placement and targeting effectiveness.\n\n* **Traffic:**\n * Of the total clicks, **170 were Link Clicks**, directly driving traffic to your website. The **Cost Per Link Click was $0.40**, demonstrating excellent efficiency in getting interested users to your landing page.\n\n* **Conversions:**\n * The campaign successfully drove **5 purchases** during the week.\n * The **Cost Per Purchase (CPP) was $13.56**. This metric needs to be evaluated against the average order value or profit margin to determine its profitability.\n * **Return on Ad Spend (ROAS) cannot be calculated** as the revenue generated from these purchases is not available.\n\n* **Strengths:**\n * **Highly Engaged Audience:** The strong CTR and efficient CPC/CPLinkC indicate that the retargeting audience found the ads highly relevant.\n * **Cost-Effective Traffic:** The campaign efficiently drove traffic to your site at a low cost.\n * **Conversions Achieved:** Successfully converted 5 users into purchasers, demonstrating the value of retargeting.\n\n* **Weaknesses:**\n * **Limited Profitability View:** Without knowing the revenue or profit per purchase, it's impossible to assess the true Return on Ad Spend (ROAS) and overall profitability of the campaign.\n\n### 4. Recommendations\n\nBased on this week's performance, here are 3-5 specific, actionable next steps:\n\n1. **Implement Conversion Value Tracking:** Prioritize setting up your Facebook Pixel to pass back the purchase value for each conversion. This will enable ROAS calculation, providing crucial insight into profitability and guiding future budget allocation.\n2. **A/B Test New Creative & Offers:** Experiment with different ad creatives (e.g., video, carousel), ad copy (e.g., highlighting different benefits, urgency), and specific offers (e.g., discount codes, free shipping) to see if you can increase the conversion rate or average order value among your retargeting audience.\n3. **Segment Retargeting Audience Further:** Explore creating more granular retargeting audiences (e.g., people who added to cart but didn't purchase, people who visited specific high-value pages, or users who engaged with your content recently). Tailor specific messages and offers to these segments to potentially boost conversion rates.\n4. **Explore Dynamic Product Ads (DPAs):** If you have a product catalog, consider setting up Dynamic Product Ads. These ads automatically show users the specific products they viewed on your website, which can be highly effective for retargeting and driving purchases.",
"Here is an analysis of your \"New Product Launch\" Facebook Ads campaign for the specified week:\n\n---\n\n### **Facebook Ads Campaign Performance Report**\n\n**1. Campaign Name:** New Product Launch\n**2. Date Range:** 2025-08-12 – 2025-08-18\n\n**3. Insights**\n\n* **Engagement:**\n * The campaign achieved **20,345 impressions**, indicating a good level of visibility for the new product.\n * The overall Click-Through Rate (CTR) was **2.51%** (512 clicks from 20,345 impressions), which is a solid performance, suggesting the ad creative and copy were effective in capturing audience attention.\n * The Cost Per Click (CPC) was very efficient at **$0.39**.\n * Notably, 480 out of 512 total clicks were link clicks, indicating that most interactions were valuable clicks to your website, rather than just likes or comments.\n\n* **Traffic:**\n * The campaign successfully drove **480 link clicks** to your landing page or website.\n * The Cost Per Link Click (CPLLC) was **$0.42**, demonstrating excellent efficiency in driving potential customers to explore your new product further.\n\n* **Conversions:**\n * The campaign generated **20 purchases**, which is a positive outcome for a new product launch.\n * The Cost Per Purchase (CPP) was **$10.03**, indicating that acquiring a customer through this campaign was relatively efficient.\n * The conversion rate from link clicks to purchase was strong at **4.17%** (20 purchases from 480 link clicks), suggesting that the landing page and product offering resonated well with the traffic driven.\n\n* **Strengths:**\n * **Highly Efficient Traffic Generation:** Very low CPC and CPLLC demonstrate that the campaign is excellent at attracting clicks.\n * **Strong Conversion Rate:** A 4.17% conversion rate from link clicks to purchases is very healthy, indicating good audience targeting and effective product appeal on the landing page.\n * **Low Cost Per Acquisition:** The $10.03 Cost Per Purchase is a significant strength, pointing to a potentially profitable campaign.\n\n* **Weaknesses:**\n * Without knowing the average order value (AOV) or profit margin per product, it's impossible to calculate Return on Ad Spend (ROAS) to definitively confirm profitability, though the CPP looks promising.\n\n**4. Recommendations**\n\n1. **Increase Budget Incrementally:** Given the strong performance and efficient Cost Per Purchase ($10.03), consider a modest increase in daily budget (e.g., 10-20%). Monitor performance closely to ensure efficiency is maintained as spend scales.\n2. **Optimize for Purchase Events:** Ensure the campaign's optimization goal is explicitly set to \"Purchases.\" This will help Facebook's algorithm find more users who are most likely to convert, potentially improving overall volume while maintaining cost efficiency.\n3. **Implement Retargeting Campaigns:** Create custom audiences of users who initiated a link click but did not complete a purchase. Serve these users specific retargeting ads with compelling messaging, testimonials, or perhaps a limited-time offer to encourage them to complete their purchase.\n4. **A/B Test Ad Creatives & Messaging:** While current ads are performing well, continuously test different ad creatives (images/videos) and ad copy variations. This can help identify even higher-performing combinations that could further improve CTR and conversion rates. Focus on different angles or benefits of the new product.",
"Here is an analysis of your \"Holiday Promo\" campaign performance:\n\n---\n\n### **Campaign Performance Summary**\n\n**1. Campaign Name:** Holiday Promo\n\n**2. Date Range:** 2025-08-12 – 2025-08-18\n\n**3. Insights**\n\n* **Engagement:**\n * The campaign generated **11,230 impressions** and achieved a Click-Through Rate (CTR) of **2.23%**. This indicates that the ad creative and copy were effective in capturing audience attention.\n * The Cost Per Click (CPC) was remarkably efficient at **$0.38**, suggesting that you are acquiring clicks at a very reasonable price.\n\n* **Traffic:**\n * Out of 250 total clicks, **230 were link clicks**, meaning the vast majority of users who clicked were driven to your intended destination (likely a landing page). This demonstrates good traffic quality and relevance.\n\n* **Conversions:**\n * The campaign successfully drove **8 purchases**.\n * The Cost Per Purchase (CPP) was **$11.88**, indicating the average cost to acquire one customer through this campaign.\n * Return on Ad Spend (ROAS) cannot be calculated without the total revenue generated from these purchases, so it's currently unavailable.\n\n* **Strengths:**\n * **Efficient Click Acquisition:** The low CPC and good CTR highlight that your ads are resonating and driving traffic cost-effectively.\n * **Positive Conversion Activity:** The campaign is generating direct purchases, which is its primary objective.\n * **Relevant Traffic:** Most clicks are translating into actual link clicks, indicating interest in your offer.\n\n* **Weaknesses:**\n * **Profitability Unclear:** Without knowing the value of each purchase (ROAS), it's challenging to assess the overall profitability of the campaign.\n * **Conversion Rate Potential:** While purchases are happening, there might be opportunities to optimize the conversion rate from link clicks to purchases.\n\n**4. Recommendations**\n\nTo further enhance the \"Holiday Promo\" campaign's performance next week, consider the following:\n\n1. **Integrate Purchase Value Tracking:** Implement tracking for the value of each purchase to calculate Return on Ad Spend (ROAS). This is crucial for understanding the campaign's true profitability and justifying further investment.\n2. **Optimize Landing Page & Offer:** Analyze your landing page and the \"Holiday Promo\" offer. A/B test elements such as the Call-to-Action (CTA), product descriptions, images, or checkout process to potentially increase the conversion rate from link clicks to purchases.\n3. **Implement Retargeting:** Create a specific retargeting audience of users who clicked on your ad but did not complete a purchase. Serve them reminder ads with a slightly different creative or an exclusive offer to encourage them to convert.\n4. **A/B Test Ad Creative Variations:** Given the strong initial engagement, test minor variations in your ad creatives (e.g., different headlines, images/videos, or calls to action) to see if you can achieve even higher CTRs or lower cost per purchase.\n5. **Consider Budget Scale (Post-ROAS):** If ROAS proves to be positive and profitable once tracked, consider gradually increasing the campaign budget to capitalize on the efficient click acquisition and conversion rates.",
"Here is the performance summary for your \"Retargeting High-Intent\" campaign:\n\n---\n\n**Campaign Performance Summary**\n\n**1. Campaign Name:** Retargeting High-Intent\n\n**2. Date Range:** 2025-08-12 – 2025-08-18\n\n**3. Insights**\n\n* **Engagement:**\n * The campaign generated 9,320 impressions with 220 total clicks, resulting in a Click-Through Rate (CTR) of 2.36%.\n * The average Cost Per Click (CPC) was $0.40, indicating efficient spending for driving interactions.\n * Given it's a retargeting campaign, a CTR above 2% is generally healthy, suggesting the creative is resonating with the high-intent audience.\n\n* **Traffic:**\n * Out of 220 clicks, 200 were specific link clicks, showing that a high percentage (90.9%) of interactions led to users visiting the intended destination.\n * The Cost Per Link Click was $0.44, which is a good rate for driving qualified traffic.\n\n* **Conversions:**\n * The campaign successfully drove 7 purchases.\n * The Cost Per Purchase (CPP) was $12.68, which is a strong result for a retargeting campaign, indicating good conversion efficiency.\n * The conversion rate from link clicks to purchases was 3.5% (7 purchases from 200 link clicks), suggesting that the retargeted audience is indeed high-intent and the landing page experience is effective for converting these users.\n * Return on Ad Spend (ROAS) cannot be calculated as revenue data per purchase is unavailable.\n\n* **Strengths & Weaknesses:**\n * **Strengths:** Excellent efficiency in driving purchases with a low Cost Per Purchase. The high percentage of link clicks out of total clicks indicates the ad creative is effectively prompting users to visit the site. The conversion rate from link clicks to purchases is commendable for a retargeting audience.\n * **Weaknesses:** ROAS is unknown, so the ultimate profitability cannot be fully assessed from this data. There's no information on potential ad fatigue (frequency) within this retargeting audience.\n\n**4. Recommendations**\n\nBased on this week's performance, here are 3–5 actionable next steps:\n\n1. **Consider a Modest Budget Increase:** Given the strong Cost Per Purchase ($12.68) and efficient traffic generation, consider increasing the budget slightly to capture more of this high-intent audience, provided the audience size allows for scaling without significant frequency issues.\n2. **A/B Test Creative & Offers:** Experiment with different ad creatives (visuals, copy) or specific retargeting offers (e.g., a limited-time discount, free shipping for returning visitors) to potentially improve CTR or conversion rate further.\n3. **Refine Audience Exclusions:** Ensure that recent purchasers are excluded from this retargeting audience to avoid showing ads unnecessarily and wasting budget (unless the campaign specifically targets repeat purchases). This keeps the audience truly high-intent for new conversions.\n4. **Monitor Ad Frequency:** Keep an eye on the ad frequency metric to ensure the target audience isn't seeing the ads too often, which could lead to ad fatigue and diminishing returns in the coming weeks."
]
}
}
],
"Weekly Trigger": [
{
"json": {
"Hour": "15",
"Year": "2025",
"Month": "August",
"Minute": "07",
"Second": "40",
"Timezone": "Asia/Karachi (UTC+05:00)",
"timestamp": "2025-08-19T15:07:40.737+05:00",
"Day of week": "Tuesday",
"Day of month": "19",
"Readable date": "August 19th 2025, 3:07:40 pm",
"Readable time": "3:07:40 pm"
}
}
],
"AI Report Writer": [
{
"json": {
"index": 0,
"message": {
"role": "assistant",
"content": "<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n<meta charset=\"UTF-8\">\n<title>Weekly Facebook Ads Performance Report</title>\n</head>\n<body>\n\n<h1>Weekly Facebook Ads Performance Report</h1>\n\n<h2>Campaign Analysis</h2>\n\n<h3>Summer Sale Campaign</h3>\n<p>Date Range: 2025-08-12 – 2025-08-18</p>\n<ul>\n <li>Impressions: 15,342</li>\n <li>Clicks: 456 with a Click-Through Rate (CTR) of 2.97%</li>\n <li>Cost Per Click (CPC): $0.27</li>\n <li>Link Clicks: 400 with Cost Per Link Click of $0.31</li>\n <li>Purchases: 12 with Cost Per Purchase (CPP) of $10.29</li>\n <li>Conversion Rate from Link Clicks to Purchases: 3.00%</li>\n <li>Return on Ad Spend (ROAS): unavailable</li>\n <li>Post-click behavior data: unavailable</li>\n</ul>\n<ul>\n <li>Increase budget gradually and test Lookalike Audiences from purchasers or high-value visitors.</li>\n <li>Review and improve the landing page experience, focusing on speed, clarity, and mobile optimization.</li>\n <li>Create a retargeting campaign for users who clicked but did not purchase, using urgency and incentives.</li>\n <li>Run A/B tests on ad creatives, headlines, and messages to further improve engagement and reduce CPP.</li>\n</ul>\n\n<h3>Retargeting Campaign</h3>\n<p>Date Range: 2025-08-12 – 2025-08-18</p>\n<ul>\n <li>Impressions: 8,421</li>\n <li>Clicks: 198 with CTR of 2.35%</li>\n <li>CPC: $0.34</li>\n <li>Link Clicks: 170 at Cost Per Link Click of $0.40</li>\n <li>Purchases: 5 with CPP of $13.56</li>\n <li>ROAS: unavailable</li>\n</ul>\n<ul>\n <li>Set up conversion value tracking for better profitability insight and ROAS calculation.</li>\n <li>Test new creatives and offers like discount codes or free shipping to increase conversions.</li>\n <li>Segment retargeting audiences by behavior (cart abandoners, page visitors) and tailor ads accordingly.</li>\n <li>Consider Dynamic Product Ads to show users products they viewed to boost conversions.</li>\n</ul>\n\n<h3>New Product Launch</h3>\n<p>Date Range: 2025-08-12 – 2025-08-18</p>\n<ul>\n <li>Impressions: 20,345</li>\n <li>Clicks: 512 with CTR of 2.51%</li>\n <li>CPC: $0.39</li>\n <li>Link Clicks: 480 with Cost Per Link Click of $0.42</li>\n <li>Purchases: 20 with CPP of $10.03</li>\n <li>Conversion Rate from Link Clicks to Purchases: 4.17%</li>\n <li>ROAS: unavailable</li>\n</ul>\n<ul>\n <li>Increase budget by 10-20% and watch performance closely to maintain good CPP.</li>\n <li>Optimize campaign for purchase conversions to help Facebook find better buyers.</li>\n <li>Launch retargeting ads for visitors who did not buy, focusing on testimonials or limited offers.</li>\n <li>Continue A/B testing creatives and ad copy to find higher-performing combinations.</li>\n</ul>\n\n<h3>Holiday Promo</h3>\n<p>Date Range: 2025-08-12 – 2025-08-18</p>\n<ul>\n <li>Impressions: 11,230</li>\n <li>Clicks: 250 with CTR of 2.23%</li>\n <li>CPC: $0.38</li>\n <li>Link Clicks: 230</li>\n <li>Purchases: 8 with CPP of $11.88</li>\n <li>ROAS: unavailable</li>\n</ul>\n<ul>\n <li>Implement purchase value tracking to calculate ROAS and measure profitability.</li>\n <li>Test landing page elements and offer details to improve conversion rate.</li>\n <li>Create retargeting for users who clicked but did not buy, with new creatives or exclusive offers.</li>\n <li>Try small creative changes to increase CTR and lower cost per purchase.</li>\n <li>Plan budget increases only after confirming positive ROAS.</li>\n</ul>\n\n<h3>Retargeting High-Intent</h3>\n<p>Date Range: 2025-08-12 – 2025-08-18</p>\n<ul>\n <li>Impressions: 9,320</li>\n <li>Clicks: 220 with CTR of 2.36%</li>\n <li>CPC: $0.40</li>\n <li>Link Clicks: 200 at Cost Per Link Click of $0.44</li>\n <li>Purchases: 7 with CPP of $12.68</li>\n <li>Conversion Rate from Link Clicks to Purchases: 3.5%</li>\n <li>ROAS: unavailable</li>\n</ul>\n<ul>\n <li>Consider modest budget increase to reach more high-intent users if audience size allows.</li>\n <li>Test different ad creatives and offers like discounts or free shipping to raise conversion rates.</li>\n <li>Exclude recent purchasers from this audience to avoid wasted spend on repeat ads.</li>\n <li>Monitor ad frequency to prevent ad fatigue and keep performance stable.</li>\n</ul>\n\n<h2>Summary and Recommendations</h2>\n\n<p><strong>Which campaigns performed best and why:</strong></p>\n<ul>\n <li><em>New Product Launch</em> had the highest number of purchases (20), a strong 4.17% conversion rate, and a low Cost Per Purchase ($10.03), showing efficient traffic and good product appeal.</li>\n <li><em>Summer Sale Campaign</em> delivered strong engagement with a 2.97% CTR and low CPC ($0.27), plus 12 purchases, indicating good audience targeting and creative.</li>\n <li><em>Retargeting High-Intent</em> showed solid conversion efficiency with a 3.5% purchase rate from link clicks and good CPC ($0.40), proving the value of focused retargeting on high-intent users.</li>\n</ul>\n\n<p><strong>Which campaigns underperformed and why:</strong></p>\n<ul>\n <li><em>Retargeting Campaign</em> had fewer purchases (5) and a slightly higher Cost Per Purchase ($13.56), suggesting room for better audience segmentation or creative improvement.</li>\n <li><em>Holiday Promo</em> generated only 8 purchases with a relatively higher CPP ($11.88) and had the lowest CTR (2.23%), indicating opportunity to optimize ad creative and landing page experience.</li>\n <li>All campaigns lacked ROAS data, limiting insight into true profitability and making it hard to prioritize budget confidently.</li>\n</ul>\n\n<p><strong>Recommendations to improve results next week:</strong></p>\n<ul>\n <li>Set up conversion value tracking for all campaigns to calculate ROAS and guide budget allocation effectively.</li>\n <li>Increase budgets carefully on top-performing campaigns like New Product Launch and Summer Sale, monitoring to preserve cost efficiency.</li>\n <li>Expand retargeting efforts by segmenting audiences by behavior and using tailored creative and offers to boost conversions.</li>\n <li>Continuously A/B test ad creatives, headlines, and calls to action to improve CTR and conversion rates across all campaigns.</li>\n <li>Optimize landing pages focusing on user experience and persuasion to increase conversion rates from link clicks to purchases.</li>\n</ul>\n\n</body>\n</html>",
"refusal": null,
"annotations": []
},
"logprobs": null,
"finish_reason": "stop"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "7b2985a5-534f-4bb6-af3b-b217bac641db",
"connections": {
"OpenAI": {
"ai_languageModel": [
[
{
"node": "AI Summarizer",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Set Node": {
"main": [
[
{
"node": "Generate PDF",
"type": "main",
"index": 0
}
]
]
},
"Format Data": {
"main": [
[
{
"node": "AI Summarizer",
"type": "main",
"index": 0
}
]
]
},
"Generate PDF": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
]
]
},
"AI Summarizer": {
"main": [
[
{
"node": "Merge Reports",
"type": "main",
"index": 0
}
]
]
},
"Fetch FB Data": {
"main": [
[
{
"node": "Format Data",
"type": "main",
"index": 0
}
]
]
},
"Merge Reports": {
"main": [
[
{
"node": "AI Report Writer",
"type": "main",
"index": 0
}
]
]
},
"Weekly Trigger": {
"main": [
[
{
"node": "Fetch FB Data",
"type": "main",
"index": 0
}
]
]
},
"AI Report Writer": {
"main": [
[
{
"node": "Set Node",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 文档提取, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用 AI 和 Gmail 自动更新 YNAB 中的亚马逊交易备注
使用 AI 和 Gmail 自动更新 YNAB 中的亚马逊交易备注
If
Set
Wait
+13
30 节点Angel Menendez
文档提取
使用 Tavily 的职位发布
基于 Tavily 的自动化职位搜索
Set
Code
Gmail
+8
17 节点May Ramati Kroitero
杂项
使用AI分析检测病毒式YouTube视频并发送邮件报告
使用AI分析检测病毒式YouTube视频并发送邮件报告
Set
Code
Sort
+14
26 节点gclbck
杂项
MailChimp自动化
基于AI的餐厅通讯生成器，集成Mailchimp和Telegram审批
If
Set
Code
+16
43 节点Femi Ad
人工智能
自动化博客撰写与社交媒体推广代理
使用GPT-4、Perplexity和WordPress自动化SEO博客创建+社交媒体
Set
Code
Gmail
+21
79 节点LukaszB
设计
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
工作流信息
难度等级
高级
节点数量16
分类2
节点类型10
作者
Muhammad Ali
@ali01Transforming Business Workflows into Revenue Engines with n8n. From Marketing to Sales Ops, I Design Automations that Save Time and Increase Profits. Connect with me on LinkedIn for Custom Solutions.
外部链接
在 n8n.io 查看 →
分享此工作流