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
2.6K members online now
2.6K members online now
Ask questions about Data Studio
Guide Me

Data Studio - Custom Dimension - MySQL

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I managed to connect Data Studio to my MySQL database, but my metrics aren't good for reports, so I need to create some custom metrics, and I have some doubts:


1 - I'm trying to create a metric that counts some ids, but I try to enter the formula COUNT(id) and it doesn't work. What do I do?


2 - In the filters, it doesn't appears all the metrics that I have in my table database (but they appear in the metrics section). Why is that?


3 - When I try to create graphics, I try to create using different ids, like id_user and id_product. For one of them the graphic works, but it doesn't for the other. Why is that? Do I need to adapt my database to another format before using it?