Google Ads module reference

Applies to

Bridge by Smartsheet

Google Ads integration has no triggers

Use it with other Bridge integrations, such as Smartsheet, that include triggers.

Get Campaign Info

Use this module to pull an aggregated list of all performance metrics and details associated with a specific campaign.

An image of the Get Campaign module

Get Campaign Info

You can use data references in all these fields.

Name 
In this field, enter the name given to the branched state.

Customer ID 
In this field, enter a unique number assigned to each Google Ads account. Remove any special characters.

Manager Customer ID 
In this field, enter the unique ID assigned to the manager’s access to the Google Ads account. Remove any special characters. 

Campaign ID 
In this field, enter the unique number assigned to each campaign.

Export of performance metrics 

When you pull the performance metrics of a campaign within a date range, you’ll see these details:

  • Start Date: Shows the date in YYYY-MM-DD format
  • End Date: Shows the date in YYYY-MM-DD format
    • If you didn’t specify an end date, the module will use the current date.

Once Bridge executes the Get Campaign Info module, the following information will be available in the Run Log pane: 

  • Data
    • fieldMask: This field lists the keys for the values recorded in the State group.
    • Result: This group provides the details of the campaign in an array (group of values enclosed in parentheses). If there is no data to pull, there will be no result object. But the status in State (below) will still read Succeeded.
      • Campaign: Lists all available metrics. Below is an example of some of those listed in the output:
        • biddingStrategyType: Defined type 
          • UNSPECIFIED
          • UNKNOWN
          • COMMISSION
          • ENHANCED_CPC
          • INVALID
          • MANUAL_CPC
          • MANUAL_CPM
          • MANUAL_CPV
          • MAXIMIZE_CONVERSIONS
          • MAXIMIZE_CONVERSION_VALUE
          • PAGE_ONE_PROMOTED
          • PERCENT_CPC
          • TARGET_CPA
          • TARGET_CPM
          • TARGET_IMPRESSION_SHARE
          • TARGET_OUTRANK_SHARE
          • TARGET_ROAS
          • TARGET_SPEND
        • endDate: Shows a date in YYYY-MM-DD format
        • Name: Campaign name
        • resourceName: Path including account and campaign unique IDs
        • servingStatus: Status dependent on start and end dates
        • startDate: Shows date in YYYY-MM-DD format
        • Status: This shows one of the following status labels:
          • PAUSED
          • ENABLE
          • REMOVE
      • CampaignBudget
        • amountMicros: Value assigned in cost-per-thousand
        • resourceName
        • Shared_budget: Shows either of these values: True or False
      • Metrics 
        • allConversions: The total number of conversions, including all conversions regardless of the value of include_in_conversions_metric
        • allConversionsValue: The value of all conversions divided by the number of all conversions
        • clicks: Total number of clicks for the campaign
        • Conversions: The number of conversions
          • This only includes conversion actions with the include_in_conversions_metric attribute set to True
          • If you use conversion-based bidding, your bid strategies will optimize for these conversions
        • costMicros: The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period
        • impressions: Count of how often your ad has appeared on a search results page or website on the Google Network
        • Clickthrough Rate: The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions)
        • Segments: Campaigns separated by either device or Ad Network Type
  • State: Refer to this section to check if the module worked
    • Code: This is the success/error code the module returns from Smartsheet
    • Message: A system message the module returns from Smartsheet 
      • For example, if a module didn’t find the value, the message may be “Not found”
    • Status: This is the status the module returns from Smartsheet 
      • Succeeded: The system successfully found the information
      • Failed: The system didn’t find the information

Update Campaign Status

Use this module to change the campaign status when you update rows in your Smartsheet sheet.

An image of the Update Campaign Status fields

Update Campaign Status fields

You can use data references in all these fields.

Name 
In this field, enter the name given to the branched state.

Customer ID 
In this field, enter a unique number assigned to each Google Ads account. Remove any special characters.

Manager Customer ID 
In this field, enter the unique ID assigned to the manager’s access to the Google Ads account. Remove any special characters. 
This isn’t mandatory. Add this information only if applicable. 

Campaign ID 
In this field, enter the unique number assigned to each campaign

Status 
In this field, select one from this status list: 

  • PAUSED 
  • ENABLE 
  • REMOVE

Start Date 
In this field, enter the start date of the campaign period in YYYY-MM-DD format.

End Date
In this field, enter the end date of the campaign period in YYYY-MM-DD format.

Once Bridge executes the Update Campaign Status module, the following data will be available in the Run Log pane: 

  • Data
  • State: Refer to this section to check if the module worked 
    • Code: This is the success/error code the module returns from Smartsheet
    • Message: A system message the module returns from Smartsheet 
      • For example, if a module didn’t find the value, the message may be “Not found”
    • Status: This is the status the module returns from Smartsheet 
      • These are examples of status labels you may see:
        • Succeeded: The system successfully found the information
        • Failed: The system didn’t find the information