r/GoogleDataStudio

Anyone build your own SEO dashboard from GSC and GA4?

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.

reddit.com
u/OffGridMarketing — 6 days ago

I think technical SEO dashboards are underrated.

Everyone shares keyword and traffic dashboards.

I find crawl health dashboards far more actionable because they answer questions like:

  • Are pages actually indexable?
  • Is crawl budget being wasted?
  • Are canonicals and redirects working as expected?

Curious if anyone else reviews crawl metrics regularly, or is it only when something breaks?

reddit.com
u/Mountain-Career1091 — 5 days ago

Timeline Function Errors

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!

reddit.com
u/Most_Requirement9126 — 8 days ago

Help showing role changes in AuditTrail module please?

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!

reddit.com
u/blaster_worm500 — 11 days ago