Uğur Kadir Karahan

Projects

Idea to production, one pair of hands.

At Merzigo I spot problems as a product manager and solve them myself as a developer. For each app below I own the whole process: the idea, the scope, the interface, the backend, the database and the server.

PM

As a Product Manager

  • I define the problem with the teams
  • I set the scope and priorities
  • I track usage and plan the next release
DEV

As a Developer

  • I write the interface and the API
  • I set up the database and integrations
  • I deploy and maintain it

Merzigo

Built for the company

These are internal tools, available only to Merzigo accounts. Images show their sign-in screens.

Reach — Brand partnership reporting

01 / 06·Internal tool

Reach

Brand partnership reporting

Brings brand partnership performance across YouTube, Facebook, Instagram, X and TikTok into a single report.

Problem
View data for brand campaigns was scattered across five platforms and hand-built spreadsheets. Every client report was a separate chore.
Solution
A panel where the team manages campaigns while data syncs from Google Sheets on a schedule. Clients see their campaign through a read-only link, no login required.
  • React
  • Vite
  • Node.js
  • Fastify
  • TypeScript
  • PostgreSQL
  • Google OAuth
  • Google Sheets API
  • Docker
GEO — YouTube region restriction analysis

02 / 06·Internal tool

GEO

YouTube region restriction analysis

Shows where a YouTube video can be watched on a world map and scans playlists for broken items.

Problem
Finding out where a video was blocked meant reading raw API responses one by one. Deleted or private videos sat unnoticed in playlists.
Solution
Paste a video link to see allowed and blocked countries on an interactive map, or scan a playlist for problem items. Results can be shared through a no-login link.
  • Next.js 15
  • React
  • TypeScript
  • YouTube Data API
  • react-simple-maps
  • Google OAuth
  • Docker
Target — Contract & revenue target tracking

03 / 06·Internal tool

Target

Contract & revenue target tracking

Compares partner contracts, minimum guarantees and channel targets against YouTube and Facebook earnings.

Problem
Partner contract targets and actual earnings lived in Excel files. Minimum guarantees, grace periods and multi-year contracts made the math error-prone.
Solution
A system for defining contracts, channels and targets, with daily revenue entered one by one or in bulk. The dashboard shows each contract over its full term and per calendar year, with role- and company-based access.
  • React
  • Express
  • Prisma
  • PostgreSQL
  • Zod
  • JWT
  • Google OAuth
  • Docker
Policy — Content ID policy management

04 / 06·Internal tool

Policy

Content ID policy management

Tracks channels, videos and Content ID policies across YouTube CMS accounts and maps where each video is available.

Problem
Content ID policies could only be checked video by video in CMS. There was no way to see which company's videos were blocked in which countries at a glance.
Solution
A panel that connects CMS accounts through Google and syncs channels and new videos automatically. Policies can be changed one by one or in bulk, reports export to Excel, and access tokens are stored encrypted.
  • React
  • D3
  • Express
  • Prisma
  • PostgreSQL
  • YouTube Content ID API
  • Google OAuth
  • Docker
GIF Creator — AI-assisted GIF creation

05 / 06·Internal tool

GIF Creator

AI-assisted GIF creation

Finds the best moments in a video with AI, adds text and emoji and turns them into GIFs.

Problem
Making a GIF for social media meant scrubbing through a whole video for the right moment and cutting it by hand in an editor.
Solution
Upload a video and an analysis service suggests the best moments based on facial expression and image quality. Pick moments manually if you prefer; add text and emoji and the GIF is ready in minutes.
  • React
  • Vite
  • .NET 8
  • Python
  • ffmpeg
  • PostgreSQL
  • OpenAI API
  • Docker
Rights — Content ID rights & dispute tracking

06 / 06·Internal tool

Rights

Content ID rights & dispute tracking

Tracks Content ID assets, claims and estimated revenue per company, and gathers dispute decisions into a single queue.

Problem
Claims, disputes and the revenue tied to them were scattered across CMS screens and email. Keeping track of which dispute was still pending was hard.
Solution
A panel that connects CMS accounts and shows assets, claims and estimated revenue per company. Dispute decisions go into an operations queue, and related emails land in the panel through a Gmail integration.
  • React
  • TypeScript
  • Vite
  • Express
  • Prisma
  • PostgreSQL
  • YouTube Content ID API
  • YouTube Reporting API
  • Gmail API
  • Docker

Freelance

I build outside the company, too.

I take early-stage product ideas from concept to launch for clients. Projects will appear here as they go live.

Have an idea? Get in touch