Hey so I have a report for GA4 data with a time series showing daily event count filtered by event name = file_download and page path = specific page path. This is fine it gives me daily values over a specified month. I now want a scorecard that shows me the total event count for the month with the same filters. Once I create this, the value shown on the scorecard does not equal the sum of the daily event count. I am seeing the same issue with the views metric as well. It doesn't seem to matter what date dimension I use.

To add to the confusion if I create a table showing the month total, then I get a matching value. But if I change the date range for the table to show each month in the year to date, those values don't match the scorecard or the time series.

What is happening and how can I fix this?

Not sure if their Google account is part of their organisation's workspace, but it's the same domain. Problem is they can't access their org's admin account.

How do I deal with this?

https://preview.redd.it/t410hyu60jxd1.png?width=1160&format=png&auto=webp&s=12d534f9d578d103e539328032868ec951e5b290

Trying to change my organization permissions to have access to looker studio. Is one of these secretly it? I don't see where it is.

Hey there,

I'm trying to figure out if it possible to create a connection (like in PowerBI) between different sources in post.

What I need to do is :

- I already have a functional dashboard with product ID as main link

- I added an external Excel file with only two coloumn: Product ID and Flag(YES/NO)

Blending data works...but only in the blended datasource.

I cannot redo the whole dashboard using a blended one, I need a way to just link tha actual dashboard to the new relationship

This is the blended i used

https://preview.redd.it/16csfkn22hxd1.png?width=1627&format=png&auto=webp&s=a08c67be89e2ed4c5ccf553f51d38c7e023e80e6

Is there a way?

I think what I need is to dynamically change the Breakdown Dimension Source, but as much as I try to look for a solution, I cant find any.

I have a count per year, per Location (Continent, Country, City)

The bar chart stacks the count per continent. per year.

So, my chart: Dimension: Date Breakdown Dimension: Continent Metric: Count.

I have three Dropdowns linked to Continent, Country and City field on my source.

When I select a Continent (the country and city dropdown automatically filter by that continent and the bar chart shows the total count for that continent but, what I want to do here, is (when a continent is selected) change the Breakdown dimension from Continent to Country (and so on for City)

Is this possible?

Hi everyone,

I am struggling with getting the right RegEx to extract data (Impressions, Clicks, Average Position) from a list of specific URLs - around 100 - from a website with a total of 7,500 URLs.

I really only wanted to look at the performance of those 100 URLs.

However, my attempts to run the right RegEx have been unsuccessful.

Can you please help?

Thanks in advance.

Cheers,

Luke

Hello community!

I think I'm experiencing a bug when working with a BigQuery Datasource constructed by a Custom Query with parameters. Without passing the parameters to the custom query, Looker Studio allows me to set the default value of the parameter wherever the Datasource is used (on report level, page level, group level or chart level), see the following pics for reference:

Custom Query for Test Datasource

Test Datasource set on report level, with two parameters, based on a custom query with no parameters passed onto it

Parameters being able to be modified on the reports setting window

But whenever I pass one of the parameters into the custom query that generates the data source, like so:

https://preview.redd.it/o6h9fcxktywd1.png?width=1273&format=png&auto=webp&s=0bc25e42c0be2648bbf8dc4cb4fa65bdf7ecbf4d

It no longer gives me the option to modify the default parameter values on the report settings (same happens when using the Datasource at page level, group level or chart level):

https://preview.redd.it/h9v5wklmtywd1.png?width=1360&format=png&auto=webp&s=6bcc587e8af656c036dd1dbcf84358d43fd94842

https://preview.redd.it/2tmxo5qotywd1.png?width=1348&format=png&auto=webp&s=5f2cfa468a40e029d2092d27de947764d0e464f1

I have searched the documentation but I have not found anything about this. Is this expected behavior or a bug? If it is expected, what alternative would you suggest for this issue?

Looker is being so laggy today, any information or solution

Hey all! I’m a newbie with Looker Studio trying to blend data from Google Search Console and GA4. I’m following along with some YouTube video to get the join key set correctly - in this case isn’t landing pages. I have trimmed the domain from the GSC landing pages to match with GA4, but I can only see the homepage in either report. I haven’t a clue what I’ve done wrong and could use any advice you have! Thanks!!

Hi there

I'm considering switching from an Macbook Air 13 M1 8GB RAM to an Macbook Air 15 M3, mainly because of screen size, but I am undecided between 8GB vs 16GB of RAM.

Heavyest task would be Looker Studio. Experience with it is fairly decent with the M1 8GB, but if there is any real benefit of going from 8GB to 16GB, with this type of work, I will splurge the extra € needed to get the bigger RAM.

I wonder if anyone could share their experience with a similar switch of setup. Thanks.

Hi! I'm working on updating some charts on my report. When I looked at some of the filters the data source has changed and some of the conditions are missing. When I fix the data source and conditions now I can't save (the Save button is still greyed out). Any thoughts on how to fix this and/or why it occurred? Thank you! 

https://preview.redd.it/q8gb45u3vkwd1.jpg?width=1887&format=pjpg&auto=webp&s=405b5a93f8758c58645de20a5f265555899f6c63

https://preview.redd.it/cuvbkbu3vkwd1.jpg?width=1886&format=pjpg&auto=webp&s=c9d0f91f638d554bc9de1d9348101e956517e7be

Hey guys, is Looker Studio still having issues with the session key event rate for a specific key event? They all show 0 for me, despite displaying some in the count. Obviously no filter is applied.

Anyone experiencing this too?

Hey everyone! I'm new to Looker Studio. I've got some xlsm files in a shared drive, I was trying to connect to those but cant seem to use them, It seems I can only use excel files from my pc or google sheets from drive. Is there a way of going around this? The obvious would be to change everything to google sheets, however I'm working with files that arent mine and I dont want to change their way of working (they are kindda older people).

Hello, I'm pulling data into Looker from GA4.

I want to be able to indicate if a page was viewed in a session that led to a key event (e.g. user visited this page, then later made a donation - it's a charity website).

I have a Looker report page that has a bunch of key event counts in Charts, and can be filtered to a specific GA4 Page path using a Control widget. One of the key events is a completed donation, but most page paths selected won't show results as the event only occurs on the checkout website page that other pages link through to.

Trying to figure out how I can indicate in a Chart if the current page selected in the Control was viewed in a session that also included the donation key event.

Has anyone managed to achieve something like this, possibly through a combination of Content groups in GA4, filters in Looker?

Thank you.

I apologize because I’m 100% sure that someone has asked this question before but I honestly don’t even know what search terms to use. So apologies that I might be asking a common question. I’m trying to do some simple formula in the calculated field but getting some really strange results and I just can’t figure out what I’m doing wrong.

Scenario: I’m trying to create a simple table that shows a list of clients, the monthly revenue per client, the total cost per client, and the last two columns to show the profit and margin per client. Whenever I try to create a calculated field, the static monthly revenue seems to cause an issue based upon the aggregate (sum, avg, etc.). The results are all over the place. I’ve created other bar charts and score cards from the same dataset that are correct, so I feel confident that the problem isn’t that there is a flaw in the data. I just can’t seem to figure out why I can’t figure out how to do a simple arithmetic table showing Income - Cost = Profit.

Would really appreciate any help anyone can provide. Thank you.

Hello,

Switching dates for each page is time consuming when comparing data.

Is it possible to make a date range control that would update the whole report?

Thanks

Hi there!

I am trying to do a simple summary chart of ad performance across Google + Meta for specific campaigns, using blended data.

https://preview.redd.it/uoiwf1yg87vd1.png?width=1113&format=png&auto=webp&s=8c5255efffadfdced228f30d8c0cd8e4ae2a59d6

Individually, I'm able to filter the data for Google Search, Display/Video, and Meta perfectly fine. However, when I blend the data, Google Search & Meta add up, but Display/Video gets left uncounted.

The Google Search box pulls in Search Campaign data with a filter of:

Campaign contains A1C
AND
Campaign does not contain Performance

--

The Display & Video box, which is also pulling from the exact same Google Ads account, has only one campaign is needs to pull which is called A1C - Performance Max***.*** So the Display & Video box has the filter of:

Campaign contains A1C
AND
Campaign contains Performance

--

So in the blended data, I am trying to pull everything from Google with just the filter:
Campaign contains A1C

https://preview.redd.it/c0hhncqb97vd1.png?width=1270&format=png&auto=webp&s=e7e99d57785f0f36fe3fd9f83b073cb0d8c603a3

This should pull both the Google Search and Display/Video campaigns. When I have a Google-only metric (so not blended data) and use this exact filter, it pulls in both Search + Display/Video without issue. For some reason, only in the blended data environment is it not working.

Any help is greatly appreciated!

Hi. I would like to display a calendar like chart vertically, broken down by hours for each day. On this vertical calendar, I want to display measurement values at the exact minute I recorded them. For example, if I measured something at 14:30, it should be positioned between 14 and 15. How can I achieve this?

Hi everyone!

A client of mine has multiple websites/webshops via different domains and thus many different GA properties.
Individually reporting is simple, but there is a huge wish to create an 'overview report' in Looker Studio that combines all the properties and shows a few basic metrics (page views, new visitors, active users etc.).

Now I'm wondering: Is blending all these properties the only option that can be used? And would it still be possible to filter on specific properties within this overview report, after blending the data?

For example: Properties A, B and C are blended to show the total of pageviews in a scorecard. Is there a filter that can be used to select certain properties and would the scorecard reflect the filtered properties?

Thanks in advance!

Hi, I'm new to Looker studio.

Is there a way to create a table with a column list of GCLIDs and then in column 2 whether it registered a conversion action for that GCLID?

thanks!

I have two data sources:

1. Data dump of ad metrics in a google sheet (aggregated by date and utm campaign)
2. A big query database of actions taken, aggregated by utm campaign and date

Originally I was just agging by UTM campaign, blending both sourced with that was the join, and its working. But when I have refinded the query and tried to blend it is showing me a lower number of actions.

I am joining on UTM campaign and date. I have confirmed that both sources (google sheet and BQ) have no duplicates when I dedupe on both utm campaign and date. My goal was to make this a 1:1 match

When I run the query on its own, it returns a different number of actions than I see with the join.

I feel like I have QA'd everything I can. Any ideas what could be doing this?

My end goal is to compare social media metrics from month to month stored in Google Sheets, however I some of the columns have the same header (so I modified some of them to: Metrics_YT_1) as Looker Studio doesn't let sheets have the same header.

Overall, I'm looking for the best practices to enable a quick dashboard creation. As I will be comparing the current month with the previous one. I'm storing the data in Google Sheets.

Hi I am facing a problem that in google analytics I have all my key events and their clicks displayed, but in Looker Studio they are not displayed. I am a beginner and now I am trying to replicate the table as in google analytics in the screenshot below, but due to the problems with key events I am not getting any results. Can you please suggest a solution if you have encountered this problem?

https://preview.redd.it/h3hzov474zud1.png?width=1500&format=png&auto=webp&s=ac133db4a658f5a4bef147acb80874a3cc74834b

https://preview.redd.it/js8x6nw74zud1.png?width=1697&format=png&auto=webp&s=e03f0c880fbe80f8f5ffcdc37ca773c12e8c4cc0

Background: Our site sells base products as well as add-ons. Add-ons can be free as part of a product or they can be a paid add-on.

Goal: Calculate "paid attachment rate", which I basically define as (base purchases + paid addons)/base purchases, eg. 10 purchases with 1 paid addon is 1.10 (probably more acceptably calculated as simply 10%, but we like the 1.x format).

Problem: I cant figure out for the life of me how to do this in Looker Studio without running into the feared "you cant mix these 2" error. Does anyone have any idea how to achieve this?

The basic logic behind what I'm doing is simple. I just need to recognize a "paid item flag", aka Item Revenue >0 and Item Category = "Addons". If so, that flag of 1 gives me all I need to make that formula above happen.

Any ideas?

Hello, I'm looking for a little assistance with calculated field syntax. I have two custom events in GA4: "appointment_step_1" and "appointment_step_2". I would like to divide the total count of appointment_step_2 events out of the total count of appointment_step_1 events... I've tried a few things unsuccessfully but not quite sure what the syntax should be. Any suggestions from seasoned Looker peeps would be much appreciated. Thanks in advance.

Hi,

So, I want to filter a chart based on the value typed in Advanced Filter.

https://preview.redd.it/tc68pxscfpud1.png?width=648&format=png&auto=webp&s=b0e398e495d8eb762a771090e4649c093285a445

Basically, I am working on Meta Ads report and would like to filter the table based on certain words found in the Adset name column. I can do it just fine by manually typing and searching. But what I want to be able to select a predefined value from a dropdown list and then the chart will filter accordingly so that I don't have to manually type to search and filter the chart.
Thanks.

Can someone please guide me on creating a CTR from 1 page to another?

This is for Google Looker Studio and using Google Analytics 4 as the data source.

What would the CTR formula be for URL/CategoryPage [Page A] to URL/StateroomPage [Page B]?

Do I need to create a Key Event in Google Tag Manager for this to work?

Thanks

Anthony

So I was venturing into building a dashboard but I didnt know that if I deleted a data source from a page, it would affect all the pages of that report.. Well, mistakes were made and lessons were learnt, but is there a way to recover this data source?
I tried checking the report history but it would only change back the layout of the pages not the removed data source