Amazon Ads & Power BI: How to integrate your data and template

Welcome to this instructional guide, crafted to empower you to amalgamate your Amazon Ads marketing data with PowerBI seamlessly. By the end of this guide, you'll have gained the proficiency to effectively transport your marketing metrics straight to PowerBI, revealing insights that can propel your decision-making process and enhance your marketing strategies.

How to Connect Your Amazon Ads Account to PowerBI

Add a source on Catchr

Begins your integration journey by visiting Catchr's homepage. From the left menu, select 'Source,' and then click on 'Add a Source' situated towards the top right corner.

Select 'Amazon Ads'. Navigate through the authentication process to connect Catchr with Amazon Ads.

Create the request to transfer Amazon Ads data to PowerBI

• Within Catchr, locate and select 'API' on the left-side menu.

• Change the export format to 'PowerBI'.

• Select 'Amazon Ads' as your platform of choice from the 'Source' tab.

• Specify which Amazon Ads account you wish to extract data and KPIs from, with an option to select multiple accounts.

• Choose the metrics and dimensions you require for your data request, with freedom to select several.

• Warning: For template users, ensure you select all dimensions and metrics as per the Catchr template's guidelines to load all necessary data.
• Decide on a time period for your Amazon Ads data extraction, opting for either a custom or predefined span.

• If necessary, enhance your data request with filters that cater to your analysis needs. It's possible to apply multiple filters.

• Explore additional options for your request, tailored specifically to Amazon Ads.

• Upon completion, an URL will be presented in the top bar. Preview the outcome by selecting 'Preview' in the top right.

• Content with the preview? Copy the URL; it's a vital component for the next steps within PowerBI.

Import the Amazon Ads data and KPI to PowerBI

PowerBI Desktop: Within PowerBI Desktop, the 'Web' data source is required to import the Amazon Ads data.

• Select 'Get Data', then 'Web'.

• Stay in basic mode and insert the URL you previously saved from Catchr.

• Click 'OK' to proceed.

PowerBI Desktop will now process your request, a step which might require a few minutes. Once completed, you can use PowerBI Query Editor to manage your data types and continue to develop your analytical dashboard.

PowerBI Web App: To leverage your data via the PowerBI Web App, initiate by publishing your data set from the desktop version. Within the Web App, select 'New Report' and opt for a previously published data set to progress with report creation.

Through this guide, you've traversed the path from connecting Amazon Ads to PowerBI until the visualization phase. Unlocking the value within your marketing data using Catchr and PowerBI's combined force is a testament to your growing expertise. Ready to dive into analytics? Your next campaign's success awaits the insights you now have at your command.

Exploring the Analytics Horizon: Metrics and PowerBI Integration for Amazon Ads

PowerBI's dynamic capabilities, when combined with Catchr's data exporting prowess, offer a robust visual analytics platform. Here are examples of how you can utilize these metrics within PowerBI:

Use Campaign Budget Metrics to draft financial report visualizations, tracking spend efficiency over selected periods. Analyze Click and Impression Metrics to evaluate campaign reach versus engagement, providing insight into ad effectiveness. Capitalize on Sales and Conversion Metrics to identify patterns and trends, which can inform future targeting strategies. Explore New To Brand Metrics to gauge the impact of your campaigns on acquiring new customers; this data can shed light on brand growth potential.

To harness the full potential of these metrics, consider delving into Catchr's comprehensive field listing for Amazon Ads.

‍