Amazon Ads
Amazon Ads is an advertising service that allows online merchants to present products on the Amazon platform.
Amazon Ads integration replicates data using the Amazon Ads API.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
To retrieve your credentials:
- Log into your Amazon Developer console.
- Select Login with Amazon.
- Click Create a New Security Profile.
You are required to provide several information to create a new profile. For more information, see Create an LWA security profile.
- From the Login with Amazon page, select Show Client ID and Client Secret.
- Copy and paste your client ID and client secret into a secured file.
- From the Security Profile Management page, copy and paste your security profile into a secured file.
Creating the connection
자세한 내용은 SaaS 응용 프로그램에 연결을 참조하십시오.
필수 연결 설정을 입력한 후 인증을 클릭합니다.
소스 응용 프로그램에 로그인하라는 메시지가 나타날 수 있습니다.
인증 코드를 포함하는 창이 표시됩니다.
코드를 클립보드에 복사하고 연결 대화 상자로 돌아갑니다.
소스에서 제공하는 코드로 인증 완료에 코드를 붙여넣고 확인을 클릭합니다.
팁 메모이 필드를 보려면 아래로 스크롤해야 할 수도 있습니다.상태가 확인됨이면 인증이 확인된 것입니다.
연결 이름에 연결 이름을 입력합니다.
연결이 만들어질 때 연결에 대한 메타데이터를 정의하려면 연결 메타데이터 열기를 선택합니다.
| Setting | Description |
|---|---|
| Data gateway | 사용 사례에 필요한 경우 데이터 이동 게이트웨이를 선택합니다. 정보 메모 이 필드는 데이터 이동 게이트웨이를 지원하지 않으므로 Qlik Talend Cloud 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이를 사용하지 않으려면 없음을 선택합니다. 데이터 이동 게이트웨이의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 Qlik 데이터 게이트웨이 - 데이터 이동를 참조하십시오. |
| Start Date | Enter the date, in the format MM/DD/YYYY, from which the data must be replicated from your source to your target. |
| Profiles | Profile associated with the Login with Amazon account. |
| Client ID | Client ID. |
| Client Secret | Client secret. |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 2.
Depending on your destination, table and column names may not appear as they are outlined below.
invoices
The invoices table contains info about the invoices in your Amazon Ads account.
Replication Method | CDC |
Primary Key | id |
Replication Keys | invoiceDate |
| Useful links |
portfolios
The portfolios table contains info about the portfolios in your Amazon Ads account.
Replication Method | CDC |
Primary Key | id |
Replication Keys | invoiceDate |
| Useful links |
profiles
The profiles table contains info about the profiles in your Amazon Ads account.
Replication Method | Full Table |
Primary Key | profileId |
| Useful links |
sponsored_brands_ad_creatives
Replication Method | CDC |
Primary Key | adId |
Replication Keys | lastUpdateTime |
| Useful links |
sponsored_brands_ad_groups
Replication Method | CDC |
Primary Key | adGroupId |
Replication Keys | extendedData.lastUpdateDate |
| Useful links |
sponsored_brands_ads
Replication Method | CDC |
Primary Key | adId |
Replication Keys | extendedData.lastUpdateDate |
| Useful links |
sponsored_brands_bid_recommendations
Replication Method | Full Table |
Primary Key | recommendationId |
| Useful links |
sponsored_brands_budget_rules_campaigns
Replication Method | Full Table |
Primary Key | campaignId |
| Useful links |
sponsored_brands_budget_rules
Replication Method | CDC |
Primary Key | ruleId |
Replication Keys | lastUpdatedDate |
| Useful links |
sponsored_brands_campaigns_budget_rules
Replication Method | CDC |
Primary Key | ruleId |
Replication Keys | lastUpdatedDate |
| Useful links |
sponsored_brands_campaigns
Replication Method | CDC |
Primary Key | campaignId |
Replication Keys | extendedData.lastUpdateDate |
| Useful links |
sponsored_brands_keywords
Replication Method | Full Table |
Primary Key | keywordId |
| Useful links |
sponsored_brands_negative_keywords
Replication Method | Full Table |
Primary Key | keywordId |
| Useful links |
sponsored_brands_negative_targets
Replication Method | Full Table |
Primary Key | targetId |
| Useful links |
sponsored_brands_product_targets
Replication Method | Full Table |
Primary Key | targetId |
| Useful links |
sponsored_brands_store_assets
Replication Method | Full Table |
Primary Key | assetID |
| Useful links |
sponsored_display_ad_groups
Replication Method | CDC |
Primary Key | adGroupId |
| Useful links |
sponsored_display_brand_safety_list
Replication Method | Full Table |
Primary Key | requestId |
| Useful links |
sponsored_display_budget_rules_campaigns
Replication Method | Full Table |
Primary Key | campaignId |
| Useful links |
sponsored_display_budget_rules
Replication Method | CDC |
Primary Key | ruleId |
Replication Key | lastUpdatedDate |
| Useful links |
sponsored_display_campaigns_budget_rules
Replication Method | CDC |
Primary Key | ruleId |
Replication Key | lastUpdatedDate |
| Useful links |
sponsored_display_campaigns
Replication Method | CDC |
Primary Key | campaignId |
Replication Key | lastUpdatedDate |
| Useful links |
sponsored_display_creatives
Replication Method | Full Table |
Primary Key | creativeId |
| Useful links |
sponsored_display_negative_targeting_clauses
Replication Method | CDC |
Primary Key | targetId |
Replication Key | lastUpdatedDate |
| Useful links |
sponsored_display_product_ads
Replication Method | CDC |
Primary Key | adId |
Replication Key | lastUpdatedDate |
| Useful links |
sponsored_display_targetings
Replication Method | CDC |
Primary Key | targetId |
Replication Key | lastUpdatedDate |
| Useful links |
sponsored_products_ad_groups
Replication Method | CDC |
Primary Key | adGroupId |
Replication Key | extendedData.lastUpdateDateTime |
| Useful links |
sponsored_products_ads
Replication Method | CDC |
Primary Key | adId |
Replication Key | extendedData.lastUpdateDateTime |
| Useful links |
sponsored_products_budget_rules
Replication Method | CDC |
Primary Key | ruleId |
Replication Key | lastUpdatedDate |
| Useful links |
sponsored_products_campaigns
Replication Method | CDC |
Primary Key | campaignId |
Replication Key | extendedData.lastUpdateDateTime |
| Useful links |
sponsored_products_keywords
Replication Method | CDC |
Primary Key | keywordId |
Replication Key | extendedData.lastUpdateDateTime |
| Useful links |
sponsored_products_negative_keywords
Replication Method | CDC |
Primary Key | keywordId |
Replication Key | extendedData.lastUpdateDateTime |
| Useful links |