Amazon Ads Connector
Read and write Amazon Ads data effortlessly. Integrate, manage, and automate campaigns, ad groups, and performance metrics — almost no coding required.
Establish a two-way connection to query and load Amazon Ads data using SSIS, SQL Server, ETL platforms, reporting tools, any ODBC/JDBC-compatible application, or your preferred programming language.
Integrate Amazon Ads with these applications
Actions supported by Amazon Ads Connector
Amazon Ads Connector supports following actions for REST API integration:
Get Beta Report
Description
Generates and downloads an Amazon Ads report.
Parameters
You can provide the following parameters to this action:
-
Report Name -
Report Type -
Report Start Date (yyyy-MM-dd) Maximum date range: 31 days -
Report End Date (yyyy-MM-dd) Maximum date range: 31 days -
Report Start Date (yyyy-MM-dd) Maximum date range: 731 days -
Report End Date (yyyy-MM-dd) Maximum date range: 731 days -
Time Unit -
Group By -
Group By -
Group By -
Group By -
Group By -
Metrics -
Metrics -
Metrics -
Metrics -
Metrics -
Metrics
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Get Profiles
Description
Gets your Amazon Ads profiles.
Parameters
You can provide the following parameters to this action:
-
N/A
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
ProfileId -
CountryCode -
CurrencyCode -
DailyBudget -
Timezone -
AccountInfoMarketPlaceStringId -
AccountInfoId -
AccountInfoType -
AccountInfoName -
AccountInfoValidPaymentMethod -
UserId
Visit documentation for more information.
Get Report
Description
Downloads an Amazon Ads report.
Parameters
You can provide the following parameters to this action:
-
Record Type -
Report Date (yyyyMMdd) -
Metrics -
State Filter -
Campaign Type -
Segment
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Test Connection
Description
Endpoint to test connection.
Parameters
You can provide the following parameters to this action:
-
N/A
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Make Generic REST API Request
Description
This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.
Parameters
You can provide the following parameters to this action:
-
HTTP - Url or File Path -
HTTP - Request Body -
HTTP - Is MultiPart Body (Pass File data/Mixed Key/value) -
HTTP - Headers (e.g. hdr1:aaa || hdr2:bbb) -
Parser - Filter (e.g. $.rows[*] ) -
Download - Enable reading binary data -
Download - File overwrite mode -
Download - Save file path -
Download - Enable raw output mode as single row -
Download - Raw output data RowTemplate -
Download - Request Timeout (Milliseconds)
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Make Generic REST API Request (Bulk Write)
Description
This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.
Parameters
You can provide the following parameters to this action:
-
Url -
IsMultiPart -
Filter -
Headers
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.