2

I know how to get the total number of new users over time in Google Analytics (Acquisition > Channels):

enter image description here

And the table below shows the total for direct vs organic vs paid vs social, etc over the period.

But how can I use the graph to show the total for each source over time? I'd like a stacked area graph, or similar.

1 Answer 1

2

Within Google Analytics, the best you can do is the "plot rows" option along with changing the metric shown in the graph to New Users. You can select only up to 6 rows, and they are plotted independently, not in a stack. From Google's demo account:

GA Demo Account plot rows graph option screenshot

However, you can get the kind of graph you want in Google Data Studio quite easily.

After signing in to Data Studio and connecting your GA account (here is Google's documentation for adding a data source) you'll start a new report and add an area graph or a bar chart to it. You can also get acquainted with Data Studio using the sample GA data they provide, which is what I used for the screenshots below.

[Side note: the graphs are squashed for better-fitting screenshots - they could be twice as wide and half again as tall as they are.]

For an area graph, I set the dimensions to Date and Channel, and the metric to New Users. There are longer stretches of time available as well, up to Year.

Data Studio area graph setup screenshot

For the bar chart, there are two steps; first I set the dimensions to Date and Channel and the metric to New Users, and then second I changed from Data to Style in the sidebar and selected Stacked Bars in the Bar Chart section. By default you get a cluster of side-by-side bars.

Data Studio bar chart setup screenshot

Data Studio bar chart style options screenshot

Everything else shown in the screenshots is the default setting or happened automatically when I set the metric and dimensions.

1
  • But how can the date come as ascending format, the date are coming according to the spike not in the regular format.
    – Himansu
    Commented Jan 12, 2023 at 11:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.