Amazon Ads is a powerful advertising platform that allows sellers and brands to promote their products on Amazon. This guide will walk you through how to connect Amazon Ads to Power My Analytics, create reports in Looker Studio, and understand key metrics and limitations.

Prerequisites

1. An active Amazon Ads account
2. A developer account on Amazon:
1. Registered as a developer at developer.amazon.com
2. Created a Login with Amazon (LwA) security profile
3. Amazon Ads API access:
1. Approved application for Direct Advertiser API access
2. API access assigned to your LwA application
4. Required credentials:
1. Client ID from your LwA security profile
2. Client Secret from your LwA security profile
5. Scopes configured for your LwA application, including:
1. profile
2. advertising::campaign_management
6. Configured return URLs:
1. Allowed Return URLs set to: https://us-central1-power-my-analytics.cloudfunctions.net/connectors-amazon-token and https://us-central1-power-my-analytics.cloudfunctions.net/connectors-amazon-auth/token
7. Basic understanding of Amazon Ads terminology and metrics
   

Adding Amazon Ads as a Data Source

1. Navigate to your Hub and select Sources from the menu.
2. Click + Add new source and choose Amazon Ads from the gallery.
3. Enter your Client ID and Client Secret from Amazon Ads and click Connect.
   

Creating a Looker Studio Report

1. After adding Amazon Ads as a data source in the PMA hub, navigate to Reports > Looker Studio
2. Select Amazon Ads under Create Looker Studio Report (opens official Looker Studio application in new window)
3. Google Looker Studio Configuration:
1. Step 1:
1. Name data source: "Untitled Data Source" > unique name (e.g. "Amazon Ads - Organization Name")
2. Choose Power My Analytics hub from dropdown
3. Optional: Leave "Use report template for new reports" checked for PMA demo template
4. Click Next
2. Step 2:
1. User Account: select Amazon Ads account (real data) or "Sample Account" (sample data)
2. Click Next
3. Step 3: 
1. Choose "Accounts" for reports
2. Optional: Allow "Accounts" modification in reports
3. Click Connect (top right) to complete the data source configuration
4. Step 4: 
1. Click Create Report (top right)
   

Key Reports and Fields

Limitations and Important Considerations

1. Backfilling: Backfilling is limited to 60 days.
   
1. Initial backfill: An initial backfill of the past 60 days of data will be performed when you first connect your Amazon Ads account as a data source
2. Adding an Amazon Ads data source to an existing report: The Amazon Ads data source must be created from your PMA hub, then added to the report.
   
3. Search term breakdown reporting: Search term breakdown is not currently available for Sponsored Brands and Sponsored Brand Video campaigns. This functionality should become available when Amazon’s v3 API exits preview, and all campaign types are supported.
4. Field limitations with Sponsored Display ads: The following fields can only be used with Sponsored Display ads: 
1. Bid
2. Bid Optimization
3. Bid Multiplier
4. Ad Format
5. Landing Page URL
6. Campaign Serving Status
   

Unavailable Data

1. Custom fields
   

How to Blend Amazon Data with Other Data

Report Amazon Ads Data with Amazon Sales Data

1. Export your Amazon Ads data into a Google Sheet.
   
2. Either join that data in Google Sheets/Excel or create a data source in Looker Studio with the Google Sheets connector. Google offers this support article on the subject if you require a more detailed walk-through.
   
3. Use the Blending feature in Looker Studio when you need both Ads and Sales data in the same report.