Archive for May, 2009

AdWords API Sandbox v2009 CampaignService->mutate() SOAP request

May 20th, 2009 1 comment

Here is an example of a successful, raw SOAP request to the mutate() operation of the AdWords API v2009 CampaignService that was made on May 20, 2009:

Read more…

Search Marketing API GeoTargeting Limitations

May 7th, 2009 Comments off

I have had the ‘priviledge’ of spending a good amount of time with the Yahoo Search Marketing API as of late, and I must say, while having the ability to use an API to connect to a Yahoo Search Marketing account is awesome, I am less then impressed with how Yahoo has implemented many of it’s services and operations.  One topic area that has had my attention recently is working with the TargetingService operations and being able to programmatically update the GeoLocations of a campaign and/or adgroup. Maybe I am taking this ability for granted, but it would definitely be nice to geotarget more than 250 geolocations at once within a campaign/adgroup. Not only that, I w0uld highly suggest to Yahoo, and I have, that this limit be specifically stated in the Yahoo Search Marketing API documentation.  I have checked the release notes, the updateTargetingProfileForCampaign operation notes, and all of the child documentation for that operation. Even when you log into the Yahoo! Marketing Solutions user interface and drill down into the Campaign Settings for a campaign, there is no mention of any sort of limitation on the number of locations you can geotarget.

Quickly duplicating MySQL table structures

May 1st, 2009 Comments off

I often find myself duplicating table structures to either do some testing or duplicating a database structure from one database to another. Most of the time,  I find that I do not need to copy the existing data to the new database table. The easiest way I have found to do this is using MySQL’s CREATE TABLE…LIKE… () syntax. Even the most basic form can fulfill most requirements. This form could be something like:

CREATE TABLE `bar` LIKE `foo`;

For the MySQL 5.1 reference page, go here:

Categories: MySQL Tags: ,