AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
3.1K members online now
3.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Numeric Custom Dimension from an Event Category

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

Hi,

In our GA we track clicks on different buttons on our website using event Category, Action and Label. I want to create a table showing each event separately (defined by each event's Category) and segmented by source. What should be the formula to create the custom metric that would allow me to do this? It should look like this:

Screen Shot 2016-09-23 at 10.56.18 AM.png

 

Thanks for your help!

Numeric Custom Dimension from an Event Category

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

I think that custom report with pivot table will do the job.
Go to CUSTOMISATION tab and choose +New Custom Report
Add "Total Events" as a metric then "Source" and "Event Category" as a dimension.
Save your report and click "pivot" (it's a small icon just above the table on the right side).
Last thing you need to do is to change "Pivot by" option by selecting "Event Category".
To save your work create shortcut by clicking "Shortcut" link. After that you will find your report under "Shortcuts" section in "REPORTING" tab.

Numeric Custom Dimension from an Event Category

Follower ✭ ☆ ☆
# 3
Follower ✭ ☆ ☆

Ok good! And is it possible to do it directly on Data Studio?