Connect Amazon Ads to BigQuery

Transform complex raw data into meaningful insights with Coupler.io. The whole process to connect Amazon Ads to BigQuery will take several minutes through a three-step journey.

Sign in to your Coupler.io account or create a new one without any credit card requirements. Then, add a new importer and put Amazon Ads as a source and BigQuery as a destination.

Step 1: Collect data
Link your Amazon Ads account to grant Coupler.io read-only permissions. Afterward, select the account from where to extract data. Then, select one of the report types available on the list: Mention the start and end dates for the reporting period and select those metrics you’d like to see in your report.



Step 2: Organize & Transform
Before you export Amazon Ads to BigQuery, it’s a good practice to prepare and preprocess your data. That way, it will arrive ready for analysis and other operations in BigQuery. Coupler.io offers the following options for data preparation:

• Column Management: Hide/unhide columns, rename them, and change their order and data types according to your needs.
• Calculable Columns: Add new columns that perform calculations using formulas supported by Coupler.io.
• Data Filtering: Apply filters to your dataset so you can extract precise insights based on specific criteria.

Step 3: Load and schedule refresh
To import data from Amazon Ads to BigQuery, it’s also necessary to set up the destination properly. For that, go to the Destination tab, connect to BigQuery, and select the existing dataset or table. Coupler.io will automatically detect the table schema, but you can manually toggle this parameter off and indicate the table schema manually.



Once the destination is set up, you can save and run the importer right away or enable automatic data refresh in the next tab.

Take your data transfer to the next level with Coupler.io’s automatic data refresh. The available intervals for data updates are 15 minutes, 30 minutes, 1 hour, 1 week, and 1 month. However, you can also specify the days of the week and the exact time at which integration should occur. Such automation ensures that BigQuery always reflects the most recent Amazon Ads data. This helps you maintain up-to-date tracking dashboards for your ad campaign. It also enables you to make informed decisions on ad spending.