(Cross-posted with Google Analytics Blog)

Advanced Segmentation is one of Google Analytics most powerful features - you can use it to slice and dice your Google Analytics data by, well, pretty much anything. Weve made it a little easier to see what your iPhone visitors are doing on your site by adding a default Advanced Segment showing just visits from iPhones.

Enabling the new iPhone segment is easy: click on the drop down menu at the top right of any report next to the text "Advanced Segments", and select "Visits from iPhones" in the list of default segments. You might want to turn off "All Visits" when viewing your iPhone segment; if the percentage of total visits to your site from the iPhone is small, it will be difficult to visualize the two sets on numbers on the same graph.



Like any Advanced Segment, all of Google Analytics reports are available; this includes AdWords performance, of course. If you use AdWords, you can now use Analytics to better analyze the performance of any campaigns that use our new iPhone and high-end mobile targeting feature. Weve added the iPhone segment to get you started, but you can always create a custom Advanced Segment to compare or combine iPhone visits with other mobile operating systems; for instance, if youre targeting ads in AdWords to iPhone & high end mobile devices (which currently includes Android devices), you can create a new segment for iPhone & Android.

From the Advanced Segments drop-down, click on "Create a new advanced segment", and create a segment with 2 criteria. Drag "Operating System" under the "Systems" dimension into the target area with the dotted-line border, and type "iPhone" into the "Value" field. Click "Add or statement" to get a second target area, and do the same for Android. Then, you can name your segment "High-end mobile" and see that traffic in Analytics.

Posted by Chrix Finne, Google Mobile Ads Team

Read More..

Google Cloud SQL is a fully managed MySQL service hosted on Google Cloud Platform. Today, we are embracing open standards and expanding customers’ choice of tools, technologies and architectures by adding support for native MySQL connections.



MySQL Wire Protocol is the standard connection protocol for MySQL databases. It lets you access your replicated, managed, Cloud SQL database from just about any application, running anywhere. Here are some of the top features enabled by the MySQL Wire Protocol:

• Low latency connections from applications running on Google Compute Engine and Google App Engine


• Use all your favourite tools such as MySQL Workbench, Toad and the MySQL command-line tool to manage your Cloud SQL instances


• Use standard drivers, such as Connector/J, Connector/ODBC, and Connector/NET, making it exceptionally easy to access Cloud SQL from most applications


• Replication to external MySQL databases for low latency connections and easy migration

Native connectivity also gives you great flexibility and control over managing and deploying your cloud databases. For example, you can use DBMoto from HiTSW to replicate data between Cloud SQL and on-premise databases -- including Oracle, SQL Server, and DB2. And you can use DBShards from CodeFutures to manage sharding across Cloud SQL instances, and migrate on- and off-cloud with no downtime.



Genoo, a SaaS provider of online marketing tools, has already put wire protocol support to use. They were outgrowing their existing cloud services provider, but were worried about migrating a live application to another environment. So Kim Albee, Genoo’s founder and President, turned to DBShards who used native connectivity to migrate Genoo’s database without any service disruption. She said, "Ive been amazed by what Cloud SQLs support for native connections can do. Before this feature, migrating between cloud providers would have been too costly."



You can read more about how they did it in this case study, or learn more about Cloud SQL.



-Posted by Joe Faith, Product Manager

Read More..