Quick Start - Google Analytics with PowerPoint® - Custom Templates
Within ShufflePoint Studio, the Analytics Query Tool is used to associate queries with the charts, tables, and shapes within your custom report templates.
Follow these steps to begin creating refreshable presentations with your Google Analytics data.
Setup step: Associate your ShufflePoint account with Google Analytics
If you have not already done so, click the Google Analytics link on the
right side of the “My ShufflePoint” page, and follow Google's instructions.
Upon granting access and returning to the ShufflePoint site, you should see a list of
Google Analytics accounts and profiles which may now be queried using ShufflePoint.
View the tutorial movie.
Step 1: Upload Template Presentations
Create your own slide templates and slide masters using PowerPoint on your desktop, and then save them in the PowerPoint 2003 (*.ppt) format. New slide layouts must be created in PowerPoint 2003 for Windows. New slide masters can be created with PowerPoint 2007 for Windows or PowerPoint 2008 for Mac; however, 2007/2008 charts are currently incompatible with ShufflePoint.
The presentation title property will be used in Studio to identify a presentation.
Log into www.shufflepoint.com and click the “Launch ShufflePoint Studio” button. This will bring up Studio as seen below.
Click the “Upload Presentation” button in the upper left to upload your template file. Then click on the new item in the “My Catalog” tree. Once processing is complete, you will see the presentation displayed in the top panel.
Step 2: Associate Queries with Placeholders
Now drag-and-drop a slide template from the top panel to the right panel, and then move your mouse
over the center preview image. Note that placeholders that can be associated with AQL queries
are highlighted with a green box. Click on the box, and then click on the 
button
under the preview image to bring up the Query Tool.
Use drag-and-drop to select the metrics and dimensions of interest. Note that only one profile can be selected unless you have chosen the “GA Profile” dimension. If you leave the “Profile” box empty, then the default profile will be used. See the “Presentation Defaults” section below for further details. Click “Get Results” under the Profile box in the upper right to display the query results in the grid at the bottom. Once you are satisfied with the results, check “Refresh Image” and click the “Save” button. This will refresh the slide with your data. Note that if you have many placeholders on one slide, you may only want to check the “Refresh Image” button when saving the last query.
Step 3: Manage Presentation Defaults
Click the 
button at the bottom or the right panel to set a
presentation's default profile and timeframe.
The specified profile will be used for all queries defined without a profile. The specified timeframe will be used for all queries
that use the "default" timeframe. The advantage of using these defaults is that you can create one presentation template and easily
use it for multiple profiles and timeframes without changing the underlying queries. You can regenerate the presentation with a
different master by clicking the 
button at the bottom. Using this combination,
you can assemble one presentation for use with multiple profiles and masters.
Step 4: PowerPoint Generation
Click on the 
button at the top of the right panel to save
the presentation to the “My Presentations” list. Then click on the 
button to generate a PowerPoint file. Once the spinner to the right of the presentation turns into a PowerPoint icon,
click the icon to download the PowerPoint. Clicking the button again
in the future will regenerate the presentation with the latest data.