Stop Wasting Hours
on Manual Reporting
Stop downloading CSVs. Automate your Amazon Advertising reports directly in Google Sheets. Track campaigns, optimize spend, and build custom ROAS dashboards—no code required.
Why Google Sheets
for Amazon Ads
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 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.
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.
Get started in 3 simple steps
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).
Select your reports
Choose the Amazon Ads integration. Select the exact reports you need, like "Sponsored Products Campaign Report" or "Search Term Report."
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.
Idea
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.
template
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.
pre-made solution
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.