Breaking Games logoBreaking Games Externship via Extern·🟢 Open to work

Jiwan Gurung

**Marketing Graduate | Aspiring Data Analyst | SQL • Python • Tableau • Excel**

Work samples

  • Breaking Games E-Commerce Data Analysis & Strategy Externship
    Breaking Games E-Commerce Data Analysis & Strategy Externship
    Breaking Games logo

    Breaking Games · ✅ Verified by Extern · ⏱️ In progress

    Breaking Games E-Commerce Data Analysis & Strategy Externship

    A Breaking Games externship on e-commerce analytics and conversion strategy, using real marketing and sales data to analyse customer behaviour and purchase funnels.

    Data AnalysisDigital MarketingSalesPresentation Skills

About me

**Marketing Graduate | Aspiring Data Analyst | SQL • Python • Tableau • Excel**

I’m a Marketing graduate with 4+ years of experience in data management, reporting, compliance, and business administration. I have practical skills in SQL, Python, Tableau, and Excel, and I enjoy exploring data, identifying trends, solving business problems, and turning insights into actionable recommendations. I’m looking to gain hands-on experience through real-world projects and develop my career in data analytics.

Externships

Breaking Games E-Commerce Data Analysis & Strategy Externship

In progress

Education

University of Winchester

B.A. Marketing · Class of 2020

Skills

PythonSQLTableauExcelGoogle Sheets

✅ Verified by Extern · ⏱️ In progress

Breaking Games E-Commerce Data Analysis & Strategy Externship

A Breaking Games externship on e-commerce analytics and conversion strategy, using real marketing and sales data to analyse customer behaviour and purchase funnels.

Data AnalysisDigital MarketingSalesPresentation Skills

Overview

The externship analysed marketing and sales datasets from Google Analytics, Meta Ads, and Shopify to trace the online customer journey and identify conversion points. The work mapped user flows, examined funnel stages, and connected traffic sources to purchase outcomes. Deliverables documented where shoppers dropped off and how different channels contributed to sales.

Breaking Games E-Commerce Data Analysis & Strategy Externship

What I've accomplished

I produced a stage-by-stage funnel spreadsheet that recorded user actions, channels, feelings, and which touchpoints supported awareness, consideration, and conversion.

Project breakdown

During my BA I mapped my awareness, consideration and conversion steps for enrolling in the paid certificate. I recorded actions (search, YouTube reviews), feelings, and which touchpoints worked, producing a stage-by-stage funnel spreadsheet.

Google Sheets
Access

The work examined raw referral and ad exports, filtered and ran formulas to compute conversion, bounce and added-to-cart rates, and produced a sheet with charts. It reported top referral sources, campaign reach and clicks and per-source conversion figures.

Google Sheets
Access

I reviewed GA4 exports, compared behaviour of paid-search and direct visitors, and wrote a narrative comparing two visitor journeys. I reported that ad-driven visitors showed higher engagement and conversion intent than returning direct visitors.

Google Docs
Access

I reviewed campaign-level Google and Meta data, compared CTR, CPC, CPA and ROAS, and identified which campaigns drove purchases versus traffic. I recommended reallocating spend toward higher-efficiency Google purchase campaigns while keeping Meta for upper-funnel reach.

Google Docs
Access

The brief asked to organize Shopify exports. I structured Google Sheets with Customer Types, Orders & Checkouts, and Products sheets, noted that customer volume fell by over half, 94% of buyers were one-time purchasers, unpaid/unfulfilled orders existed, and highlighted top-selling SKUs.

View all work