I'm using the comparison option in my scorecards, and would like to show our progress toward the goal of LOWERING CPM. Since the goal with CPM is to lower it (spend less money), I would like my graph to show the progress toward a final value of $5.39, from $6.49.

If I input these values into looker, the system is not taking into account the fact that I want this dollar metric to LOWER, and it's showing the following progress bar with a 110% increase. This is incorrect because the starting value is $6.49 and the final value is $5.39 - so actually we are only 82% of the way to achieving this goal.

Is there a way to use this feature to show actual dynamic percentage change?

https://preview.redd.it/jn6xmc332o7e1.png?width=310&format=png&auto=webp&s=68b9a595752b3b03944d7250997aa73021b5f81f

Hi everyone,

I have been familiarising myself with Looker Studio and have tried to visualise some company data but I have been running into an issue with missing data once I imported the data set into Looker Studio.

You can see from the CSV file that there is sales data for each day. However, once I try to apply the data to a chart within Looker Studio, significant data is missing.

I have checked and re-imported the data multiple times but I cannot find a solution. Any help would be much appreciated!

Thanks

Data from CSV file

Table from Looker Studio

Hello everyone, I have found these templates from Porter Metrics and would like to recreate some of the charts since those seem useful for the A/B Testing dashboard that I'm trying to build for PMs. Does anyone have any idea/tutorial/resource to recommend that could be helpful?
p.s. I don't know if that is necessary for these use cases, but I can't use LookML

https://preview.redd.it/v5ag50os7e7e1.png?width=1146&format=png&auto=webp&s=071510baa076857b187f8bdedad22220f4242313

https://preview.redd.it/3a2eg9y28e7e1.png?width=1146&format=png&auto=webp&s=e32a8dc70191de7a0c798d388eeeb62a2e3036d6

Hey guys! I'm creating a dashboard of Bed Management Unit. The data is stored in Google Sheets where user enter submission from Google Forms.

Here's the Sheets I'm using. Don't worry, they're just dummy data I entered.

So I wanted to show the most recent entry for each column so that it can be seen in a table but the problem is that while it does show the recent entry, it only shows the entry for that particular column. I want it to show recent entry for all column, and to make sure that when there's new submission, it will update that column but doesn't affect the table.

https://preview.redd.it/5zlf5cate47e1.png?width=318&format=png&auto=webp&s=58917d8a3caf53b6b604b9df71ca7a770077159e

https://preview.redd.it/wv81qktgg47e1.png?width=1919&format=png&auto=webp&s=80d90bf600d61cd8dfc85191e99b47b691f98bbd

Just wondering if it's possible. Maybe there's another chart that I should be using instead? Sorry if I used some repetitive words there, or maybe I'm not being clear enough. It's kinda hard to put in into text.

I am trying to create a line graph that has a line showing the page views per month of a single page on our site each month and also a line to show the monthly views from the overall webpage for comparison. Why is this so difficult? Has anyone figured this out? I've tried filtering (ends up filtering all metrics when I just want it filter one metric) and blending the data to no avail. I don't understand how a table can show this info, but I can't create a graph with the same information. Any help is appreciated!

I am wanting to represent conversion count by day for three separate HubSpot Form GUIDs. Ideally, this would be a chart, but I am struggling to find a way to filter three calculated fields. I know one option would be to have three separate charts and filter each chart, but I'm wanting to avoid having this take up too much real estate on the page.

Thanks!

Hi.

1. I have this table, where I want to show the email instead of the user ID. I have a separate Google Sheets doc with the user ID and email in two different columns. I have tried working with blend data. It's probably easy to do, but I can't figure it out.

2. Is it possible to hide columns and translate the event names in the table?

Hi Everyone,

I build operations dashboard for some of our investment companies abroad. I love to use Looker because once I build it, it can easily be maintained by anyone who has a base knowledge of Sheets/Excel.

However, we are shifting our clientele to possibly include the US. Because LookerStudio only pulls from Google, I'm having a hard time finding a simple way for business to operate under HIPAA guidelines. If it would integrate into Microsoft 365, it would be doable. There are workarounds like having someone dedicated to pulling data and wiping sensitive information, but I'm wondering if there are other similar solutions out there that would allow me to integrate with Excel in 365. Again, minimal coding is best, as these are small businesses and they don't have the resources to dedicate someone to coding once I'm done.

Hello, I'm trying to display a basic comparison in a table where the dimension is set to date but can't manage to get it work, regardless of the data source.

Steps:
- create a new report
- add, say a GA4 data source (or any data source with a date dimension)
- create a table with "date" a dimension, and any metric, for example "views"
- toggle the "comparison date rage" in the Setup options, and chose "previous period" or "previous year"

Expected result:
A "% Δ" column is added next to the Views column in the table, showing the variation of the metric vs comparison date.

Actual result:
the "% Δ" is added but is empty
only the summary row is showing a value.

When duplicating the table and changing it to a time series chart or a score card, the comparison is shown correctly.

I found this ticket in the community bug tracker, but it doesn't seem to have much activity.

Is anyone else impacted by this?

https://preview.redd.it/v6rtdkmh1y5e1.png?width=1072&format=png&auto=webp&s=51f88ad61abf448b04b3ca6f37a765a987d7e80f

I desperately need to help with this! I've tried many things but can't seem to make it work. I have a data blend that combines Google analytics and BigQuery, I need to combine website sessions and sales to calculate conversion rate (sales data i not accurate on GA4 because of setup issues). However, when I try to add a date range control, it doesn't apply to any charts with the blend as a data source. Any idea why?

Edit: Both data sources have a date and its used to join them (see image). Also, I noticed that when I set the date range as 'auto' on the settings, it falls back to 'custom > last 28 days'.

https://preview.redd.it/xk6i9v4ps36e1.png?width=1132&format=png&auto=webp&s=aeb22b057c079fc8b55e0fdac7d4252932167100

Hey folks, I'm working on a dashboard in Looker Studio, using data from Google Forms and Google Sheets. The project is for hospital bed management, and I have two forms, Status Booking and Status Confirmation.

1. Status Booking: Used to book a bed with fields like Patient Name, Identity Number, Diagnosis, Current Location, Oxygen, Disposition, and Remark. (but the most important here are Patient Name and Identity Number)
2. Status Confirmation: Used to confirm the booking with fields like Patient Name, Identity Number, Transport Date, and Status (in Forms, the options are ACCEPT and CANCEL).

So users will fill up Status Booking Google Forms first and it will appear on the dashboard. Let's say the patient name is JOHN DOE with identity number 1234.

https://preview.redd.it/mmjkjbnbnj5e1.png?width=1235&format=png&auto=webp&s=d938da8cffcd0a3ab2051f011551ea791c69e185

Then other users can see the details on the dashboard and will fill up another Forms, which is Status Confirmation. The user will fill in the same Patient Name and Identity Number.

https://preview.redd.it/pfn1ay0onj5e1.png?width=1228&format=png&auto=webp&s=e29ef2554edb80ad34008d7096d26ca229e9032c

Basically, if user choose that Cancel status in confirmation form, and it matches the name and ID, it will delete that row that has the same name and ID in booking form.

https://preview.redd.it/9usze2w4qj5e1.png?width=183&format=png&auto=webp&s=2a9ec9681aca1679eaa07bed3f60a55db1e67005

Is that possible? I'm still relatively new to Looker Studio. I have used it before but not to this extent so I'm not sure if I can do this.

Anyway, feel free to ask me if anything here doesn't make sense or seems unclear.

Currently, I have clients who have been complaining about the slow loading speed in Looker Studio.
I manage their paid media platforms, such as Google Ads, Social Media Ads, GA4, and some platforms that require an API to extract and load data into Looker Studio (e.g., SuperMetrics).
I already provided them with a solution, which is to create separate dashboards for specific views or reduce the amount of visuals and metrics, but they prefer having a single dashboard to view everything.

Are there any solutions to improve the dashboard's loading speed?

We currently use Google Data Studio to build our reports.

It works OK, but I find copying and editing reports to be too clunky and end up spending too much time with each new client building a new report to fit their needs. We do email marketing, Google Ads, Meta Ads, and TikTok ads, so there are a lot of parts that are not relevant for everybody. Also, creative reporting is not great with Data Studio.

What reporting software do you use and why? I’ve heard good things about Superads, it’s supposed to have strong integrations with ad platforms and customizable templates, which might save time. Thoughts? Would anybody have recommendations for alternatives to Google Data Studio?

I am looking for an example of a Data Studio report that uses data from surveys or Google forms. I'm not seeing exactly what I want when I search on Google. I want to see how other companies/non-profits set up their pages. Thanks for helping!

Hi

Is it possible to create a filter which contains two OR conditions, then one AND condition which only applies to one of the previous criteria? For example, I want to create a filter which includes: 

1. GA4 "Organic Search" channel OR

2. GA4 "Organic shopping" channel where the source is 'google'

My solution was the following photo however this applies the 'google' source rule to both the previous two rules, whereas I only want it applying to the bottom one.

https://preview.redd.it/g0fx5wc3285e1.jpg?width=3840&format=pjpg&auto=webp&s=7e92006b3440a59a7d7934fff080d8e214eeb4f8

Thanks in advance

Hi,

I am using a table to show some Facebook Ads metrics, and there are some weeks, where we have not run any ads, however, I would still like to show the missing weeks - and then just not show anything in the metrics.

As an example, you can see below, that it shows week 11-12 and 14-15, but NOT week 13.

https://preview.redd.it/vxwvzd8i4m4e1.png?width=217&format=png&auto=webp&s=8abb22da4a93afd4b139e80406bf663cced28020

Thanks for your help!

Hi there,

I'm working on a dashboard that includes a funnel with GA4 session data for each step. The particularity of the funnel is that it is made of URLs with unique IDs, such as:

example.com/subscription/[unique_id]/start
example.com/subscription/[unique_id]/profile
example.com/subscription/[unique_id]/end

I am thus creating a funnel_step calculated metric based on page path to aggregate the data for each unique URL.

CASE
  WHEN CONTAINS_TEXT(PagePath, "/start") THEN 1
  WHEN CONTAINS_TEXT(PagePath, "/profile") THEN 2
  WHEN CONTAINS_TEXT(PagePath, "/end") THEN 3
  ELSE NULL
END

When I display Session data, I believe that Looker Studio sums the number of counted sessions for each of the unique URLs (eg. sessions for /1/start + sessions for /2/start + ...).

But I guess that if the same user visited /1/start and /2/start in the same session, it'll be counted as two separate sessions. Is that correct?

And if so, what would your strategies be to avoid getting duplicates?

As I can't access the session ID in Looker Studio, I was thinking of creating a custom GA4 dimension session_id_custom that would trigger once per session, but I'm not 100% sure that'd be the best way. Any suggestions are appreciated!

Hey Everyone, I send out roughly 50 simple google review reports that go out to different managers across the business but ran into an issue a couple weeks ago, and again today.

The reports were not sending after being successful for about 8 months. To fix this, I created a new gmail and transferred all of the scheduled deliveries to that email and that fixed the issue. Fast forward to Thursday (2 weeks later) and the issue is occurring again on the new email address.

Does anyone know what is going on? This is greatly impacting business and it was frustrating enough transferring over the 50 reports.

I created several pages in a report and want it on display 24/7 on a TV in the office. Is there a way to have the presentation automatically rotate through the pages at a given time interval?

Also, will the data update automatically or is there a way to do so? I'm pulling the data from a Google Sheet spreadsheet.

I have a business e-mail connected to one Google account. With that, for some reason, I don’t have an option to upgrade from free to pro licence of LS within Cloud admin. I always receive an error and on support page I see that may mail might not have a possibility to upgrade.

Do you have some ideas or reasons why is it impossible to upgrade? What would be the recommended approach then - to create another Google account with some specific configuration or something similar?

Thanks!

Hey All,

I have a Looker Studio report with a GA4 data feed which includes a custom dimension that reports the ID numbers of logged in users on the site. The Used ID number correlates to an Organisation name.

My aim is to blend the GA4 data with a Google sheet which contains a list of these User IDs and the corresponding Organisation name, then if the number is listed in reports the blended data does a look up to fetch the actual Organisation name from the spreadsheet, then display that in the Looker Studio report

Hopefully this makes sense - I'm new to data blending and was hoping to gauge if this sort of functionality is possible?

Thanks

Tom

Hello, I have two different campaign in google ads for one product but in different languages. I want to know if I can combine their data into one bar chart and search keywords report?

How is the "Data sources" page sorted? It seems to be completely random. Is there any logic at all to the ordering here?

I have a bar chart in LookerStudio that shows a sales funnel - this chart can also be filtered down by selecting the branches / salespeople on the right hand side, to show only the data related to this:

The report with nothing selected on the left hand side

The problem I am having, is that when we filter down the chart by selecting a value to the left, any empty metrics are not shown:

With a staff member selected, it does not show rows with empty values

I understand that this would likely also happen if the overall data had a 0 value as well for a stage - is there any way to show the empty rows? As we still want to see if, for example, there are 0 people in the "delayed" stage.

Any help would be greatly appreciated!

OK, so I have 2 Tables:

SOW TABLE

PROJECTS TABLE

I Left Join these two tables on SOW: SOW # = Projects: SOW #
The join results in this table:

I want to calculate how much budget has been used for each SOW. Seems it should be dead simple but can't figure it out...

This is what I want to end up with:

Hi everyone.

I have scheduled some reports on looker studio since many months, everything was fine but since last few days it not sends the scheduled reports anymore. If I change the account, it does.

I tried "send now" too, but it show "Unable to send report".

Anyone has the same issue?
Is there any hide monthly limit?

Thanks in advance for the support.

Context: Blended data is unable to have Date as a dimension as Looker will over-aggregate the data to a very large number but would still like to still see trends by date.

I want to build a dashboard that shows off multiple charts with a date filter that offers options by quarter, not by date. So you can choose 2023, Q1 for example, rather than January to March.

As far as I can tell, getData() requests for blended sources always request all fields. Usually I check if all the requested fields are dimensions which tells me that the request is coming from a filter control so that I can change the API request to only get distinct values in order to make my filter controls update faster and reduce the amount of data I'm requesting.

Is there any way to make it so that a filter control for a blended source doesn't request every field? Alternatively, is there actually any other way to identify that a request is for a filter control than my method of checking which fields are being requested?

Hi guys i have a table as shown above. I'm trying to find a way on calculating the sum of the distinct ID using the calculated field on Looker. I've tried googling but couldn't find the answer. Appreciate if someone could help thank you very much