Google Data Studio

Google Data Studio

Table of Contents

What is Data Studio

Customer's First Data Request

Customers 2nd+ Data Request

Adding a Data Source

 

Data Base Info

 

Data Studio

If a customer has paid for additional data analysis we use a tool called Google Data Studio to sleuth through their data. 

Here is a tutorial: https://analytics.google.com/analytics/academy/course/10

 

 

Customer's First Data Request

If this is the first time a customer has requested data services then we will have to notify the development team so they can create a password for our internal team to use.  Once the development team has confirmed that a password has been generated you can go ahead and create a new report in Google Data Studio under the account support@milkcrate.tech

Customers 2nd+ Data Request

If this is not the first data request by a customer they should already have a report that can be accessed from the support@milkcrate.tech account.

Adding a Data Source

If this is the customer's first data request when you generate a new report it will immediately ask you for a data source. If the customer already has a report and the data that you need is not available then hit the "Add data" button when you are in the edit mode of a report.

Step 1: Find the PostgreSQL Connector 

find postgreSQL

 

Step 2: Entering the customer's credentials

You will have to enter the following information.

Host Name: milkcrate-prod.cgn8sec56kfk.us-east-1.rds.amazonaws.com
Database: milkcrate_prod
User Name: (check password spreadsheet)
Password: (check password spreadsheet)

If you cannot find the customer on the password spreadsheet you will have to contact the development team.

Step 3: Select the Table You Need

There are a wide range of tables from our database you can access from Data Studio. Anytime you need access to a new table you will have to hit the "Add data" button and repeat this process.

Step 4: Rename Data Source

Immediately after you add a data source be sure to change the name inside the report by pressing on Resources>Manage added data sources. OTHERWISE, you will have a lot of data sources with the same exact name.

 

    • Related Articles

    • Data Specialist Role

      Responsibilities: Your day-to-day responsibilities will include the following: Attending data related customer meetings Creating reports using Google Data Studio based on customer needs Communicating with customers to present and request feedback on ...

    • Data Analysis

      A Data Analyst will build custom charts and exports that will always display live data based on your data evaluation needs. It would be $1,000 for the initial set up and $50 an hour for additional requests.

    • Data Entry / Upload

      A MilkCrate staff person can be hired on an hourly basis to enter in or alter data on your behalf at a rate of $25 an hour. For larger, bulk uploads, a MilkCrate developer can be hired on an hourly basis to build a custom script on your behalf at a ...

    • Add Testers On Google Play (Android Users)

      Invitation Email Potential testers will be receiving an email invitation from Apple, inviting them to be a member on our Google Play (Android) Developer Team. This invitation will include a URL so testers can download our app. Download Test App ...

    • Data Support

      Requesting a Chart: Email support@milkcrate.tech to request a chart. We should be able to fulfill your request in 4-16 business days. Reports: Our team will create a quarterly report to review the AARRR metrics and key user scenario success.