A Frakture account running multiple dataflows to your warehouse is probably generating a welter of data tables. As you get started rolling your own reports, it's natural to ask which of these tables really matter?
Although the answer to that question is ultimately driven by your reporting priorities, the tables most commonly used for core reporting needs such as message performance and revenue are enumerated below.
These also happen to be the tables used in Frakture's own stock Google Data Studio reports. Creating a separate Google Data Source for each of these tables, then copying our template and re-targeting the copy's data to your new Data Sources, is all you need to spin off your own fully customizable clone of our template. But even if you're building from scratch in your own reporting environment, these are probably the tables you'll want to start with.
Joining Source Codes With Dates
Critical Warehouse Tables for Reporting
When building a report in Google Data Studio, you'll need to start by creating one or more Data Sources. A typical build would involve about five Data Sources ... one for each of the tables above.
To get started, obtain a login ID and password capable of reading the warehouse in question. If you host your own warehouse, just create your own user credentials. If it's a Frakture-hosted warehouse, drop a note to Frakture support and we'll facilitate.
Now, turn to Google Data Studio.
Click the Create button in the upper left, and select Data Source.
Click the type of data connector you intend to use. For data in the Frakture warehouse, select the MySQL connector. (Note that Data Studio currently has no stock connector for SQL Server databases: if you're operating in a self-hosted MS SQL environment, you'll need a different reporting solution such as Tableau or Power BI.)
Now you'll need to make the actual connection to the MySQL warehouse.
If it's the Frakture warehouse, use warehouse.frakture.com as the host and 3306 as the port, unless you've been told otherwise.
Then enter the account-specific database, username, and password and click the "Authenticate" button.
If your credentials are sound, then upon Authenticating you'll see a list of data objects (tables and views) available in your warehouse. Select one table — might we suggest the critical tables in the list above on this page? — then find the "Connect" button in the upper right.