Sample build. Text in [brackets] is a placeholder Bert fills in before going live. Case-study numbers are real but anonymized (no brand names or ASINs).

Amazon PPC & Listing Optimization Specialist

Grow your Amazon sales without letting ad spend eat your margin.

I manage Sponsored Products, Brands and Display, and I use the same Brand Analytics data to tune your listings. Your ads and your listing work toward the same keywords. You get clear weekly reporting and one person who owns the channel.

  • 3+ yearsrunning Amazon Ads for US brands
  • 2 flagship brandsat $500K–$860K/month in sales each
  • 12–14% TACoSheld on those accounts
  • Amazon AdsSponsored Ads & Foundations certified
Tools I work in every day
  • Seller Central
  • Vendor Central
  • Amazon Ads Console
  • Brand Analytics (SQP)
  • Amazon Marketing Cloud
  • Helium 10
  • DataDive
  • Pacvue
  • Perpetua

Services

Everything your Amazon channel needs, handled by one specialist

Start with one service or hand me the whole channel. Every engagement comes with weekly check-ins and clear next steps.

📈

PPC management

Sponsored Products, Brands and Display, set up and managed to a clear TACoS or ACoS goal.

  • Target-level bid control, not blunt budget cuts
  • Keyword harvesting, negation and SKAG structure
  • Hero-ASIN keyword mapping and bulk-sheet optimization
  • AMC insights and custom audiences where they fit
🔎

Listing optimization

Titles, bullets and backend search terms rewritten from real search data instead of guesses.

  • Brand Analytics: Search Query Performance and Top Search Terms
  • Reverse-ASIN research on your top competitors
  • Keyword gap map: where you're seen vs. where you convert
  • Organic rank checks after each change
🧾

Account & PPC audits

A full review of what's working, what's wasting money, and what to fix first.

  • Business Report by child ASIN plus all ad reports
  • Wasted spend, cannibalization and structure issues
  • Products grouped your way (by SKU, ASIN, title or keyword)
  • Prioritized action plan you can keep
🩺

Account health & monitoring

Problems caught early, before they show up in your monthly sales.

  • Daily sales, spend and TACoS tracking with alerts
  • Listing health: suppressions and unwanted catalog changes
  • Review root-cause analysis (packaging, product, directions)
  • Weekly reports and monthly reviews

How I work

A simple process with no surprises

  1. 1

    Audit

    I pull your Business Report and ad reports and review structure, wasted spend, listing gaps and account health. You get a short written plan, ranked by impact.

    Week 1
  2. 2

    Plan & restructure

    We agree on one goal, usually a TACoS target. I group your products the way your business thinks about them and clean up campaign structure and naming.

    Week 1–2
  3. 3

    Launch & optimize

    New campaigns built from harvested keywords and launched through bulk files, with nothing launched twice. Bids are managed at the target level. When a target's spend passes 60% of the product price with no sale, it gets paused.

    Ongoing
  4. 4

    Report & refine

    A weekly check-in with what changed, why, and what's next, plus a monthly report against target. Listing updates follow the search data.

    Weekly / monthly

Tools I've built

Repeatable systems, so the work is faster and has fewer mistakes

I build my own Excel, VBA and Python tools for audits, launches and monitoring. Clients get consistent, checkable work instead of one-off spreadsheets.

Excel · VBA

Account Overview Audit

A full-account audit workbook built around configurable product groups. Groups are defined by rules on SKU, ASIN, title, campaign or keyword (contains, starts with, exact or wildcard), and the first match wins. That lets every client's catalog be grouped the way that brand thinks about it.

  • Ad-restriction checks, e.g. "this product line may only run in the catch-all campaign"
  • Performance rolled up by product group across all ad reports
  • Flags for ungrouped products and rules that match nothing
Excel 365 · VBA

Campaign Creation Tool

It takes the account's Sponsored Products bulk export and keyword research (Cerebro, Search Query Performance or Search Term reports). It sorts candidates into Broad, Phrase, Exact and "Gold Panning" lists using volume, purchase and spend floors. Anything already live for that ASIN is skipped.

  • One click writes Amazon bulk-upload Create rows: campaign, ad group, ads, targets, negatives
  • A launch log means no ASIN and keyword pair is launched twice
  • Blocks itself until the input checks pass
Python · Excel

Listing Keyword Harvest

A Helium 10 Cerebro-style keyword workbook built from Brand Analytics: Search Query Performance, Top Search Terms and top-clicked-product data. It finds the top 10 competitor ASINs and ranks keywords by relevance and purchase share.

  • Keyword map: title, bullets and backend search terms
  • Relevance filter, plus lists of negatives and competitor brands
  • Output feeds straight into the Campaign Creation Tool
Web app

Client Monitor

A fast browser dashboard covering every account I manage: sales, ad spend, ACoS, TACoS and ROAS against each brand's targets, budget pacing, an ASIN table and automatic alerts. Built to replace a slow 30 MB monitoring spreadsheet.

Results

Real numbers from accounts I've managed

Brand names, products and ASINs are removed and figures are rounded. Most of these were agency engagements at My Amazon Guy: I managed the PPC as part of a team, so the results belong to that team too. Each before/after compares the same kind of 30-day ad window taken from the account's own exports. Seasonality isn't adjusted for, so I note where a sales event falls inside a window.

4,000+advertised ASINs in one catalog
~4,900ASINs managed at the same time
8,900+campaigns in a single account
~$2Mpeak month of sales on one account (Q4)
$500K+peak monthly ad spend on one account
6marketplaces: US, CA, UK, DE, FR, IT
~45brands supported since 2023
Agency team · managed PPC

US orthopedic & medical-supplies seller · ~2,700 advertised ASINs · SP, SB, SD

More ad sales from the same budget

Period: the earliest 30-day backup on file (Mar–Apr 2025) vs. March 2026.

What changed in the files: the account went from about 700 to about 6,800 enabled campaigns, and negative targeting more than doubled. Spend stayed within 4%.

Where it landed: about $860K in total sales in March 2026 at a 14% TACoS.

28% → 21%ACoS
+37%ad sales (spend +4%)
−22%cost per click
Agency team · managed PPC

US packaging-supplies brand · ~2,150 advertised ASINs · SP, SB, SD

Scaling ad sales faster than spend

Period: the earliest 30-day backup on file (Jun–Jul 2025, which included Prime Day) vs. March 2026.

What changed in the files: enabled campaigns were consolidated from about 1,370 to 625, and negative coverage roughly tripled.

Where it landed: April 2026 brought about $780K in total sales at a 20% ACoS and an 11.7% TACoS.

+58%ad sales (spend +22%)
26% → 20%ACoS
+56%ad orders
Agency team · managed PPC

US home-textiles brand · 4,000+ advertised ASINs · Q4 peak

Black Friday on a 4,000-ASIN catalog

Period: the 30 days before Nov 12 vs. the 30 days to Dec 4, 2024, covering Black Friday and Cyber Monday.

What happened: ad spend was scaled about 2.2x into the holiday peak, and ACoS stayed level instead of climbing. Most of the sales lift is seasonal. The point here is that efficiency held at that volume.

$0.9M → $2.1Mtotal sales, 30 days
40% → 39%ACoS at 2.2x spend
$1.5Mad sales in the peak window
Direct client · early results

US specialty food brand · 2 parent ASINs · Seller Central US

Rebuilding a small ad account: first 3 weeks

Period: the first 3 weeks (Sep 17 – Oct 7, 2026) vs. the 3 weeks before I took over.

What I did: rebuilt the campaigns from Brand Analytics and competitor keyword research and scaled spend from a very small base. A keyword-driven listing rewrite is in progress.

Honest caveat: TACoS rose from about 10% to 30% while spend was rebuilt. This is three weeks of data, not a finished result.

2.3xtotal sales
53% → 34%ACoS
4 → 65ad orders
Agency team · managed PPC

US appliance-parts seller · ~470 advertised ASINs · plus a Canada storefront

Cheaper clicks, steady ACoS

Period: a 30-day window to early Dec 2023 vs. one to early Aug 2024. Both windows include a sales event.

What changed in the files: negative targeting nearly doubled and clicks grew 76% at a lower CPC. On the Canada storefront, spend was cut by more than half and ACoS fell from 26% to 15%.

+22%ad sales (US)
−28%cost per click (US)
~16%ACoS held (US)
Agency team · managed PPC

US supplement brand · drink-mix powders · SP, SB

Bringing a high ACoS down while growing

Period: a 30-day window to early Mar 2026 vs. one to mid-Jul 2026.

What changed in the files: enabled campaigns grew from about 60 to about 260, and a negative-keyword layer was added where there had been none.

47% → 37%ACoS
+48%ad sales
+17%ad spend

All results at a glance

Account (anonymized)MarketWindows comparedAd spendAd salesACoSRole
Orthopedic & medical supplies, ~2,700 ASINsUSMar 2025 → Mar 2026+4%+37%28% → 21%Team
Packaging supplies, ~2,150 ASINsUSJul 2025 → Mar 2026+22%+58%26% → 20%Team
Home textiles, 4,000+ ASINs (Q4)USOct–Nov → Nov–Dec 20242.2x2.3x40% → 39%Team
Appliance parts, ~470 ASINsUSDec 2023 → Aug 2024+27%+22%16% → 17%Team
Appliance parts, ~340 ASINsCADec 2023 → Aug 2024−57%−25%26% → 15%Team
Baby gear, high-ticket, ~140 ASINsUSDec 2023 → Aug 2024−20%−12% (orders +7%)32% → 29%Team
Supplement drink mixesUSMar 2026 → Jul 2026+17%+48%47% → 37%Team
Odor-control productsUSJan 2025 → Nov 2025+31%+23% (orders +17%)39% → 41%Team
Specialty food, 2 parent ASINsUS3 weeks → 3 weeks, 20267x (from ~$56)11x53% → 34%Direct · early
Luxury accessories, ~80–120 ASINs per marketUK, DE, FR, IT, US2024Scope only: five marketplaces run in parallel, 75–140 enabled campaigns eachTeam

Ad metrics are Amazon's click-attributed figures from 30-day bulk exports. Total sales and TACoS come from Business Reports where those were available. Figures are rounded and nothing here is extrapolated. Most of these accounts were agency engagements, so the results are shared with the team.

Photo placeholder for Bert Quilay

About me

Hi, I'm Bert.

I'm an Amazon PPC and listing optimization specialist based in Pampanga, Philippines, and I work US Eastern Time hours. For 3+ years I've run Sponsored Products, Sponsored Brands and Sponsored Display for US brands.

As Advertising Specialist 3 at My Amazon Guy (since June 2023), I manage around 5 of the agency's largest accounts. Two of them are flagship brands doing $500K–$860K a month in sales each, run at about 12–14% TACoS. I earned those after running up to 20 smaller accounts at once. I also work with Amazon Marketing Cloud (AMC) audiences, Vendor Central, and EU/UK marketplaces.

On my own, I work directly with brand owners on PPC audits, turnarounds and listing optimization. I'm the person doing the work and the person you talk to.

3+ yrsAmazon Ads
~5large agency accounts managed
Up to 20accounts run at once
US · EU/UKmarketplaces

Certifications & training

Certified by Amazon Ads

Amazon Ads

Sponsored Ads Certification

Amazon Ads Academy · Aug 2025, valid to Aug 2027

Amazon Ads

Amazon Ads Foundations

Amazon Ads Academy · Aug 2025, valid to Aug 2027

AMC

Amazon Marketing Cloud for Custom Audience Building

MAG School · Jun 2026

Training

MAG School

PPC, SEO, Catalog, Amazon DSP, Customer Service, Retention, MAGi Essentials

Also: Amazon PPC+ (Sandbox VA) · Amazon Seller VA Masterclass (AmazoNation PH) · Udemy Must-Have VA Skills · MBA in a Box

Testimonials

What clients say

[Client testimonial goes here: one or two sentences on results and working together.]
[Name][Title, brand or category]
[Client testimonial goes here: one or two sentences on results and working together.]
[Name][Title, brand or category]
[Client testimonial goes here: one or two sentences on results and working together.]
[Name][Title, brand or category]

FAQ

Common questions

What access do you need?

For an audit, report exports are enough: Business Report by child ASIN and your Sponsored Ads reports. For ongoing management, you add me as a user in Seller Central and Amazon Ads with only the permissions the work needs. Optionally, you can connect your account to my monitoring portal through Amazon's official authorization.

Do you only do PPC?

No. PPC and listings work best together, so I use the same Brand Analytics search data for both campaigns and titles, bullets and backend search terms.

How do you report?

A weekly check-in with the numbers, what changed and what's next, plus a monthly review against your target. You can also see your account in the client portal at any time.

What hours do you work?

I'm in the Philippines and available during US Eastern Time business hours.

Let's talk

Get a free 20-minute account review

Tell me about your brand and your goal. I'll look at your account and come back with the top three things I'd fix first. There's no obligation.

Book a call [Calendly link]

Opens your email app with the message filled in. [Can be switched to Netlify Forms or Formspree when hosted.]