Amazon Ads (formerly known as AMS or Amazon Marketing Services) is an advertising platform that lets you create and manage ads to promote your products and brand across Amazon and third-party sites. It provides tools to manage campaigns, targeting, and creatives, along with performance measurement and analytics to help you optimize your advertising strategy.
Hevo uses the Amazon Ads API to replicate data from your Amazon Ads account to the Destination of your choice. To ingest data, you must authorize Hevo to access your Amazon Ads account using Open Authorization (OAuth) 2.0.
Supported Features
| Feature Name | Supported |
|---|---|
| Capture deletes | Yes (for the Profile object) |
| History mode | No |
| Custom data (user-configured tables & fields) | No |
| Data blocking (skip objects and fields) | Yes |
| Resync (objects and Pipelines) | Yes |
| API configurable | No |
Prerequisites
- An active Amazon Ads account exists, with at least one advertiser account, from which data is to be ingested.
Configure Amazon Ads as a Source in your Pipeline
Perform the following steps to configure your Amazon Ads Source:
-
Click Pipelines in the Navigation Bar.
-
Click + Create Pipeline in the Pipelines List View.
-
On the Select Source Type page, select Amazon Ads.
-
On the Select Destination Type page, select the type of Destination you want to use.
-
On the Select Pipeline Type page, click Edge, and then click Continue.
This page appears only if the selected Destination type is supported in Edge and your Team has an existing Amazon Ads Pipeline with the same Destination type. Otherwise, you can proceed to create an Edge Pipeline.
-
In the Configure Source screen, specify the following:
-
Source Name: A unique name for your Source, not exceeding 255 characters. For example, Amazon Ads Source.
-
In the Connect to your Amazon Ads account section, do the following:
-
Click Authenticate Your Amazon Ads Account, log in to your Amazon Ads account, and grant Hevo access to your account.
-
From the Region drop-down, select the region of your Amazon Ads advertiser account. This determines the API endpoint Hevo uses to connect to your account. Default value: North America.
-
-
In the Sync Settings section, specify the following:
-
Profiles sync mode: Choose whether to sync data for all advertiser accounts in the selected region, or only for specific ones:
-
Sync all profiles: Hevo syncs data for all advertiser accounts accessible to your authorized Amazon Ads account in the selected region, including any accounts added later.
-
Sync specific profiles: Hevo ingests data only for the accounts you select from the Profiles to sync drop-down.
-
-
-
In the Reporting Settings section:
- Click Attribution window (optional): The number of days between a person clicking your ad and completing a conversion. This setting applies to Sponsored Products reporting objects only. Default value: 30 days.
-
-
Click Test & Continue to test the connection to your Amazon Ads Source. Once the test is successful, you can proceed to set up your Destination.
Data Replication
Hevo replicates data for all the objects selected on the Configure Objects page during Pipeline creation. By default, all supported objects and their available fields are selected. However, you can modify this selection while creating or editing the Pipeline.
Hevo ingests the following types of data from your Source objects:
-
Historical Data: The first run of the Pipeline ingests all available historical data for the selected objects and loads it into the Destination.
-
Incremental Data: Once the historical load is complete, new and updated records for objects are ingested as per the sync frequency.
For the following objects, Hevo ingests only the incremental data in subsequent Pipeline runs:
-
Advertised Product Report
-
Campaign Level Report
-
Purchased Product Keyword Report
-
Purchased Product Targeting Report
-
Search Term Ad Keyword Report
-
Search Term Targeting Report
For all other objects, Hevo ingests the entire data during each Pipeline run.
Amazon Ads enforces rate limits on the number of calls that can be made to its API in a given time period. If this limit is exceeded, a rate limit exception occurs. To understand how Hevo handles such scenarios, read Handling Rate Limit Exceptions.
Note: You can create a Pipeline with this Source only using the Merge load mode. The Append mode is not supported for this Source.
Schema and Primary Keys
Hevo uses the following schema to upload the records to the Destination. For a detailed view of the objects, fields, and relationships, click the ERD.
Data Model
The Amazon Ads data model is organized into the following sections:
-
Account Information: Contains basic details about your Amazon Ads account, such as advertiser profiles and portfolios.
-
Sponsored Products: Contains data about ads that promote individual products on Amazon. This includes information about campaigns and ad groups, the products, and the search terms customers use.
-
Sponsored Display: Contains data about ads that promote products to users based on their interests or shopping activity. This includes information about campaigns, ad groups, and the products being advertised.
Note: For Sponsored Display objects, Hevo uses the
sd_prefix in their names on the Configure Objects page.
Account Information
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
| Object | Description |
|---|---|
| Profile | Contains details of your Amazon Ads advertiser accounts, including the account ID, country, marketplace, account type, and currency used for daily budgets. |
| Portfolio | Contains details used to group related campaigns together in your Amazon Ads account, including the name, budget, and status. |
Sponsored Products
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
| Object | Description |
|---|---|
| Ad Group | Contains details of groups used to organize related ads, including the name, default bid, status, start date, and the campaign it belongs to. It includes a child object, Ad Group Serving Status Detail. |
| Ad Group Suggested Keyword | Contains words and phrases that Amazon Ads recommends using to target users for a specific ad group or campaign. |
| Ad Group Theme-Based Bid Recommendation | Contains Amazon’s suggested bid amounts for different products, categories, or audiences that you can target with an ad group, including the recommended targeting type. |
| Advertised Product Report | Contains daily performance data for each advertised product, identified by its Amazon Standard Identification Number (ASIN) or Stock Keeping Unit (SKU). Performance data includes impressions, clicks, cost, ad spend efficiency, sales, purchases, and units sold over different time periods, along with related budget and naming details for the campaign and ad group. |
| Campaign | Contains details about campaigns, including the campaign name, budget, bidding strategy, targeting type, start and end dates, state, and portfolio. It includes the following child objects: - Campaign Placement Bidding - Campaign Serving Status Detail - Campaign Tag |
| Campaign Level Report | Contains daily performance data for campaigns, such as clicks, cost, sales, purchases, units sold, and how often ads appeared at the top of search results, along with the campaign’s budget details. |
| Campaign Negative Keyword | Contains keywords excluded at the campaign level, including the keyword, match type, status, and whether it’s currently active. It includes a child object, Campaign Negative Keyword Serving Status Detail. |
| Campaign Placement Report | Contains daily performance data for campaigns, including clicks, cost, sales, purchases, and units sold, broken down by where the ad appeared. |
| Keyword | Contains the search terms you want to target with ads, including the keyword, match type, bid, translated keyword, and status. It includes a child object, Keyword Serving Status Detail. |
| Negative Keyword | Contains the search terms you want to exclude with ads, including the keyword, match type, translated keyword, and status. It includes a child object, Negative Keyword Serving Status Detail. |
| Negative Product Targeting | Contains products and categories excluded from targeting, including the exclusion type, status, and active status. It includes the following child objects: - Negative Targeting Expression - Negative Targeting Resolved Expression - Negative Targeting Serving Status Detail |
| Product Ad | Contains details about ads created to promote products, including the product’s ASIN and SKU, custom ad text, and the ad’s status. It includes a child object, Product Ad Serving Status Detail. |
| Purchased Product Keyword Report | Contains daily data about products that customers purchased after clicking an ad that appeared for a specific keyword. |
| Purchased Product Targeting Report | Contains daily data about products customers purchased after clicking an ad that appeared for a specific product, category, or audience. |
| Search Term Ad Keyword Report | Contains daily data about the words or phrases customers searched for before clicking an ad, including performance metrics such as clicks, cost, sales, purchases, and units sold. |
| Search Term Targeting Report | Contains daily data about the search terms customers used when they clicked an ad shown for a specific product or category, including the product or category that triggered the ad, clicks, cost, sales, purchases, and units sold. |
| Targeting Clause | Contains the products, categories, or audiences that an ad group is set up to target, along with the bid, targeting type, and status. It includes the following child objects: - Targeting Expression - Targeting Resolved Expression - Targeting Serving Status Detail |
Sponsored Display
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
| Object | Description |
|---|---|
| Ad Group | Contains details about a group of related ads, including its name, default bid, ad format, targeting approach, and status. |
| Campaign | Contains details about campaigns, including the campaign name, budget, cost type, targeting approach, portfolio, start and end dates, and status. |
| Product Ad | Contains details about product ads in an ad group, including the ad name, landing page, and status. |
| Targeting | Contains the products, categories, or audiences that an ad group is set up to target, including the targeting type, creation date, and status. It includes the following child objects: - Targeting Expression - Targeting Resolved Expression |
Additional Information
Read the detailed Hevo documentation for the following related topics:
Handling of Deletes
For the Profile object, Hevo uses a full data refresh approach to capture delete actions. During each Pipeline run, Hevo compares the data fetched from the Source object with the data present in the Destination table. If a record exists in the Destination but is no longer returned by the Source, the record is marked as deleted by setting the value of the metadata column __hevo__marked_deleted to True.
Limitation
- Currently, Hevo does not ingest data for Sponsored Brands ads from Amazon.