I’m planning to use Google Data Studio (GDS) to report on aspects of a Wordpress site. A lot of what I need to do is entirely new to me so I thought I’d reach out to see if anyone can offer advice.
I’ve built reports in GDS before, but only using Google sheets, so once the data connection is established I should be OK. It’s the data added by the Lifterlms plugin that I’m interested in by the way - so I’ll need to sort out a sql query to focus on the data I need, but I’ll worry about that later.
From reading around it appears I need
- Host name or IP
but another source suggested I also needed to provide a read only link to prevent problems.
Initially I’ll create a fresh installation to test this all out because I have next to no experience of interacting with the database.
As a first step to scope out the problem I tried using the “Launch Database Manager”, but that led to " This site can’t be reached" error. Any ideas what might be going wrong there or advice on using the other methods of connecting to the database.