Automasi Attribution dan Lead Engine

# Project Brief: Multi-Channel Marketing Attribution & Automated Lead Engine

IMPORTANT NOTES: I'm looking for freelancer/ specialist who speaks Bahasa Indonesia

## 1. Objective
Build an automated data pipeline, lead deduplication engine, lead scoring, multi-touch journey tracker, and WhatsApp notification workflow using self-hosted n8n, an AI Agent node, a relational database (Google BigQuery or Supabase), and Looker Studio.

## 2. Key Scope & Deliverables

1. Ad Data Ingestion Pipeline (Bypassing Supermetrics):
- Configure scheduled n8n workflows pulling spend, impressions, clicks, CPM, and CTR directly via platform REST APIs (Meta Insights, TikTok Marketing, LinkedIn Ads, YouTube Data API).

2. AI Schema Standardization & Lead Scoring:
- Implement an LLM API node (OpenAI/Claude) in n8n to unify ad metrics into a single database schema and parse UTM parameters.
- Configure lead scoring rules to grade lead quality (Hot/Warm/Cold) based on platform origin, ad set metadata, and form values.

3. Phone & Email Deduplication + Smart Rotator:
- On incoming lead submission (formulir.id / web form):
- Query database by `phone_number` and `email`.
- IF lead exists: Route to existing assigned sales rep.
- IF new lead: Assign to sales reps via weighted round-robin based on lead score.

4. Multi-Touch Journey Logging:
- Design an event-based database schema tracking interactions over time (e.g., Nov 2026 IG ad -> Jan 2027 WA outreach -> Feb 2027 LinkedIn purchase) to calculate true CPL, CPLPV, CPP, and ROAS.

5. WhatsApp Messaging Integration:
- Build outbound HTTP API triggers connecting n8n to Mekari Qontak API or self-hosted WAHA (WhatsApp HTTP API) for immediate auto-replies and automated broadcast sequences.

6. Visualization Dashboard:
- Connect BigQuery/Supabase to Google Looker Studio displaying unified top-of-funnel and bottom-of-funnel performance.

## 3. Required Technical Stack
- Orchestration: Self-hosted n8n (Docker container on VPS)
- AI Node: OpenAI GPT-4o / Anthropic API
- Database: Google BigQuery or Supabase
- Dashboard: Google Looker Studio
- WhatsApp API: Mekari Qontak Open API / WAHA (WhatsApp HTTP API)