Five Important Things for All PPC Agencies to Focus On

Pay Per Click

There are certain things that every PPC agency should make a point of focusing on in order to become as successful as possible. It’s easy to lose sight of what’s really important when you are running a business, which is why it’s so important that you keep certain things in mind at all times.

When you learn which things you should concentrate on the most when running a PPC advertising agency, you will be able to serve your clients well. And the happier your clients are, the more likely they will be to keep paying for your services.

1.     Maintaining a Personal Connection with Clients

It is crucial that you put a lot of emphasis on creating and maintaining a personal relationship with each of your clients as well as potential clients. When they feel like you actually care about helping them reach their business goals, you won’t have any issues keeping them. There are so many faceless PPC agencies out there, and part of what so many people want is that personal touch.

2.     Innovative Solutions

It’s also imperative that you come up with innovative solutions for your clients. You aren’t going to last very long in this line of work if you are just doing the same exact thing as every other agency. You’ll need to get creative when it comes to helping your clients meet all of their goals, where businesses can rely on your PPC agency as a true partner. This is one of the biggest things to focus on when running this type of business.

3.     Solve Your Client’s Primary Issues

If you want to run a successful PPC advertising firm, you will need to solve each client’s primary issues, whatever they are. Whether your client is having issues with breaking into social media, or they are trying to figure out how to refresh their brand, it’s up to you to come up with solutions. You should ask each of your clients to describe the problem they are having in a succinct manner so you’ll have an easier time helping them with what they need.

4.     Make Your Website Professional and Attractive

Nobody will want to pay for the advertising services you have to offer unless you have a good-looking website that also appears professional. Make sure that you invest a decent amount of time into designing a website that is easy to navigate and is aesthetically pleasing.

5.     Communication is Key

People want an advertising agency that is good at communicating back and forth with them, so that’s exactly what you’ll need to provide your clients with. Make sure that you promptly respond to all queries so that none of your clients feel the slightest big neglected.

With all of the different PPC advertising companies that exist, you will need to make sure that you stand apart from the competition. As long as you put in the necessary time and effort, you should have no problems whatsoever maintaining a healthy number of clients. Pay-Per-Click advertising has become very popular over the years, so there is plenty of untapped potentials out there to explore.

User Request Web Content Prognostication

Discover ways to examine web server log files to learn ways of users website browsing and forecast next browsed content. This article explains applying extensible Markov model to cluster web pages on a website and predict the place user will move next. The algorithm utilizes InfoSphere® Streams and R for regular issue prognostications based on model.


Webserver log files are used to examine users surfing behaviour. As an illustration, in “Predicting Web Users’ Next Access Based on Log Data”, Rituparna Sen and Mark Hansen have utilized combination of first-order Markov models to examine clusters of pages on a website. They applied these models for prognostication which webpage user supposed to visit next. They suggested implementing this information to pre-fetch a resource before a real request by user. This article will explain how to use IBM InfoSphere Streams, combined with R to run an identical analysis of webserver logs.
This solution is implementing extensible Markov models (EMMs), initially released in 2004 by Margaret Dunham, Yu Meng, and Jie Huang, to mix a stream clustering algorithm with a Markov chain. A Markov chain is a mathematical system that reviews transformations from one state to other, in which the following state is relying only on present and not the sequence of proceedings that came before.
The states of Markov chain are aggregation specified by stream clustering algorithm. The EMM can transform eventually by including new states since they are discovered and also damping or trimming current states with time. Consequently, the model is able to make adjustments eventually. This opportunity is particularly crucial in systems with dynamic usage style that changes over the time. As an example, website will probably display dynamic usage pattern, as well as improvements in structure, in some time.

Advantages of integration

The majority of machine learning models designed for forecasting are performed offline on big amounts of training info. Right after the model are properly trained, prediction could be done right away. This technique is suitable for numerous sorts of issues, however if the patterns for prediction are changing regularly, this method could create models that drop behind the system they are attempting to forecast. Since EMM could be educated dynamically, they are effective for modelling systems like network traffic, auto traffic, or another system in which clustering patterns can transform eventually. Web server traffic is one of those sphere. Server logs deliver an infinite source of streaming information to educate the model when the system is already performing forecasting.

Prognosticating content requests from web server logs

Internet servers are keeping logs of resource queries. Every log entry consists IP address of user, timestamp for request, and the destination for requested data. All this information characterize user and requests to website.


This article shows how to forecast users actions on a website to predict content requests using webserver log files. The modelling and prognosticating are completed by applying EMM. The solution represented here is a testament to concept. Upcoming work is essential for developing a genuine solution. Next actions involve enhancing overall performance by clustering sets of webpages, incremental studying, and using InfoSphere Streams to carry several cases of R.

Cognos 10.1 install on CentOS 6.3 64 bit

  1. yum update (then reboot if kernel has been patched)
  2. yum install glibc.i686
  3. yum install openmotif
  4. yum install libgcc.i686
  5. yum install openmotif22
  6. yum install openmotif22.i686
  7. yum install xauth
  8. yum install libXtst
  9. tar xvzf bisrvr_linuxi8664h_10.1.1_ml.tar.gz
  10. cd linuxi38664h/
  11. ./isetup

How to Flatten a Dimensional Data Model Built in Excel with Pivot Tables

To flatten a dimensional model built in Excel using pivot tables, follow these steps:

  1. save the original worksheet with the pivot table as a CSV (tab delimited is even better)
  2. select the range or column that contains the blanks (if you have blanks under the header, don’t select the column header in the range)
  3. select Edit -> Go to… -> Special
  4. select blanks (at this point Excel will select all the blank cells
  5. press equal
  6. point to the cell above the first selected cell
  7. press <ctrl>+Enter and Excel will copy the formula to all the blank cells
  8. to replace the formula by the values, simply save the worksheet again as CVS, or copy and paste special the cells as values
  9. that’s it, you’re done. (Don’t forget to save.)

Intro to Statistics

Q: Could you recommend some books on statistics that would allow me to be more efficient at Business Analytics?

A: Below are some sites that you may find useful.

1)      The online copy of StatSoft, the Statistica textbook, a good resource, and it’s organized as a book.

2) UCLA has an online probability and statistics book, although it may be too elementary for you.

3)      Planet Math has a lot of very useful links.   If you scroll down the page for the URL below, you’ll see a link labeled 62-XX, Statistics.  (There are plenty of other valuable links too.)

4)      The Kahn has some excellent short videos on specific topics in statistics.  More generally, the entire site is very well regarded.

It you share the name(s) of the (text)book(s) that you’ve read I can identify which resources may be of the most use to you.  As I’m sure you’ve discovered, statistics fractures into a myriad of sub topics just like mathematics.  So narrowing this down will let me help you better.

Enterprise Social Media Analytics with Atlas for Connections

The key benefits from deploying an enterprise social media software are to improve

  • customer satisfaction by building stronger relationships with customers,
  • staff effectiveness by simplifying access to existing internal expertise,
  • staff retention by allowing employees to build a stronger network and stronger relationships within the enterprise.

Atlas for IBM Lotus Connections is a social networking application, available from IBM Software Services for Lotus (ISSL), that allows users to visualize their current network of contacts and see how they can efficiently extend that network to tap into valuable resources and trusted experts across an entire organization.

Atlas enables these capabilities by accessing information from the different components of Lotus Connections. When users log in to their dashboard, Atlas compiles and displays information that will help them better understand the company’s professional networks and who they can tap into these networks to increase their effectiveness day in and day out.

With the help of these different components, Atlas allows users to:

  • visualize and analyze social networks in an organization,
  • identify the shortest path to reach someone,
  • find expertise across extended networks,
  • visualize and manage their personal networks.

Contact us to leverage this social networking and visualization application to help your company build vibrant and balanced professional networks, increase team effectiveness, and improve individual productivity.

Watch this brief demo from IBM demonstrating how to unlock the value of enterprise social media.

Installing a Secure Certificate on IBM Smart Business Server (VERDE)

At the time of this writing, the IBM Smart Business Server’s control panel doesn’t allow importing a secure certificate (SSL cert). Never-the-less it is possible to install a valid (CA signed) secure certificate from the command line. This article assumes that the reader is familiar with SSL and the basic SSL KEY, CSR, and CRT generation step. We are therefore picking up at the point where you have an SSL KEY as well as an SSL CRT. You will also need a machine that has openssl installed (any Linux or Mac box will do). In fact the smart business server itself has openssl installed, as well as keytools, so all the steps can be performed directly on the smart business server.

Please note that this is a draft document, and work in progress. At this time only the public facing websites have been successfully set up with a CA signed certificate.

  • The Apache configuration file for the setup wizard is:/etc/apache2/httpdWSW.conf
  • The Apache configuration file for the intranet is here:/etc/apache2/httpdInt.conf with the corresponding SSL configuration here: /etc/apache2/extra/httpdInt-ssl.conf
  • First copy the new key and cert (in the same file, key goes on top and then the cert) into /etc/opt/ibm/bbp/smartcontainer/httpdWSW.cert
  • (Optional, this step hasn’t been successfully tested, because a non-RFC compiant method is used.) To create an RFC compliant PKCS8 version of the key pair where the intranet config file is expecting it:
    cd /etc/opt/ibm/bbp/
    openssl pkcs8 -topk8 -inform PEM -nocrypt -in smartcontainer/httpdWSW.cert -out PKCS8.cert
  • Make sure the CA bundle is made available and properly reference in the above mentioned config files (cp path/to/sf_bundle.crt smartcontainer/)
  • Create a PKCS12 version of your certificate:
    openssl pkcs12 -export -chain -CAfile sf_bundle.crt -in '<your>.crt' -inkey '<your>.key' -out PKCS12.cert -name <name> -passout pass:111111
    (at the time of this writing, the default cert store password hard coded in the VERDE install is 111111)
  • Location of the Java SSL Keystore: /etc/opt/ibm/bbp/SSLkeystore
  • Location of the [SAFEv3] encription tool:/opt/ibm/bbp/saf/
  • Password retrieval command:/opt/ibm/bbp/saf/lib/security/manageAdminCreds -f get -a JavaKeyStore2048BitKey -i 1
  • Create a new keystore based on the PKCS#12 cert:
    keytool -importkeystore -destkeystore -srckeystore PKCS12.cert -srcstoretype PKCS12 -alias <common_name_of_SSL_cert>
  • Update the Keystore configuration reference in /opt/ibm/bbp/saf/cfg (use the password retrieved above).
  • Copy the PKCS#12 cert to the VERDE Tomcat cert store:
    cp PKCS12.cert /var/lib/verde/host.p12
    cp /var/lib/verde/host.p12 /usr/lib/verde/etc/host.p12
    (Make sure you save your previous copies of any file you modify.)

At this point, you have to restart the system, to make sure that all public services get the proper certificate loaded on boot. If you prefer, you can restart the services:

  • /etc/init.d/lwi restart
  • /etc/init.d/simpleAgent_d restart
  • restart the VERDE software from the web console


  • Many thanks to the bISV IBM support team

Free IBM training video for CloudBurst Appliance

IBM CLoudBurst Appliance Training Video

IBM just published fresh training videos for their CoudBurst Appliance.

“This video, based on five online lectures and five online demonstrations, provides in-depth information about WebSphere CloudBurst Appliance and WebSphere Application Server Hypervisor Edition. It demonstrates how to: configure resources managed in the cloud; create virtual systems for deployment to the cloud; administer resources deployed to the cloud; and create a multiple image pattern and manage dynamic machines. ”

IBM CloudBurst Appliance Training Video (As of 2016, the video is no longer available.)

Business Analytics Software Efficiencies are Key

Business Analytics, Business Intelligence and the Hardware Upgrade Tarpit

A common misconception about business analytics, is that better business analytics usually requires better hardware.

Business Analytics: Software rules over Hardware

A number of blogs have recently reflected on the “REPORT TO THE PRESIDENT AND CONGRESS DESIGNING A DIGITAL FUTURE: FEDERALLY FUNDED RESEARCH AND DEVELOPMENT IN NETWORKING AND INFORMATION TECHNOLOGY” pointing out how progress on algorithms has contributed 43 times more to advances on processing speed than pure hardware improvements (Moore’s Law). &emdash; The report notes that in a 15 year span ending in 2003, hardware improvements accounted for a 1,000 fold increase in compute speeds, while during the same period, the algorithmic improvements accounted for a 43,000 fold improvement.

Business Analitycs

Business Analytics: Focus on Smarter Data Warehousing

While these numbers may certainly be up for debate, the main point to retain, is that by improving the algorithms, i.e. the software used in your systems, you can attain much higher efficiencies then by replacing the hardware alone. Taking a holistic approach, using an Information Agenda that takes into account all aspects of the data lifecycle paves the way for a better Data Warehouse that enables smarter Business Analytics, avoiding the tar pit of never ending hardware and software upgrades.

Updating the Rate Sheet in the COGEXO Rating Engine

Rate table update on MySQL backed database

The concepts in this guide apply for the DB2 version of the rating engine.

Data Fromat


Data Upload

For the MySQL back-end, use phpMyAdmin to upload the data:

      Log in to phpMyAdmin
      Select the rate table
      Click the import tab
      Select the file that has the comma delimited values (CSV)
      Set the number of lines to skip to 1
      Select CSV radio button
      Set the delimiter to “,”
      Check the replace data with file box
      Click Go

Upon successful import, a message diplaying the number of values imported, for example:
Import has been successfully finished, 1578 queries executed.