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. Here's a quick solution. 1. Create a new xlsm (macro enabled) file 2. In the Visual Basic editor, add a new module and add this code Sub MoveAllSheets() Dim sh As Worksheet, wb As Workbook Set wb = ThisWorkbook For Each sh In Workbooks("source.xlsx").Worksheets sh.Move After:=wb.Sheets(wb.Sheets.Count) Next sh End Sub 3. Open up the workbook which has a problem and be sure to unhide all sheets. 4. In the macro code above, replace "source.xlsx"...

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

December 05, 2012

Using forumulas for queries in Excel

Using a formula expression is a common technique in Excel reports built using ShufflePoint, and I see that we don't have a blog posting about it. In a nutshell, there are times when you need a query to be dynamic beyond what is provided by the timeframe and property parameters. Two common scenarios are a) filtering out branded keywords, and b) special timeframes. In this article I'll show a query formula which does the later. In the attached workbook, you'll see there are rows labeled "today" and "today last year". These have, respectively, the formulas =TEXT(TODAY(),"yyyy-MM-dd") and =TEXT(DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),"yyyy-MM-dd") On the...

Read more...

November 21, 2012

Updating Your Credit Card Information

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

November 02, 2012

A note from the Google AdWords API team I thought worth sharing

Got this email today related to the new AdWords API: Some API users have noticed a difference between the search volume numbers returned by the TargetingIdeaService in versions v201206 and later compared to earlier versions and the user interface. When running a query of 'STATS' request type with the latest API version, you will typically get a higher number for search volume compared to the user interface. The reason for the difference is that the volume returned by the latest API includes Search Partners data in its calculation, while the UI and the older API versions don’t have this metric...

Read more...

October 29, 2012

Introducing In2GA

Hey there Google Analytics fans! If you've been following the Google Analytics Summit here in Mountain View today you know that it was just announced that, among many other hot new features, Google Analytics now supports the ability to import cost data from sources other than Adwords into GA. Hence the name of our new product that supports this feature - In2GA! In2GA allows you to automatically populate a "Google Analytics Custom Data Source" with Bing Ad cost data. Other data sources coming very soon. Read more about this exciting new development on the Official Google Analytics Blog

Read more...