Built the AI-traffic measurement layer on my own site: correct GA4 capture of ChatGPT/Perplexity ...Built the AI-traffic measurement layer on my own site: correct GA4 capture of ChatGPT/Perplexity ...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Built the AI-traffic measurement layer on my own site: correct GA4 capture of ChatGPT/Perplexity referrals, LLM crawler segmentation (GPTBot, OAI-SearchBot, PerplexityBot) and a BigQuery attribution pipeline connecting cited prompts to sessions. The exact method I deploy for clients.
30-sec UGC ad for VELORA, a fictional shampoo brand, from concept to visuals, including the model, product design, scenes, dialogue, and final commercial direction.
Prompt in the comments.
What do you think?
Really impressive and I like it as you maintained the character's location as her home as opposed to the regular shampoo commercials where they are shown with paparazzi in an awards event or something like that.
Niva is a premium Framer template built for AI automation agencies, consultants, and AI-driven service businesses who want a website that actually converts — not just looks good in a screenshot.
Most templates in this category default to the same cyan-and-glow "tech startup" aesthetic. Niva takes a different approach: a warm, rose-gold accent on a deep charcoal base, paired with refined typography and generous spacing — designed to signal maturity and trust to enterprise buyers, not just early-stage hype.
What's inside:
— 13+ fully designed pages, including Home, About, Services, Case Studies, Blog, and Contact
— CMS-ready case study and blog collections
— Conversion-focused structure: clear funnel from problem → solution → proof → pricing → CTA
— Custom 3D iconography in a cohesive rose-gold material system
— Built-in accessibility (WCAG 2.1 AA) and performance optimization
Whether you're running an AI agency, automation consultancy, or AI strategy practice, Niva gives you a site that positions you as the premium option in a crowded, hype-driven category.
Interested in a custom version for your agency? Let's talk — DMs open.
Finding the right job often requires manually comparing a resume against dozens of job descriptions.
This project automates that process by:
Analyzing a resume against multiple real job postings
Generating AI-powered match scores
Identifying missing skills
Providing resume improvement suggestions
Storing results in a SQL database
Visualizing insights in Power BI
Offering a live Streamlit web application
🛠️ Tech Stack
Python
Pandas
SQLite
SQL
Google Gemini AI API
Streamlit
Power BI
VS Code
📊 Key Features
AI Resume Analysis
Resume-to-job match scoring (0–100%)
Missing skill identification
AI-generated recruiter feedback
Resume improvement recommendations
Database & SQL
Stores analyzed jobs in SQLite
Performs analytical queries
Identifies skill gaps
Finds best-fit companies and locations
Power BI Dashboard
Average Match Score
Strong Fit Jobs
Top Match Score
Company Match Analysis
Skill Gap Analysis
Streamlit Application
Paste any job description and instantly receive:
Match Score
Missing Skills
AI Feedback
Resume Improvement Tips
📈 Dashboard Insights
The dashboard provides:
Overall resume strength across jobs
Best matching companies
Skill gap analysis
Job fit distribution
Career improvement opportunities
🎯 Business Value
This project demonstrates:
Data Cleaning
Data Analysis
SQL Querying
AI Integration
Dashboard Development
Data Visualization
End-to-End Analytics Workflow
🔮 Future Improvements
Analyze 100+ job postings
Automated LinkedIn job ingestion
Multiple resume comparison
Industry-specific recommendations
Advanced skill trend tracking
👨💻 Author
Gourav Jangid
Aspiring Data Analyst passionate about transforming data into actionable insights using Analytics, SQL, Python, Power BI, and AI.