#Data Warehouse Project
Please note! The user_data.php and client_secrets.p12 files are not included and need and need to be added for this app to run.
##Instructions to recreate this project
###Google Analytics API
####PHP Client Library
To download and set up the PHP Client Library, follow Google’s Hello Analytics API PHP QuickStart Guide (for Service Accounts, not Web Apps): https://developers.google.com/analytics/devguides/reporting/core/v3/quickstart/service-php
####Amcharts Code Template
Instead of using Google’s HelloAnalytics.php code to make API calls, you can use the more universal code example from the following Amcharts tutorial (amcharts.php was renamed app.php in the main folder of the client library): https://www.amcharts.com/tutorials/use-amcharts-to-visualize-google-analytics-data/
####Query the Analytics data
The tutorials above don’t explain how to work with with multiple metrics and dimensions, so this is an example:
`$results = $analytics->data_ga->get( 'ga:' . $google_account[ 'profile' ], 'yesterday', 'today', 'ga:sessions, ga:organicSearches, ga:transactions, ga:transactionRevenue,',
array(
'dimensions' => 'ga:date, ga:source, ga:medium ',
'sort' => 'ga:date',
)
);`
####Google Query Explorer
You can test and construct API queries with Google’s Query Explorer: https://ga-dev-tools.appspot.com/query-explorer/
###Amazon Web Services
####Connecting with MySQL
Follow this youtube tutorial to set up a database (RDS instance) on AWS and connect to mysql https://www.youtube.com/watch?v=LnAvUOmH1n0
####Connecting with phpMyAdmin
This blog post explains how to connect phpMyAdmin to you RDS: http://www.tothenew.com/blog/remotely-connect-multiple-rds-instances-with-phpmyadmin/
which comes down to this:
On your computer go to the phpmyadmin folder, and its config.inc.php file.
In the config.inc.php file search here for $cfg[‘Servers’][$i] After moving down few lines you will find a line $i++;
After the first code block add following lines.
`$i++;
$cfg['Servers'][$i]['host'] = 'Your RDS Endpoint'; $cfg['Servers'][$i]['port'] = '3306'; $cfg['Servers'][$i]['socket'] = ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['compress'] = TRUE; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'USERNAME'; $cfg['Servers'][$i]['password'] = ‘PASSWORD’;`
Now you can select your AWS database from a dropdown menu in phpMyAdmin.
####Connecting the Analytics API Query app to your RDS instance
In app.php (previously amcharts.php) file under session start() add this code to connect to the AWS database:
$server = ‘mysql:host=your-db-instance-end-point-point-here;port=3306;db=yourdbnamehere’; $username = ‘your-username-here’; $password = ‘your-password-here’; $db = new PDO($server, $username, $password);
###Legal
Copyright (c) 2016
http://developers.google.com/api-client-library/php
For the latest installation and setup instructions, see the documentation.