Amazon Ads Data Connector User Guide

Amazon Ads Data Connector User Guide

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

Before connecting Amazon Ads to Power My Analytics, ensure you have:
  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 URL:
    1. Allowed Return URL set to: https://us-central1-power-my-analytics.cloudfunctions.net/connectors-amazon-token
  7. Basic understanding of Amazon Ads terminology and metrics
For more information, please see How to Connect to Amazon Ads.

Adding Amazon Ads as a Data Source

  1. Navigate to your Hub and select Sources from the menu.
  2. Click + New Data 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

Follow these steps to create a Looker Studio report using your Amazon Ads data:
  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

Amazon Ads data in Power My Analytics offers a wide range of metrics and dimensions. Here are some popular metrics you can use in your reports:
  • Key Performance Metrics: Spend, Sales, ACOS, Impressions, Clicks
  • Campaign Metrics: Budget, Cost Type, Spend, Orders, Sales, ROAS
  • Ad Group Metrics: Spend, Orders, Sales, ROAS
  • Advertised Product Metrics: Spend, Orders, Sales, ROAS
  • Targeting Metrics: Spend, Orders, Sales, ROAS
  • Search Term Metrics: Clicks, Spend, Orders, Sales, ROAS
For a complete list of available Amazon Ads fields in Power My Analytics, refer to the Schema Explorer.

Limitations and Important Considerations

  1. Backfilling: Backfilling is limited to 60 days.
  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. 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

To join Amazon Ads data with 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.

Troubleshooting

See our article Troubleshooting Amazon for information on issues that may affect Amazon connectors.

    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • Quora Ads Data Connector User Guide

        Quora Ads allows marketers to reach a highly engaged audience through targeted advertising on the Quora platform. This guide will walk you through how to connect your Quora Ads data to Power My Analytics and create insightful reports in Looker ...
      • Google Ads Data Connector User Guide

        Google Ads is a powerful online advertising platform that allows businesses to reach potential customers across Google's vast network. This guide will walk you through how to connect your Google Ads data to Power My Analytics, create reports in ...
      • Instagram Ads Data Connector User Guide

        Instagram Ads allows businesses to create and run paid advertisements on the Instagram platform. This guide will walk you through setting up Instagram Ads as a data source in Power My Analytics and creating reports in Looker Studio. Prerequisites ...
      • X Ads (Twitter) Data Connector User Guide

        X Ads (formerly Twitter Ads) is a powerful advertising platform that allows marketers to reach their target audience on one of the world's most popular social media networks. This guide will walk you through the process of connecting your X Ads ...
      • Facebook Ads Data Connector User Guide

        Facebook Ads is a powerful advertising platform that allows businesses to reach their target audience on Facebook, Instagram, and across the web. This guide will walk you through how to connect your Facebook Ads account to Power My Analytics, create ...