Friday, November 8, 2013

Google Ads Developer Blog

Google Ads Developer Blog

Getting to know AWQL: It’s like SQL for AdWords

Posted: 07 Nov 2013 01:17 PM PST

If you want to get your campaign management data using the AdWords API, AWQL (AdWords Query Language) is a great choice. AWQL offers an SQL-like syntax for setting up your fields, ordering, paging, and predicates all in one simple string. AWQL is mainly used for reports, but is also supported with some services.

Services Supported

There are currently five services that support AWQL: CampaignService, CampaignCriterionService, AdGroupService, AdGroupCriterionService, and AdGroupAdService.

Here is a Java code comparison that finds the IDs and names of ad groups within a specific campaign. Using the standard methods, you have to set fields, ordering, paging, and predicates separately. 
  Selector selector = new Selector();  selector.setFields(new String[] {"Id", "Name"});  selector.setOrdering(new OrderBy[] {new OrderBy("Name", SortOrder.ASCENDING)});  selector.setPaging(new Paging(offset, PAGE_SIZE));  Predicate campaignIdPredicate =      new Predicate("CampaignId", PredicateOperator.IN, new String[] {campaignId.toString()});  selector.setPredicates(new Predicate[] {campaignIdPredicate});  AdGroupPage page = adGroupService.get(selector);
The same task can be done more simply using AWQL, as shown below. 
  String query =       "SELECT Id, Name" +       " WHERE CampaignId IN [%d]" +       " ORDER BY Name ASC" +       " LIMIT %d, %d";  query = String.format(query, campaignId, offset, PAGE_SIZE);  AdGroupPage page = adGroupService.query(query);
We also have plans to add support for AWQL to more services in upcoming releases.

Reporting Features

Within AdHoc reports, AWQL also supports the unique DURING clause, which is an easy way to filter results in a given date range. For example, if you were interested in finding campaigns with few impressions during October, you could run a query like this. 
  SELECT CampaignId, CampaignName, Clicks, Impressions  FROM CAMPAIGN_PERFORMANCE_REPORT  WHERE Impressions < 100  DURING 20131001,20131031
Remember that stats are only available via AdHoc reports.

We recommend using AWQL as an expressive, easy way to retrieve data from your AdWords campaigns. Please feel free to ask any questions on the AdWords API forum or on our Google+ page.

- Michael Cloonan, AdWords API Team

Introducing the Ad Review Center for AdMob

Posted: 07 Nov 2013 09:17 AM PST

The Ad Review Center is a new feature in AdMob that gives you more transparency and control over the ads which appear in your apps.

Ad Review Center lets you review ads before they appear in your app, and you can see the ads which have already shown in your app, to assess if you want to continue showing those ads to your users. It's particularly useful for brand-conscious developers.

The Ad Review Center is available to all AdMob developers globally. Getting started is easy: you can manually enable it within your account by visiting the Monetize tab of your account, then clicking 'Ad review center' in the left hand navigation and following the instructions. Once its set up, you can choose between two modes:

  • Run ads immediately. This mode gives you the most potential revenue. Ads of all targeting types (contextual, interest-based, and placement) automatically serve to your apps, taking into account whatever filters you've already set up in your account. You can then review the ads which have appeared and potentially block them from running again.
  • Hold ads for 24 hours. This mode applies to placement-targeted ads only, which are ads that advertisers have chosen to target to your app specifically. Ads are held up to 24 hours before showing in your apps, or until you explicitly approve them. If you don't take action within 24 hours, ads will begin showing in your app.

Holding and blocking ads can have a significant impact on your revenue, and ads which are awaiting review or have been blocked don't compete in the auction. We strongly recommend that you use the Run ads immediately mode, then review and take action if you don't want particular ads to appear again later.

More details about this new feature can be found on the AdMob Help Center.

Posted by Vishay Nihalani, Product Manager, AdMob
Posted by at

No comments:

Post a Comment