0
Declined

Sorting of previous period in analytics

Rasmus Thomsen 6 months ago in Analytics updated by Stéphane Hamel 4 weeks ago 3

Option to sort data in Google analytics on basis of the compared date period

Answer

Answer
Declined

I was thinking of an a better/easier alternative:

  • in Data Studio, connect to your Google Analytics data source
  • Add a Date Range selector to your report and set it to "Last 28 days"
  • Create a table with the Search Query dimension and Clicks, Impressions and CTR metrics
  • In the Data setup of this table, add a "Compare date range to previous period"
  • Tweak the report to your liking :)

It it close, but sadly, DS doesn't allow you to sort by the "delta" column or turn it into a heatmap to easily spot the major changes. But still, I think it might be easier to find the major changes.

I know it would be possible to create exactly what you are looking for using Tableau and some calculated fields. 

Under review

I'm not sure I understand what you mean - could you provide an example scenario of how this would work?

hi, sure thing.

example:

When looking at data in the search console section under queries, it would be great to be able to sort to find the keyword with the highest amount of clicks in the previous period.

It's only possible to sort based on highest or lowest number in the current period.

Since it's not possible you might miss a keyword that had a high amount of clicks in the previous period, but in the this period it's not in the top 100, and it could be missed.

Makes sense? :)

Answer
Declined

I was thinking of an a better/easier alternative:

  • in Data Studio, connect to your Google Analytics data source
  • Add a Date Range selector to your report and set it to "Last 28 days"
  • Create a table with the Search Query dimension and Clicks, Impressions and CTR metrics
  • In the Data setup of this table, add a "Compare date range to previous period"
  • Tweak the report to your liking :)

It it close, but sadly, DS doesn't allow you to sort by the "delta" column or turn it into a heatmap to easily spot the major changes. But still, I think it might be easier to find the major changes.

I know it would be possible to create exactly what you are looking for using Tableau and some calculated fields.