Skip to main content

Google Ads

Google Ads (previously Google AdWords) is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web users.

Google Ads' system is based partly on cookies and partly on keywords determined by advertisers. Google uses these characteristics to place advertising copy on pages where they think it might be relevant. Advertisers pay when users divert their browsing to click on the advertising copy. Partner websites receive a portion of the generated income.

Connecting to the Google Ads​

Mammoth allows you to connect to your Google account and get the data into Mammoth.

  1. Select API & Databases from the 'Add Data' menu and click on Google Ads.
  1. Click on Sign in with Google and log into your Google account.

Logging into your Google Ads account

  1. Click on the account next.

Selecting an account

  1. Once your Google account is connected with Mammoth, you will be presented with a list of tables.
  • Select the desired table to get a preview.
  • Write a SQL query or run a test query and preview the result.
  • Click on Next.

Choosing tables

After you have selected the metrics you want to work on, you get options to configure your Dataset as follows -

  • Save as new dataset: You can use this option to rename the table and save it as a new dataset.
  • Retrieval frequency: This is to set the frequency of the data import.
  • Start retrieving: This is to decide when to initiate the data import - Now or Later.
  • On refresh: You can choose what happens to new data Schedule pull. There are three option to choose from - Replace all data, Add new data since data pull, Replace with new data since new pull.

Scheduling your Data Pulls​

You can start retrieving the data now or at a specific time. Further schedule the data imports to get the latest data from your Database at a certain time interval - just once, daily, weekly or monthly.

On every data pull from your Database, you also have options to - Replace all data, Add new data since data pull, or Replace with new data since new pull.

Scheduling data imports from Google Ads

On choosing options Add new data since data pull or Replace with new data since new pull, you will get an option to choose a unique sequence column. Using this column, on refresh, Mammoth will pick up all the rows that have greater value in this column than the previous data pull.

note

Google Ads allows selecting a date range for a data pull for a selected number of tables.