Google Ads

Our Google Ads connector enables simple API data extraction without writing a single line of code.

Automatic Data Synchronization

With the Google Ads connector in the Dataddo app you can sync your data automatically in hourly, daily, weekly, or monthly increments.

Available Fields

All available fields from the Google Ads API are listed here.

Rate Limits

All limitations for API calls are described on the Rate Limits page on the Google Ads Documentation.

How to create a Google Ads Data Source

To create a Google Ads data source, navigate to Sources at the top left of the Dataddo app.

   
Number 1

Sign in to your Dataddo account and click on Sources at the top of the page. Home Page - Data Source

Number 2

Click on Create Source in the top right corner.Data Sources - Create Source

Number 3 From the list of sources, choose Google Ads. You can type Google ads into the search bar to find the connector faster.
Google Ads - step 3
Number 4 From the drop-down menu, choose your Google Account connected to Dataddo, and then select Google Ads Account and Sub-account (if you use My Client Center). Click on Next to continue with the setup. Google Ads - step 4
a) Add new account
If you want to connect a new Google Account that is not on the list, click on Add Account. You will be redirected to the Google Sign In page to confirm the right account. Once you confirm, you will be redirected back to the Dataddo app.
Google Ads - step 4 add new account
Google Ads - step 4b
b) Authorize Google Account
If you have not authorized your Google Account with Dataddo, click on Authorize and you will be redirected to your account to log in.
Google Ads - step 4a
After you log in and give Dataddo the necessary permissions to access your data, you will be redirected back to the connector.
Number 5

Choose a Name for your Data Source, select the Report type, Metrics, Attributes and Segments. To continue to the next page, click Next.

NOTE: The fields depend on the Report type you select. You can select 70 metrics,100 attributes and 2 segments per source. There is also a minimum of at least one Metric and one Attribute.

TIP: The reporting types are:

  • Campaign Performance Report
  • Video Performance Report
  • Ad Performance Report
  • Keyboard Performance Report
  • Shopping Performance Report

Google Ads - step 5
Google Ads - step 5a

Number 6

On the Storage selection page, you can set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.

  • A) Click on the option Dashboarding App if you want your data to connect to applications such as Google Data Studio, Power BI, or Tableau.
  • B) Click on the option Data Warehouse, if you want your data to be sent to warehouse storage, e.g., MySQL, Big Query or PostgreSQL.
Google Ads - step 6
Number 7

Configure your snapshotting preferences by choosing your Data range, Sync type, Snapshotting frequency, Time and Timezone. Confirm your setup by clicking on Next.

NOTE: If you need to load historical data, check our guide.
Google Ads - step 7

Number 8 In the last step you can preview your data. Click on Save and your new Data Source is ready.
Google Ads - step 8 preview
* Broken view / Error message
If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are:
  • Date range - we recommend a smaller date range. If you need to load historical data, check our guide.
  • Invalid metrics, attribute or breakdowns, or their combination - you may not have any values for them.
Google Ads - step 8 broken preview

Congratulations, your new Data Source is ready!


Need assistance?

Feel free to contact us or create a ticket and we will help you setup the Data Source.