You may already know that you can pull most of your Analytics profile data using the Google Analytics Data Export API just by creating the right query. To help you, build a query from scratch, Google built “Data Feed Query Explorer,” a visual aid to make query construction a snap. You can use the tool to quickly get data from your Analytics account before you even start to write your first line of code. Log into the tool, select a profile, and get a display of data in seconds. From there, you can figure out just what data you want, while at the same time learning how to use the API.

More info: Data Feed Query Explorer