Hidehisa Watch

%a
abbreviated weekday name according to the current locale
%A
full weekday name according to the current locale
%b
abbreviated month name according to the current locale
%B
full month name according to the current locale
%c
preferred date and time representation for the current locale
%h
same as %b
%p
either “AM” or “PM” according to the given time value, or the corresponding strings for the current locale
%P
like %p, but lower case
%r
time in AM and PM notation equal to %I:%M:%S %p
%x
preferred date representation for the current locale without the time
%X
preferred time representation for the current locale without the date

Thanks to a variety of developers, here are four solutions that can transform you from a reporting monkey to an analysis ninja (as Avinash would say).

* VBA Macros - The simplest solution of them all. Mikael Thuneberg’s page explains how to make API requests directly from Excel using VBA Scripts and includes a pre-built Excel worksheet to get you started.

* The Tatvic Excel Plugin - Another easy-to-use plugin for Windows users that supports both Excel 2003 and Excel 2007. To get started you download the plugin then register to use the tool. Its simple UI helps you build complex queries and get data from Analytics right into your Excel worksheet.

Tatvic’s Plugin Query Builder

* Excellent Analytics - Is an open-source initiative by Mark Red and Dropit. This Excel 2007 plugin works on Vista/XP and comes with a query builder to help you create Google Analytics queries and pull data right into Excel. Webanalytics.info put together a great step by step tutorial to get started using this plugin.

Excellent Analytic’s Query Builder Interface

*
ShufflePoint - Works somewhat differently than the solutions above. ShufflePoint has developed a query language that works with the Google Analytics API to achieve common tasks, such as defining the last 30 days as a date range. One then uses this language to construct an Analytics Data Export API query either by navigating to a URL within Excel, or by using their web-based query builder, then importing this data into Excel. This process allows the ShufflePoint solution to work across most versions of Excel, as well as Powerpoint, and iGoogle gadgets.

Shufflepoint’s Web Based Query Builder

We continue to be impressed by the new solutions developers are bringing to market by leveraging the Google Analytics Platform. If you have developed a useful new tool or integration on top of Google Analytics, drop us an email at analytics-api@google.com. If it’s innovative and useful we’ll highlight it to our readers on this blog.

PHPで仕事をするときの注意(備忘のため）

http://slashdot.jp/askslashdot/comments.pl?sid=389009&cid=1290697
から、本文も引用しておく

* コーディング規約を守る。組織にコーディング規約がないなら、Zend Framework PHP標準コーディング規約 [zend.com]を使う。オレ流コーディングスタイルは禁止。
* 内部コードにはEUC-JPかUTF-8を使う。入出力もできるだけShift JISを避ける。Shift JISを使う場合には2byte目に0x5Cを含む文字の動作を忘れずに確認する。
* 開発環境の警告レベルをE_STRICTにする。本番環境ではdisplay_errorsをオフにする。
* register_globals、magic_quotesはオフにする。
* type hintingを積極的に使う。
* スコープの長い配列をクラスでラップする。
* プレゼンテーションとロジックを分割すること。プレゼンテーションには変数または関数の出力とループ以外のロジックを残さないこと。ロジックの中で直接出力をしないこと。ロジックはSimpleTestを使って単体テストすること。
* SQL文に変数を埋め込むときにはプレースホルダを使う（PDOのprepareとbindParams）。
* リクエストから取得したパラメータを出力するときはhtmlspecialcharsを使う。
* 関数が長くなったら分割する（composite methodパターンを使おう）。
* グローバル変数を使うのは避ける。
* 変数を定数として使わない。定数はdefineで定義するか、const宣言する。
* 常に最新バージョンでテストできる環境を作り、サービスイン後もバージョンアップに対応するための予算をとっておく（サービスイン後にお金をかけたくないなら、PHPは避けるべき）。
* 継承を使うなら、クラス図くらいは書いておく（単にコードを再利用したいだけなら、移譲を検討すること）。
* 各URLにおけるパラメータとその閾値を文書化すること。パラメータの閾値の境界線についてソースレビューし、テストすること。
* 既存のフレームワークを学習することに投資すること（学習コストを嫌って自己流のフレームワークを作ることは、バグを作りこむことになるのでかえってコスト高になる）。
* PHPしか使えない作業者の成果物はこまめにレビューすること。
* 設計を重視すること。
* コピー＆ペーストプログラミングの匂いを発見したら、そのコードを書いた人にプログラミングの基礎を教えること。
* リファクタリングの時間をスケジュールに入れること。
* require/includeを条件文や関数宣言の中に記述しないこと。

チューニングの手順 †

• MySQLチューニング
• MySQL サーバーを調整する
• MySQLちょっと上級チューニング

• 限界までMySQLを使い尽くす!!

• はじめてのMySQLチューニング
  • 第５回：key_buffer_sizeの違いによるパフォーマンス比較
  • 第６回：query_cache_sizeの違いによるパフォーマンス比較

• MySQLのパラメータチューニング

• MySQL：インデックスまとめメモ
• MySQLの最適化
• 【MySQLウォッチ】第8回 MySQLチューニングのテクニック

• MySQLの内部構造

• MySQLの最適化
  • サーバパラメータのチューニング
  • MySQL でのメモリの使用
  • システム変数
  • 動的システム変数
• Default value of tmp_table_size is meaningless
• MySQLサーバステータス

• MySQLの最適化
• サーバー設定を見直してMySQLの性能を引き出す
• MySQLのチューニング
• 5分でできる、MySQLのメモリ関係のチューニング！
• MySQLチューニング

• MySQLパフォーマンス・チューニング
• MySQLのクエリを最適化する10のTips
• 「ちょっと待て」 真・MySQLのクエリを最適化する10のTips
• MySQL Performance Blog
  • MySQL Performance Presentations
• Top 84 MySQL Performance Tips

• MySQL Performance Tuning Key
  • [MySQL Performance Tuning Primer:http://day32.com/MySQL/]]

InnoDBのデータファイルの調整 †

• 拡張され続ける InnoDB のデータファイルのサイズを小さくする方法
• 【MySQLウォッチ】第32回 MySQL Enterprise 最初のバージョンアップとデータベースファイルのリサイズ

ツール †

Maatkit †

• MOONGIFT: » MySQLの高度な管理ツール「Maatkit」

mytop †

MySQL Activity Report †

• レポート例

mysqlreport †

複数実行 †

• 同じマシン上での複数 MySQL サーバの実行

webサーバのキャッシュ更新方法 (2007/09/21追記)

* ロードバランサから落とし、Apacheを再起動後に、apc_compile_file()で、ユーザのアクセスをトリガにするのではなく、PHPスクリプトをopcodeキャッシュに変換していく。さらに、Serialize形式で配布されたデータをunserializeしてapc_storeで共有メモリに格納し、それが終わったらサービスインさせる
* ここが特殊かも。ユーザアクセスをトリガにすると、アクセスが多い場合に同時に同じファイルのキャッシュを生成をしようとしたりして無駄が発生するらしい(そんなサービス作ったことないから知らない)のですが、こうやって予め作ってサービスインさせると、最初のアクセスからキャッシュが利用されるようになり効率がいいのかとおもいます。

ロック機構を pthread mutex lock に

* デフォルトはFile Lock。pthred mutex lockは”Experimental”扱い。(—enable-apc-pthreadmutexでビルド。その他のオプションはconfig.m4参照)

apc_store()、apc_fetch()をうまく使ってファイルやDBアクセスを減らすと、効果があるかもしれません。 (自分だと、例えば設定がXMLで書かれているときに、1度だけXMLを解析、配列にしてapc_store()しておくってのをよくやります)

This last one works, is non-destructive, but there is one
modification.

After you rename the directory data_files to data_files.old, create a
new directory/folder called “data_files” — without this, sync won’t
be able to save your settings and won’t connect. It’ll just keep
prompting you for your user name and password. This was the case on
my system (Vista).

In Vista, the directory is
C:\Users\\AppData\Local\Google\Google Calendar Sync
\data_files

1) rename the data_files directory to data_files.old
2) create a new directory named data_files
3) restart gcal sync - you’ll be prompted to enter your username and
pw again
4) synchronize

Hope that helps.

For Google Calendar Sync to work, your calendar appointments message class has to be: IPM.Appoinment

If it is not that EXACT message class it will not sync. A different message will occur if someone has used a custom form to send you an appointment request. To view your message class:

Open Outlook Calendar on the computer.Choose View > Current View > Events.For Windows Vista, choose View > Current View > Customize Current View.
For Windows XP, choose View > Arrange By > Current View > Customize Current View.Click the Fields button and choose All Appointment fields from the pop-up menu in the “Select available fields from” section.In the “Available Fields” column, select “Message Class” and click the Add button.Click OK.Click OK.This will show you what each appointments message class is. See any correlation to missing appointments and them being something different than IPM.Appointments? They probably look like: IPM.Appoinments.Something. I sure did in mine.

Next step: Change your appointments back to the standard message class.

Apparently, there are all sorts of ways to do this, but the easiest way I have found was to download this program: DocMessageClass

I downloaded it from this site:
http://www.publicshareware.us/public-share-outlook-utilities.php

You just run the app (no installation) and select your calendar folder. It will populate the list of all available message classes. Select all EXCEPT for IPM.Appointment and convert them into IPM.Appointment.

BOOM! Successful sync of all my events.

FYI: I actually found the answer to this because the iPhone suffers from a similar issue.

This is NOT the best fix. It is only a workaround that I’ve found. Now, everyone yell at Google to fix this.

Once you have identified your goals and KPIs and created your list of 100-250,000 targeted, rank-influencing link prospects (we crawl to build our large scale link prospect lists) you must further analyze them to identify those that will help you meet your link building goals. Remember, the criteria you set for qualifying link prospects must follow from your goals.

Even if you don’t create link prospect sets in the hundreds of thousands you may find our qualifiers useful. At the end of the article you’ll find all 55.

We recommend a 2-step approach in the qualification stage. First, use automated methods to focus on easily measurable factors to cull the list down to those urls most beneficial to your goals. Then use a by-hand, human review to further qualify and segment the best link opportunities.

In 3 Goals and 20 KPIs for Large Scale Link Building Campaigns we proposed 3 possible goals for link building. For the sake of continuity we’ll stick to those goals as we discuss data points for automated and by-hand link prospect analysis.

Sample Link Building Goals:
1) Increase conversions through targeted search traffic
2) Increase conversions from targeted referral traffic
3) Increase conversions from positive mentions by influential media

Even if our sample link building goals don’t match yours, walking through our automated and by-hand qualifiers will help you to brainstorm possibilities for your large scale link building campaign.

1) Increase conversions through targeted search traffic
Conversions are valuable actions that people can make on your website, including direct sales, signing up for a newsletter, requesting more information, downloading a white paper and more. By now you have identified your high-conversion key phrases and can use these as seeds for generating your link prospect list. Links from the sites that currently influence rankings for your converting search terms increases your rank for these terms.

Goal 1 Automated Qualifiers:
Primarily these metrics and measures help you identify the most rank-influencing web pages from amongst your prospects. Each one of these data points is a knob you can twist to fine tune your target urls to your goals. This is far from a comprehensive list, but will give you a good starting point.

-Keywords appear in target URL
-Keywords appear in target URL title tag
-Keywords appear in H1 tags
-Keyword occurrences in body text
-Keyword occurrences in Meta keywords and description
-Number of outbound links on target URL
-Number of inbound links to target url
-Number of inbound links to domain
-Followed/NoFollowed outbound links
-Competitor URLs
-Excessive Ad Placements
-PageRank of URL
-PageRank of Domain
-Domain age
-Page type (social network, blog, answers page, forum, links page, etc)

Goal 1 By-Hand Qualifiers:
Once you’ve whittled your stack of URLs down considerably using the automated qualifiers it’s time to start going through your URLs one by one. Get out your magnifying glass, fine toothed comb and whatever elixir you prefer that helps you concentrate for long periods of time (we prefer coffee ;).

-Is there genuine relevance between the page and the page you’re building links to?
-Is it a previously-unidentified competitor?
-Is the text human-generated?
-Are there excessive, obtrusive ads?
-What motivated the current links on the target URL?
-Recent posts, recent site updates, updated copyright date?
-At first pass is the text correct in grammar and spelling?
-What is the design and image quality?
-How thorough and well tended does the resources/links page seem?
-Is there more than one links page?
-When was the last update?
-Is the site owner/moderator easily accessible by email or phone?
-Is there a comments box?
-What is the quality of comments and conversation there now?

2) Increase conversions through targeted referral traffic
Referral traffic are your site visitors who clicked links on other websites to get to your website. Targeted referral traffic - from sites that cater to your target market - can deliver higher conversion rates than search traffic. When targeting this type of traffic growth you need not be concerned with nofollow tags. You DO need to be highly concerned with tracking conversions.

Goal 2 Automated Qualifers:
In targeting this type of link opportunity you’re less concerned with the signals that the site deliberately gives to search engines and more concerned with what they say to visitors and their standing in their space.

-Keywords appear in H1 tags
-Keyword occurrences in body text
-Number of inbound links to target url
-Number of inbound links to domain
-PageRank of URL
-PageRank of Domain
-Site Type Inlinks
-Page type (social network, blog, answers page, forum, links page, etc)
-Number of comments in comment threads

Goal 2 By-Hand Qualifiers:
Pages likely to be good sources of targeted referral traffic show up as a subset of your search-influencing link prospects. Here are some other factors that help to identify these types of sites.

-Discussion related to your product or service
-Established community in comments or adjunct forum
-Q/A forms on the site
-Strong content
-Site editors
-Links out to other known influencers
-Written reviews
-Email newsletter or other signs of reach and distribution
-”In The News” section with quotes by major news papers and industry publications

3) Increase positive mentions from influential media
You’ll find that segments of your link prospects may respond well to public relations-styled outreach including offers of sneak previews and executive access for interviews. Your objective here of course is to influence these influencers by discovering first and foremost how your organization can help them. In the realm of analyst influence the offer of data related to area of focus reigns supreme. Links from these sources are valuable, but always keep your eyes on the bigger prize here: purchase recommendations by influentials.

Goal 3 Automated Identifiers:
As you cross over into the realms of relationships and “influencing the influential” the signals become increasingly subjective. You can still use machines and spreadsheets to identify the following factors though.

-Inlinks from news sites, .edus or .govs
-Inlinks from blogs and other sites within your prospect set
-Forum signature inlinks
-Inlinks from niche/industry news sites
-Inlinks from industry groups and organizations
-Social media inlinks
-Social media/industry group badge outlinks
-Page type (blog, review page, links page, etc)

Goal 3 By-Hand Qualifiers:
This type of site typically “jumps out” at you. Here are some indicators that you’re dealing with someone who influences the market as well as the search rankings.

-Person’s name is the URL
-Industry analyst/consultant site
-Niche industry news coverage site
-Robust commenting community with a great deal of response from author
-Writing about recent industry news and developments
-Obviously attends conferences
-Multiple media formats
-You’ve seen this url on multiple blogrolls

Qualifying your link prospects, while sometimes agonizingly tedious, makes quick and efficient work of link prospect segmentation and link acquisition efforts. By qualifying your prospects based on your goals you ensure maximum impact on your link building KPIs.

55 Link Opportunity Qualifiers:
This list of 55 qualifiers will help you to separate true link opportunities from your link prospects. Without large link prospect data sets in the hundreds of thousands, some of these qualifiers lose some significance. These qualifiers gain value to your efforts when you choose those that best serve your link building goals. These lists are far from exhaustive, nor are they representative of the entirety of qualifiers we use in our services.

24 Automated Qualifiers:
-Keywords appear in target URL
-Keywords appear in target URL title tag
-Keywords appear in H1 tags
-Keyword occurrences in body text
-Keyword occurrences in Meta keywords and description
-Number of outbound links on target URL
-Number of inbound links to target url
-Number of inbound links to domain
-Followed/NoFollowed outbound links
-Competitor URLs
-Excessive Adsense placements
-PageRank of URL
-PageRank of Domain
-Domain age
-Page type (social network, blog, answers page, forum, links page, etc)
-Number of comments in comment threads
-Inlinks from news sites, .edus or .govs
-Inlinks from blogs and other sites within your prospect set
-Forum signature inlinks
-Inlinks from niche/industry news sites
-Inlinks from industry groups and organizations
-Social media inlinks
-Social media/industry group badge outlinks
-Page type (blog, review page, links page, etc)

31 By-Hand Qualifiers:
-Is there genuine relevance between the page and the page you’re building links to?
-Is it a previously-unidentified competitor?
-Is the text human-generated?
-Are there excessive, obtrusive ads?
-What motivated the current links on the target URL?
-Recent posts, recent site updates, updated copyright date?
-At first pass is the text correct in grammar and spelling?
-What is the design and image quality?
-How thorough and well tended does the resources/links page seem?
-Is there more than one links page?
-When was the last update?
-Is the site owner/moderator easily accessible by email or phone?
-Is there a comments box?
-What is the quality of comments and conversation there now?
-Discussion related to your product or service
-Established community in comments or adjunct forum
-Q/A forms on the site
-Strong content
-Site editors
-Links out to other known influencers
-Written reviews
-Email newsletter or other signs of reach and distribution
-”In The News” section with quotes by major news papers and industry publications
-Person’s name is the URL
-Industry analyst/consultant site
-Niche industry news coverage site
-Robust commenting community with a great deal of response from author
-Writing about recent industry news and developments
-Obviously attends conferences
-Multiple media formats
-You’ve seen this url on multiple blogrolls