AI, Bright Data, Sheets 및 Slack 기반의 제휴사 경쟁사 추적 및 분석

• •Slack Bot Token 또는 Webhook URL
• •대상 API의 인증 정보가 필요할 수 있음
• •Google Sheets API 인증 정보

{
  "meta": {
    "instanceId": "db30e8ae4100235addbd4638770997b7ef11878d049073c888ba440ca84c55fc"
  },
  "nodes": [
    {
      "id": "1db8cf8c-ac58-46a4-9222-6306c71c3368",
      "name": "경쟁사 점검 일정 설정",
      "type": "n8n-nodes-base.scheduleTrigger",
      "notes": "Runs twice daily to monitor competitor offers automatically",
      "position": [
        -1120,
        240
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours",
              "hoursInterval": 12
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "3d6e51b2-80ab-4781-8783-50a6f43487d5",
      "name": "경쟁사 사이트 스크래핑",
      "type": "n8n-nodes-base.httpRequest",
      "notes": "Uses Bright Data API to scrape competitor affiliate pages",
      "position": [
        -896,
        240
      ],
      "parameters": {
        "url": "https://api.brightdata.com/datasets/v3/trigger",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "sendHeaders": true,
        "authentication": "genericCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "dataset_id",
              "value": "gd_l7q7dkf244hwjntr0"
            },
            {
              "name": "url",
              "value": "={{$json.competitorUrl}}"
            },
            {
              "name": "format",
              "value": "json"
            }
          ]
        },
        "genericAuthType": "httpHeaderAuth",
        "headerParameters": {
          "parameters": [
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "95e9a310-42f7-4791-ba94-524632e63473",
      "name": "AI 오퍼 분석",
      "type": "n8n-nodes-base.code",
      "notes": "Analyzes competitor offers and identifies threats to your program",
      "position": [
        -672,
        240
      ],
      "parameters": {
        "jsCode": "// AI-powered competitive offer analysis\nconst items = $input.all();\nconst analyzedItems = [];\n\nfor (const item of items) {\n  const data = item.json;\n  let competitiveScore = 0;\n  let insights = [];\n  let recommendations = [];\n  let alertLevel = 'normal';\n  \n  // Extract competitor data\n  const competitorName = data.competitorName || 'Unknown';\n  const commissionRate = parseFloat(data.commissionRate) || 0;\n  const cookieDuration = parseInt(data.cookieDuration) || 0;\n  const averageOrderValue = parseFloat(data.averageOrderValue) || 0;\n  const conversionRate = parseFloat(data.conversionRate) || 0;\n  const payoutThreshold = parseFloat(data.payoutThreshold) || 0;\n  \n  // Get your current rates from workflow context\n  const yourCommissionRate = 10; // Your current rate\n  const yourCookieDuration = 30; // Your cookie days\n  const yourAOV = 150; // Your AOV\n  \n  // Commission Rate Analysis\n  const commissionDiff = commissionRate - yourCommissionRate;\n  if (commissionDiff > 5) {\n    competitiveScore += 35;\n    insights.push(`HIGH ALERT: ${competitorName} offers ${commissionRate}% commission vs your ${yourCommissionRate}% (+${commissionDiff.toFixed(1)}% advantage)`);\n    recommendations.push(`URGENT: Consider matching or beating ${competitorName}'s ${commissionRate}% commission rate`);\n    alertLevel = 'critical';\n  } else if (commissionDiff > 2) {\n    competitiveScore += 25;\n    insights.push(`WARNING: ${competitorName} offers ${commissionRate}% commission vs your ${yourCommissionRate}% (+${commissionDiff.toFixed(1)}% advantage)`);\n    recommendations.push(`Review commission structure to stay competitive with ${competitorName}`);\n    alertLevel = alertLevel === 'critical' ? 'critical' : 'warning';\n  } else if (commissionDiff > 0) {\n    competitiveScore += 15;\n    insights.push(`${competitorName} offers slightly higher commission: ${commissionRate}% vs ${yourCommissionRate}%`);\n  } else if (commissionDiff < -3) {\n    insights.push(`YOUR ADVANTAGE: You offer ${yourCommissionRate}% vs ${competitorName}'s ${commissionRate}% (-${Math.abs(commissionDiff).toFixed(1)}% in your favor)`);\n    recommendations.push(`Promote your superior ${yourCommissionRate}% commission rate in affiliate recruitment`);\n  } else {\n    insights.push(`Commission rates are competitive: ${commissionRate}% vs your ${yourCommissionRate}%`);\n  }\n  \n  // Cookie Duration Analysis\n  const cookieDiff = cookieDuration - yourCookieDuration;\n  if (cookieDiff > 30) {\n    competitiveScore += 25;\n    insights.push(`HIGH ALERT: ${competitorName} offers ${cookieDuration}-day cookies vs your ${yourCookieDuration} days`);\n    recommendations.push(`URGENT: Extend cookie duration to match ${competitorName}'s ${cookieDuration} days`);\n    alertLevel = 'critical';\n  } else if (cookieDiff > 15) {\n    competitiveScore += 15;\n    insights.push(`WARNING: ${competitorName} offers longer cookies: ${cookieDuration} vs ${yourCookieDuration} days`);\n    recommendations.push(`Consider extending cookie duration to improve conversion attribution`);\n    alertLevel = alertLevel === 'critical' ? 'critical' : 'warning';\n  } else if (cookieDiff > 0) {\n    competitiveScore += 8;\n    insights.push(`${competitorName} has slightly longer cookies: ${cookieDuration} vs ${yourCookieDuration} days`);\n  } else if (cookieDiff < -15) {\n    insights.push(`YOUR ADVANTAGE: ${yourCookieDuration}-day cookies vs ${competitorName}'s ${cookieDuration} days`);\n    recommendations.push(`Highlight your superior ${yourCookieDuration}-day cookie window in marketing`);\n  }\n  \n  // Average Order Value Analysis\n  const aovDiff = averageOrderValue - yourAOV;\n  if (averageOrderValue > 0) {\n    if (aovDiff > 100) {\n      competitiveScore += 20;\n      insights.push(`${competitorName} has higher AOV: $${averageOrderValue} vs your $${yourAOV}`);\n      recommendations.push(`Target higher-value products or bundles to compete with ${competitorName}`);\n    } else if (aovDiff > 50) {\n      competitiveScore += 10;\n      insights.push(`${competitorName} AOV slightly higher: $${averageOrderValue} vs $${yourAOV}`);\n    } else if (aovDiff < -50) {\n      insights.push(`YOUR ADVANTAGE: Higher AOV of $${yourAOV} vs ${competitorName}'s $${averageOrderValue}`);\n      recommendations.push(`Emphasize your higher earnings per conversion: $${yourAOV}`);\n    }\n  }\n  \n  // Conversion Rate Analysis\n  if (conversionRate > 0) {\n    if (conversionRate > 5) {\n      competitiveScore += 15;\n      insights.push(`${competitorName} reports strong ${conversionRate}% conversion rate`);\n      recommendations.push(`Research ${competitorName}'s landing page optimization tactics`);\n    } else if (conversionRate > 3) {\n      competitiveScore += 8;\n      insights.push(`${competitorName} has good ${conversionRate}% conversion rate`);\n    }\n  }\n  \n  // Payout Analysis\n  if (payoutThreshold > 0) {\n    if (payoutThreshold < 50) {\n      competitiveScore += 10;\n      insights.push(`${competitorName} has low $${payoutThreshold} payout threshold (affiliate-friendly)`);\n      recommendations.push(`Consider lowering your payout threshold to improve cash flow for affiliates`);\n    } else if (payoutThreshold > 100) {\n      insights.push(`YOUR ADVANTAGE: Lower payout threshold than ${competitorName}'s $${payoutThreshold}`);\n    }\n  }\n  \n  // Calculate EPC (Earnings Per Click)\n  const theirEPC = (averageOrderValue * commissionRate / 100 * conversionRate / 100).toFixed(2);\n  const yourEPC = (yourAOV * yourCommissionRate / 100 * 3 / 100).toFixed(2); // Assuming 3% conversion\n  \n  if (parseFloat(theirEPC) > parseFloat(yourEPC) * 1.3) {\n    insights.push(`ALERT: ${competitorName} estimated EPC $${theirEPC} vs your $${yourEPC}`);\n    recommendations.push(`Focus on improving your EPC through better commission or conversion optimization`);\n  } else if (parseFloat(yourEPC) > parseFloat(theirEPC) * 1.2) {\n    insights.push(`YOUR ADVANTAGE: Superior EPC of $${yourEPC} vs ${competitorName}'s $${theirEPC}`);\n    recommendations.push(`Promote your higher earnings potential: $${yourEPC} EPC`);\n  }\n  \n  // Determine threat level\n  let threatLevel = 'Low';\n  if (competitiveScore >= 70) {\n    threatLevel = 'Critical';\n  } else if (competitiveScore >= 45) {\n    threatLevel = 'High';\n  } else if (competitiveScore >= 25) {\n    threatLevel = 'Medium';\n  }\n  \n  // Strategic recommendations based on threat\n  if (threatLevel === 'Critical' || threatLevel === 'High') {\n    recommendations.push('Schedule emergency meeting with affiliate team');\n    recommendations.push('Analyze affiliate churn risk immediately');\n    recommendations.push('Prepare competitive response strategy within 48 hours');\n  } else if (threatLevel === 'Medium') {\n    recommendations.push('Monitor closely for additional changes');\n    recommendations.push('Survey top affiliates about competitive pressures');\n  } else {\n    recommendations.push('Continue monitoring - maintain current competitive position');\n    recommendations.push('Look for opportunities to widen competitive advantage');\n  }\n  \n  analyzedItems.push({\n    json: {\n      ...data,\n      competitorName: competitorName,\n      competitiveScore: competitiveScore,\n      threatLevel: threatLevel,\n      alertLevel: alertLevel,\n      insights: insights,\n      recommendations: recommendations,\n      comparison: {\n        commission: {\n          theirs: commissionRate,\n          yours: yourCommissionRate,\n          diff: commissionDiff.toFixed(1)\n        },\n        cookies: {\n          theirs: cookieDuration,\n          yours: yourCookieDuration,\n          diff: cookieDiff\n        },\n        aov: {\n          theirs: averageOrderValue,\n          yours: yourAOV,\n          diff: aovDiff.toFixed(2)\n        },\n        epc: {\n          theirs: theirEPC,\n          yours: yourEPC\n        }\n      },\n      analyzedAt: new Date().toISOString()\n    }\n  });\n}\n\nreturn analyzedItems;"
      },
      "typeVersion": 2
    },
    {
      "id": "e97dc192-289e-4e33-b2fc-16f50cdd276a",
      "name": "위협 수준별 라우팅",
      "type": "n8n-nodes-base.if",
      "notes": "Separates critical threats from routine competitive intelligence",
      "position": [
        -448,
        240
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": false,
            "typeValidation": "strict"
          },
          "combinator": "or",
          "conditions": [
            {
              "id": "critical-threat",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.threatLevel }}",
              "rightValue": "Critical"
            },
            {
              "id": "high-threat",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.threatLevel }}",
              "rightValue": "High"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "433b0b95-e1e6-4dc9-b5ae-6ba579f3c7f0",
      "name": "경쟁사 대시보드에 기록",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Records all competitive intelligence to centralized tracking sheet",
      "position": [
        0,
        48
      ],
      "parameters": {
        "columns": {
          "value": {
            "Date": "={{ $now.toFormat('yyyy-MM-dd') }}",
            "Score": "={{ $json.competitiveScore }}",
            "Your AOV": "$={{ $json.comparison.aov.yours }}",
            "Your EPC": "$={{ $json.comparison.epc.yours }}",
            "Their AOV": "$={{ $json.comparison.aov.theirs }}",
            "Their EPC": "$={{ $json.comparison.epc.theirs }}",
            "Competitor": "={{ $json.competitorName }}",
            "Threat Level": "={{ $json.threatLevel }}",
            "Your Cookies": "={{ $json.comparison.cookies.yours }} days",
            "Their Cookies": "={{ $json.comparison.cookies.theirs }} days",
            "Commission Diff": "={{ $json.comparison.commission.diff }}%",
            "Your Commission": "={{ $json.comparison.commission.yours }}%",
            "Their Commission": "={{ $json.comparison.commission.theirs }}%"
          },
          "mappingMode": "defineBelow"
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultName": "Competitor Analysis"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "your-competitor-tracking-spreadsheet-id",
          "cachedResultName": "Affiliate Competitor Intelligence"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "46260c58-cdff-4bcb-991d-62d09b53e360",
      "name": "모든 데이터 아카이빙",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Maintains historical record for trend analysis over time",
      "position": [
        -224,
        432
      ],
      "parameters": {
        "columns": {
          "value": {
            "AOV": "$={{ $json.comparison.aov.theirs }}",
            "EPC": "$={{ $json.comparison.epc.theirs }}",
            "Alert": "={{ $json.alertLevel }}",
            "Threat": "={{ $json.threatLevel }}",
            "Timestamp": "={{ $now.toISO() }}",
            "Commission": "={{ $json.comparison.commission.theirs }}%",
            "Competitor": "={{ $json.competitorName }}",
            "Cookie Days": "={{ $json.comparison.cookies.theirs }}"
          },
          "mappingMode": "defineBelow"
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=1",
          "cachedResultName": "Historical Log"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "your-competitor-tracking-spreadsheet-id",
          "cachedResultName": "Affiliate Competitor Intelligence"
        }
      },
      "typeVersion": 4.4
    },
    {
      "id": "e7b22a6c-09b8-44cc-b92d-fde97f43b72f",
      "name": "긴급: 경쟁 위협 알림",
      "type": "n8n-nodes-base.slack",
      "notes": "Immediate alert for critical competitive threats needing action",
      "position": [
        -224,
        -96
      ],
      "webhookId": "40725e22-f6b3-4b9c-b64a-63f3c680a8a9",
      "parameters": {
        "text": "🚨 *CRITICAL COMPETITIVE THREAT DETECTED*\n\n*Competitor:* {{ $json.competitorName }}\n*Threat Level:* {{ $json.threatLevel }}\n*Competitive Score:* {{ $json.competitiveScore }}/100\n\n*📊 HEAD-TO-HEAD COMPARISON*\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n*Commission Rate:*\n• Theirs: {{ $json.comparison.commission.theirs }}%\n• Yours: {{ $json.comparison.commission.yours }}%\n• Difference: {{ $json.comparison.commission.diff }}%\n\n*Cookie Duration:*\n• Theirs: {{ $json.comparison.cookies.theirs }} days\n• Yours: {{ $json.comparison.cookies.yours }} days\n\n*Average Order Value:*\n• Theirs: ${{ $json.comparison.aov.theirs }}\n• Yours: ${{ $json.comparison.aov.yours }}\n\n*Earnings Per Click (EPC):*\n• Theirs: ${{ $json.comparison.epc.theirs }}\n• Yours: ${{ $json.comparison.epc.yours }}\n\n*⚠️ KEY INSIGHTS:*\n{{ $json.insights.join('\\n') }}\n\n*🎯 IMMEDIATE ACTION REQUIRED:*\n{{ $json.recommendations.join('\\n') }}\n\n_⏰ Response deadline: Within 48 hours_",
        "otherOptions": {}
      },
      "typeVersion": 2.1
    },
    {
      "id": "f4d4bf7d-11ce-4b9a-bf50-fd685fe2a97d",
      "name": "전략 보고서 생성",
      "type": "n8n-nodes-base.code",
      "notes": "Creates detailed competitive intelligence reports for email distribution",
      "position": [
        -224,
        240
      ],
      "parameters": {
        "jsCode": "// Generate comprehensive competitive intelligence report\nconst items = $input.all();\nconst reportItems = [];\n\nfor (const item of items) {\n  const data = item.json;\n  const competitor = data.competitorName || 'Competitor';\n  const threat = data.threatLevel || 'Medium';\n  const alertLevel = data.alertLevel || 'normal';\n  \n  let emailSubject = '';\n  let emailBody = '';\n  let priority = 'Medium';\n  \n  if (threat === 'Critical' || threat === 'High') {\n    priority = 'Urgent';\n    emailSubject = `🚨 URGENT: ${competitor} Competitive Threat - Immediate Action Required`;\n    emailBody = `COMPETITIVE THREAT ALERT\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n\nDear Affiliate Team,\n\nWe've identified a ${threat.toUpperCase()}-LEVEL competitive threat that requires immediate strategic response.\n\n🎯 COMPETITOR OVERVIEW\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\nCompetitor: ${competitor}\nThreat Level: ${threat}\nCompetitive Score: ${data.competitiveScore}/100\nAlert Level: ${alertLevel.toUpperCase()}\n\n📊 COMPETITIVE COMPARISON\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n\n🔹 COMMISSION RATES\n   ${competitor}: ${data.comparison.commission.theirs}%\n   Your Program: ${data.comparison.commission.yours}%\n   Gap: ${data.comparison.commission.diff}%\n   ${parseFloat(data.comparison.commission.diff) > 0 ? '⚠️ DISADVANTAGE' : '✅ ADVANTAGE'}\n\n🔹 COOKIE DURATION\n   ${competitor}: ${data.comparison.cookies.theirs} days\n   Your Program: ${data.comparison.cookies.yours} days\n   ${data.comparison.cookies.theirs > data.comparison.cookies.yours ? '⚠️ THEY HAVE LONGER TRACKING' : '✅ YOU HAVE BETTER TRACKING'}\n\n🔹 AVERAGE ORDER VALUE\n   ${competitor}: $${data.comparison.aov.theirs}\n   Your Program: $${data.comparison.aov.yours}\n\n🔹 EARNINGS PER CLICK (EPC)\n   ${competitor}: $${data.comparison.epc.theirs}\n   Your Program: $${data.comparison.epc.yours}\n   ${parseFloat(data.comparison.epc.theirs) > parseFloat(data.comparison.epc.yours) ? '⚠️ THEY OFFER BETTER EARNINGS' : '✅ YOU OFFER BETTER EARNINGS'}\n\n⚠️ CRITICAL INSIGHTS\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n${data.insights.map((insight, i) => `${i + 1}. ${insight}`).join('\\n')}\n\n🎯 STRATEGIC RECOMMENDATIONS\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n${data.recommendations.map((rec, i) => `${i + 1}. ${rec}`).join('\\n')}\n\n⏰ IMMEDIATE ACTION ITEMS\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n1. Schedule emergency affiliate strategy meeting within 24 hours\n2. Assess affiliate churn risk with top 20 partners\n3. Develop counter-strategy and updated commission structure\n4. Prepare affiliate communication addressing competitive landscape\n5. Review budget for potential commission rate adjustments\n\n📈 BUSINESS IMPACT ASSESSMENT\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n• Risk of Affiliate Defection: ${threat === 'Critical' ? 'VERY HIGH' : 'HIGH'}\n• Estimated Monthly Revenue at Risk: Review with finance team\n• Competitive Response Timeline: 48-72 hours maximum\n• Market Position: ${threat === 'Critical' ? 'DETERIORATING' : 'AT RISK'}\n\nThis competitive intelligence was detected through our automated monitoring system. Please treat this information as confidential and time-sensitive.\n\nBest regards,\nAffiliate Intelligence System\n\n---\nGenerated: ${new Date().toLocaleString()}\nNext Check: In 12 hours`;\n  } else {\n    emailSubject = `📊 Competitive Intelligence Report: ${competitor}`;\n    emailBody = `COMPETITIVE INTELLIGENCE UPDATE\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n\nDear Affiliate Team,\n\nHere's your regular competitive intelligence update for ${competitor}.\n\n📊 CURRENT STANDING\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\nThreat Level: ${threat}\nCompetitive Score: ${data.competitiveScore}/100\n\n🔍 COMPETITIVE ANALYSIS\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n\nCommission Rates:\n• ${competitor}: ${data.comparison.commission.theirs}%\n• Your Program: ${data.comparison.commission.yours}%\n\nCookie Duration:\n• ${competitor}: ${data.comparison.cookies.theirs} days\n• Your Program: ${data.comparison.cookies.yours} days\n\nEarnings Per Click:\n• ${competitor}: $${data.comparison.epc.theirs}\n• Your Program: $${data.comparison.epc.yours}\n\n💡 KEY INSIGHTS\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n${data.insights.map((insight, i) => `${i + 1}. ${insight}`).join('\\n')}\n\n📋 RECOMMENDATIONS\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\n${data.recommendations.map((rec, i) => `${i + 1}. ${rec}`).join('\\n')}\n\nContinue monitoring for changes in competitive positioning.\n\nBest regards,\nAffiliate Intelligence System\n\n---\nGenerated: ${new Date().toLocaleString()}`;\n  }\n  \n  reportItems.push({\n    json: {\n      ...data,\n      emailSubject: emailSubject,\n      emailBody: emailBody,\n      priority: priority,\n      requiresUrgentAction: threat === 'Critical' || threat === 'High',\n      estimatedResponseTime: threat === 'Critical' ? '24 hours' : threat === 'High' ? '48 hours' : '1 week'\n    }\n  });\n}\n\nreturn reportItems;"
      },
      "typeVersion": 2
    },
    {
      "id": "b7ae2883-2bf2-437a-9da2-fea3d99f2259",
      "name": "제휴사 팀에 이메일 전송",
      "type": "n8n-nodes-base.emailSend",
      "notes": "Sends comprehensive competitive analysis reports to affiliate management team",
      "position": [
        0,
        240
      ],
      "webhookId": "efe26ea9-1d03-4afc-9bf3-270b974bc7e2",
      "parameters": {
        "options": {
          "replyTo": "affiliate-manager@yourcompany.com",
          "allowUnauthorizedCerts": false
        },
        "subject": "={{ $json.emailSubject }}",
        "toEmail": "affiliate-team@yourcompany.com",
        "fromEmail": "affiliate-intelligence@yourcompany.com"
      },
      "typeVersion": 2.1
    },
    {
      "id": "747e1f46-51f9-45f5-872f-5ee4d2132d77",
      "name": "정기 모니터링 알림",
      "type": "n8n-nodes-base.slack",
      "notes": "Regular updates for medium/low threats requiring ongoing monitoring",
      "position": [
        -224,
        624
      ],
      "webhookId": "79531d84-e5a6-4610-8309-5e6172e372dd",
      "parameters": {
        "text": "📊 *Competitive Intelligence Update*\n\n*Competitor:* {{ $json.competitorName }}\n*Threat Level:* {{ $json.threatLevel }}\n*Score:* {{ $json.competitiveScore }}/100\n\n*Quick Comparison:*\n• Commission: {{ $json.comparison.commission.theirs }}% (yours: {{ $json.comparison.commission.yours }}%)\n• Cookies: {{ $json.comparison.cookies.theirs }} days (yours: {{ $json.comparison.cookies.yours }})\n• EPC: ${{ $json.comparison.epc.theirs }} (yours: ${{ $json.comparison.epc.yours }})\n\n_No immediate action required - monitoring continues_",
        "otherOptions": {}
      },
      "typeVersion": 2.1
    },
    {
      "id": "f0bde90a-49ea-4493-bb42-60664086ef84",
      "name": "시장 위치 계산",
      "type": "n8n-nodes-base.set",
      "notes": "Aggregates competitive intelligence into market position summary metrics",
      "position": [
        224,
        144
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "total-competitors",
              "name": "totalCompetitors",
              "type": "number",
              "value": "={{ $input.all().length }}"
            },
            {
              "id": "critical-threats",
              "name": "criticalThreats",
              "type": "number",
              "value": "={{ $input.all().filter(item => item.json.threatLevel === 'Critical').length }}"
            },
            {
              "id": "high-threats",
              "name": "highThreats",
              "type": "number",
              "value": "={{ $input.all().filter(item => item.json.threatLevel === 'High').length }}"
            },
            {
              "id": "medium-threats",
              "name": "mediumThreats",
              "type": "number",
              "value": "={{ $input.all().filter(item => item.json.threatLevel === 'Medium').length }}"
            },
            {
              "id": "low-threats",
              "name": "lowThreats",
              "type": "number",
              "value": "={{ $input.all().filter(item => item.json.threatLevel === 'Low').length }}"
            },
            {
              "id": "avg-score",
              "name": "avgCompetitiveScore",
              "type": "string",
              "value": "={{ ($input.all().reduce((sum, item) => sum + (item.json.competitiveScore || 0), 0) / $input.all().length).toFixed(1) }}"
            },
            {
              "id": "market-summary",
              "name": "marketPositionSummary",
              "type": "string",
              "value": "📊 Competitive Landscape Summary\n\n{{ $('Calculate Market Position').item.json.totalCompetitors }} competitors monitored:\n• 🚨 {{ $('Calculate Market Position').item.json.criticalThreats }} Critical Threats\n• ⚠️ {{ $('Calculate Market Position').item.json.highThreats }} High Threats\n• 📋 {{ $('Calculate Market Position').item.json.mediumThreats }} Medium Threats\n• ✅ {{ $('Calculate Market Position').item.json.lowThreats }} Low Threats\n\nAvg Competitive Pressure: {{ $('Calculate Market Position').item.json.avgCompetitiveScore }}/100"
            }
          ]
        }
      },
      "typeVersion": 3.3
    },
    {
      "id": "b3a3e3fc-690b-45d3-8cd1-b12ed23a3bdd",
      "name": "스티커 메모",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1712,
        16
      ],
      "parameters": {
        "width": 500,
        "height": 620,
        "content": "# 🎯 Affiliate Competitor Intelligence System\n\nAutomatically monitors competitor affiliate programs using Bright Data web scraping API, analyzes commission rates, cookie durations, and payout terms, then alerts your team about competitive threats requiring immediate action.\n\n**AI Analysis:** Compares commission rates, cookie windows, AOV, EPC, and identifies critical competitive advantages/disadvantages.\n\n**Setup:**\n- Get Bright Data API credentials\n- Configure HTTP Request with your dataset ID\n- Add competitor URLs to monitor\n- Link Google Sheets for tracking\n- Configure Slack channels for alerts\n- Set up SMTP for email reports\n\n**Benefits:**\n- Never lose affiliates to better offers\n- Respond to competitive changes in 48hrs\n- Data-driven commission strategy\n- Automated market intelligence\n\n*Built by Daniel Shashko*\n[Connect on LinkedIn](https://www.linkedin.com/in/daniel-shashko/)"
      },
      "typeVersion": 1
    },
    {
      "id": "c7e8b8eb-c11d-40a0-b430-62fe3789f570",
      "name": "스티커 메모1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1152,
        128
      ],
      "parameters": {
        "width": 160,
        "height": 80,
        "content": "Runs twice daily to monitor competitor offers automatically\n"
      },
      "typeVersion": 1
    },
    {
      "id": "cce67763-13cb-4f69-b421-a5415295a209",
      "name": "스티커 메모2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -928,
        112
      ],
      "parameters": {
        "width": 160,
        "height": 96,
        "content": "Uses Bright Data API to scrape competitor affiliate pages\n"
      },
      "typeVersion": 1
    },
    {
      "id": "5253eb5b-dc0f-416a-9bc7-713cd0550e94",
      "name": "스티커 메모3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        96
      ],
      "parameters": {
        "width": 160,
        "height": 112,
        "content": "Analyzes competitor offers and identifies threats to your program"
      },
      "typeVersion": 1
    },
    {
      "id": "d4b6d5b3-f3f1-442e-8789-3894d4e9b30e",
      "name": "스티커 메모4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -480,
        112
      ],
      "parameters": {
        "width": 160,
        "height": 96,
        "content": "Separates critical threats from routine competitive intelligence\n"
      },
      "typeVersion": 1
    },
    {
      "id": "58925f96-eff2-4e33-9944-926998e3ce32",
      "name": "스티커 메모5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -256,
        -224
      ],
      "parameters": {
        "width": 160,
        "height": 96,
        "content": "Immediate alert for critical competitive threats needing action\n"
      },
      "typeVersion": 1
    },
    {
      "id": "56f697ff-864c-4ab8-8fb7-e0c1bbe37b7f",
      "name": "스티커 메모6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -416,
        432
      ],
      "parameters": {
        "width": 160,
        "height": 80,
        "content": "Maintains historical record for trend analysis over time\n"
      },
      "typeVersion": 1
    },
    {
      "id": "92ae294d-6fa9-4d8a-89ac-68b47829cfca",
      "name": "스티커 메모7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -32,
        -96
      ],
      "parameters": {
        "width": 160,
        "height": 112,
        "content": "Records all competitive intelligence to centralized tracking sheet\n"
      },
      "typeVersion": 1
    },
    {
      "id": "19deffee-57e4-4620-aa63-ba21d512dfb3",
      "name": "스티커 메모8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        96
      ],
      "parameters": {
        "width": 160,
        "height": 112,
        "content": "Creates detailed competitive intelligence reports for email distribution\n"
      },
      "typeVersion": 1
    },
    {
      "id": "3ebb136f-3b88-4802-9881-a90a838aa4f4",
      "name": "스티커 메모9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -32,
        400
      ],
      "parameters": {
        "width": 160,
        "height": 128,
        "content": "Sends comprehensive competitive analysis reports to affiliate management team"
      },
      "typeVersion": 1
    },
    {
      "id": "87a2d559-c25e-4805-9dd5-21610455e1e3",
      "name": "스티커 메모10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -416,
        624
      ],
      "parameters": {
        "width": 160,
        "height": 96,
        "content": "Regular updates for medium/low threats requiring ongoing monitoring\n"
      },
      "typeVersion": 1
    },
    {
      "id": "7b74ac47-dde6-4568-a675-560cfc39f4bc",
      "name": "스티커 메모11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        208,
        0
      ],
      "parameters": {
        "width": 160,
        "height": 112,
        "content": "Aggregates competitive intelligence into market position summary metrics\n"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "95e9a310-42f7-4791-ba94-524632e63473": {
      "main": [
        [
          {
            "node": "e97dc192-289e-4e33-b2fc-16f50cdd276a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b7ae2883-2bf2-437a-9da2-fea3d99f2259": {
      "main": [
        [
          {
            "node": "f0bde90a-49ea-4493-bb42-60664086ef84",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e97dc192-289e-4e33-b2fc-16f50cdd276a": {
      "main": [
        [
          {
            "node": "433b0b95-e1e6-4dc9-b5ae-6ba579f3c7f0",
            "type": "main",
            "index": 0
          },
          {
            "node": "46260c58-cdff-4bcb-991d-62d09b53e360",
            "type": "main",
            "index": 0
          },
          {
            "node": "e7b22a6c-09b8-44cc-b92d-fde97f43b72f",
            "type": "main",
            "index": 0
          },
          {
            "node": "f4d4bf7d-11ce-4b9a-bf50-fd685fe2a97d",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "433b0b95-e1e6-4dc9-b5ae-6ba579f3c7f0",
            "type": "main",
            "index": 0
          },
          {
            "node": "46260c58-cdff-4bcb-991d-62d09b53e360",
            "type": "main",
            "index": 0
          },
          {
            "node": "747e1f46-51f9-45f5-872f-5ee4d2132d77",
            "type": "main",
            "index": 0
          },
          {
            "node": "f4d4bf7d-11ce-4b9a-bf50-fd685fe2a97d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3d6e51b2-80ab-4781-8783-50a6f43487d5": {
      "main": [
        [
          {
            "node": "95e9a310-42f7-4791-ba94-524632e63473",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f4d4bf7d-11ce-4b9a-bf50-fd685fe2a97d": {
      "main": [
        [
          {
            "node": "b7ae2883-2bf2-437a-9da2-fea3d99f2259",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1db8cf8c-ac58-46a4-9222-6306c71c3368": {
      "main": [
        [
          {
            "node": "3d6e51b2-80ab-4781-8783-50a6f43487d5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "433b0b95-e1e6-4dc9-b5ae-6ba579f3c7f0": {
      "main": [
        [
          {
            "node": "f0bde90a-49ea-4493-bb42-60664086ef84",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}