26 Apr '13, 10pm

Nice! @anniecushing does it again: Deduplicate Your Google Analytics Reports in Excel

One of the steps in my last post on finding 404 pages worth saving involved determining if any of your404 pages received traffic in the past year. This can be accomplished by pulling a landing page report and using VLOOKUPs in Excel to see any of your broken pages used to receive traffic. However, Google Analytics (GA) content reports are case sensitive, so you might have multiple versions of what should be a single line item because of this. For example, /default.aspx and /Default.aspx are considered two different pages in Google Analytics. If you’re used to exporting your content or landing page reports without taking this extra step, you’re probably reporting inaccurate data. Deduplicating With Pivot Tables A simple solution to this would be to create a pivot table. This will automatically merge your data — and isn’t case sensitive. However, that won’t help you in a sit...

Full article: http://searchengineland.com/deduplicate-your-google-analy...

Tweets

Deduplicate Your Google Analytics Reports in Excel

searchengineland.com 26 Apr '13, 1pm

One of the steps in my last post on finding 404 pages worth saving involved determining if any of your404 pages received t...

Deduplicate Your @GoogleAnalytics Reports in Ex...

searchengineland.com 26 Apr '13, 7pm

One of the steps in my last post on finding 404 pages worth saving involved determining if any of your404 pages received t...

Google Analytics Explains The Customer Purchase...

seroundtable.com 26 Apr '13, 12pm

The Google Analytics blog announced a new benchmark tool that is made up of statistics and analytics from 36,000 Google An...

A Marketer's Guide To Table Formatting In Excel...

searchengineland.com 27 Apr '13, 1pm

To navigate large workbooks with multiple tables. You can easily navigate to one of your tables by choosing your table fro...

Prove The Value of SEO With These Free Google A...

seo.com 27 Apr '13, 1pm

Every once in a while, you come across a piece of information that revolutionizes the way you perform. I had that epiphany...

Google Reports Surge in Government Takedown Req...

searchenginewatch.com 27 Apr '13, 2pm

From July to December 2012 Google received 2,285 government requests to remove content from its platforms, an all-time hig...

New Google Analytics Interactive Tool: Customer...

searchenginewatch.com 25 Apr '13, 5pm

After releasing a barrage of new reports to help you understand attribution from multi-channel funnel reports , attributio...

4 Killer Lists Using Google Analytics Remarketing

searchenginejournal.com 02 May '13, 12pm

One of the coolest list ideas using this feature is to target visitors based on their source. If you’ve been toiling over ...

10

seo.com 25 Apr '13, 12pm

Every once in a while, you come across a piece of information that revolutionizes the way you perform. I had that epiphany...

New in Google Analytics: Real-Time Conversion Report

New in Google Analytics: Real-Time Conversion R...

searchenginewatch.com 05 May '13, 2pm

It's been nearly two years since Google Analytics added real-time reports . Over that time, there have been a handful of c...

New Google Analytics Path To Purchase Report Pr...

searchengineland.com 25 Apr '13, 4pm

The Customer Journey to Online Purchase ” analytics report today, a new benchmarking tool that provides insight into the v...

Google: Don't Redirect All Mobile Users To A Si...

seroundtable.com 29 Apr '13, 12pm

There are two types of people reading this right now, (1) those who are like me and cannot stand when this happens and (2)...

Google Analytics Premium Is Coming To France, G...

searchenginejournal.com 24 Apr '13, 4pm

Google Analytics Premium meets the demanding digital analytical needs of Privalia. We find it to be a comprehensive, flexi...

#China reports new #bird #flu case in #Hunan province

#China reports new #bird #flu case in #Hunan pr...

straitstimes.com 27 Apr '13, 12pm

BEIJING (REUTERS) - China on Saturday reported its first case of H7N9 bird flu in the southern province of Hunan, the late...

Google: Stop Repeating The Same Keyword Over & ...

seroundtable.com 30 Apr '13, 12pm

A Google Webmaster Help thread has one webmaster asking why Google isn't ranking his seven year old web site. Google's Joh...