欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

How to Create a Website Analytics Service_MySQL

程序员文章站 2022-06-14 10:43:53
...
How to Create a Website Analytics Service_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.

How to Create a Website Analytics Service_MySQL

Steps

  1. After registering; go to Openshift home page and click on the “MY APPS” on the top of the screen.How to Create a Website Analytics Service_MySQL
  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.How to Create a Website Analytics Service_MySQL
  3. You’ll be directed to a window, select the “PHP 5.4” tab from the “PHP” menu.How to Create a Website Analytics Service_MySQL
  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.How to Create a Website Analytics Service_MySQL
  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:How to Create a Website Analytics Service_MySQL
  6. Leave everything as it’s and click on “Create Application” tab at the end of the window.How to Create a Website Analytics Service_MySQL
  7. It will take a while then you’ll be directed to a new window, just click on the blue “Not now continue” link.How to Create a Website Analytics Service_MySQL
  8. You’ll be directed to a new window where you should add MySQL just by clicking the blue “MySQL” link.How to Create a Website Analytics Service_MySQL
  9. You’ll be directed to a new window, just click on the “Add Cartridge” tab.How to Create a Website Analytics Service_MySQL
  10. You shall be directed to anew window where you shall find all of your “MySQL” credentials.How to Create a Website Analytics Service_MySQL
  11. Now you’ll need to add phpMyAdmin; click on the blue “Add phpMyAdmin” located at the bottom of the same window.How to Create a Website Analytics Service_MySQL
  12. You’ll then be directed to a new window to confirm the addition of phpMyAdmin, just click on the “Add Cartridge” tab.How to Create a Website Analytics Service_MySQL
  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).How to Create a Website Analytics Service_MySQL
  14. You’ll be directed to the Piwik installation window, just click on “Next”.How to Create a Website Analytics Service_MySQL
  15. You’ll be directed to a new window, it’ll check the status of some services, just click on “Next”.How to Create a Website Analytics Service_MySQL
  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.How to Create a Website Analytics Service_MySQL
  17. A new window will popup just copy the number shown in the below screenshot.How to Create a Website Analytics Service_MySQL
  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.How to Create a Website Analytics Service_MySQL
  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”.How to Create a Website Analytics Service_MySQL
  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.How to Create a Website Analytics Service_MySQL
  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.How to Create a Website Analytics Service_MySQL
  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.

How to Create a Website Analytics Service_MySQLNow, you’ve a fully functional analytics system for your website that’s accurate, secure and free.