Sponsored Products
Automate your Sponsored Products campaign reports. Track performance by campaign, ad group, keyword, and ASIN. Pull clicks, spend, sales, impressions, and calculate ACOS automatically.
Connect Amazon Ads to Google Sheets, Instantly
Stop downloading CSVs. Automate your Amazon Advertising reports directly in Google Sheets.
Trusted every day by modern Amazon teams
Why Google Sheets for Amazon Ads
Track campaigns, optimize spend, and build custom ROAS dashboards—no code required.
Without Hopted
Manual Data Drains Your Day
Every day, you log into Amazon Seller Central, navigate the clunky Advertising Console, and manually download 5, 10, or 20 different reports. You copy-paste CSV data, fight with VLOOKUP, and pray the numbers are correct. By the time your report is done, it's already out of date.
With Hopted
Fresh Amazon Ads data, on your schedule
Hopted connects directly to the Amazon Advertising API and your Google Sheets account. Set your schedule once—daily, hourly, or on-demand—and Hopted automatically pulls all your campaign data into your spreadsheet. Get fresh, accurate data to make decisions, not build reports.
All Your Amazon PPC Data, Up to date in Google Sheets
Pull comprehensive data from all your Amazon Ads campaigns. Hopted gives you the granular data you need to find optimization opportunities and scale your ads.
Sponsored Brands
Connect your Sponsored Brands & Sponsored Brands Video data. Analyze top-of-funnel metrics, attribute sales to your brand-building efforts, and track new-to-brand (NTB) customer data.
Search Term Reports
Pull the complete Amazon Search Term Report for all campaign types. Automatically import customer search terms to find new keywords and identify negative keywords to reduce wasted spend.
Sponsored Display
Integrate your Sponsored Display campaign data. Track performance by audience, ASIN targeting, and placements to understand your full-funnel impact.
Placement & Targeting
Get Placement reports to see where your ads are showing (Top of Search, Product Pages) and optimize your bids accordingly. Analyze targeting reports to refine your strategy.
All Key Metrics
Import all the metrics that matter: Spend, Sales, ACOS, ROAS, CPC, CTR, Clicks, Impressions, Orders, Units, and more, all automatically refreshed in your spreadsheet.
Who is Hopted for?
Amazon private label sellers and brand owners
Amazon vendors
FBA sellers
Manufacturers
Fulfillment By Merchant (FBM) sellers
Agencies working with Amazon Selling Partners
Resellers
Virtual assistants
Amazon Ads reports that you can automatically import into spreadsheets.
Brand metrics
Campaign performance — all ad types
Ad group performance
Sponsored Brands ads
Advertised product performance
Audience performance
Sponsored Brands placements
Gross & invalid traffic
Purchased product attribution
Search term reports
Targeting reports — all ad types
Get started in 3 simple steps
Step 1
Connect your accounts
Install the Hopted Google Sheets Add-on. Securely connect your Amazon Advertising profiles in just a few clicks. (This is separate from your SP-API connection).
Step 2
Select your reports
Choose the Amazon Ads integration. Select the exact reports you need, like “Sponsored Products Campaign Report” or “Search Term Report.”
Step 3
Set your schedule
Choose your target sheet and set an automatic refresh schedule (e.g., “Refresh daily at 7 AM”). Your data will now update automatically, forever.
What you can build.
From data to decisions.
Build a Unified ROAS Dashboard
Combine your Amazon Ads data with your Amazon Seller (SP-API) data to calculate your true Total ACOS (TACOS). See your total ad spend and total sales in one simple chart.
Create a PPC Pacing Report
Build a simple dashboard that tracks your daily ad spend against your monthly budget. Instantly see if you are over- or under-spending and adjust your campaigns.
Streamline Search Term Optimization
Automate your Search Term Report to a new tab. Add a column next to the search terms called “Action” and quickly tag new keywords to add or negative keywords to block.
Frequently asked questions
Hopted uses the official Amazon Advertising API, which is a secure, standard way to access your data. You grant permission, and we can then pull the reports you request. We never have access to your password.
Hopted specializes in pulling your Amazon ads and PPC data directly into spreadsheets, helping you avoid manual CSV downloads.
Yes, this is a separate and new integration. The SP-API (Seller) integration pulls data on your Orders, Inventory, and FBA shipments. The Amazon Ads (Advertising) integration pulls data on your PPC campaigns. The most powerful Hopted users combine both!
You can set your automation schedule to refresh as often as every 15 min, or set it to run hourly, daily, weekly. However, Amazon typically refreshes PPC report data once or twice a day.
Hopted allows you to pull data based on your plan. We can pull large volumes of data, including historical data, to populate your reports. See Hopted pricing → for more details.
Yes. Hopted allows you create custom PPC reports which contains live information from your Amazon Ads account.
Yes. Hopted is built for agencies and Amazon brand aggregators. You can connect as many Amazon Ads accounts (and Seller accounts) as you need and either pull data into one master sheet or into separate sheets.
No. Hopted is easy to use 1-Click connector for Amazon PPC that allows you to export your Amazon ads data in spreadsheets and keep the up to date.
It depends on your needs. Hopted is designed to be the number one solution for a specific, crucial task: automatically pulling your Amazon Ads data directly into your spreadsheets.
Currently Hopted is not a full PPC management service; Soon you'll be able to create campaigns or manage your bids.
Yes. You can link unlimited number of Amazon Ads profiles and centralize all their data in spreadsheets in a way your team works.
