Connect Amazon Ads to Looker Studio: A Complete Guide with Free Templates

Read this guide to uncover simple and efficient ways to connect your Amazon Ads data to your favorite visualization platform: Google Looker Studio.

Sep 26, 2024

By Two minute reports

10 min read

Imagine a place where people look out for ads and engage with them. Their only motivation to be there is to look or shop for a product. This seemingly giant marketplace, Amazon, has over 310 million active users around the globe and offers a strong advertising platform that enables multiple ad formats–this is the high-value proposition that Amazon Ads promises. 

Amazon Ads have become a staple for most consumer-facing brands because of the value they bring in the form of detailed customer data and buying patterns. Aside from its robust features, Amazon Ads is still an advertising platform; each part is data-driven and offers robust analytics. In this article, we will take you through various steps to bring all your Amazon Ad data to a single (or more) Looker Studio Dashboard in under two minutes. 

This two-minute process could potentially save you hours of manual work. 

How to connect Amazon Ads data to Looker Studio in under two minutes?

Two Minute Reports (TMR) helps you pull data from Amazon Ads and build intuitive and automated reports quickly. The best part is that you don’t need a single line of code. You just need to follow a few simple steps to configure your report, and you’re set. 

There are two methods to generate your Amazon Ads Looker Studio report using TMR

Method 1: Connect Amazon Ads to Looker Studio and build a report from scratch

Method 2: Connect Amazon Ads to Looker Studio using in-built Templates of Two Minute Reports.

Step 0: Getting Started

Screenshot 2024-09-25 at 12.18.54 PM.png

  • Both methods start with logging in through their apps portal or from Home > Login 

1.png

  • Once logged in, choose Two Minute Reports for Looker Studio from the My Apps page. 

2.png

  • Select a team to access its dashboard. 
    • If you work with multiple teams, choose the relevant team for the report. 
    • If you aren’t added to multiple teams, you’ll be redirected to the Connectors Page.   

Note: Every organization has separate teams with their separate tasks. In Two Minute Reports, you can create separate “Teams” or groups to enable collaboration. 

3.png

  • From the connectors page, choose the relevant data source connector; in this case, click on Amazon Ads. This will take you to the Amazon Ads Connector Dashboard. 

You’re now all set to start creating your Amazon Ads report. 

Method 1: Creating an Amazon Ads report from scratch

Step 1: Adding the Data Source and authorizing through the Amazon Ads account

4.png

  • Once inside the Amazon Ads Connector dashboard, click “Add New” from the Data Sources section. 

6.png

  • Name your data source, log into your Amazon Ads account, and authorize TMR to fetch data from your campaigns.
  • Once authorized, your Amazon Ads account is connected to Looker Studio. We can now move on to configuring the data query. 

Step 2: Query Configuration

  • Click the “Query Configs” section to configure a query that exports data from Amazon Ads to Looker Studio.
  • Click “Add New” to open the “Adding New Query Configuration” window. 

7.png

  • Select the data source you’ve already created (in Step 1) and click Next. 

8.png

  • In the next tab, name the query and choose the relevant Ad ProfilesYou can choose one or multiple Ad Profiles at the same time.

9.png

  • You can also modify your data from the Data Options drop-down menu.  

10.png

  • Once you’ve completed the configuration, Save it to create the Query Config. 

Step 3: Creating the report from the Google Data Studio Dashboard

  • After adding data source and query configs, click the green “Create Report” button to open the “Creating New Data Studio Report” window. 

11.png

  • From this window, choose the relevant Query Config (previously created) from the search bar and click on the Next button. 

12.png

  • Under the Create Report tab, click “Create Report from scratch” to launch Looker Studio.

13.png

Want to choose “Quick start from a template”? Jump to Method 2 here. 

14.png

  • Once Looker Studio opens, choose the relevant team. Ensure that “Use report template for new reports” is checked. Once you’ve done this, click on Next to continue.  

15.png

  • Then, select the relevant Query Config for the data source and click on the Connect button at the top-right corner.

14.png

  • The next window shows all the available Amazon Ads metrics, ready for the report. You can modify the metrics or click the Create Report button at the top-right corner. 

16.png

  • You’ll then be notified when new data is added to the Looker Studio report. Click on Add to Report to authorize the activity.
  • Your Google Looker Studio Dashboard is ready now! The sidebar will contain all the metrics and dimensions you need to add to the report. 

To create a table/chart with a particular metric: 

  • Create a table or chart at the desired position. 

17.png

  • With the table/chart selected, choose the metrics that you need in your report. Explore the categories in the “Metrics” dropdown menu, like Engagement, Clicks, or Impressions, and add them to your report. 
  • Next, we set the dimensions of the report. Choose the right dimensions to add to your report, like Date or Place, from the Dimensions” dropdown menu.
  • From the sidebar, you can either choose the preset date range or your custom range. 

You can repeat the same steps to add the required tables/charts to your new report. 

Method 2: Creating an Amazon Ads Dashboard using templates

One of the best things about Two Minute Reports is its templates. These preset dashboards for Looker Studio combine relevant marketing data to serve specific purposes. Our analysts and marketers craft every template to reduce your time on the report editor for manually creating charts, tables, and graphs.    

Follow Steps 1 and 2 from the previous method to get started with this method. 

Step 3: Creating the Looker Studio report

11.png

  • After adding the data source and configuring the queries, click the green “Create Report” button to open the “Creating New Data Studio Report” window. 

12.png

  • From this window, choose the relevant Query Config (previously created) from the search bar and click on the Next button. 

1.png

  • From the Create Report tab, you can explore TMR’s templates from the Template Gallery for the chosen connector. Once you’ve selected the required template, click it to launch the template on Looker Studio. 

15.png

  • Once redirected to Looker Studio, choose the relevant team and check the box next to “Use report template for new reports”. Click Next to continue.
  • Then, select the relevant Query Config for the data source and click on the Connect button at the top-right corner. This step connects TMR to Looker Studio. 
     

14.png

  • The next window shows all the available Amazon Ads metrics, ready for the report. You can modify the metrics or click the Create Report button at the top-right corner.

    16.png
     
  • Next, authorize the data export activity and complete the report with preset tables and charts with your metrics. 

Screenshot 2024-07-15 at 12.48.45 PM(1).png

  • Set a date range from the dashboard to display the relevant data. You can choose from preset date ranges like “Last 7 days” or “Last Month”, or set your custom date range from the drop-down calendars. 

Just like that, you’ve created your Amazon Ads report on Looker Studio. You can modify the tables/charts, metrics, and dimensions from the TMR sidebar. Learn more about data freshness and report scheduling to get data directly to your inbox here. 

How to build the perfect Amazon Ads Report

With TMR, you can draw deep and detailed analytics from Amazon Ads in under two minutes. Here’s a sneak peek into everything the metrics that you can track using Amazon Ads: 

  • Clicks
  • Impressions
  • View impressions
  • Amount spent
  • Cost Per Click (CPC)
  • Return on ad spend (ROAS)
  • CTR
  • Conversion rate (CVR)
  • ACOS
  • Total orders (7, 14, and 30-day time periods) 
  • Total ad sales (1, 7, 14, and 30-day time periods)

You can also add dimensions to these metrics to make your data more accurate. View all the metrics and dimensions you can track here: Metrics and Dimensions - Amazon Ads.

With these KPIs, you can tweak your client’s business strategy for better performance. This is where a great report could help you. Having your data organized, categorized, and well-represented helps you draw conclusions and make better decisions from your data. Here are some steps that you can follow to build a that fits your needs: 

  1. Understand what your report needs: Explore the various types of KPIs and their relationships with each other to choose the most relevant KPIs to your needs. 
  2. Choose the Key Metrics: With Amazon Ads, almost every activity (qualitative or quantitative) can be tracked as a metric. Choose the right metrics (and dimensions) that align with your KPIs.
  3. Choose the Key Metrics: Choose metrics that match your goals. Do you want more orders/sales? Or do you want your brand to have more reach to build a loyal customer base? These decisions could give better direction to your analytics. 
  4. Track and Optimize: Your campaigns could always evolve. Diligently track these changes and make consistent changes to your campaigns. Never underestimate the insights that your reports could give you! 

Use our quick templates for Looker Studio

1. Amazon Ads - Orders and Sales Analytical Report

Amazon Ads - Orders and Sales Analytical Report
View Template
Amazon Ads - Orders and Sales Analytical Report

Let me introduce you to our newly built "Amazon Ads Performance Report Template". As the name suggests, you get all the performance insights you need to monitor from your Amazon ads multiple ad accounts, but everything in a single frame. Get all your top KPIs like Total ad sales, Impressions, clicks, CTR, Amount spent etc.. as scorecards and tabular charts which also shows the performance of its previous time period. You have specific individual tables to monitor Order and Sales Performance. you also get a comparison graph for Order vs Sales Performance, followed by a campaign status table which gives you the campaign status with its bid optimization type collectively with the Amount spent for it. Finally, you get a Geo chart for countries with the top CPC. Click on preview Template to get a better perspective out of it!

Why Two Minute Reports (TMR)?

  1. Centralized Data Integration: TMR is a Looker Studio add-on that consolidates your metrics from a vast array of platforms, including top advertising sources and analytics tools. It eliminates the need for manual CSV imports, creating a seamless dataflow from Amazon Ads to Looker Studio.
  2. Extensive Integrations and Upcoming Features: TMR’s Looker Studio add-on currently supports integrations with a wide range of platforms across advertising, analytics, SEO, social media, ecommerce, email, mobile, CRM, and databases. This includes Facebook, Amazon Ads, LinkedIn, Shopify, and more, with exciting integrations coming up to enhance its capability.
  3. Intuitive Reporting: All the reports created with the TMR add-on are professional and mobile-friendly. The intuitive interface enables you to craft and customize reports and share them with unlimited users.
  4. Cost-Effective and User-Friendly: TMR is a user-friendly add-on with a low learning curve and is affordable–without sacrificing functionality.
  5. Native Connectors and API Bridge: Native connectors simplify pulling data from various sources. The API Bridge feature allows connection to any data source that returns JSON, limiting data accessibility in Looker Studio.
  6. Efficiency and Customization: TMR’s add-on helps you set up dashboards swiftly with pre-built templates (that can be customized and duplicated). These templates streamline your report generation and client setup.

Two Minute Reports is not just about data consolidation but also about empowering agencies. With TMR’s powerful report configuration tools, your agency can now automate and streamline reporting processes, making data-driven decisions quicker and more efficient. 

Why import Amazon Ads Data in Looker Studio? 

Looker Studio has been a popular option for all types of report creation, including analyses of Amazon Ads, Google Ads, and Facebook (Meta) Ads performance. 

Add-ons and Extensions

Looker Studio can integrate several key functions through add-ons. For example, with an add-on like Two Minute Reports, you can extract data, manage data, create reports, and even schedule reports.    

Optimized Data Management

By constantly integrating your Amazon Ads data to Looker Studio, you don't have to download CSV files to analyze and create reports manually. Real-time data is fresh and actionable, ensuring you’re always working with the most current information. 

Comprehensive Data Analysis

Insightful metrics and collaborative accessibility are key benefits when using Looker Studio to manage your website/app’s performance. With an Amazon Ads add-on, you can dissect and analyze data, compare, and create custom metrics that align with your campaign and overall business goals. 

Collaborative Access

Building a spreadsheet also allows for seamless collaboration between functions in your organization. The ease of data accessibility allows teams to work together with real-time data, fostering a highly collaborative environment. 

Customization and Flexibility

Importing Amazon Ads data into Looker Studio will enable you to customize your reports according to your (and client’s) needs. Looker Studio allows the proper arrangement of the metrics and dimensions most relevant to your agency goal for successful analysis. 

Workflow Efficiency

Setting up automated workflows to channel data from Amazon Ads to Looker Studio effectively streamlines the data journey from source to analysis. This process ensures seamless synchronization when you connect Amazon Ads to Looker Studio, enabling consistent workflow management by keeping your datasets always synchronized.

Marketing Strategy Enhancement

When you export Amazon Ads data into Looker Studio, you can conduct multi-channel analyses to simultaneously evaluate performance across multiple channels. This approach enables you to make data-driven decisions that enhance the effectiveness of your marketing strategy.

How to build the perfect Amazon Ads Report

With TMR, you can draw deep and detailed analytics from Amazon Ads in under two minutes. Here’s a sneak peek into everything the metrics that you can track using Amazon Ads: 

  • Clicks
  • Impressions
  • View impressions
  • Amount spent
  • Cost Per Click (CPC)
  • Return on ad spend (ROAS)
  • CTR
  • Conversion rate (CVR)
  • ACOS
  • Total orders (7, 14, and 30-day time periods) 
  • Total ad sales (1, 7, 14, and 30-day time periods)

You can also add dimensions to these metrics to make your data more accurate. View all the metrics and dimensions you can track here: Metrics and Dimensions - Amazon Ads.

With these KPIs, you can tweak your client’s business strategy for better performance. This is where a great report could help you. Having your data organized, categorized, and well-represented helps you draw conclusions and make better decisions from your data. Here are some steps that you can follow to build a that fits your needs: 

  1. Understand what your report needs: Explore the various types of KPIs and their relationships with each other to choose the most relevant KPIs to your needs. 
  2. Choose the Key Metrics: With Amazon Ads, almost every activity (qualitative or quantitative) can be tracked as a metric. Choose the right metrics (and dimensions) that align with your KPIs.
  3. Choose the Key Metrics: Choose metrics that match your goals. Do you want more orders/sales? Or do you want your brand to have more reach to build a loyal customer base? These decisions could give better direction to your analytics. 
  4. Track and Optimize: Your campaigns could always evolve. Diligently track these changes and make consistent changes to your campaigns. Never underestimate the insights that your reports could give you! 

     

Get Amazon Ads data in Looker Studio

Two Minute Reports can integrate Amazon Ads data with Looker Studio (formerly Google Data Studio), enabling advanced data analysis and visualization. 

This Amazon Ads add-on allows the creation of detailed reports and dashboards from Amazon Ads’ performance data without the complexity of manual data entry. Looker Studio’s customization capabilities also let users craft custom formulae in a user-friendly interface. 

With TMR’s seamless integration, comprehensive analytical capabilities, and automated workflows, strategic business intelligence from Amazon Ads has become quicker and more accessible. 

Connect other data sources with Looker Studio

With this add-on, you can connect 30+ Data Sources to Looker Studio, create additional reports, create visualizations, and build a comprehensive report. 

Facebook Ads

Social media ad platform for targeted audience reach.

Advertising platform for displaying ads on Google's search results pages.

Linkedin Ads

Professional social media platform's advertising data source.

Snapchat Ads

Social media advertising platform for Snapchat users.

Increase your Client's ROI by 2x
Reports done in two minutes
ctaStart your Free trial now

Frequently Asked Questions

What are data sources?

A report's data source is where you grab data for analysis, comparison, and decision-making. Determining and adding a data source is the first step in creating a report.

What are Dimensions in Amazon Ads?

Dimensions are additional attributes of your website which provide information about it. For example, the “Date” dimension tells the date a visitor visited your website.

How do I connect Amazon Ads to Looker Studio?

Several add-ons, like the Amazon Ads Spreadsheet add-on or Two Minute Reports, connect your Amazon Ads account(s) to Looker Studio and automate data extraction. 

What data to pull from Amazon Ads?

The best data to pull from Amazon Ads varies based on your business needs and types. Ensure your data informs you about your user’s behaviors, website/app’s performance, and user experience. 

What is Two Minute Reports?

It is an add-on that helps you integrate data from 30+ data sources (like Facebook, LinkedIn, Shopify, Klaviyo, etc.) to Looker Studio and Google Sheets to create reports and analyze data effectively and seamlessly.