Amazon Ads Reporting

PDF

After authorized, you can open the notebook Ads_Reporting_Interface.ipynb and follow instructions to request a report from the Amazon Ads Reporting API.

Before generating the report, you’ll need to first execute the code cells in the Profiles section of this notebook to retrieve all your connected profiles in the specified regions. Refer to Profilesfor more information.

To create a report request, you need to provide the following values:

1. profile_id: The identifier of a profile.

2. region: The region where you want to submit the report request. Acceptable values include North America, Europe, and APAC. For Regions, see API endpoints.

3. table_name: An optional parameter. If you don’t specify a table name, the data lake will use the provided {Profile Id}-{Report Type Id} as the destination table.

4. authId: An optional parameter that selects right OAuth credentials to use when making API calls to this instance. You only need to specify it when multi-credential secrets configured.

5. request_body: Construct the report request body using the information from Creates a report request and Report types documentation. Dynamic Date functions can be used in the startDate and `endDate`fields of the request body.

Once you’ve entered these values, you can execute the code cell to send the report request.

The microservice provides the ability to schedule report requests on a customized cadence. You’ll need to define a schedule expression using the Cron format and provide a rule name.