Order Systems and Shopping Carts
      Back to home
      1. Wicked Help Center
      2. 1. SETUP
      3. Order Systems and Shopping Carts

      How To Integrate Amazon and Wicked Reports for Sales and Ad data

      This document is for marketers who advertise and/or sell products on Amazon and want Amazon's high level data included in their marketing analysis.

       

      Note: The Amazon integation is a limited closed Beta.  For access to this Beta, please contact support.

      Table of Contents

      About this Integration

      The Amazon Integration in Wicked Reports lets you bring in key data from your Amazon Ads and Amazon Sales channel, giving you high-level insights into your advertising spend and sales performance directly within Wicked Reports. By connecting your Amazon Ads and Sales data, you can seamlessly analyze your Amazon performance alongside other marketing channels. This integration supports holistic cross-channel reporting, so you can measure and optimize your marketing efficiency with a unified view.

      Why you need this

      Understanding your Amazon performance in the context of all your marketing channels is essential for effective budget allocation and decision-making. By integrating Amazon with Wicked Reports, you can:

      • Analyze Your Ad Spend: Track Amazon Ad spend to understand its role in your marketing mix without needing to log in to separate platforms for analysis.
      • Measure Amazon Sales Impact: Bring in sales data to monitor Amazon revenue and calculate key metrics like Marketing Efficiency Ratio (MER), Return on Ad Spend (ROAS), Customer Acquisition Cost (CAC), and Average Order Value (AOV).
      • Streamline Cross-Channel Insights: Gain insights into how Amazon contributes to your broader marketing strategy by comparing it with other channels, identifying the most cost-effective sources, and adjusting tactics for better results.

      How it works

      The Amazon integration pulls in two types of data:

      1. Amazon Ad Data at the Channel-Level: Once connected, Wicked Reports imports your Amazon Ad spend data, available as a channel-level view only. This means you’ll see the total ad spend over a chosen date range, but not individual campaign performance. This high-level view helps you evaluate your Amazon advertising investments without diving into granular campaign details.

      2. Amazon Sales & Revenue Data: This includes your Amazon sales transactions, giving you visibility into the number of sales and total revenue generated. With this data, Wicked Reports calculates essential metrics like MER, ROAS, CAC, and AOV for Amazon, so you can see how Amazon sales contribute to your overall marketing strategy.

      Both data types can be connected independently via a simple authorization process. As soon as the connection is established, Wicked Reports starts importing data from Amazon, enabling you to analyze Amazon’s impact across all key metrics.

      Integration Steps for Amazon Ads

      1. On your Authorizations page, find Amazon under the Advertising Data column and click "Connect"

      2. You will confirm that you want to Authorize Amazon as a source for Ads.  Click "Yes, Proceed"

      3. Follow the Amazon Authorization Process

      4. Select the Amazon Ad Accounts you want to import into Wicked Reports and click "Assign"

      5. Click the "Go To Authorizations Page" button to confirm Amazon Ads accounts are connected

      6. Wicked Reports has now begun pulling in your Amazon Ads data.  Check back later to start seeing the data.

      Integration Steps for Amazon Orders

      1. On your Authorizations page, find Amazon under the Orders Data column

      2. You will confirm that you want to Authorize Amazon as a source for Ads.  Click "Yes, Proceed"

      3. Follow the Amazon Authorization Process

      4. Select the Amazon Accounts you want to import into Wicked Reports and click "Assign"

      5. Click "Go To Authorizations Page" and confirm Amazon accounts are connected

      6. Wicked Reports has now begun pulling in your Amazon Order data.  Check back tomorrow to start seeing the data

      What's Next?

      Once Wicked Reports has pulled in your Amazon Ad and/or Order data, this data will begin showing up in your channel level reporting on Mission Control and FunnelVision

      On Mission Control an Amazon channel row will be included in the Channels report

      Note: If no Amazon data is found for the selected date range, the FunnelVision report will not include the Amazon channel.

       

      FAQ

      Why do so many of my Amazon columns have "-" instead of a value? 

      Amazon only provides us specific data points.  For example, we are not able to get actual customer information.  So, we don't know which customer made which purchase.  This means we don't know if they are a new customer or a repeat customer.  We also don't know if they are a new visitor or not.  Any column that uses this type of info or a calculation based on these values cannot be displayed 

       

      Why doesn't my Amazon revenue match revenue in my Amazon account?

      There are likely two reasons for this. 

      First, when Wicked Reports pulls in Amazon revenue, it includes Taxes while your Amazon account likely does not.

      Second, Wicked Reports pulls in Amazon sales and reports them based on Eastern Standard Time (EST), while your Amazon account may be reporting on a different timezone.