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.
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.
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.
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.
Move on to the "Select account(s)" section and pick the Amazon Ads account(s) from which you wish to import data.
Now it's time to select the data points you wish to analyze. Navigate to the "Metrics" and "Dimensions" sections to make your selections.
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.
To refine your data further, apply filters in the "Filters" tab. Input the following criteria:
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.
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:
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.