Amazon Ads & Google Sheets: how to integrate your data

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.

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.

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.

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.

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.

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.

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

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.

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.

‍