Questions tagged [google-data-studio]

For questions about interacting with Google Data Studio. Questions about how to do data analysis are off-topic.

Filter by
Sorted by
Tagged with
0
votes
0answers
7 views

Add a number of Zeros to a data set and Calculate STDEV in Google Data Studio

I want to calculate Standard Deviation in Google Data Studio for a data set. Now, I have a data set that looks like this: 30€ 35€ 20€ 10€ etc. And I also have the number of users (in this case 100 for ...
0
votes
0answers
13 views

Display Survicate survey results into a Data Studio dashboard (through Google Analytics events)

I'm trying to create a dashboard to display survey results. The survey was powered by Survicate and linked to Google Analytics through events. This allows to get more data on survey respondents. Then ...
0
votes
0answers
42 views

Create a custom sort order for filters in Google Data Studio

I have a dashboard where I am filtering by month, but I have had to change the dates that fall within each month because of fiscal periods so they are stored as text. Because of this, my filter shows ...
0
votes
0answers
9 views

Data Studio formula for one-to-many count

I have a large table of transaction data that I am trying to analyze. The table is formatted with a transaction having multiple rows depending on the number of items purchased (one row for each item). ...
0
votes
0answers
8 views

Return a COUNT of goal completions this month *excluding today*

I'm trying to create a calculated field that adjusts our daily goal target for the remaining days in the month. My logic is: ((overall daily target * # of days in the month) - goal completions *...
0
votes
0answers
8 views

Google Analytics - Reporting a custom value

I have a vue website, using vue-gtag but a general answer can help and I will set the settings accordingly to vue-gtag. I want to report how many items the user sees anytime he opens up a specific ...
0
votes
0answers
28 views

Google Data Studio - getting Returning Users in a bar chart

I am new to Data Studio, so forgive me if it's a silly question. This is also my first question on StackExchange, so be nice to me :-) I am trying to get returning users' % on a bar chart. It's more ...
0
votes
0answers
49 views

Google Data Studio - "(not set)" value when using Custom Dimension from Google Analytics in Firebase

I'm using Google Analytics in Firebase and I want to make a report in Google Data Studio. I created one custom dimension for an event but in Google Data Studio I only see "(not set)" value ...
0
votes
0answers
224 views

How to create a metric of specific events in Google Analytics or Data Studio?

On my site, I am firing an event when the user lands on a specific URL. I'm firing another event when the user clicks on a button on that specific page. When I go to Analytics, I can see the Total ...
0
votes
0answers
18 views

in_app_purchase event from Google Analytics is missing product ID info when imported in Data Studio

We have imported our Google Analytics (GA4) into Data Studio to analyze our revenue data. Unfortunately the in_app_purchase event appears to be missing information about the product ID purchased. This ...
1
vote
0answers
24 views

Google data studio not showing comparison

I have 2 data sources - one is Google Analytics, the other one is a table from big query: I am simply trying to display the % change per day in both metrics, so for example in the first I would show: ...
0
votes
0answers
19 views

How do I find the most popular directories on Google Analytics?

I want to be able to track the most popular directories on my site. The site is split as follows: www.sitename.com/directoryA www.sitename.com/directoryB www.sitename.com/directoryC Each directory ...
1
vote
0answers
10 views

Google Data Studio - can I use Bubble Chart to show totals for fixed combinations of X and Y (not statistics but values)

So I have a list of items that have Impact and Urgency parameters. These parameters all have a value of 1, 2 or 3. I'd like to visualize a grid that shows the amount of items for each combination of ...
0
votes
0answers
12 views

Is there a way to track site-served ads impressions using Google Analytics mechanisms

I want to track impression for a on-site served ad (html 5 zip sent directly to the publisher) and hope to use the attribution model on GA to check if the ad has assisted in conversions and to assign ...
1
vote
0answers
73 views

Google Data Studio - Average group by

I have a table with the following columns: Customer Id | Customer Name | Participants customer #1 | C1 Name | 10 customer #2 | C2 Name | 20 customer #3 | C3 Name | 30 customer #1 | ...
1
vote
1answer
161 views

Google Data Studio - Calculting Two Same name Fields in Two Different Data Sources

I am using Data Studio to do a Report on two Data Sources: Income and Expenses. These data sources have the same field names and each one of them has a scorecard to sum each of their values in the ...
0
votes
1answer
974 views

How to create a row level calculated field in Google Data Studio?

If my table looks like: Date Conversions Clicks 2020-02-10 2 20 2020-02-09 50 80 And I'd like to add a calculated field of Ratio (conversions/clicks), which ...
0
votes
1answer
1k views

How to filter a data range dynamically by default in Google Data Studio?

I have a table with a date column. There are 2 alternative dynamic filters I'd like to have by default in the table I prepared inside Google Data Studio: Show only data from the latest date in the ...
1
vote
1answer
1k views

How to make the width fit to text in Google Data Studio?

While preparing a regular table, all the text (header and body) gets cut off. Is there a way to have the width auto fit to text? There is an option of Wrap Text, but that's not what I want.
1
vote
1answer
1k views

How do you use a lookup table in Google Data Studio?

So blended data in Google Data Studio is not a lookup table. Here is what I'm trying to do. Say I have data set A that has sales data like this: Name | Product | Price Mary | ...
0
votes
1answer
124 views

Average monthly pageviews from Google Analytics in Google Data Studio

I'm using a Google Analytics property as a data source in Google Data Studio. I have a table where each row is a section of the site (The table dimension is "Page path level 1"). I'd like each row ...
0
votes
2answers
3k views

Google Data Studio - Sum of 2 fields from different data sources

I'm just getting started with Google Data Studio. I have connected 2 different Shopify stores to it, which worked totally fine. Now I try to show the sum of the revenue of both stores, but the ...
0
votes
1answer
10k views

How do I remove a "null" column or legend in Google Data Studio?

I have a simple Google Sheet for my source for Google Data Studio charts. Legends in pie charts and columns in bar charts show a "null" that I can't explain. My columns display correctly but there's ...
5
votes
1answer
685 views

Google Data Studio and Slack integration

How Can I connect my Google Data Studio reports, or parts of them with slack? I would like that each day appear in slack some report that I will customize in Google Data Studio. And if I want to do ...
1
vote
0answers
215 views

Google Data Studio Multiple Date Range

I'm a Data Studio newby so pardon me if my question seems stupid, I've a very simple dataset to report (see a record sample below): CheckIn CheckOut Rate 2017-01-01 2017-01-10 ...
1
vote
1answer
92 views

Can I create a custom ratio based on two fields in Google Data Studio?

I'm trying to create a custom ratio in Google Data Studio that is: 'sessions with a particular event' / 'all sessions' Can anyone tell me if this is possible? I tried using a calculated field, but ...
1
vote
0answers
240 views

Google Analytics and Google Data Studio show a different 'Users' metric

There's a discrepancy between Google Analytics and Google Data Studio data. The metric "Users" displayed in Google Analytics is different from the one shown in Google Data Studio when I query the ...
2
votes
0answers
2k views

Google Data Studio - Comparison by previous month

I have this simple data: Date Total Revenue 1/1/2017 $22,219.00 2/1/2017 $22,119.00 3/1/2017 $22,360.00 4/1/2017 $22,097.00 5/1/2017 $22,320.00 6/1/2017 $22,126.00 7/1/2017 $...
0
votes
1answer
576 views

Google Data Studio Date Range Filter -Report Level

I am creating multiple reports in Google Data Studio, I want to persist my date range selection for all reports. I have made date range control as 'Report Level' If I am creating multiple pages on ...
2
votes
1answer
1k views

Insert Text from Spreadsheets to Data Studio?

Is there a way/workaround to display a text value (not numeric) from Google Spreadsheets in Data Studio Report? I found a way to display numeric values in Data Studio, but I couldn't replicate the ...
2
votes
0answers
991 views

How to evaluate a boolean in Google Data Studio using CASE

I am importing data from a spreadsheet with contains many columns, two of which are Address (which returns the URL of the page) and Canonical Link Element 1 (which returns the canonical URL). I wish ...
6
votes
3answers
17k views

In Google Data Studio, how can I join 2 tables to be available in a report?

When I'm building a report in Google Data Studio from a MySQL source, I appear to only ever be able to work with 1 table per data source: If I attempt to edit or change the datasource, I'm simply ...