MYSQL ALTER Statement for TIMESTAMP Column to Change on Update

January 7th, 2011 Comments off

If you need to alter a TIMESTAMP column to update the column automatically when the contents of the row are changed, run the following MySQL ALTER statement against the table: Read more…

Categories: MySQL Tags: , ,

Thousands of Accounts in adCenter Sandbox account

November 23rd, 2010 Comments off
Today was the first time in a long time I accessed our sandbox environment in the MSN adCenter API version 7. To my suprise, when I called the getAccountsInfo method of the Customer Management service, I downloaded over 4,600 accounts Read more…

MSN adCenter Sample CustomerManagement.GetAccount() Raw SOAP Response

October 20th, 2010 Comments off

Here is a a sample of the raw SOAP from the production environment of MSN adCenter API v7 (ran using PHP and the built-in SOAP extension):

Read more…

MSN adCenter Sample CustomerManagement.GetAccount() Raw SOAP Request

October 20th, 2010 Comments off

Below is a sample of a production SOAP call using PHP and the built-in SOAP extension to call the GetAccount() function of the Customer Management service in version 7 of MSN adCenter API:

Read more…

MSN adCenter Parameter Restrictions (Param1, Param2, Param3)

October 18th, 2010 Comments off

MSN adCenter gives advertisers the ability to define their own parameters for use with ad copies and keywords. The names of these user defined parameter are aptly named: param1, param2, and param3. (You can find more about adCenter defined parameters here: As with most everything in life, there are some restrictions on what exactly you can do with those three user defined parameters. Here is a short list of those restrictions:

Read more…

Microsoft adCenter Dynamic Keyword Insertion to Boost Performance

October 18th, 2010 Comments off

Just like in Google AdWords, MSN adCenter gives advertisers the ability to use dynamic keyword and parameter insertion, not only in your ad copies, but also within your destination URLs for your ads or keywords.  The following is a list of dynamic keys that you can easily implement into your ad copies and destination URLs to increase click thru and conversion performance and gather more data on what exactly are triggering your consumers to click on your ad and ultimately convert on your site.

Read more…

adCenter API v7 Production Web Services Addresses

October 15th, 2010 Comments off

The following list contains a list of available production web services addresses for use in version 7 of the MSN adCenter API:

Administration Service -

Campaign Management –

Read more…

Limits in MSN AdCenter (Account, Campaign, AdGroups, etc.)

October 12th, 2010 Comments off

The MSN adCenter has a different set of limitations than what you may find in other PPC engines (such as Google AdWords). Here is a quick rundown of the account, campaign, campaign adgroups, adgroup ads, account keywords,  adgroup keywords, etc.

Accounts per Customer – 6

Read more…

Categories: adCenter API, MSN, SEM Tags: ,

Sample Request/Response for v201003 AdGroupService of AdWords API

June 18th, 2010 Comments off

Below are sample SOAP request and SOAP responses for a mutate operation against the v201003 AdGroupService through the Google AdWords API. The request was generated using the built-in PHP SOAP extension.

Read more…

Categories: Uncategorized Tags:

Google AdWords v201003 Sample rval for AdGroupReturnValue

June 17th, 2010 Comments off

Below is a sample rval object returned when adding a new adgroup to a AdWords campaign:

Read more…