Microsoft Ads - Search Automation RSAs

Overview

This task automates the creation and editing of Responsive Search Ads (RSAs) for Bing Ads accounts.

You can use it to:

Submit new RSAs or make edits to existing ones using input control sheet

Automatically generate a platform-ready bulk sheet

Choose between auto-submission to the ad engine or manual QA via Slack

Alli RSAs will send a CSV file containing the final RSAs to a Slack channel of your choice. This file can either be manually uploaded into the platform or submitted live—based on your configuration.

Variables

Name	Reference	Type	Required	Default	Options	Description
Sheet ID	HQ_SHEET_ID	Alphanumeric	➖	-	-	The Id of your Google Control Sheet that houses the HQ tab.
HQ Tab Name	HQ_TAB_NAME	Alphanumeric	➖	-	-	The tab name of your HQ tab. (likely just called 'HQ')
Slack Channel For Bulk Upload File	SLACK_CHANNEL_FOR_BULK_UPLOAD_FILE	Alphanumeric	✅	-	-	Without # The name of the slack channel you want the bulk upload file to be delivered to.
Slack Channel For Errors	SLACK_CHANNEL_FOR_ERRORS	Alphanumeric	✅	-	-	Without # The name of the slack channel you would like Alli RSA alerts to be sent.
People To At	PEOPLE_TO_AT	Alphanumeric	➖	-	-	Who you would like to be @'d when an Alli RSA Alert is sent via slack.
Match All Identifier	MATCH_ALL_IDENTIFIER	Alphanumeric	✅	All	-	The value which can be used to in either the Account Inclusions or Camp / Adgrp Inclusions columns to signify you would like to match to all possible options.
Communication Type	COMMUNICATION_TYPE	Select	✅	slack	Email: email Slack: slack Both Email and Slack: both	Where would you like to get the bulk upload sheet delivered
Email_Recipients	EMAIL_RECIPIENTS	Alphanumeric	➖	-	-	Email Recipients for delivering the bulk upload file
Output Type	OUTPUT_TYPE	Select	✅	bulk_sheet	Download bulk upload sheet: bulk_sheet Submit Live: submit_live	Choose your output type. You can choose to just get a bulk csv sheet that you can QA and upload manually. You can also choose to submit live. You will still get a bulk upload sheet for QA.
Ad Status	AD_STATUS	Select	✅	paused	PAUSED: paused ENABLED: enabled
Engine	ENGINE	Select	✅	google	Google: google Bing: bing
Google Login Customer id	GOOGLE_LOGIN_CUSTOMER_ID	Alphanumeric	➖	-	-	Google Ads login customer ID MCC ID(manager account).
Bing Ads Login Customer ID	BING_ADS_LOGIN_CUSTOMER_ID	Alphanumeric	✅	-	-
OAuth Code	OAUTH_AUTHORIZATION_CODE	Alphanumeric	✅	-	-	Authorization tokens needed for Bing Ads Access. In order to get credentials for OAuth Code, State, and Response, add credentials using the blue "Use Credentials" button at the top and then click on "add credential group". Then follow the instructions, and save credential group to be easily identifiable. The user adding the credential group must HAVE ACCESS to the bing ads account.
OAuth State	OAUTH_STATE	Alphanumeric	✅	-	-
OAuth Response	OAUTH_ACCESS_TOKEN_RESPONSE	Alphanumeric	➖	-	-

YAML

Below is the YAML template

YAML


source:
  template: Microsoft Ads - Search Automation RSAs
  inputs:
    HQ_SHEET_ID:
    HQ_TAB_NAME:
    SLACK_CHANNEL_FOR_BULK_UPLOAD_FILE:
    SLACK_CHANNEL_FOR_ERRORS:
    PEOPLE_TO_AT:
    MATCH_ALL_IDENTIFIER: All
    COMMUNICATION_TYPE: slack
    EMAIL_RECIPIENTS:
    OUTPUT_TYPE: bulk_sheet
    AD_STATUS: paused
    ENGINE: google
    GOOGLE_LOGIN_CUSTOMER_ID:
    BING_ADS_LOGIN_CUSTOMER_ID:
    OAUTH_AUTHORIZATION_CODE:
    OAUTH_STATE:
    OAUTH_ACCESS_TOKEN_RESPONSE:
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101