blog post

Import your Amazon Ads marketing KPI to Google Sheets: How-to, metrics and more

Florian Cabirol
September 11, 2024
Import your Amazon Ads marketing KPI to Google Sheets: How-to, metrics and more

Quick steps to create a Amazon Ads report with Google Sheets:

You can easiliy create a Amazon Ads report following this step :

  1. Get informations from the data integration from our Amazon Ads connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Amazon Ads data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Amazon Ads report with Looker Studio:

You can easiliy create a Amazon Ads report following this step :

  1. Get informations from the data integration from our Amazon Ads connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Amazon Ads at the end of the page.

The tutorial

Quick steps to create a Amazon Ads report with PowerBI:

You can easiliy create a Amazon Ads report following this step :

  1. Get informations from the data integration from our Amazon Ads connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Amazon Ads at the end of the page.

The tutorial

This comprehensive tutorial is designed to guide marketing professionals on how to effortlessly connect their Amazon Ads data to Google Sheets using Catchr. By the end of this guide, you'll have the knowledge to visualize and analyze your marketing data more effectively, enabling better decision-making and strategizing for your Amazon Ads campaigns.

How to Connect Your Amazon Ads Account to Google Sheets

Add a Source on Catchr

To start, navigate to the Catchr homepage. Look for the option labeled "Source" on the left-side menu and select it. Next, click "Add a Source" located at the top right corner of your screen. Choose "Amazon Ads" as your platform and follow the prompt steps to authorize Catchr to access your Amazon Ads data.

Adding Amazon Ads as a source in Catchr

Create a New Query

Next, launch Google Sheets and from the menu, select "Catchr." Here, you'll have the option to click on "New Query." This action sets the stage for importing your Amazon Ads data into the spreadsheet.

Select Your Data Source

Within the query tab, ensure "Amazon Ads" is chosen as your data source. If it's not listed, you can simply add it by clicking the "+" icon.

Selecting the data source in Catchr

Select Your Account(s)

Move on to the "Select account(s)" section and pick the Amazon Ads account(s) from which you wish to import data.

Selecting Amazon Ads account in Catchr

Choose Metrics and Dimensions

Now it's time to select the data points you wish to analyze. Navigate to the "Metrics" and "Dimensions" sections to make your selections.

Metrics:

  • Clicks: The total number of clicks on your ads.
  • Sales: The total value of sales generated from your ads.
  • ACoS (Advertising Cost of Sales): The ratio of ad spend to targeted sales.
Choosing metrics in Catchr

Dimensions:

  • Ad Group Name: The name of the ad group your ad belongs to.
  • Product Category: Category of the advertised product on Amazon.
  • Campaign Name: Name of the campaign the ad is part of.
Choosing dimensions in Catchr

Set Date Range

After making your selections, proceed to the "Date Range" tab. Here you can opt for predefined ranges such as "Last month" or set a custom range to meet your data analysis needs.

Setting the date range in Catchr

Apply Filters

To refine your data further, apply filters in the "Filters" tab. Input the following criteria:

  • Field: Campaign Name
  • Operator: Equals
  • Value: Your specific campaign name
Applying filters in Catchr

Schedule & Customize Data Refreshness

Finally, in the "Options" tab, you can schedule your data to refresh automatically. Additional settings like "Append rows" or "Combine rows" can also be adjusted here according to your preferences.

Scheduling data refresh in Catchr

In conclusion, mastering these steps will streamline the process of importing your Amazon Ads data into Google Sheets. This integration empowers you with the flexibility to analyze and visualize your marketing data efficiently, leading to better campaign strategies and outcomes.

Example of Google Sheets You Can Create to Use with the Amazon Ads Source

The integration of Amazon Ads with Google Sheets offers numerous possibilities for marketing data visualization and analysis. Here are examples of the types of Google Sheets dashboards you can create:

  • Performance Dashboard: Compile key metrics like Clicks, Impressions, Conversion Rate, and ACoS to monitor the performance of your ads over time.
  • Keyword Analysis: Create a sheet dedicated to keyword performance, tracking metrics like Clicks, Impressions, Cost Per Click, and Sales, to identify high-performing and underperforming keywords.
  • Product Performance: Analyze sales, ACoS, and other product-level metrics to understand which products are the most profitable and which need further optimization.
  • Budget Tracking: Keep an eye on your ad spending across different campaigns, ad groups, and products to ensure you're allocating your budget effectively and staying within limits.
  • Time-Based Trends: Use the power of Google Sheets to create charts and graphs that showcase trends over specific time periods, enabling you to make informed decisions based on seasonality and other factors.

By customizing your Google Sheets with Catchr, you can leverage tailored dashboards that meet your specific analytic needs. Explore various layouts and formulas to enhance your data storytelling and share actionable insights with your team.

Empower your Marketing data analysis
Discover +50 connectors to import your Marketing data into your favorite dashboard tool! Unlock instant data integration with Catchr's no-code feature – no IT team required!
Start your free trial!

All your marketing data on Google Sheets

Build Google Sheets dashboard with your different marketing data and track all the essential KPIs.

Start your free trial!
Keep an eye on your data

Connect your Amazon Ads data to Google Sheets thanks to Catchr's no code connector!

Start your free trial!
Need a clearer view of your marketing data?
Unlock your free Looker Studio dashboard template for from a collection of +50 stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
Unlock your free Power BI dashboard template from a collection of stunning designs. Elevate your data visualization!
Get it for free
Need a clearer view of your marketing data?
No items found.
No items found.
Need a clearer view of your marketing data?
No items found.
No items found.
No items found.

In this Amazon Ads template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this Amazon Ads template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Amazon Ads