Search our Knowledge Base

Google Ads

To integrate Google Ads data directly into your Rank Ranger account, an authorization script needs to be generated and added to the Google Ads account. Two options are available: Daily Ads updates and Historical Ads data import and storage in your Rank Ranger account for use in reports and graphs.

Each Rank Ranger campaign can be integrated with one Google Ads account. Google Ads campaigns can be filtered in the report and metric graph settings.
Google Ads Connection Tool

Generate Daily Google Ads Data Script

Google Ads Connection Tool
The Google Ads connection script generation tool is located in Tools > Utilities > Misc.

Google Ads Daily Updates        
  • Select a Campaign
  • Select the Daily option to enable daily updates of Google Ads data to Rank Ranger
  • Click the Generate button
  • Copy the Code
  • Proceed to the Authorize Google Ads Integration instructions below

Generate Historical Google Ads Data Script

Get Historical Ads Data for Reporting Trends

Integrate Historical Google Ads data

  • Select a Campaign
  • Select the Historical option for storage of Google Ads data
  • Select the Date Range for the data that you want imported to Rank Ranger
  • Click the Generate button
  • Copy the Code
  • Proceed to the Authorize Google Ads Integration instructions below

Authorize Google Ads Integration

Google Ads Tools
Access your Google Ads account and click the TOOLS icon and then select Scripts in the BULK ACTIONS section. 

Google Ads Tools Scripts

Add Script
Click the +Add script button 

add script

Click the AUTHORIZE link in the yellow bar 

Authorize script

Select a Google Account
This must be a Google account that has administrative permissions for Google Ads

select Google account

Click the Allow button

allow access

Add Script

This example is for Historical update which is a one-time script.

add Google Ads script
  • Name the script, we recommend using a name that is descriptive of the data to help anyone working in the Google Ads account understand what the script is for.
  • Paste the Rank Ranger script code into the box, overwriting their default content 
  • Click the SAVE link
  • Click Scripts

Additional Steps for Daily Updates
If this script is for DAILY updates, locate the new script in the list and click the pencil icon to edit it. 

script frequency
  • Set frequency to Daily and select a time and click Save
  • Select the Google Account

    choose account

  • Click the Allow button

    Authorize script

Script Status
Click the SCRIPT HISTORY tab to view the scripts that have processed (i.e., Status will be "Finished successfully" and they will display data in the Results column)             
Google Ads Scripts

Scripts Processed Today
Select Today in the calendar to determine if your new script has processed (it usually is not ready instantly, you may need to wait an hour).
scripts today

Script Action Options
If your new script isn't displayed in the Script History for today within an hour of creating it, you can click back to the Scripts screen and in the Actions column select the Run option. 

Script action options

Google Ads Insight Graph

Ads performance data directly from the Google Ads API* can be displayed in Insight Graphs and Single Metric Widgets, and displayed in branded Marketing Dashboards, Client Dashboards, and scheduled PDF Reports.
* Refer to integration instructions

Graph Settings
In both the Insight Graph and Metric Widgets:
  • Enter a Metric Name for display in the graph
  • Data Source: PPC
  • Type: Google Ads
  • Metric Options:
    • Avg CPC
    • Avg CPM
    • Avg CPV
    • Clicks
    • Conversions
    • Cost
    • CTR
    • Impressions
    • Views
  • Optional filters and settings include:
    • Ads Campaign: all campaigns combined or individual campaign
    • Markup on Cost or Avg CPC: percentage of markup over the actual cost or CPC. This can be useful if your client has given you an advertising budget and you want to include an overhead cost in that charge to be displayed in their graph. For example, if you want to add 50% to the Ads spend, then enter 50 in the Markup on Cost field.
    • Frequency: default is day, additional options are for week or month. This setting determines the frequency of data points on the line or column 
  • Select the desired color and other display and date settings, and click the Save button. 

Repeat for each individual metric that you want included on the graph.

Google Ads metrics graph settings

Google Ads Insight Graph Example

Google Ads Graph

Get the ultimate SEO tools with the Rank Ranger Software
Learn More About Rank Ranger