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.

Select API & Databases from the add menu and click on Google AdWords.

Click on New Connection and log in into your Google account.

Select the account and click on Next.

Once your Google account is connected with Mammoth, you will be presented with a list of reports.

Select the desired report to get the metrics in it.

Select the metrics you want to add as columns in the Dataset.

Click on Next .

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

Rename it in the data pull scheduling window.

Save it in a desired location in the Data Library from Adding file to option.

Scheduling your Data Pulls¶

You can start retrieving the data now or at a specific time according to your choice. You can also schedule the data pull in order to get the latest data from your Database at a certain time interval - every few minutes, daily, weekly or monthly.

On every data pull from your Database, you also have an option to either replace the older data or combine with older data.

On choosing Combine with older data option, 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.