HowtoCreateaWebsiteAnalyticsService_MySQL

Website analytics is one of the most crucial tools for webmasters; they provide insight for the number of unique visitors, page views, Bounce rate, visitors’ location, visitors’ path (entry and exit pages) and more. All of these information help the webmaster better understand the website users and how to better serve them.

There’re many website analytics solutions available; Google Analytics, StatCounter, AWStats are three of the most commonly used website analytics solutions but each one comes with its own drawback. Piwik is open source website analytics software that’s very accurate, very easy to install and use and gives the webmaster a detailed overview about the website analytics. This post will present a step by step guide on how to create your own website analytics service using Piwik and Openshift, without further ado let’s go to the steps:

Ingredients

1. A free Openshift account, just go toOpenshiftwebsite and register using your email, no credit card is required.

Steps

1. After registering; go to Openshift home page and click on the “MY APPS” on the top of the screen.
2. You’ll be directed to your log-in window and enter your credentials, you’ll be directed to a new window click on the blue “Create your first application now” link.
3. You’ll be directed to a window, select the “PHP 5.4” tab from the “PHP” menu.
4. You’ll be directed to a new window, in the public URL; type the name of the project/application name (e.g. MyAwesomeAnalytics, Piwik, etc.) in the first space and the domain name (it’s not your real domain name, just any identification name e.g. AwesomeGuy/AwesomeGal) in the second space.
5. Under the public URL, there’s the source code slot, just copy and paste the following link “https://github.com/openshift/piwik-openshift-quickstart.git” and it should like the screenshot below:
6. Leave everything as it’s and click on “Create Application” tab at the end of the window.
7. It will take a while then you’ll be directed to a new window, just click on the blue “Not now continue” link.
8. You’ll be directed to a new window where you should add MySQL just by clicking the blue “MySQL” link.
9. You’ll be directed to a new window, just click on the “Add Cartridge” tab.
10. You shall be directed to anew window where you shall find all of your “MySQL” credentials.
11. Now you’ll need to add phpMyAdmin; click on the blue “Add phpMyAdmin” located at the bottom of the same window.
12. You’ll then be directed to a new window to confirm the addition of phpMyAdmin, just click on the “Add Cartridge” tab.
13. You’ll be directed to the main window again and it’s time to go to your Piwik installation window, to do that simply click on the blue link at the top of the screen (that’s your URL).
14. You’ll be directed to the Piwik installation window, just click on “Next”.
15. You’ll be directed to a new window, it’ll check the status of some services, just click on “Next”.
16. You’ll then be directed to a new window where you should provide your database credentials, there’s s small trick here which is getting your database server IP, the easiest way to do so is to return to your application and click on the small arrow at the phpMyAdmin tab.
17. A new window will popup just copy the number shown in the below screenshot.
18. Paste that number in the database server slot in the Piwik installation, then fill in the rest of the information from your database credentials that you can find in your application, then click next.
19. You’ll be directed to anew window informing you that a table has been created successfully which means that everything is going fine will now, just click “Next”.
20. You’ll then be directed to a new window where you should create a username, password and email address and then click on next.
21. You’ll then be directed to a new window where you should fill your website’s name and address, just fill it and click next then you’ll be directed to a new window where you shall find the tracking code you should put on your website.
22. You’ll then be directed to a new window, click on “Continue to Piwik” and you’ll be directed to Piwik login window, just fill in your credentials, and then you’ll be directed to the Piwik home page.

Now, you’ve a fully functional analytics system for your website that’s accurate, secure and free.