Yes, I completely agree! I was literally SHOCKED when I realized that
URL was not included in the data warehouse. This is the most obvious
element to include, it blows my mind why it was missed. Matt, to answer
your question: Without this feature, you cannot determine the difference
between paid and organic search in the data warehouse because the
Omniture data warehouse also does not include a paid/natural flag! Since
I'm in charge of Search Analytics, this is a serious problem.
Actually, I'd like to see alerts based on statistical ranges, not
percentage of previous period. So if traffic exceeds 1.x standard
deviations form the average for that period over a trailing period,
alert me. In my case, I look at data that falls outside the 95th
percentile confidence interval for the trailing last six weeks or so. So
if Mondays traffic is above the average for a Monday over the previous
six weeks by greater than 1.645 standard deviations (.05 confidence
interval) then flag me.
In Legacy Excel Client, you're able to build a list of (for example)
keywords with the "select specific" tab. The keywords you select will be
pulled into the resulting report without regard for case. The new Report
Builder has more advanced list capabilities, allowing you to pluck your
items out of a search or link directly from the spreadsheet.
unfortunately, both methods are now CASE SENSITIVE!!! The problem comes
when you're trying to do trended keyword analysis. Users change case all
I absolutely agree with this. I pull this data down into Excel so that I
can calculate whether or not a data point falls outside of 95%
confidence interval ranges. It's nice to see, for example, that traffic
was up on Monday, but is that spike statistically significant for a
Monday when compared to all Mondays over the trailing last six weeks?
It's the difference between data and actionable information! I also run
linear regressions on my trended keyword data to determine if the slope