Java
// Copyright 2018 Google LLC // // Licensed under the Apache License, Version 2.0 (the "License"); // you may not use this file except in compliance with the License. // You may obtain a copy of the License at // // https://www.apache.org/licenses/LICENSE-2.0 // // Unless required by applicable law or agreed to in writing, software // distributed under the License is distributed on an "AS IS" BASIS, // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. // See the License for the specific language governing permissions and // limitations under the License. package com.google.ads.googleads.examples.advancedoperations; import com.beust.jcommander.Parameter; import com.google.ads.googleads.examples.utils.ArgumentNames; import com.google.ads.googleads.examples.utils.CodeSampleParams; import com.google.ads.googleads.lib.GoogleAdsClient; import com.google.ads.googleads.v17.errors.GoogleAdsError; import com.google.ads.googleads.v17.errors.GoogleAdsException; import com.google.ads.googleads.v17.resources.AdGroupBidModifier; import com.google.ads.googleads.v17.services.GoogleAdsRow; import com.google.ads.googleads.v17.services.GoogleAdsServiceClient; import com.google.ads.googleads.v17.services.GoogleAdsServiceClient.SearchPagedResponse; import com.google.ads.googleads.v17.services.SearchGoogleAdsRequest; import java.io.FileNotFoundException; import java.io.IOException; import javax.annotation.Nullable; /** Gets ad group bid modifiers. */ public class GetAdGroupBidModifiers { private static class GetAdGroupBidModifiersParams extends CodeSampleParams { @Parameter(names = ArgumentNames.CUSTOMER_ID, required = true) private Long customerId; @Parameter(names = ArgumentNames.AD_GROUP_ID) private Long adGroupId; } public static void main(String[] args) throws IOException { GetAdGroupBidModifiersParams params = new GetAdGroupBidModifiersParams(); if (!params.parseArguments(args)) { // Either pass the required parameters for this example on the command line, or insert them // into the code here. See the parameter class definition above for descriptions. params.customerId = Long.parseLong("INSERT_CUSTOMER_ID_HERE"); // Optional: Specify an ad group ID to restrict search to only a given ad group. params.adGroupId = null; } GoogleAdsClient googleAdsClient = null; try { googleAdsClient = GoogleAdsClient.newBuilder().fromPropertiesFile().build(); } catch (FileNotFoundException fnfe) { System.err.printf( "Failed to load GoogleAdsClient configuration from file. Exception: %s%n", fnfe); System.exit(1); } catch (IOException ioe) { System.err.printf("Failed to create GoogleAdsClient. Exception: %s%n", ioe); System.exit(1); } try { new GetAdGroupBidModifiers().runExample(googleAdsClient, params.customerId, params.adGroupId); } catch (GoogleAdsException gae) { // GoogleAdsException is the base class for most exceptions thrown by an API request. // Instances of this exception have a message and a GoogleAdsFailure that contains a // collection of GoogleAdsErrors that indicate the underlying causes of the // GoogleAdsException. System.err.printf( "Request ID %s failed due to GoogleAdsException. Underlying errors:%n", gae.getRequestId()); int i = 0; for (GoogleAdsError googleAdsError : gae.getGoogleAdsFailure().getErrorsList()) { System.err.printf(" Error %d: %s%n", i++, googleAdsError); } System.exit(1); } } /** * Runs the example. * * @param googleAdsClient the Google Ads API client. * @param customerId the client customer ID. * @param adGroupId the ad group ID for which ad group bid modiifers will be retrieved. If {@code * null}, returns all ad group bid modifiers. * @throws GoogleAdsException if an API request failed with one or more service errors. */ private void runExample( GoogleAdsClient googleAdsClient, long customerId, @Nullable Long adGroupId) { try (GoogleAdsServiceClient googleAdsServiceClient = googleAdsClient.getLatestVersion().createGoogleAdsServiceClient()) { String searchQuery = "SELECT" + " ad_group.id, " + " ad_group_bid_modifier.criterion_id," + " campaign.id," + " ad_group_bid_modifier.bid_modifier," + " ad_group_bid_modifier.device.type," + " ad_group_bid_modifier.hotel_date_selection_type.type," + " ad_group_bid_modifier.hotel_advance_booking_window.min_days," + " ad_group_bid_modifier.hotel_advance_booking_window.max_days," + " ad_group_bid_modifier.hotel_length_of_stay.min_nights," + " ad_group_bid_modifier.hotel_length_of_stay.max_nights," + " ad_group_bid_modifier.hotel_check_in_day.day_of_week " + "FROM" + " ad_group_bid_modifier"; if (adGroupId != null) { searchQuery += String.format(" WHERE ad_group.id = %d", adGroupId); } searchQuery += " LIMIT 10000"; // Creates a request that will retrieve ad group bid modifiers. SearchGoogleAdsRequest request = SearchGoogleAdsRequest.newBuilder() .setCustomerId(Long.toString(customerId)) .setQuery(searchQuery) .build(); // Issues the search request. SearchPagedResponse searchPagedResponse = googleAdsServiceClient.search(request); // Iterates over all rows in all pages and prints the requested field values for the ad group // bid modifiers in each row. for (GoogleAdsRow googleAdsRow : searchPagedResponse.iterateAll()) { AdGroupBidModifier adGroupBidModifier = googleAdsRow.getAdGroupBidModifier(); System.out.printf( "Ad group bid modifier with criterion ID %d in ad group ID %d of campaign ID %d ", adGroupBidModifier.getCriterionId(), googleAdsRow.getAdGroup().getId(), googleAdsRow.getCampaign().getId()); // When working with an 'optional' protocol buffer field such as AdGroup.bidModifier, use // hasXX() to check if the field is set, and only retrieve the value using getXX() if // hasXX() returns true. See the protocol buffer documentation on field presence for more // information: // https://protobuf.dev/programming-guides/field_presence/#presence-in-proto3-apis if (adGroupBidModifier.hasBidModifier()) { // Prints the bid modifier value since it is set. System.out.printf( "has a bid modifier value of %.2f.%n", adGroupBidModifier.getBidModifier()); } else { // Does not print the bid modifier value since it is not set. Printing the result of // adGroupBidModifier.getBidModifier() in this case would be misleading, since it will // be 0. System.out.println("does NOT have a bid modifier value."); } // Gets a detailed message specific to the type of criterion. String criterionDetails = " - Criterion type: " + adGroupBidModifier.getCriterionCase() + " "; switch (adGroupBidModifier.getCriterionCase()) { case DEVICE: criterionDetails += "Type: " + adGroupBidModifier.getDevice().getType(); break; case HOTEL_ADVANCE_BOOKING_WINDOW: criterionDetails += "Min Days: " + adGroupBidModifier.getHotelAdvanceBookingWindow().getMinDays() + ", Max Days: " + adGroupBidModifier.getHotelAdvanceBookingWindow().getMaxDays(); break; case HOTEL_CHECK_IN_DAY: criterionDetails += "Day of the week: " + adGroupBidModifier.getHotelCheckInDay().getDayOfWeek(); break; case HOTEL_DATE_SELECTION_TYPE: criterionDetails += "Date selection type: " + adGroupBidModifier.getHotelDateSelectionType().getType(); break; case HOTEL_LENGTH_OF_STAY: criterionDetails += "Min Nights: " + adGroupBidModifier.getHotelLengthOfStay().getMinNights() + ", Max Nights: " + adGroupBidModifier.getHotelLengthOfStay().getMaxNights(); break; } System.out.println(criterionDetails); } } } }
C#
// Copyright 2019 Google LLC // // Licensed under the Apache License, Version 2.0 (the "License"); // you may not use this file except in compliance with the License. // You may obtain a copy of the License at // // http://www.apache.org/licenses/LICENSE-2.0 // // Unless required by applicable law or agreed to in writing, software // distributed under the License is distributed on an "AS IS" BASIS, // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. // See the License for the specific language governing permissions and // limitations under the License. using CommandLine; using Google.Ads.Gax.Examples; using Google.Ads.GoogleAds.Lib; using Google.Ads.GoogleAds.V17.Errors; using Google.Ads.GoogleAds.V17.Resources; using Google.Ads.GoogleAds.V17.Services; using Google.Api.Gax; using System; using static Google.Ads.GoogleAds.V17.Resources.AdGroupBidModifier; namespace Google.Ads.GoogleAds.Examples.V17 { /// <summary> /// This code example gets ad group bid modifiers. /// </summary> public class GetAdGroupBidModifiers : ExampleBase { /// <summary> /// Command line options for running the <see cref="GetAdGroupBidModifiers"/> example. /// </summary> public class Options : OptionsBase { /// <summary> /// The Google Ads customer ID for which the call is made. /// </summary> [Option("customerId", Required = true, HelpText = "The Google Ads customer ID for which the call is made.")] public long CustomerId { get; set; } /// <summary> /// The ad group ID for which ad group bid modiifers will be retrieved. /// </summary> [Option("adGroupId", Required = false, HelpText = "The ad group ID for which ad group bid modiifers will be retrieved.")] public long? AdGroupId { get; set; } } /// <summary> /// Main method, to run this code example as a standalone application. /// </summary> /// <param name="args">The command line arguments.</param> public static void Main(string[] args) { Options options = ExampleUtilities.ParseCommandLine<Options>(args); GetAdGroupBidModifiers codeExample = new GetAdGroupBidModifiers(); Console.WriteLine(codeExample.Description); codeExample.Run(new GoogleAdsClient(), options.CustomerId, options.AdGroupId); } /// <summary> /// Returns a description about the code example. /// </summary> public override string Description => "This code example gets ad group bid modifiers."; /// <summary> /// Runs the code example. /// </summary> /// <param name="client">The Google Ads client.</param> /// <param name="customerId">The Google Ads customer ID for which the call is made.</param> /// <param name="adGroupId">The ad group ID for which ad group bid modiifers will /// be retrieved.</param> public void Run(GoogleAdsClient client, long customerId, long? adGroupId) { // Get the GoogleAdsService. GoogleAdsServiceClient googleAdsService = client.GetService(Services.V17.GoogleAdsService); string searchQuery = @" SELECT ad_group.id, ad_group_bid_modifier.criterion_id, campaign.id, ad_group_bid_modifier.bid_modifier, ad_group_bid_modifier.device.type, ad_group_bid_modifier.hotel_date_selection_type.type, ad_group_bid_modifier.hotel_advance_booking_window.min_days, ad_group_bid_modifier.hotel_advance_booking_window.max_days, ad_group_bid_modifier.hotel_length_of_stay.min_nights, ad_group_bid_modifier.hotel_length_of_stay.max_nights, ad_group_bid_modifier.hotel_check_in_day.day_of_week, ad_group_bid_modifier.hotel_check_in_date_range.start_date, ad_group_bid_modifier.hotel_check_in_date_range.end_date FROM ad_group_bid_modifier"; if (adGroupId != null) { searchQuery += $" WHERE ad_group.id = {adGroupId}"; } searchQuery += " LIMIT 10000"; // Creates a request that will retrieve ad group bid modifiers. SearchGoogleAdsRequest request = new SearchGoogleAdsRequest() { CustomerId = customerId.ToString(), Query = searchQuery }; try { // Issue the search request. PagedEnumerable<SearchGoogleAdsResponse, GoogleAdsRow> searchPagedResponse = googleAdsService.Search(request); // Iterates over all rows in all pages and prints the requested field values for // the ad group bid modifiers in each row. foreach (GoogleAdsRow googleAdsRow in searchPagedResponse) { AdGroupBidModifier agBidModifier = googleAdsRow.AdGroupBidModifier; AdGroup adGroup = googleAdsRow.AdGroup; Campaign campaign = googleAdsRow.Campaign; Console.Write("Ad group bid modifier with criterion ID {0} in ad group " + "with ID {1} of campaign ID {2} ", agBidModifier.CriterionId, adGroup.Id, campaign.Id); // When working with an 'optional' protocol buffer field such as // AdGroup.bidModifier, use HasXX to check if the field is set, and only // retrieve the value if HasXX returns true. See the protocol buffer // documentation on field presence for more information: // https://protobuf.dev/programming-guides/field_presence/#presence-in-proto3-apis if (agBidModifier.HasBidModifier) { // Prints the bid modifier value since it is set. Console.WriteLine("has a bid modifier value of {0:0.00}.", agBidModifier.BidModifier); } else { // Does not print the bid modifier value since it is not set. Printing the // result of agBidModifier.BidModifier in this case would be misleading, // since it will be 0. Console.WriteLine("does NOT have a bid modifier value."); } string criterionDetails = " - Criterion type: " + $"{agBidModifier.CriterionCase}, "; switch (agBidModifier.CriterionCase) { case CriterionOneofCase.Device: criterionDetails += $"Type: {agBidModifier.Device.Type}"; break; case CriterionOneofCase.HotelAdvanceBookingWindow: criterionDetails += $"Min Days: {agBidModifier.HotelAdvanceBookingWindow.MinDays}," + $"Max Days: {agBidModifier.HotelAdvanceBookingWindow.MaxDays}"; break; case CriterionOneofCase.HotelCheckInDay: criterionDetails += $"Day of the week: " + $"{agBidModifier.HotelCheckInDay.DayOfWeek}"; break; case CriterionOneofCase.HotelDateSelectionType: criterionDetails += $"Date selection type: " + $"{agBidModifier.HotelDateSelectionType.Type}"; break; case CriterionOneofCase.HotelLengthOfStay: criterionDetails += $"Min Nights: {agBidModifier.HotelLengthOfStay.MinNights}," + $"Max Nights: {agBidModifier.HotelLengthOfStay.MaxNights}"; break; case CriterionOneofCase.HotelCheckInDateRange: criterionDetails += $"Start Date: {agBidModifier.HotelCheckInDateRange.StartDate}," + $"End Date: {agBidModifier.HotelCheckInDateRange.EndDate}"; break; } Console.WriteLine(criterionDetails); } } catch (GoogleAdsException e) { Console.WriteLine("Failure:"); Console.WriteLine($"Message: {e.Message}"); Console.WriteLine($"Failure: {e.Failure}"); Console.WriteLine($"Request ID: {e.RequestId}"); throw; } } } }
PHP
<?php /** * Copyright 2018 Google LLC * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * https://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ namespace Google\Ads\GoogleAds\Examples\AdvancedOperations; require __DIR__ . '/../../vendor/autoload.php'; use GetOpt\GetOpt; use Google\Ads\GoogleAds\Examples\Utils\ArgumentNames; use Google\Ads\GoogleAds\Examples\Utils\ArgumentParser; use Google\Ads\GoogleAds\Lib\OAuth2TokenBuilder; use Google\Ads\GoogleAds\Lib\V17\GoogleAdsClient; use Google\Ads\GoogleAds\Lib\V17\GoogleAdsClientBuilder; use Google\Ads\GoogleAds\Lib\V17\GoogleAdsException; use Google\Ads\GoogleAds\V17\Enums\DayOfWeekEnum\DayOfWeek; use Google\Ads\GoogleAds\V17\Enums\DeviceEnum\Device; use Google\Ads\GoogleAds\V17\Enums\HotelDateSelectionTypeEnum\HotelDateSelectionType; use Google\Ads\GoogleAds\V17\Errors\GoogleAdsError; use Google\Ads\GoogleAds\V17\Services\GoogleAdsRow; use Google\Ads\GoogleAds\V17\Services\SearchGoogleAdsRequest; use Google\ApiCore\ApiException; /** This example gets ad group bid modifiers. */ class GetAdGroupBidModifiers { private const CUSTOMER_ID = 'INSERT_CUSTOMER_ID_HERE'; // Optional: Specify an ad group ID below to restrict search to only a given ad group. private const AD_GROUP_ID = null; public static function main() { // Either pass the required parameters for this example on the command line, or insert them // into the constants above. $options = (new ArgumentParser())->parseCommandArguments([ ArgumentNames::CUSTOMER_ID => GetOpt::REQUIRED_ARGUMENT, ArgumentNames::AD_GROUP_ID => GetOpt::OPTIONAL_ARGUMENT ]); // Generate a refreshable OAuth2 credential for authentication. $oAuth2Credential = (new OAuth2TokenBuilder())->fromFile()->build(); // Construct a Google Ads client configured from a properties file and the // OAuth2 credentials above. $googleAdsClient = (new GoogleAdsClientBuilder())->fromFile() ->withOAuth2Credential($oAuth2Credential) // We set this value to true to show how to use GAPIC v2 source code. You can remove the // below line if you wish to use the old-style source code. Note that in that case, you // probably need to modify some parts of the code below to make it work. // For more information, see // https://developers.devsite.corp.google.com/google-ads/api/docs/client-libs/php/gapic. ->usingGapicV2Source(true) ->build(); try { self::runExample( $googleAdsClient, $options[ArgumentNames::CUSTOMER_ID] ?: self::CUSTOMER_ID, $options[ArgumentNames::AD_GROUP_ID] ?: self::AD_GROUP_ID ); } catch (GoogleAdsException $googleAdsException) { printf( "Request with ID '%s' has failed.%sGoogle Ads failure details:%s", $googleAdsException->getRequestId(), PHP_EOL, PHP_EOL ); foreach ($googleAdsException->getGoogleAdsFailure()->getErrors() as $error) { /** @var GoogleAdsError $error */ printf( "\t%s: %s%s", $error->getErrorCode()->getErrorCode(), $error->getMessage(), PHP_EOL ); } exit(1); } catch (ApiException $apiException) { printf( "ApiException was thrown with message '%s'.%s", $apiException->getMessage(), PHP_EOL ); exit(1); } } /** * Runs the example. * * @param GoogleAdsClient $googleAdsClient the Google Ads API client * @param int $customerId the customer ID * @param int|null $adGroupId the ad group ID for which ad group bid modifiers will be * retrieved. If `null`, returns from all ad groups */ public static function runExample( GoogleAdsClient $googleAdsClient, int $customerId, ?int $adGroupId ) { $googleAdsServiceClient = $googleAdsClient->getGoogleAdsServiceClient(); // Creates a query that retrieves ad group bid modifiers. $query = 'SELECT ad_group.id, ad_group_bid_modifier.criterion_id, campaign.id, ' . 'ad_group_bid_modifier.bid_modifier, ' . 'ad_group_bid_modifier.device.type, ' . 'ad_group_bid_modifier.hotel_date_selection_type.type, ' . 'ad_group_bid_modifier.hotel_advance_booking_window.min_days, ' . 'ad_group_bid_modifier.hotel_advance_booking_window.max_days, ' . 'ad_group_bid_modifier.hotel_length_of_stay.min_nights, ' . 'ad_group_bid_modifier.hotel_length_of_stay.max_nights, ' . 'ad_group_bid_modifier.hotel_check_in_day.day_of_week, ' . 'ad_group_bid_modifier.hotel_check_in_date_range.start_date, ' . 'ad_group_bid_modifier.hotel_check_in_date_range.end_date ' . 'FROM ad_group_bid_modifier'; if ($adGroupId !== null) { $query .= " WHERE ad_group.id = $adGroupId"; } $query .= " LIMIT 10000"; // Issues a search request. $response = $googleAdsServiceClient->search(SearchGoogleAdsRequest::build($customerId, $query)); // Iterates over all rows in all pages and prints the requested field values for // the ad group bid modifier in each row. foreach ($response->iterateAllElements() as $googleAdsRow) { /** @var GoogleAdsRow $googleAdsRow */ $adGroupBidModifier = $googleAdsRow->getAdGroupBidModifier(); printf( "Ad group bid modifier with criterion ID %d in ad group ID %d of campaign ID %d ", $adGroupBidModifier->getCriterionId(), $googleAdsRow->getAdGroup()->getId(), $googleAdsRow->getCampaign()->getId() ); // When working with an 'optional' protocol buffer field such as AdGroup::$bid_modifier, // use hasXX() to check if the field is set, and only retrieve the value using getXX() // if hasXX() returns true. See the protocol buffer documentation on field presence for // more information: // https://protobuf.dev/programming-guides/field_presence/#presence-in-proto3-apis if ($adGroupBidModifier->hasBidModifier()) { // Prints the bid modifier value since it is set. printf( "has a bid modifier value of %.2f.%s", $adGroupBidModifier->getBidModifier(), PHP_EOL ); } else { // Does not print the bid modifier value since it is not set. Printing the result of // $adGroupBidModifier->getBidModifier() in this case would be misleading, since it // will be 0. print 'does NOT have a bid modifier value.' . PHP_EOL; } $criterionDetails = ' - Criterion type: ' . $adGroupBidModifier->getCriterion() . ', '; switch ($adGroupBidModifier->getCriterion()) { case 'device': $criterionDetails .= 'Type: ' . Device::name($adGroupBidModifier->getDevice()->getType()); break; case 'hotel_advance_booking_window': $criterionDetails .= 'Min Days: ' . $adGroupBidModifier->getHotelAdvanceBookingWindow()->getMinDays() . ', '; $criterionDetails .= 'Max Days: ' . $adGroupBidModifier->getHotelAdvanceBookingWindow()->getMaxDays(); break; case 'hotel_check_in_day': $criterionDetails .= 'Day of the week: ' . DayOfWeek::name($adGroupBidModifier->getHotelCheckInDay()->getDayOfWeek()); break; case 'hotel_date_selection_type': $criterionDetails .= 'Date selection type: ' . HotelDateSelectionType::name( $adGroupBidModifier->getHotelDateSelectionType()->getType() ); break; case 'hotel_length_of_stay': $criterionDetails .= 'Min Nights: ' . $adGroupBidModifier->getHotelLengthOfStay()->getMinNights() . ', '; $criterionDetails .= 'Max Nights: ' . $adGroupBidModifier->getHotelLengthOfStay()->getMaxNights(); break; case 'hotel_check_in_date_range': $criterionDetails .= 'Start Date: ' . $adGroupBidModifier->getHotelCheckInDateRange()->getStartDate() . ', '; $criterionDetails .= 'End Date: ' . $adGroupBidModifier->getHotelCheckInDateRange()->getEndDate(); break; } print $criterionDetails . PHP_EOL; } } } GetAdGroupBidModifiers::main();
Python
#!/usr/bin/env python # Copyright 2018 Google LLC # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # https://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. """This example illustrates how to retrieve ad group bid modifiers.""" import argparse import sys from google.ads.googleads.client import GoogleAdsClient from google.ads.googleads.errors import GoogleAdsException def main(client, customer_id, ad_group_id=None): ga_service = client.get_service("GoogleAdsService") query = """ SELECT campaign.id, ad_group.id, ad_group_bid_modifier.criterion_id, ad_group_bid_modifier.bid_modifier, ad_group_bid_modifier.device.type, ad_group_bid_modifier.hotel_date_selection_type.type, ad_group_bid_modifier.hotel_advance_booking_window.min_days, ad_group_bid_modifier.hotel_advance_booking_window.max_days, ad_group_bid_modifier.hotel_length_of_stay.min_nights, ad_group_bid_modifier.hotel_length_of_stay.max_nights, ad_group_bid_modifier.hotel_check_in_day.day_of_week, ad_group_bid_modifier.hotel_check_in_date_range.start_date, ad_group_bid_modifier.hotel_check_in_date_range.end_date FROM ad_group_bid_modifier""" if ad_group_id: query += f" WHERE ad_group.id = {ad_group_id}" # Limit results to 10,000 rows as the number of bid modifiers can be large. query += " LIMIT 10000" search_request = client.get_type("SearchGoogleAdsRequest") search_request.customer_id = customer_id search_request.query = query results = ga_service.search(request=search_request) for row in results: modifier = row.ad_group_bid_modifier print( "Ad group bid modifier with criterion ID " f"'{modifier.criterion_id}', bid modifier value " f"'{modifier.bid_modifier or 0.00}', device type " f"'{modifier.device.type_.name}' was found in ad group with ID " f"'{row.ad_group.id}' of campaign with ID '{row.campaign.id}'." ) criterion_field = type(modifier).pb(modifier).WhichOneof("criterion") criterion_details = f" - Criterion type: {criterion_field}, " if criterion_field == "device": criterion_details += f"Type: {modifier.device.type_}" elif criterion_field == "hotel_advance_booking_window": criterion_details += ( f"Min Days: {modifier.hotel_advance_booking_window.min_days}, " f"Max Days: {modifier.hotel_advance_booking_window.max_days}" ) elif criterion_field == "hotel_check_in_day": criterion_details += ( f"Day of the week: {modifier.hotel_check_in_day.day_of_week}" ) elif criterion_field == "hotel_date_selection_type": criterion_details += f"Date selection type: {modifier.hotel_date_selection_type.type_}" elif criterion_field == "hotel_length_of_stay": criterion_details += ( f"Min Nights: {modifier.hotel_length_of_stay.min_nights}, " f"Max Nights: {modifier.hotel_length_of_stay.max_nights}" ) else: criterion_details = " - No Criterion type found." print(criterion_details) if __name__ == "__main__": parser = argparse.ArgumentParser( description="List ad group bid modifiers for specified customer." ) # The following argument(s) should be provided to run the example. parser.add_argument( "-c", "--customer_id", type=str, required=True, help="The Google Ads customer ID.", ) parser.add_argument( "-a", "--ad_group_id", type=str, required=False, help=( "The ad group ID. Specify this to list ad group " "bid modifiers solely for this ad group ID." ), ) args = parser.parse_args() # GoogleAdsClient will read the google-ads.yaml configuration file in the # home directory if none is specified. googleads_client = GoogleAdsClient.load_from_storage(version="v17") try: main( googleads_client, args.customer_id, ad_group_id=args.ad_group_id, ) except GoogleAdsException as ex: print( f'Request with ID "{ex.request_id}" failed with status ' f'"{ex.error.code().name}" and includes the following errors:' ) for error in ex.failure.errors: print(f'\tError with message "{error.message}".') if error.location: for field_path_element in error.location.field_path_elements: print(f"\t\tOn field: {field_path_element.field_name}") sys.exit(1)
Rita
#!/usr/bin/env ruby # Encoding: utf-8 # # Copyright 2018 Google LLC # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # https://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. # # This example gets ad group bid modifiers. require "optparse" require "google/ads/google_ads" def get_ad_group_bid_modifiers(customer_id, ad_group_id = nil) # GoogleAdsClient will read a config file from # ENV['HOME']/google_ads_config.rb when called without parameters client = Google::Ads::GoogleAds::GoogleAdsClient.new search_query = <<~QUERY SELECT ad_group.id, ad_group_bid_modifier.criterion_id, ad_group_bid_modifier.bid_modifier, ad_group_bid_modifier.device.type, ad_group_bid_modifier.hotel_date_selection_type.type, ad_group_bid_modifier.hotel_advance_booking_window.min_days, ad_group_bid_modifier.hotel_advance_booking_window.max_days, ad_group_bid_modifier.hotel_length_of_stay.min_nights, ad_group_bid_modifier.hotel_length_of_stay.max_nights, ad_group_bid_modifier.hotel_check_in_day.day_of_week, ad_group_bid_modifier.hotel_check_in_date_range.start_date, ad_group_bid_modifier.hotel_check_in_date_range.end_date, campaign.id FROM ad_group_bid_modifier QUERY if ad_group_id search_query << "WHERE ad_group.id = #{ad_group_id}" end search_query << " LIMIT 10000" response = client.service.google_ads.search( customer_id: customer_id, query: search_query, page_size: PAGE_SIZE, ) response.each do |row| ad_group_bid_modifier = row.ad_group_bid_modifier ad_group = row.ad_group campaign = row.campaign print "Ad group bid modifier with criterion ID #{ad_group_bid_modifier.criterion_id} in " \ "ad group ID #{ad_group.id} of campaign ID #{campaign.id} " if ad_group_bid_modifier.has_bid_modifier? puts "has a bid modifier value of #{sprintf("%.2f", ad_group_bid_modifier.bid_modifier)}." else puts "does NOT have a bid modifier value." end criterion_details = " - Criterion type: #{ad_group_bid_modifier.criterion}, " case ad_group_bid_modifier.criterion when :device criterion_details += "Type: #{ad_group_bid_modifier.device.type}" when :hotel_advance_booking_window hotel_advance_booking_window = ad_group_bid_modifier.hotel_advance_booking_window criterion_details += "Min Days: #{hotel_advance_booking_window.min_days}, " \ "Max Days: #{hotel_advance_booking_window.max_days}" when :hotel_check_in_day hotel_check_in_day = ad_group_bid_modifier.hotel_check_in_day criterion_details += "Day of the week: #{hotel_check_in_day.day_of_week}" when :hotel_date_selection_type hotel_date_selection_type = ad_group_bid_modifier.hotel_date_selection_type criterion_details += "Date selection type: #{hotel_date_selection_type.min_days}" when :hotel_length_of_stay hotel_length_of_stay = ad_group_bid_modifier.hotel_length_of_stay criterion_details += "Min Nights: #{hotel_length_of_stay.min_nights}, " \ "Max Nights: #{hotel_length_of_stay.max_nights}" when :hotel_check_in_date_range hotel_check_in_date_range = ad_group_bid_modifier.hotel_check_in_date_range criterion_details += "Start Date: #{hotel_check_in_date_range.start_date}, " \ "End Date: #{hotel_check_in_date_range.end_date}" else criterion_details = ' - No Criterion type found.' end puts criterion_details end end if __FILE__ == $0 PAGE_SIZE = 1000 options = {} # The following parameter(s) should be provided to run the example. You can # either specify these by changing the INSERT_XXX_ID_HERE values below, or on # the command line. # # Parameters passed on the command line will override any parameters set in # code. # # Running the example with -h will print the command line usage. options[:customer_id] = 'INSERT_CUSTOMER_ID_HERE' options[:ad_group_id] = nil OptionParser.new do |opts| opts.banner = sprintf('Usage: %s [options]', File.basename(__FILE__)) opts.separator '' opts.separator 'Options:' opts.on('-C', '--customer-id CUSTOMER-ID', String, 'Customer ID') do |v| options[:customer_id] = v end opts.on('-A', '--ad-group-id AD-GROUP-ID', String, '(Optional) AdGroup ID') do |v| options[:ad_group_id] = v end opts.separator '' opts.separator 'Help:' opts.on_tail('-h', '--help', 'Show this message') do puts opts exit end end.parse! begin get_ad_group_bid_modifiers(options.fetch(:customer_id).tr("-", ""), options[:ad_group_id]) rescue Google::Ads::GoogleAds::Errors::GoogleAdsError => e e.failure.errors.each do |error| STDERR.printf("Error with message: %s\n", error.message) if error.location error.location.field_path_elements.each do |field_path_element| STDERR.printf("\tOn field: %s\n", field_path_element.field_name) end end error.error_code.to_h.each do |k, v| next if v == :UNSPECIFIED STDERR.printf("\tType: %s\n\tCode: %s\n", k, v) end end raise end end
Perl
#!/usr/bin/perl -w # # Copyright 2019, Google LLC # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # # http://www.apache.org/licenses/LICENSE-2.0 # # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. # # This example gets ad group bid modifiers. use strict; use warnings; use utf8; use FindBin qw($Bin); use lib "$Bin/../../lib"; use Google::Ads::GoogleAds::Client; use Google::Ads::GoogleAds::Utils::GoogleAdsHelper; use Google::Ads::GoogleAds::Utils::SearchGoogleAdsIterator; use Google::Ads::GoogleAds::V17::Services::GoogleAdsService::SearchGoogleAdsRequest; use Getopt::Long qw(:config auto_help); use Pod::Usage; use Cwd qw(abs_path); sub get_ad_group_bid_modifiers { my ($api_client, $customer_id, $ad_group_id) = @_; # Create a query that retrieves ad group bid modifiers. my $search_query = "SELECT ad_group.id, ad_group_bid_modifier.criterion_id, campaign.id, " . "ad_group_bid_modifier.bid_modifier, " . "ad_group_bid_modifier.device.type, " . "ad_group_bid_modifier.hotel_date_selection_type.type, " . "ad_group_bid_modifier.hotel_advance_booking_window.min_days, " . "ad_group_bid_modifier.hotel_advance_booking_window.max_days, " . "ad_group_bid_modifier.hotel_length_of_stay.min_nights, " . "ad_group_bid_modifier.hotel_length_of_stay.max_nights, " . "ad_group_bid_modifier.hotel_check_in_day.day_of_week, " . "ad_group_bid_modifier.hotel_check_in_date_range.start_date, " . "ad_group_bid_modifier.hotel_check_in_date_range.end_date " . "FROM ad_group_bid_modifier"; if ($ad_group_id) { $search_query .= " WHERE ad_group.id = $ad_group_id"; } $search_query .= " LIMIT 10000"; # Create a search Google Ads request that will retrieve all ad group bid modifiers # using pages of the specified page size. my $search_request = Google::Ads::GoogleAds::V17::Services::GoogleAdsService::SearchGoogleAdsRequest ->new({ customerId => $customer_id, query => $search_query }); # Get the GoogleAdsService. my $google_ads_service = $api_client->GoogleAdsService(); my $iterator = Google::Ads::GoogleAds::Utils::SearchGoogleAdsIterator->new({ service => $google_ads_service, request => $search_request }); # Iterate over all rows in all pages and print the requested field values for the # ad group bid modifier in each row. while ($iterator->has_next) { my $google_ads_row = $iterator->next; my $ad_group_bid_modifier = $google_ads_row->{adGroupBidModifier}; my $ad_group = $google_ads_row->{adGroup}; my $campaign = $google_ads_row->{campaign}; printf "Ad group bid modifier with criterion ID %d, bid modifier value %s, " . "was found in an ad group with ID %d of campaign ID %d.\n", $ad_group_bid_modifier->{criterionId}, $ad_group_bid_modifier->{bidModifier} ? sprintf "%.2f", $ad_group_bid_modifier->{bidModifier} : "none", $ad_group->{id}, $campaign->{id}; my $criterion_details = " - Criterion type: '%s', "; if ($ad_group_bid_modifier->{device}) { $criterion_details = sprintf $criterion_details, "Device"; $criterion_details .= sprintf "Type: '%s'", $ad_group_bid_modifier->{device}{type}; } elsif ($ad_group_bid_modifier->{hotelAdvanceBookingWindow}) { $criterion_details = sprintf $criterion_details, "HotelAdvanceBookingWindow"; $criterion_details .= sprintf "Min Days: %d, Max Days: %d", $ad_group_bid_modifier->{hotelAdvanceBookingWindow}{minDays}, $ad_group_bid_modifier->{hotelAdvanceBookingWindow}{maxDays}; } elsif ($ad_group_bid_modifier->{hotelCheckInDateRange}) { $criterion_details = sprintf $criterion_details, "HotelCheckInDateRange"; $criterion_details .= sprintf "Start Date: %s, End Date: %s", $ad_group_bid_modifier->{hotelCheckInDateRange}{startDate}, $ad_group_bid_modifier->{hotelCheckInDateRange}{endDate}; } elsif ($ad_group_bid_modifier->{hotelCheckInDay}) { $criterion_details = sprintf $criterion_details, "HotelCheckInDay"; $criterion_details .= sprintf "Day of the week: %s", $ad_group_bid_modifier->{hotelCheckInDay}{dayOfWeek}; } elsif ($ad_group_bid_modifier->{HotelDateSelectionType}) { $criterion_details = sprintf $criterion_details, "HotelDateSelectionType"; $criterion_details .= sprintf "Date selection type: '%s'", $ad_group_bid_modifier->{hotelDateSelectionType}{type}; } elsif ($ad_group_bid_modifier->{hotelLengthOfStay}) { $criterion_details = sprintf $criterion_details, "HotelLengthOfStay"; $criterion_details .= sprintf "Min Nights: %d, Max Nights: %d", $ad_group_bid_modifier->{hotelLengthOfStay}{minNights}, $ad_group_bid_modifier->{hotelLengthOfStay}{maxNights}; } print $criterion_details, "\n"; } return 1; } # Don't run the example if the file is being included. if (abs_path($0) ne abs_path(__FILE__)) { return 1; } # Get Google Ads Client, credentials will be read from ~/googleads.properties. my $api_client = Google::Ads::GoogleAds::Client->new(); # By default examples are set to die on any server returned fault. $api_client->set_die_on_faults(1); my $customer_id = undef; my $ad_group_id = undef; # Parameters passed on the command line will override any parameters set in code. GetOptions( "customer_id=s" => \$customer_id, "ad_group_id=i" => \$ad_group_id ); # Print the help message if the parameters are not initialized in the code nor # in the command line. pod2usage(2) if not check_params($customer_id); # Call the example. get_ad_group_bid_modifiers($api_client, $customer_id =~ s/-//gr, $ad_group_id); =pod =head1 NAME get_ad_group_bid_modifiers =head1 DESCRIPTION This example gets ad group bid modifiers. =head1 SYNOPSIS get_ad_group_bid_modifiers.pl [options] -help Show the help message. -customer_id The Google Ads customer ID. -ad_group_id [optional] The ad group ID. =cut