Chris Harrington from ShufflePoint here. I'd like to let you know about a new tool that we just published. We're calling it the "GA Enterprise Admin Tool" and I think of it as the "missing command-line interface for Google Analytics". I'll refer to it simply as "Admin Tool" for now on. What do I mean by that? Well, first by GA user admin I mean adding, editing, and removing users from GA entities (accounts, properties, views). By command-line I mean that you don't have to point and click your way through lots of screens and dialogs. First, I'll be up...
Read more...
In order to update your billing (Credit Card) info in ShufflePoint, simply login to ShufflePoint.com and click on the "Subscription plan & billing" link in the right sidebar.... If you already have a paid plan you will see a link to update your credit card info... If your plan has changed, you will see a different message for approving this change and either using the credit card on file, or entering a new one... These links will take you to a form where you can enter or update your credit card information....
Read more...
Excel reports built with ShufflePoint can get complex when you add lots of queries. Part of the difficulty is that Excel doesn't have good tools to look at all of the queries that you have added to your workbook at once. To troubleshoot customer workbooks we often turn to our "debug macro" which generates a new sheet named "QueryDebug" into the current workbook containing an "inventory" of sorts of all the queries in your workbook. I think any ShufflePoint customer using Excel will find this to be useful when trying to see which queries are generating error messages of missing...
Read more...
Do you manage Google Analytics for your company or agency? Are you sometimes stunned by how large the list of users, accounts, web properties, and views that you have responsibility over has gotten? Is your account filled with old clients who haven’t been active for a very long time? Or maybe employees that have long since left the company and should no longer have access to your Google Analytics? How about websites that you should no longer have access to and don't wish to see cluttering up your GA? Or maybe you've got all three of these issues! Dealing with...
Read more...
Per Google's instruction, we have updated our query engine to use the latest version of the Google AdWords reporting API (v201506). The old version (v201502) will be sunset shortly and this move was critical to keeping our AdWords integration running. As part of this update to their API, Google (among other changes) has renamed several report columns. ShufflePoint AdWords users will need to update their references to those columns in your queries. Any queries to the old version of column names will return an error. Here is the list of changed columns... Old nameNew name PromotionLine Headline PageOnePromotedRaiseBidWhenBudgetConstained PageOnePromotedRaiseBidWhenBudgetConstrained ConversionRate...
Read more...
When the GA API was first released, there was available a dimension ga:date. This dimension returns a number between 1 and 53 and specifies what week number the data represents. This limited week repertoire posed some problems. First, it did not include a year, so if your query was for a two-year time period, you would only get 53 records. The week1 record would have data for the combined values of week1/year1 and week1/year2 - perhaps useful, but not typically what one seeks. The second problem was that weeks were truncated at year boundaries. This is why the numbers go...
Read more...
The differences in the menu structure of Excel 2011 for Mac, and other versions on PC is quite frustrating. Fortunately Microsoft is working quickly to get parity between Windows and Mac versions of Office (including Excel). However that won't happen unless you download the 2016 version for Excel for Mac, which I do recommend as it's a much nicer user experience, but still a little buggy as it is currently in pre-release. Here's a link to it if you are interested in that... https://products.office.com/en-us/mac/microsoft-office-for-mac ....and yes you can run 2016 in parallel with 2011 (for now anyways). However if you...
Read more...
We've just launched a nice new feature that allows you to set a custom fiscal year date range specific to your ShufflePoint account. To access this feature login to ShufflePoint and click on "Edit user profile"... (click screen grabs below to view larger versions) Then select your custom fiscal year end date and update your profile... Once you have your custom fiscal date range set, then it's time to write some queries using it. As usual, this can be used in queries in the Query Builder or Excel. Here is an example of the timeframe in use in a query......
Read more...
Google Spring 2014 AdWords API Workshops open for registration: googleadsdeveloper.blogspot.com/2014/04/register-now-for-spring-2014-adwords.html
Read more...
First, did you know that you can query BigQuery from Excel using ShufflePoint? If you are interested please contact support for details. The BQ-GA integration pushes detailed data into BQ each day. The result is a lot of BQ tables. Including all the relevant tables one-by-one in the FROM clause would be painful if you were doing, for example, a Year-to-date query. Now BQ offers a nice solution. Google added exressiveness to the FROM clause so that you can select a group of dated tables using filtering expressions. Find out more at the update query reference at https://developers.google.com/bigquery/query-reference#tablewildcardfunctions.
Read more...
