6.4K members online now
Welcome to the Official Google Analytics Solutions Community
Data Studio lets you tell beautiful stories with data. Ask questions, get expert answers, and share tips and tricks in this community.

FEATURED CONTENT

Guide Me
9 months ago
I've tried to authenticate to my MySQL database (hosted with CloudAccess) but the authentication fails.I'm able to connect locally to that remote database (using MySQL Workbench with exact same connection data).I've also confirmed with CloudAccess that they are not blocking datastudio access. Anyone have any ideas what might be the cause?
1 hour ago
This is a follow-up question from my earlier one about finding the nth substring in a delimited Campaign Name:https://www.en.advertisercommunity.com/t5/Data-Studio/Regex-how-to-find-substring-at-nth-delimiter-structured/td-p/1126892 I have a Regex that works to find the nth substring of Campaign  when the delimiter is a single character (and there may or may not be a delimiter after my substring): REGEXP_EXTRACT(Campaign, '^(?:[^-]...
Read More
0
0 Replies
1 hour ago
Hi Data Studio friends, I've created for every marketing channel 1 separate sheet with nearly the same kind of KPIs.Now I want to create an overall summary page which sum all of the data from the other sheets. I didn't find a solution for that.Does anyone has an idea? Thanks a lot in advance!Julius
0
0 Replies
1 day ago
I have a datetime field in MySQL that I set as date range dimension in Report settings. Using this field on any table as a Date range dimension generates an error. I have logged the MySql queries and the field is not passed to the query: SELECT MTH, SUM(PAYMNT_AMOUNT) AS _PAYMNT_AMOUNT_ FROM analytics AS t0 WHERE ( >= '20170101' AND <= '20171231') GROUP BY MTH ORDER BY MTH ASC The field name in the database is TRAN_TS (if that mig...
Read More
2 hours ago
Hello all, I am struggling to create a simple pie chart to show the ratio of hard bounces to soft bounces within an email campaign. Could anyone tell me what the dimension and metric would need to be? I tried 'Type of Bounce' as a dimension and created a custom dimension (soft bounces + hard bounces) Then I had the metric has total number of bounces custom metric: (total number of soft bounces + total number of soft bounces) But no...
Read More
0
0 Replies