While we had overwhelming response to our Google Analytics Excel Plugin, we realized that it might be worth explaining in detail the core features of the plug-in.
So for this post, I have decided to explain how to use our auto refresh feature using cell references from an Excel sheet. Below are the steps that users can take in order to update their dashboards automatically by changing input criteria. You would require to login before you execute these steps.
1. Insert required from and To dates in excel sheet in two different cells as shown in image below.
2. Click on Excel Icon in the client next to “From” date
3. Select the cell where “from” date is inserted(in example it is B3) & Click “OK”. In example below, it is B3.
4. Similar to #4 select the “To” date by clicking on excel icon next to “To” date
5. Select the cell within excel where you have “To” date provided. In example below it is B4.
6. Select required parameters like data granularity (breakdown by)
7. Select the appropriate metrics & dimension that is required for analysis. In the example below, for the sake of simplicity, I have requested no. of visits by visitor type.
Once, the above request executes you will see the output as shown below.
Above table starting from cell D4 provides you visits by visitor type for the month of July-09.
Now if you need the same data for Aug-09 or for any other dates, you can just change the date in excel sheet (aka B3 & B4) and click on refresh to get updated data in your excel sheet directly.
For .e.g.
As shown below once you change the dates in cell B3 & B4, and click on refresh, the Tatvic Google Analytics Plugin will automatically, extract the data from your Google Analytics account for the updated dates based on value in cell B3 & B4. This will result in updated numbers for visitor type table as shown below. Notice that in July, there were, 22,240 visits by new visitors vs. in August about 20,762 visits by new visitors !
The following two tabs change content below.
Ravi is the co-founder of Tatvic and expert at managing different web analytics tools. Ravi actively works on conversion optimization projects to improve conversion rate and test newer hypothesis with e-commerce companies.
Latest posts by Ravi Pathak (see all)
- 6 Pricing Myths of E-commerce Companies Debunked! - December 8, 2014
- What is Product Bundling & How to Bundle Your Products to Increase Average Order Value? - November 19, 2014
- How to make tagging plan for Google Analytics|Google tag manager - March 28, 2014
1 Comment. Leave new
Is there a way to change the week starting date to Monday with weekly granularity? Even if its something I can do an excel after.
I tried to use the date field that is exported in daily to calculate a WeekNum in excel but the date format that is generated by the plugin is not being recognized as a date