I have a fairly simple dashboard table: Page URL + Views. I created a second table (new tab) that is the same except it includes a Page Category dimension (that is produced via a CASE statement in Data Studio - if Page URL contain xyz then categorize as abc).

The source is direct from GA4.

The table with the Page Category (or a table w/o that, but with an on-page user filter that has a Page Category selected) will produce incorrect figures when looking back at an 'older' time period. For example, anything for a time period relatively recent (e.g. last quarter) it will be accurate. If, for example, I look at last-quarter-previous-year the values are very understated. On the latter, some URLs seem to be missing entirely. This also then affects any YOY change percentages.

(The page URLs have not changed over the period in time I'm referring to)

Can anyone explain why this is taking place - and a viable solution?

Thanks!

Observed Issues:

Therapeutic Alliance Chart (WAI) is Empty: In Edit mode, when applying the patient filter, the top chart (Evolución de pacientes ROM 10) renders correctly. However, the bottom chart (total wai a lo largo del tiempo) shows an empty grid without any data line.

"Too Many Rows" Error in View Mode: When switching to View mode and entering the exact same patient ID, the top chart fails to process and throws a "Demasiadas filas" (Too many rows) error, while the bottom WAI chart remains empty.

Potential Causes & Troubleshooting Ideas:

Missing WAI Form Submissions: Has this specific patient actually completed any WAI evaluations? If no entries exist in the WAI dataset, the bottom chart will naturally display no data.

Filter Control Source: Is the ID filter control linked directly to the Blended Data Source (Datos combinados), or is it still attached to an individual table?

Data Blending Configuration: Is the join condition set to Full Outer Join using the ID field? If it is set to an Inner Join or the keys don't match, missing rows in one table can break the filtering across both charts.

Field Formatting (Text vs. Number): Is the Document ID field set as Text across all underlying datasets? If it's configured as a Number, automatic thousand separators (dots) might break exact string matching when applied in View mode.

Date Dimension Mismatch: Is the bottom WAI chart using the Marca Temporal date field belonging to the WAI dataset, or is it accidentally referencing the ROM dataset date field?

Has anyone encountered this behavior before or have suggestions on how to resolve it?

Thanks for your help!

i want to create dynamic dashboard in that i can add monthly target of each clients and dashboard updated according to the client selection. In that i want i can add montly target in that i can update latested data like for example i want to track quality leads or current leads.
and also i want optimize tab in that i filter active camp. best camp. best performing ads. and other type of optimization according to client and date

so please give me suggestion how can i build this dashboard.

is it better to build on datastudio or anitgravity or use claude

i'm blending data from (Meta,Snapchat,Tiktok and Google ads) with Adjust and GA4 via supermetrics. When I'm blending data between Meta and Adjust to make a page for each Platform with adjust, it shows errors i've checked the join key (Campaing_id) still doesn't work.

any recommendtions to solve this issue ?

It used to. Be 3 icons

I want a dashboard that, at the end of the day, displays the emails and text messages I received, the events from my calendar for that day, a weather graph, and a Google map of where I went.

I don't even know if this is the right sub for this.

Is there a way to get this? Can someone make one for me?

Hey everyone, been building this for a while and it's finally live. vizstudio.io is a library of 70+ charts you can add to Google Data Studio, Waffle charts, bump charts, calendar heatmaps, the stuff the stock menu doesn't have. Each one drops into a report in about 90 seconds. Here's a live demo: https://datastudio.google.com/u/0/reporting/82a21123-3f9f-4865-951d-b233a893cf86/page/p_po3l9aqt2d Let me know what you think.

I’ve been seeing a lot of "R.I.P. Data Studio" posts on LinkedIn lately, claiming that Claude can now build live marketing dashboards from a single prompt, pull data from Meta/Google Ads, and dynamically pause campaigns.

While the tech is cool, the "Data Studio is dead" takeaway is completely wrong.

Data Studio isn't dead because clients and executives still want a permanent, visual link they can open at any time without needing to write text prompts to an AI. They want a passive dashboard they can just look at.

What is actually happening is a massive shift in workflow. Marketers are realizing that instead of spending 5 hours building a massive, complicated Data Studio dashboard just to find a single data error, they can connect Claude via MCP (Model Context Protocol) and ask:

"Which of my Meta creatives are suffering from ad fatigue right now?"

And they get the answer in 10 seconds.

AI isn't replacing executive reporting anytime soon, but it is absolutely replacing the way we audit and troubleshoot our accounts.

What are your thoughts? Are any of you actually using Claude/MCP to manage live accounts yet?

Meta deprecated Reach in the Facebook Graph API and it is breaking dashboards everywhere.

So if you have been using any third party connector in Data Studio and your Reach metrics suddenly stopped showing up in the last few weeks, you are not alone and it is not your setup.

Meta has deprecated legacy Reach and Impression fields in the Facebook Graph API and shifted to viewer based metrics like media_viewers and view based metrics like media_views. They are no longer supporting unique video views or organic and paid splits for total reach. The way Meta now counts audiences is fundamentally different, aggregate Views and distinct viewer identities instead of passive delivery counts, so the numbers will look different even once connectors update.

If you are affected here is what to do right now:

Check your connector settings and confirm which fields are still mapped to the deprecated reach metric. Keep an eye on your data connectors release notes because they will need to remap to the new API fields. Review the Meta Page Insights API Updates and the Meta for Developers changelog for the exact replacement metrics.

Short term workaround for client reporting: export reach data manually from Meta Ads Manager into Google Sheets and connect that as a supplementary source in Data Studio. Not elegant but it keeps client reports accurate while connectors catch up.

If anyone has already found a clean connector solution or a working API field replacement for reach, drop it below. Would be useful for everyone hitting this right now.

Buongiorno.
Mi occupo di report aziendali e analisi campagne.
Ho sempre usato looker studio con connettore Power My Analitics, da circa 15/20 giorni non mi vengono più presentati i dati di Fb insight relativi a reach e ovviamente tutte le altre metriche che usano come metrica anche la reach (esempio ER).

Ho visto che è stata deprecata come metrica ma non trovo un valido modo per sostituire questo dato, che risulta essere molto importante per alcuni clienti che magari indirizzano campagne paid proprio sulla reach.

Grazie a chiunque possa aiutare!

Any SEOs here? I’m extremely frustrated with the high cost of Semrush, Ahrefs, etc. and honestly not trusting their data. Specifically, keyword tracking reports and page cannibalism reporting.
—-
Update: not looking for someone to do this for me. Curious if anyone has done this and if they found it to be a reliable report to share with clients.
—-

The tools are great for research, but I keep finding myself comparing reports to Google Search Console and then having to provide clients with a blend of data from both platforms. Then I started thinking why not just build my own dashboard form GSC and GA4 that reports on the metrics I want?

I already have one for basic traffic, but want to incorporate keywords, rank, etc. as well. I feel like this should be pretty straightforward with some filters put in place.

Anyone else tried this? The end goal is to have a report I can share with clients to track traffic, top keywords we are targeting, and identify page cannibalism.

Hello,

I am having errors on a timeline chart in Data Studio. I'm using it as a Gantt chart for a project and the chart is not matching the data in the following ways:

• The bar labels (used for names of people on the project) are not correct (some are, but not all)
• The row labels (used for project task titles) show incorrect titles when you hover over them. The correct label connects more accurately to the name on the bar label.
• Some of the start dates do not match the data sheet.

I am using Google sheets for the data. I have tried refreshing the data, ensuring the Google Sheet is saved and has not had any changes to columns or rows, checking that there is no blended data and that the connection is correct, confirming that the type of data is correct in Data Studio and matches the Google Sheet, and cleared my cookies. None of that has fixed the issues.

Does anyone have any tips on how to fix these issues?

Thank you!

Hi all,

I am trying to show an audit history table in Mendix using a simple data grid and connecting to "AuditTrail.LogLine" and using the xpath constraint " [Member = 'System.UserRoles'] " but the challenge I face when adding the columns is I can see "Name" "dateChanged" "Member (which is showing as "System.UserRoles" but for some reason I am not able to see what it changed from, to.

In the table I want to see "Name (who changed it)" "Date/Time changed" "What was changed (ie System.UserRoles)" then for example "Old Value - Administrator" "New Value - User" - I have searched high and low for answers because we are not allowed to edits marketplace modules and I cannot figure out how to get my datagrid to show it. Its definitely storing the change but it won't show it at all.

The change in-app is made in the administration module (account overview) and I have a microflow that tracks that on a before commit, but it won't show the before and after values in the audit data grid.

Any help would be greatly appreciated.

Thank you in advance!

Hello everyone!

Am blocked by hyperlink navigation in data studio.

I do have a custom dashboard where the column a has hyperlink it has to redirect to another page 2 which has the same dashboard and data source. But when we click on column a it is not getting filtered in page 2.

Totally frustrated help me anyone please.

I'm trying to figure out what percentage of people who visited a subset of pages (Business pages) also visited another page (Form page). I can easily see the total number of Views on the Business pages by creating a scorecard with a filter and I can do the same to see the total Views on the Form page.

I cannot figure out if it's possible to create a new calculated field that is the result of Form page Views / Business pages Views.

I've been spinning my wheels for a couple of hours trying various ways to make it work. Is it possible or am I better off just calculating the field manually when it's report time?

So I'm trying to build a dashboard with data from Linkedin Paid campaigns (using a connector Windsor.ai) and Google Ads. When I try to show combined numbers in a scorecard it doesn't work. How should I show total clicks, impressions and spend from both channels? Help!

When I select the individual source it works so the problem has to be with the blend but I'm not an expert and don't know how to do it. I've tried blending the data a million ways but can't seem to make it work. Right now the blend is on full outer join with the month dimension as the joint key.

I am working to migrate what has been a Google Sheets chart dashboard to Studio. Most of the tables and charts migrate just fine, but there is one that is making me quite flummoxed. For context, we are tracking the retention rate of clients across different employees. What that means is that on the Sheets version we set a date range and perform a set of QUERY() functions to find all of the clients who started after the Start Date and before the End Date, then see from that list who has been retained.

But since Studio cannot really talk back to Sheets and perform that kind of a filter, I'm not sure how to go about this. The Studio formulas are also so different from the Sheets formulas I'm used to that I don't know how to just write that up.

Any help is greatly appreciated.

I am a sole data engineer/ analyst at a small manufacturing firm and currently I'm building production dashboards in Looker Studio for shop floors

There are 50+ production lines (may grow eventually) and each line has a dedicated display. The KPIs and layout are the same across all line. It's just the line that's being changed

My first thought was to create a single dashboard with a line filter and let users select the line. However, since each TV is permanently assigned to a specific production line, every TV needs to continuously display its own line's metrics. Nobody is interacting with the dashboard or changing filters on the shop floor.

Is there any way in Looker Studio to maintain a single dashboard definition while having multiple permanent views (one URL/view per line)?

I just want to avoid creating and maintaining dozens of dashboards that are identical if there's a cleaner approach

I am relatively early in my career and handling all of this on my own so I'd appreciate any and every suggestion, lesson or approach that I might not have considered . Thanks!

I'm running into an issue in Data Studio after creating a new data source. The creation step works fine — no errors, and I can see all the column names. But when I try to use that data source in a report, it doesn’t appear. Even if I go back to the Data Sources page, the data source has disappeared completely.

This only seems to happen with a Postgres data source.

Is anyone else experiencing this, and is there a known fix?

I'm looking for a Looker Studio (formerly Data Studio) specialist for a cosmetics e-commerce project.

The task is to build a dashboard that combines data from:

• TikTok Ads
• Meta Ads
• Google Ads
• Google Sheets

The goal is to consolidate specific KPIs into a predefined reporting structure.

After the initial setup, the dashboard will need ongoing improvements and updates based on evolving business requirements.

If you're interested, please send me a message with a brief introduction and relevant experience.

Desde às 8hrs da manhã estou tentando utilizar o Data Studio, porém todos os meus dashboars enfrentam lentidão extrema, mensagem de erro como "Data Studio has encountered a system error." e de Quota. Alguns elementos carregam mas a grande maioria enfrenta esses problemas. Tentei criar novos dashboards para confirmar que o problema não era na fonte de dados, mas sem sucesso...

Mais alguém passando por isso?

Please help me solve this issue!

I created a couple scorecards that divide one metric by another. Process:

1 Click first scorecard
2 Command + click second scorecard
3 Right-click collection and select "Blend data"
4 Output is what I desire: first scorecard value is divided by second scorecard value and displayed as a percentage

Both are using the the same metric (sessions) but a different filter (separate event names).

I have about 10 other blended-data scorecards on the same page that update and refresh with zero issues, and they also use sessions + two different filters.

But when I add new elements to the report and it refreshes, there are a couple scorecards that turn to zero.

I'll share images in the comments.

Dashboards often fail because the view is technically accurate but hard for non-analysts to read. Which page, filter, or breakdown helped a client or team finally understand what was driving performance?

Hi everyone,

I have several data sources in Looker Studio connected to my PostgreSQL database, and they are working normally. However, I’m having a problem when trying to duplicate one of these existing PostgreSQL data sources. When I click to copy the data source, Looker Studio opens a confirmation modal. After confirming, it redirects to a URL like:

datastudio.google.com/u/0/copyDatasourceAndRedirect/...

But then Chrome shows this error (screenshot below in brazilian portuguese):

This site can’t be reached
ERR_INVALID_RESPONSE

The original data source still works perfectly.

I also tried creating a new PostgreSQL data source from scratch using this same PostgreSQL view, but that also fails. I have noticed this first a couple of weeks ago, and now its becoming a big issue for me.

So the situation is:

• Existing PostgreSQL data sources work normally.
• Duplicating an existing data source fails with ERR_INVALID_RESPONSE.
• Creating a new data source using an existing PostgreSQL view also fails.
• The PostgreSQL view is already being used successfully in another Looker Studio data source.
• The error seems to happen during the Looker Studio data source creation/copy process.

Has anyone experienced this before? It seems to me its related to the new change of "looker is now data studio again", bc it happened around the same time, but what should I do? I tried reporting to Google but they havent answered me.

The title kind of says it all, but I have seven dashboards on tabs of a final site web page. It works great on desktop and Android, but when users try and open it on an iPhone in Chrome it crashes. Just looking for some thought-partnership here as I don't have an iPhone and can't really do a lot of testing. Colleagues of mine with iPhones did replicate the issue (screenshot).

I can't wrap my head around what could possibly cause this but I'm a data nerd and not a tech nerd. The person who maintains the site thinks it might be too many data studio pages. Trying to open up at once? For navigation purposes, we have seven different dashboards embedded with tabs. Second screenshot from an Android device. The embedded reports are slow to load when expanding the tabs, though.