ghuman.online · Marketing Analytics & Neo4j

Full-funnel marketing analytics with Cypher, Power BI, and a graph-native geo layer.

This portal replaces the restaurant landing page with the new analytics case study: Neo4j-backed KPIs, BI storytelling, and geospatial targeting. It is built for LinkedIn, clients, and recruiters to explore the project live on ghuman.online.

View repo (Neo4j + BI)Connection details

Project pillars

Cypher-first analytics

ROAS, LTV, and uplift computed in Neo4j with channel, cohort, and experiment dimensions.

Geo intelligence

GeoCell catchments and cannibalization overlays mapped to stores and campaigns.

Influence graph

Referrals and communities surfaced with graph algorithms for advocacy targeting.

BI storytelling

Power BI pages for performance, cohorts, geo, experiments, and influence.

Cypher analytics

Saved queries cover ROAS, CAC, CTR/CVR, cohorts, LTV, churn, uplift tests, referral influence, geo catchments, and cannibalization. Exports feed Power BI and the map overlays.

// Channel performance and ROAS
MATCH (camp:Campaign)-[:USES]->(ch:Channel)
OPTIONAL MATCH (cust:Customer)-[o:ORDERED]->(ord:Order)-[:FROM]->(camp)
WITH ch.name AS channel, camp.name AS campaign,
     sum(o.spend) AS spend, sum(ord.value) AS revenue
RETURN channel, campaign, spend, revenue,
       CASE WHEN spend = 0 THEN 0 ELSE revenue / spend END AS roas
ORDER BY roas DESC

Data flow

Ingest

Python ETL loads CSVs to Neo4j (customers, campaigns, impressions, clicks, orders, stores, GeoCells).

Model

Constraints + projections; derive NEAR, LOCATED_IN, REFERRED, and ABTest variant relationships.

Analyze

Cypher/graph algorithms for ROAS, LTV, churn, influence, and cannibalization heatmaps.

Serve

Exported tables to Power BI and GeoJSON overlays surfaced through the Next.js Insights Portal.

Deliverables for ghuman.online

Neo4j dataset + Cypher views
Saved queries for ROAS, cohorts, churn, uplift, influence.
Power BI report
Embed-ready PBIX + PDF export for LinkedIn and ghuman.online.
Insights Portal
Next.js page hosting the story, embeds, and geo overlays.
Automation
Python loader scripts + test harness for Neo4j connection.
Power BI embeds and map tiles are placeholders until the Neo4j exports are pushed. Replace the repo link above with the new Git URL once published.

Neo4j connection

Set environment variables in .env.local and run npm run test:neo4j to validate the Aura/Neo4j connection.

NEO4J_URI=bolt+s://YOUR_URI
NEO4J_USERNAME=neo4j
NEO4J_PASSWORD=your_password
NEO4J_DATABASE=neo4j

The shared driver utility (src/lib/neo4j.ts) is ready for API routes or server components to execute Cypher and stream results into the portal.