July 21, 2015

We've Updated To The Latest AdWords API Version

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...

July 15, 2015

A Better Way to Query Weekly Data Across Years

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...

July 10, 2015

Executing ShufflePoint Queries in Excel for Mac 2011

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...

March 06, 2015

New Feature: Custom Fiscal Year Timeframes

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...

April 17, 2014

Google Spring 2014 AdWords API Workshops open for registration:

Google Spring 2014 AdWords API Workshops open for registration: googleadsdeveloper.blogspot.com/2014/04/register-now-for-spring-2014-adwords.html

Read more...

April 07, 2014

Improved syntax for querying GA Premium data in BigQuery

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...

September 23, 2013

When Excel crashes

ShufflePoint users can create reports that strain Excel to the breaking point. This is often manifest in Excel crashing when you try to save a file. This is due to the creation of erroneous data connections "hidden" in the document. Luckily there's a quick solution. 1. Open the file that will not save. 2. Click on the "Developer" tab in the Excel ribbon menu (read this to enable the developer tab if it is not already visible). 3. Click on the Visual Basic editor and then right click on the VBA project with the same name as your workbook and...

Read more...

March 01, 2013

ShufflePoint and Data Sampling in Google Analytics

We get asked quite frequently about how ShufflePoint works with Google Analytics with respect to GA data sampling. If you aren't aware of what data sampling in GA is this reference will help. Answer ShufflePoint doesn't do anything by default to deal with the data sampling that can occur via the Google Analytics API. However, we do offer time dimensions which run separate queries for each period, and using those will usually nullify sampling seen in the GA web interface. SP Dimensions that run separate queries for each period sp:month sp:date sp:week

Read more...

January 30, 2013

Troubleshooting Non-Matching Numbers

"The numbers don't match!" - a common cry in the world of web analytics! Why don't the numbers from one source match another? Or worse yet - why don't the numbers from the same source match when you get them in different ways?! We get this question very frequently in regards to Google Analytics - especially since ShufflePoint uses the Google Analytics API to pull GA data. As most GA users know, GA is subject to data sampling where large amounts of data (usually a wide timeframe) are concerned. The same data pulled through the API is also subject to...

Read more...

January 17, 2013

Excel web query timeframe parameter now supports two period expressions

An update was done today which many Excel users will find useful. You can now have a web query timeframe parameter which has two periods. A timeframe clause with two periods allows for period comparisons to be made directly in AQL. Previously such a timeframe clause had to be in the query parameter. Now you can have a timeframe parameter such as "thisMonth, lastMonth". One nice thing this now allows is for a cell to contain a formula to build a month-over-month timeframe comparison for arbitrary months. I do this by entering the following formula in the timefame parameter cell:...

Read more...