Bulk file reviewReview & Optimization

Amazon Sponsored Products bulk file review: bids, waste and a change list

Delivery from 2 daysRevisions includedQuality check
Packages
Payment protectionDetails
  • Revisions within the package are free.
  • If you do not respond within 3 days of delivery, the work is accepted automatically.
Order · $39

The money is reserved when you pay and released only once you accept the work.

Amazon Sponsored Products bulk file review: bids, waste and a change list

Example result

Example for the Standard package

Ad report review: an online plant pot shop on Google Ads

Where the budget went without sales

Search termsClicksCostSalesWhy
Care questions ("how to repot…", 37 terms)412$2860People looking for tips, not pots
"terracotta pots wholesale", "bulk planters"58$940The shop sells retail only
"free plants", "plant swap"96$710No buying intent
"plant stand ideas", "diy planter"74$480Ideas and crafts
Other shops' names (14 terms)133$1621Broad match on "pots"
Total773$661131% of spend

Negatives to add

The "Negatives" sheet has 38 words with match types, ready to paste. The main ones: "how to" (phrase), "wholesale" and "bulk" (broad), "free plants" (phrase), "ideas" (phrase), "diy" (broad), and the 14 shop names (exact).

Not added: "free" on its own, because "free shipping plant pots" brought 9 sales.

Ads to rewrite

Self-watering pots: click rate 1.9% against 4.6% for the account; the headlines say "Shop Now" and never mention self-watering.

New headlineCharacters
Self-Watering Pots, 12 Sizes28
Water Your Plants Once a Week29
New descriptionCharacters
Self-watering pots with a hidden water tank. Free shipping over $60, delivery in 3 days.88

Large floor planters: the ad sends people to the home page. Point it to the planters category instead.

Changes by priority

#ChangeWhy
1Add the 38 negatives from the sheet$661 a month went to these terms
2Lower bids by 30% on "plant stand" keywords$214 spent, 2 sales, return 0.9
3Raise bids by 15% on "large self-watering pot"Return 6.2; 40% of impressions lost to budget
4Replace the two ads aboveWeakest click rates in the account
5Move terracotta keywords to their own ad groupThey share an ad with plastic pots
6Check the search terms again in 14 daysTo see the effect of steps 1–3

These are recommendations: you decide what to apply and make the changes in your account. Files: review.docx and changes.xlsx (Negatives, Keywords to add, New ads, Change list).

Client: Pebble & Fern, an online shop selling plant pots and supplies. Reports: search terms (612 rows) and keywords (148 rows) for the last 30 days. Spend: $2,140, 41 sales, return on ad spend 2.1; the goal is 3.0. Standard package.

The client and all details are made up.

About this service

You download the Sponsored Products bulk file for a recent period and upload it; we read the campaign, ad group, keyword and product targeting rows with their spend, sales, ACoS and bids, and find where money goes without orders. We look for keywords duplicated across campaigns, bids far above what your margin can carry, ad groups with no spend at all and auto campaigns without negatives. The change list uses the same bulk-file columns with Operation set to Update, so after checking it you can upload it yourself or apply the changes by hand.

What is included

  • What you getAn Excel change list in bulk-file columns with new bids, pauses and negatives, and a Word summary of the biggest leaks and the reason for each change. You review every row before uploading it yourself.
  • Bid checkBids compared with what your margin allows
  • Duplicate targetsThe same keyword bidding against itself in several campaigns
  • Zero-sale targetsKeywords and ASINs with spend and no orders
  • Change rowsUpdate rows in bulk-file columns
  • Leak summaryWhere the budget goes, ranked by amount

How it works

  1. 1
    DownloadYou export the bulk file for 30 or 60 days
  2. 2
    ReviewWe check every target against your margin
  3. 3
    Change listYou check the rows and upload them yourself

What we need from you

The bulk file as Excel (.xlsx), the date range you chose when downloading it, your margin per product and your target ACoS.

We will ask you:

  • Which date range did you pick when downloading the bulk file?
  • What is the margin for each product, or for the account on average?
  • Which campaigns should we leave untouched?

Compare packages

PackagesBasic1 file, up to 400 rows$19StandardUp to 3 files, 1,000 rows in total$39PremiumUp to 5 files, 1,500 rows in total$69
Deadline2 days3 days4 days
Revisions123
Files or reports1up to 3up to 5
Rows in totalup to 400up to 1,000up to 1,500
Changestop 10 by priorityfull list with bidsfull list and structure
Order BasicOrder StandardOrder Premium

Payment protection

You pay when you order, but the money is released only for accepted work.

  • Fixed priceThe package price does not change after you pay.
  • The money is reservedWhen you pay, the amount is only reserved. It is released to the service once you accept the work.
  • Checked before deliveryEvery result goes through a quality check before it reaches you, and you see it on the order page before accepting it.
  • Free revisionsAsk for changes within your brief as many times as the package allows.
  • Acceptance after 3 daysIf within 3 days of delivery you neither accept the work nor ask for changes, it is accepted automatically. If you write in the order chat after delivery, the order waits; once we answer, we may start the 3 days again and will say so in the chat.
  • Redo or a full refundIf the result does not match your brief and the revisions did not fix it, or the work takes more than twice its deadline, write in the order chat: we will redo the work or refund the payment in full.
How it works →

Questions and answers

Can I upload your change list straight to Amazon?

It uses the bulk-file columns, so you can after checking each row. We cannot promise Amazon accepts every row, for example if a campaign changed after your download; Amazon's upload report shows any errors.

Which sheets of the bulk file do you read?

The Sponsored Products campaigns sheet, and the search term sheet if your download includes it. Sponsored Brands and Display sheets can be reviewed too if they fit the row limit.

Do you change anything in my account?

No. We never log in; the decisions and the upload are yours.

Packages
Order · $39· 3 days