Java
// 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 // // 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.reporting; 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.v14.errors.GoogleAdsError; import com.google.ads.googleads.v14.errors.GoogleAdsException; import com.google.ads.googleads.v14.services.GoogleAdsRow; import com.google.ads.googleads.v14.services.GoogleAdsServiceClient; import com.google.ads.googleads.v14.services.GoogleAdsServiceClient.SearchPagedResponse; import com.google.ads.googleads.v14.services.SearchGoogleAdsRequest; import java.io.FileNotFoundException; import java.io.IOException; /** * Gets Hotel-ads performance statistics for the 50 Hotel ad groups with the most impressions over * the last 7 days. */ public class GetHotelAdsPerformance { private static final int PAGE_SIZE = 1_000; private static class GetHotelAdsPerformanceParams extends CodeSampleParams { @Parameter(names = ArgumentNames.CUSTOMER_ID, required = true) private Long customerId; } public static void main(String[] args) { GetHotelAdsPerformanceParams params = new GetHotelAdsPerformanceParams(); 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"); } 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 GetHotelAdsPerformance().runExample(googleAdsClient, params.customerId); } 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); } } private void runExample(GoogleAdsClient googleAdsClient, Long customerId) { // Creates a query that retrieves hotel-ads statistics for each campaign and ad group. // Returned statistics will be segmented by the check-in day of week and length of stay. String query = "SELECT " + " campaign.id, " + " campaign.advertising_channel_type, " + " ad_group.id, " + " ad_group.status, " + " metrics.impressions, " + " metrics.hotel_average_lead_value_micros, " + " segments.hotel_check_in_day_of_week, " + " segments.hotel_length_of_stay " + "FROM hotel_performance_view " + "WHERE segments.date DURING LAST_7_DAYS " + " AND campaign.advertising_channel_type = 'HOTEL' " + " AND ad_group.status = 'ENABLED' " + "ORDER BY metrics.impressions DESC " + "LIMIT 50"; // Constructs and issues a search request by specifying page size. SearchGoogleAdsRequest request = SearchGoogleAdsRequest.newBuilder() .setCustomerId(String.valueOf(customerId)) .setPageSize(PAGE_SIZE) .setQuery(query) .build(); // Iterates over all rows in all pages and prints the requested field values for each row. try (GoogleAdsServiceClient googleAdsService = googleAdsClient.getLatestVersion().createGoogleAdsServiceClient()) { SearchPagedResponse response = googleAdsService.search(request); for (GoogleAdsRow row : response.iterateAll()) { System.out.printf( "Ad group ID %d in campaign ID %d " + "with hotel check-in on %s and %d day(s) of stay " + "had %d impression(s) and %.2f average lead value (in micros) " + "during the last 7 days.%n", row.getAdGroup().getId(), row.getCampaign().getId(), row.getSegments().getHotelCheckInDayOfWeek(), row.getSegments().getHotelLengthOfStay(), row.getMetrics().getImpressions(), row.getMetrics().getHotelAverageLeadValueMicros()); } } } }
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.V13.Errors; using Google.Ads.GoogleAds.V13.Services; using Google.Api.Gax; using System; using System.Collections.Generic; namespace Google.Ads.GoogleAds.Examples.V13 { /// <summary> /// This code example gets Hotel-ads performance statistics for the 50 Hotel ad groups with /// the most impressions over the last 7 days. /// </summary> public class GetHotelAdsPerformance : ExampleBase { /// <summary> /// Command line options for running the <see cref="GetHotelAdsPerformance"/> 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> /// 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); GetHotelAdsPerformance codeExample = new GetHotelAdsPerformance(); Console.WriteLine(codeExample.Description); codeExample.Run(new GoogleAdsClient(), options.CustomerId); } /// <summary> /// Returns a description about the code example. /// </summary> public override string Description => "This code example gets Hotel-ads performance statistics for the 50 Hotel ad groups " + "with the most impressions over the last 7 days."; /// <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> public void Run(GoogleAdsClient client, long customerId) { // Get the GoogleAdsService. GoogleAdsServiceClient googleAdsService = client.GetService( Services.V13.GoogleAdsService); // Creates a query that retrieves hotel-ads statistics for each campaign and ad group. // Returned statistics will be segmented by the check-in day of week and length of // stay. String query = $@"SELECT campaign.id, campaign.advertising_channel_type, ad_group.id, ad_group.status, metrics.impressions, metrics.hotel_average_lead_value_micros, segments.hotel_check_in_day_of_week, segments.hotel_length_of_stay FROM hotel_performance_view WHERE segments.date DURING LAST_7_DAYS AND campaign.advertising_channel_type = 'HOTEL' AND ad_group.status = 'ENABLED' ORDER BY metrics.impressions DESC LIMIT 50"; try { // Issue a search request. PagedEnumerable<SearchGoogleAdsResponse, GoogleAdsRow> result = googleAdsService.Search(customerId.ToString(), query); // Display the results. foreach (GoogleAdsRow row in result) { Console.WriteLine( $"Ad group ID {row.AdGroup.Id} in campaign ID {row.Campaign.Id} " + $"with hotel check-in on {row.Segments.HotelCheckInDayOfWeek} and " + $"{row.Segments.HotelLengthOfStay} day(s) of stay had " + $"{row.Metrics.Impressions} impression(s) and " + $"{row.Metrics.HotelAverageLeadValueMicros:0.00} average lead value " + "(in micros) during the last 7 days."); } } 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 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 * * 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\Reporting; 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\V14\GoogleAdsClient; use Google\Ads\GoogleAds\Lib\V14\GoogleAdsClientBuilder; use Google\Ads\GoogleAds\Lib\V14\GoogleAdsException; use Google\Ads\GoogleAds\Lib\OAuth2TokenBuilder; use Google\Ads\GoogleAds\V14\Enums\DayOfWeekEnum\DayOfWeek; use Google\Ads\GoogleAds\V14\Errors\GoogleAdsError; use Google\Ads\GoogleAds\V14\Services\GoogleAdsRow; use Google\ApiCore\ApiException; /** * This example gets Hotel-ads performance statistics for the 50 Hotel ad groups with the most * impressions over the last 7 days. */ class GetHotelAdsPerformance { private const CUSTOMER_ID = 'INSERT_CUSTOMER_ID_HERE'; private const PAGE_SIZE = 50; 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 ]); // 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) ->build(); try { self::runExample( $googleAdsClient, $options[ArgumentNames::CUSTOMER_ID] ?: self::CUSTOMER_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 */ public static function runExample(GoogleAdsClient $googleAdsClient, int $customerId) { $googleAdsServiceClient = $googleAdsClient->getGoogleAdsServiceClient(); // Creates a query that retrieves hotel-ads statistics for each campaign and ad group. // Returned statistics will be segmented by the check-in day of week and length of stay. $query = "SELECT campaign.id, " . "campaign.advertising_channel_type, " . "ad_group.id, " . "ad_group.status, " . "metrics.impressions, " . "metrics.hotel_average_lead_value_micros, " . "segments.hotel_check_in_day_of_week, " . "segments.hotel_length_of_stay " . "FROM hotel_performance_view " . "WHERE segments.date DURING LAST_7_DAYS " . "AND campaign.advertising_channel_type = 'HOTEL' " . "AND ad_group.status = 'ENABLED' " . "ORDER BY metrics.impressions DESC " . "LIMIT 50"; // Issues a search request by specifying page size. $response = $googleAdsServiceClient->search($customerId, $query, ['pageSize' => self::PAGE_SIZE]); // Iterates over all rows in all pages and prints the requested field values for each row. foreach ($response->iterateAllElements() as $googleAdsRow) { /** @var GoogleAdsRow $googleAdsRow */ printf( "Ad group ID %d in campaign ID %d " . "with hotel check-in on %s and %d day(s) of stay " . "had %d impression(s) and %d average lead value (in micros) " . "during the last 7 days.%s", $googleAdsRow->getAdGroup()->getId(), $googleAdsRow->getCampaign()->getId(), DayOfWeek::name($googleAdsRow->getSegments()->getHotelCheckInDayOfWeek()), $googleAdsRow->getSegments()->getHotelLengthOfStay(), $googleAdsRow->getMetrics()->getImpressions(), $googleAdsRow->getMetrics()->getHotelAverageLeadValueMicros(), PHP_EOL ); } } } GetHotelAdsPerformance::main();
Python
#!/usr/bin/env python # 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 # # 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. """Demonstrates how to request Hotel ad performance statistics. This example gets Hotel ads performance statistics for the 50 Hotel ad groups with the most impressions over the last 7 days. """ import argparse import sys from google.ads.googleads.client import GoogleAdsClient from google.ads.googleads.errors import GoogleAdsException def main(client, customer_id): ga_service = client.get_service("GoogleAdsService") query = """ SELECT campaign.id, campaign.advertising_channel_type, ad_group.id, ad_group.status, metrics.impressions, metrics.hotel_average_lead_value_micros, segments.hotel_check_in_day_of_week, segments.hotel_length_of_stay FROM hotel_performance_view WHERE segments.date DURING LAST_7_DAYS AND campaign.advertising_channel_type = 'HOTEL' AND ad_group.status = 'ENABLED' ORDER BY metrics.impressions DESC LIMIT 50""" search_request = client.get_type("SearchGoogleAdsStreamRequest") search_request.customer_id = customer_id search_request.query = query stream = ga_service.search_stream(search_request) for batch in stream: for row in batch.results: campaign = row.campaign ad_group = row.ad_group hotel_check_in_day_of_week = row.segments.hotel_check_in_day_of_week hotel_length_of_stay = row.segments.hotel_length_of_stay metrics = row.metrics print( f'Ad group ID "{ad_group.id}" ' f'in campaign ID "{campaign.id}" ' ) print( f'with hotel check-in on "{hotel_check_in_day_of_week}" ' f'and "{hotel_length_of_stay}" day(s) stay ' ) print( f"had {metrics.impressions:d} impression(s) and " f"{metrics.hotel_average_lead_value_micros:d} average " "lead value (in micros) during the last 7 days.\n" ) if __name__ == "__main__": # GoogleAdsClient will read the google-ads.yaml configuration file in the # home directory if none is specified. googleads_client = GoogleAdsClient.load_from_storage(version="v14") parser = argparse.ArgumentParser( description=("Retrieves Hotel-ads performance statistics.") ) # 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.", ) args = parser.parse_args() try: main(googleads_client, args.customer_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)
Ruby
#!/usr/bin/ruby # Encoding: utf-8 # # Copyright:: 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 # # 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 Hotel-ads performance statistics for the 50 Hotel ad groups # with the most impressions over the last 7 days. require 'optparse' require 'google/ads/google_ads' def get_hotel_ads_performance(customer_id) # GoogleAdsClient will read a config file from # ENV['HOME']/google_ads_config.rb when called without parameters client = Google::Ads::GoogleAds::GoogleAdsClient.new ga_service = client.service.google_ads # Limits to the 50 keywords with the most impressions in the date range. # If you wish to exclude entries with zero impressions, include a # predicate in the WHERE statement like 'metrics.impressions > 0' query = <<~QUERY SELECT campaign.id, campaign.advertising_channel_type, ad_group.id, ad_group.status, metrics.impressions, metrics.hotel_average_lead_value_micros, segments.hotel_check_in_day_of_week, segments.hotel_length_of_stay FROM hotel_performance_view WHERE segments.date DURING LAST_7_DAYS AND campaign.advertising_channel_type = 'HOTEL' AND ad_group.status = 'ENABLED' ORDER BY metrics.impressions DESC LIMIT 50 QUERY response = ga_service.search(customer_id: customer_id, query: query, page_size: PAGE_SIZE) if response.response.results.empty? puts sprintf("The given query returned no entries:\n %s", query) return end response.each do |row| campaign = row.campaign ad_group = row.ad_group metrics = row.metrics segments = row.segments puts "Ad Group ID #{ad_group.id} in campaign ID #{campaign.id} with hotel "\ "check-in on #{segments.hotel_check_in_day_of_week} and "\ "#{segments.hotel_length_of_stay} day(s) of stay had #{metrics.impressions} "\ "impression(s) and #{metrics.hotel_average_lead_value_micros} average lead value "\ "(in micros) during the last 7 days." end end if __FILE__ == $PROGRAM_NAME 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' OptionParser.new do |opts| opts.banner = sprintf('Usage: ruby %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.separator '' opts.separator 'Help:' opts.on_tail('-h', '--help', 'Show this message') do puts opts exit end end.parse! begin get_hotel_ads_performance(options.fetch(:customer_id).tr("-", "")) 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 Hotel-ads performance statistics for the 50 Hotel ad groups # with the most impressions over the last 7 days. 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::V14::Services::GoogleAdsService::SearchGoogleAdsRequest; use Getopt::Long qw(:config auto_help); use Pod::Usage; use Cwd qw(abs_path); use constant PAGE_SIZE => 1000; # 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. my $customer_id = "INSERT_CUSTOMER_ID_HERE"; sub get_hotel_ads_performance { my ($api_client, $customer_id) = @_; # Create a query that retrieves hotel-ads statistics for each campaign # and ad group. Returned statistics will be segmented by the check-in # day of week and length of stay. my $search_query = "SELECT campaign.id, campaign.advertising_channel_type, " . "ad_group.id, ad_group.status, " . "metrics.impressions, metrics.hotel_average_lead_value_micros, " . "segments.hotel_check_in_day_of_week, segments.hotel_length_of_stay " . "FROM hotel_performance_view WHERE segments.date DURING LAST_7_DAYS " . "AND campaign.advertising_channel_type = 'HOTEL' " . "AND ad_group.status = 'ENABLED' " . "ORDER BY metrics.impressions DESC LIMIT 50"; # Create a search Google Ads request that will retrieve hotel-ads statistics # using pages of the specified page size. my $search_request = Google::Ads::GoogleAds::V14::Services::GoogleAdsService::SearchGoogleAdsRequest ->new({ customerId => $customer_id, query => $search_query, pageSize => PAGE_SIZE }); # 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 # each row. while ($iterator->has_next) { my $google_ads_row = $iterator->next; printf "Ad group ID %d in campaign ID %d with hotel check-in on %s " . "and %d day(s) of stay had %d impression(s) and %d average lead value " . "(in micros) during the last 7 days.\n", $google_ads_row->{adGroup}{id}, $google_ads_row->{campaign}{id}, $google_ads_row->{segments}{hotelCheckInDayOfWeek}, $google_ads_row->{segments}{hotelLengthOfStay}, $google_ads_row->{metrics}{impressions}, $google_ads_row->{metrics}{hotelAverageLeadValueMicros}; } 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); # Parameters passed on the command line will override any parameters set in code. GetOptions("customer_id=s" => \$customer_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_hotel_ads_performance($api_client, $customer_id =~ s/-//gr); =pod =head1 NAME get_hotel_ads_performance =head1 DESCRIPTION This example gets Hotel-ads performance statistics for the 50 Hotel ad groups with the most impressions over the last 7 days. =head1 SYNOPSIS get_hotel_ads_performance.pl [options] -help Show the help message. -customer_id The Google Ads customer ID. =cut