The Problem
The Problem
Marketing and commercial data needed to be connected so lead acquisition, campaign source and funnel outcomes could be analyzed together.
What I Built
What I Built
I built an API-based CRM pipeline orchestrated with n8n, identified campaign / lead-source context, transformed the data, centralized it in BigQuery and connected the analytical layer to Looker Studio.
- CRM integration through REST APIs
- Campaign / lead-source identification
- Automated extraction and transformation with n8n
- Structured data in BigQuery
- Data analysis and Looker Studio visualization
Architecture
Sanitized public system flow
Public Architecture / Generic Labels
Marketing Campaign / Lead SourceSystem flow
CRMSystem flow
REST APISystem flow
n8nSystem flow
Clean & TransformSystem flow
BigQuerySystem flow
Marketing Campaign / Lead Source→CRM→REST API→n8n→Clean & Transform→BigQuery→Data Analysis→Looker Studio→Insights & Decisions
This public diagram is intentionally abstracted and does not expose client names, private endpoints, internal IDs or operational data.
Technologies
Technologies used
REST APIn8nBigQueryLooker StudioCRM
Value / Outcome
Capability created
The system makes acquisition and commercial funnel data analyzable together, reducing dependence on manual CRM data pulls and creating a clearer path from marketing source to business decision.