Marketplace reporting and brand reviews

Monthly reports, brand review decks and the checks behind them.

Screens are shared with my employer’s agreement. Real figures are hidden or replaced with made-up ones. Select an image for the full view.

Monthly ads, sales and order reports for four stores

2026 to present

Each month I report on four stores: CGI Store, ROG Store, ASUS Business and Honeywell. Browser tools I built download and check Shopee, Lazada and TikTok Shop reports, cutting manual reporting from about two days to two hours and leaving more time for analysis.

Each month I review results with the Honeywell brand team: compare ad sales with confirmed orders, score affiliate creators and identify wasted keyword spend, then suggest budget or campaign changes.

Honeywell June ads review page with spend, sales and ROAS figures hidden (opens larger view)
Honeywell’s June ads review, the page I take to the brand team. Figures are hidden.
Ads overview for four stores with sales, spend and ROAS; made-up figures (opens larger view)
All four stores’ ads on one page (made-up figures)
Ad results by store on Shopee and Lazada compared with last month; made-up figures (opens larger view)
Each store against last month
Income page with sales, fees, refunds and payouts across three marketplaces; made-up figures (opens larger view)
Sales, fees and payouts by marketplace
Monthly Shopee ads PDF report with daily spend and cancellation charts; figures hidden (opens larger view)
The monthly PDF report
Streamlit Shopee performance analyzer with figures hidden (opens larger view)
The older tool I took over and rebuilt

Python, Pandas, SQLite, Chrome extensions, Excel, PDF and PowerPoint reports

How it works

  • Browser tools download income and orders from Shopee, Lazada and TikTok Shop, and ads from Shopee and Lazada. Missed months can be queued for later download.
  • Files are checked for store and month; duplicate files are skipped. Staff approve each batch. Missing months remain gaps rather than zero sales.
  • Ads are compared by store, campaign, product and keyword using spend, sales, orders and ROAS (sales per RM1 of ad spend).
  • Income follows marketplace order dates, and each payout is matched to its orders.
  • For Honeywell, I also review affiliate, sample-request and Meta ads data, checking ad sales against confirmed orders.

Worked example: comparing ad returns month to month

ASUS monthly business review

May to Aug 2026

For four months I prepared and presented ASUS Business (ExpertBook) store reviews for Shopee and Lazada to the ASUS Business team. Each deck covered sales, the visit-to-order funnel, ad returns, vouchers, best sellers, what we missed and next month’s plan.

One data file kept the full deck, shorter meeting deck and web version on the same numbers.

ASUS May to June review deck, opening slide with figures hidden (opens larger view)
Opening slide of the May to June deck. Figures are hidden.
Shopee GMV Max ads slide with figures hidden (opens larger view)
Shopee GMV Max ads
Lazada product ads slide with figures hidden (opens larger view)
Lazada product ads

PowerPoint automation, PowerShell, Node, Excel

Back to the portfolioContact me