Data Studio Hack – Get a Filter Control to Apply on Multiple Data Sources

Suppose you have multiple data sources in one Google Data Studio report. Of course, you’d like to filter either on the date or on campaign sources, or input devices or whatever. And of course, you’d like to have one filter control to filter all your tables, hence the complete report. Currently, this is a little tricky in Google Data Studio and all hinges on the so-called “field ID” (This post an in-depth explanation of the steps outlined in Filter Controls and Data Sources.) Let’s create a pretty useful kind of report for your marketing team. A newsletter report. You’d probably […]

Data Studio Hack – Get a Filter Control to Apply on Multiple Data Sources Read More

Data Studio Hack – Connecting to the WordPress mySQL Database

I am amazed at how little attention the new Google Data Studio has gotten. I’ve been working with complex systems out there; There are a ton of “data studios” which are extremely complex and need trained people to operate and deliver something, usually not that pretty, on the screen. The Google Data Studio is simple and offers great integration of the default data sources, especially Google Analytics. However, it’s not limited to Google data. And that’s a huge step! Today I’ll show you how you can import WordPress Data to create something like the following dashboard: (yes it’s a simple […]

Data Studio Hack – Connecting to the WordPress mySQL Database Read More