About Openflow Connector for Amazon Ads¶

Note

The connector is subject to the Connector Terms.

This topic describes the basic concepts of Openflow Connector for Amazon Ads, its workflow, and limitations.

The Openflow Connector for Amazon Ads automatically ingests Amazon Ads data into your Snowflake account by using Amazon Ads Reporting API V3. Reporting API enables you to configure custom reports with selected report types, columns, filters and other groupings.

Workflow¶

A Amazon Ads administrator gets access to Reporting API by following the onboarding instructions, generates a refresh token and retrieves the client ID and client secret.
1. A Snowflake account administrator performs the following:
2. Downloads and imports the connector definition file into the Snowflake Openflow canvas.
3. Configures the connector with the required parameters, for example refresh token, report configuration, and database and schema names.
4. Runs the connector flow. The connector does the following:
  1. Fetches the specified report as specified in the connector configuration.
  2. Creates a temporary table and puts the report chunks in it.
  3. Creates a table in the provided destination schema.
  4. Synchronises data from the temporary table to the destination table.
  5. Removes the temporary table.
Marketing users with Snowflake access can view and perform operations on the data downloaded from Amazon Ads to destination tables.

Limitations¶

The connector supports incremental ingestion only for the daily value of Report Time Increment parameter.
Modification of the report definition when the processors are running might lead to data inconsistencies. To ensure consistency, stop the processors and clear the queues before updating the configuration.
If the Amazon Ads API rate limit is reached, the data doesn’t get ingested despite the connector attempting to pull data from the source system.

Next steps¶

Set up the Openflow Connector for Amazon Ads