Amazon is no longer just for buying and selling—it’s also an essential tool for businesses that want to reach their target audience. However, using Amazon ads effectively requires a good understanding because they can be complicated to manage and analyze and may involve high costs. Marketers must know how to track and report on their Amazon Ads campaigns to make the most of them.
Two Minute Reports makes connecting Amazon Ads with Google Sheets easy, allowing you to bring all your campaign performance data into one place. TMR will get real-time metrics from your Amazon Ads to your Google Sheets, extract critical insights, and help you make data-driven decisions without needing to write code. Our setup keeps your data secure by encrypting and storing it in your private Google Sheet. Now, let me explain how to connect your Amazon Ads data using Two Minute Reports in Google Sheets.
Step 1: Install and Launch Two Minute Reports
Install Two Minute Reports if you still need to do so.
Sign in to your Google Sheets with the associated Gmail ID.
Go to Extensions > Add-ons > Get add-ons.
Search for Two Minute Reports and select Install.
Review and accept the permissions necessary to run Two Minute Reports. Once you’ve accepted the terms and conditions, click Allow for Two Minute Reports to manage and access your data.
Note: Allow access is mandatory for TMR to function and efficiently analyze your data.
Next, open your Google Sheets and go to Extensions > Two Minute Reports > Launch.
Once your TMR sidebar opens, you can connect your data sources and run queries.
Step 2: Connect Amazon Ads to Google Sheets
Click Menu at the top left of the sidebar to navigate to the Data Sources section. If you see an onboarding popup, please proceed with it or minimize it by clicking the inverted arrow.
Click Add, name your data source, and select your data source type as Amazon Ads from the Advertising dropdown.
You will be prompted to sign in with a Google account. Sign in with the Amazon account linked with the data source.
If you receive an error message, please check if you have used the correct Gmail account linked to your Amazon Ads. Once you have added the data source, you can check any queries to retrieve the necessary data.
Step 3: Getting Amazon Ads data in Google Sheets
To pull Amazon Ads performance data, you must create a new query by navigating to the Data Queries section.
Click Add and choose the Amazon Ads account to analyze its campaign data. You can manage multiple clients’ Amazon ad accounts under one roof. Simply select one or multiple ad accounts to analyze performance.
Alternatively, you can navigate to the Clients section. Add your client and map their corresponding Amazon Ad account.
Click on “Manage Clients” and enter the necessary account details. Once done, click “Save & Close” to save your client’s details for future reference.
Note: You can add multiple clients and map their respective ad accounts. Doing so saves you tons of wasted hours from manually juggling numerous data sets. You can get a unified view of your client campaigns and track crucial metrics in a centralized dashboard. For further information, please read our guide – How to create queries using accounts and clients?
Next, add the Amazon metrics and dimensions you want to analyze. You can choose from a comprehensive list of metrics and dimensions to assess your Amazon Ad campaign performance. Refer to the screenshot below for better understanding.
Next, you have to configure your data reporting by choosing how to customize it.
It would be best to customize your data reporting by selecting the relevant fields and choosing whether to sort them in ascending or descending order. You can also apply custom filters to display only the necessary information.
Once you have completed the above steps, click Run Query to visualize the final output.
You can now use different Google Sheet features, such as pivot tables and VLOOKUP(), to extract critical insights and build charts to elevate your reporting.
Pro TMR Tip: Run all your queries directly from the Extensions menu on your Google Sheets. Go to Extensions > Two Minute Reports > choose your desired quick action.
You can read How to use templates for Google Sheets to learn about Two Minute Reports templates.
Step 4: (Optional) Get automatic data updates via Schedule Refresh
Once you create a report in Google Sheets, you can schedule automatic updates to get updated data. This feature is convenient for sending emails or refreshing your spreadsheets with live data and using them as a dashboard.
Under the email section, you can enter the recipient(s)’s email ID and save the new schedule.
You can also choose to specify the reporting format. You can insert the sheet content in the email body, attach the selected sheet as a PDF or Excel, or attach the spreadsheet as an Excel file.
Two Minute Reports’s schedule refresh or data refresh feature has other capabilities. For more information, please read our guide, “How to Refresh Data Automatically in Google Sheets.”
We hope you found this guide helpful. Please contact our support team via chat button or support@twominutereports.com if you have any questions.