Menu
Background
I've created a Data Studio report that looks to a Google Analytics property. In this Google Analytics property I've created custom dimensions which are being populated as I need.
I want to set up a dimension filter on the report in Data Studio but CustomDimension1, etc isn't showing as a field in the list.
What I've done so far
I've looked to see if the field exists as a filter dimension. I've tried creating a new field but can't see what the formula for this would be.
I've read the docs behind the filter control here: https://support.google.com/datastudio/answer/6312144?visit_id=637020676101086398-168687373&rd=1
I've watched a number of videos to try and find the answer.
I've looked on stack overflow but all the questions relate more to setting up custom dimensions in Google Analytics rather than pulling this information through to Data Studio.
I've searched Google and can see this question being asked before on website www.en.advertisercommunity.com but the links in the Google search results just take me to the Data Studio support site: https://support.google.com/datastudio/community?hl=en
When I search using the page title of the advertisercommunity.com pages as keywords on the Data Studio page it doesn't come back. It's as though this question was never asked. Neither does anything relevant to my question.
Question
Has anyone achieved this by creating a new field or by using another mechanism I'm not aware of?
428
Custom dimensions and metrics are set at the property level in an Analytics account. You must have Edit permission on the property to create or edit custom dimensions & metrics. Creating either a custom dimension or metric is a two step process. First, set up the custom dimension or metric in your property.
You can create a custom dimension or a custom metric in data studio by clicking on the ‘Add A Field’ button on the bottom right corner of any data source. This will open the formula editor, where you can enter the name of the custom dimension and the conditions where it will apply to the data. What are calculated fields in Google Data Studio?
Custom dimensions and metrics are supported by the Google Analytics SDKs for Android and iOS v2.x or higher, analytics.js, and the Measurement Protocol. Custom dimensions and metrics require additional setup in your Analytics account and in your tracking code. Once you complete both steps of the setup, you can use them in your reports.
Custom dimensions and custom metrics are like default dimensions and metrics in your Analytics account, except you create them yourself. You can use them to collect and analyze data that Analytics doesn't automatically track. Custom dimensions and metrics are set at the property level in an Analytics account.
Okay, the issue I had was down to timings.
I'd created the Data Studio report first and then added the custom dimensions in Google Analytics after the report had been created.
After running through the data source area, I found the refresh fields button which then detected my GA custom dimensions and added them to the list of fields. I was then able to select the custom dimension as a field on the filter control!
Further info, the GA custom dimensions pull down by their actual GA custom dimension name rather than being Customdimension1, Customdimension2 that I was looking for.
Hope this helps someone else!
105
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
