How to connect Amazon Seller to Looker Studio ?
Step 1: Create an Amazon Seller Source on Catchr
First, create an Amazon Seller source on Catchr. Follow this tutorial to add your new source: Create a source on Catchr.
Step 2: Install the Connector
Open Looker Studio and log in with your Google account.
On the Home page, click the Create button in the top-left corner.
Select Data Source.
In the search bar, type "Catchr".
Click on the Amazon Seller connector and press Authorize.
Step 3: Authenticate Your Amazon Seller Account
If you did not add a source on Catchr in Step 1, you will be prompted to do it here:
Grant the connector permission to access your Amazon Seller data.
This will link your Amazon Seller account to Looker Studio via the Catchr connector.
Step 4: Configure Your Data Source
After authentication, select the Amazon Seller account you want to pull data from (if you manage multiple accounts).
There aren’t any special configurations (e.g., attribution models) for Amazon Seller data.
If you want to use the default template, leave the checkbox "Use default template" checked.
Click Connect to create your data source.
Step 5: Review Data Source Fields
You'll now see the list of available fields for Amazon Seller. Here, you can:
Modify field types (e.g., set a field as currency, percentage, etc.).
You can return to this section later to make further modifications if needed.
Step 6: Create Your Report
Once connected, click Create Report in Looker Studio.
If you didn’t use the template, you’ll see a blank report page. If you used the template, you can add a new page by clicking the page number in the top menu, then selecting Add a page at the bottom right.
Start by clicking Add a Chart and selecting your preferred chart type (e.g., time series, bar chart).
Choose the metrics and dimensions you wish to display in each chart (e.g., sales, inventory, orders).
Continue adding multiple charts to visualize various aspects of your Amazon Seller performance.
Step 7: Customize Your Report
Date Range Filters: Add a date range filter to allow users to select specific time periods.
Custom Calculations: You can create calculated metrics (e.g., total sales, order value) directly in Looker Studio.
Blending Data: If you want to compare Amazon Seller data with other platforms (e.g., Shopify, Google Ads), use the data blending feature.
Step 8: Share or Schedule Reports
To share the report, click the Share button in the top right corner and enter the email addresses of recipients.
You can also schedule the report to be sent periodically (e.g., weekly or monthly) by setting up email delivery under File > Schedule email delivery.
First, create an Amazon Seller source on Catchr. Follow this tutorial to add your new source: Create a source on Catchr.
Step 2: Install the Connector
Open Looker Studio and log in with your Google account.
On the Home page, click the Create button in the top-left corner.
Select Data Source.
In the search bar, type "Catchr".
Click on the Amazon Seller connector and press Authorize.
Step 3: Authenticate Your Amazon Seller Account
If you did not add a source on Catchr in Step 1, you will be prompted to do it here:
Grant the connector permission to access your Amazon Seller data.
This will link your Amazon Seller account to Looker Studio via the Catchr connector.
Step 4: Configure Your Data Source
After authentication, select the Amazon Seller account you want to pull data from (if you manage multiple accounts).
There aren’t any special configurations (e.g., attribution models) for Amazon Seller data.
If you want to use the default template, leave the checkbox "Use default template" checked.
Click Connect to create your data source.
Step 5: Review Data Source Fields
You'll now see the list of available fields for Amazon Seller. Here, you can:
Modify field types (e.g., set a field as currency, percentage, etc.).
You can return to this section later to make further modifications if needed.
Step 6: Create Your Report
Once connected, click Create Report in Looker Studio.
If you didn’t use the template, you’ll see a blank report page. If you used the template, you can add a new page by clicking the page number in the top menu, then selecting Add a page at the bottom right.
Start by clicking Add a Chart and selecting your preferred chart type (e.g., time series, bar chart).
Choose the metrics and dimensions you wish to display in each chart (e.g., sales, inventory, orders).
Continue adding multiple charts to visualize various aspects of your Amazon Seller performance.
Step 7: Customize Your Report
Date Range Filters: Add a date range filter to allow users to select specific time periods.
Custom Calculations: You can create calculated metrics (e.g., total sales, order value) directly in Looker Studio.
Blending Data: If you want to compare Amazon Seller data with other platforms (e.g., Shopify, Google Ads), use the data blending feature.
Step 8: Share or Schedule Reports
To share the report, click the Share button in the top right corner and enter the email addresses of recipients.
You can also schedule the report to be sent periodically (e.g., weekly or monthly) by setting up email delivery under File > Schedule email delivery.
Updated on: 11/10/2024
Thank you!