Image

The tragedy behind Indian IT Services

Understanding Indian IT Companies (TCS, Infosys, Wipro, HCL Tech, TechM)

via Understanding Indian IT Companies (TCS, Infosys, Wipro, HCL Tech, TechM) —

An excellent infographic of the top IT/ITES providers in the country.

The bulk of the revenue comes from abroad, and this seems to be a problem. As technology keeps getting more simpler and easier to adopt, the reason to outsource the contract to another country will keep going down.

Combine this with the recent spate of visa issues, and you have one impending slump in the near future.

Google, GoDaddy and the HTTPS Conundrum

I like to stay active on this blog, and I love the constant tinkering on WordPress (right from identifying which plugins to install to customizing the theme).

This is one of the main reasons I am able to blog on a regularish basis. Obviously, since it’s a content driven site, the bulk of my traffic comes from Google Search.

So what’s wrong with that

The over dependence on organic search means for the blog to have more visitors, user engagement and comments – I have to try and follow the diktats of the market leader in Search. That’s Google.

I am a fan of most of Google’s work. However, the kind of hold they have on the search market means that publishers who want to be found on search have to work towards being search friendly. Google is all about Do No Evil, and I respect them for that. However, with the recent HTTPS update to their search algorithm, small time publishers are forced to relook at their hosting solutions.

GoDaddy and shared hosting

My site doesn’t get a lot of traffic, 2k-3k visitors a month. For that kind of traffic, a shared hosting plan is perfect. I have been using GoDaddy for quite some time now. Primarily, because most of my domains are within this account.

For the past 8 years or so, I have been using this account, I cannot complain about the service. I know it’s a shared hosting, and it has managed to meet my expectations.

Until now.

GoDaddy and HTTPS

The hosting plan I have is a simple plan and it does not support me having to install a custom SSL certificate. So much so that, even if I wanted to purchase a certificate from GoDaddy – I am not able to do so. Perhaps its a glitch in their interface.

I could get a Lets Encrypt certificate, and that’s what I have done for the 13 Llama Interactive site and for Harshaja’s blog. The problem with this approach is that both these sites are hosted on a DO instance. Where I can easily control the installation of the SSL certificate.

There is no simple option for doing that. GoDaddy support is of no use, and that leads me to a dead end.

Cloudflare can help

This is where a reverse proxy like Cloudflare helped. Atleast all the requests that are going to the site can be sent to an HTTPS version of the site. The lookup itself is done via Cloudflare and I have updated the website settings in my WordPress to serve from the HTTPS endpoint.

However, this kind of kills the wp-admin section. Thankfully through the REST API and Jetpack’s connection to WordPress.com I can still manage to post content.

So what can a publisher do?

At this juncture, I could simply shift my hosting and be done with it. It’s the easiest option. However, what about all those publishers out there who may not have such an option available to them.

There has to be a simpler solution to this mess.

Using Data Studio to create beautiful Reports

In the month of November 2016, Data Studio was made available for all users in India. The product was launched quite some time back, however, it was only accessible in the US and for premium Google Analytics 360 users.

However, as of today, anyone can use Google Data Studio to create dazzling reports that can be shared with teams and clients.

So how does one go about creating awesome reports?

That’s where Data Studio shines, it allows users to create one template which can be utilized across multiple data sources. I tried to create a quick report using one of the default templates provided, here’s a step by step guide on using Data Studio to create reports.

An update: As of 2nd Feb 2017, Data Studio has been declared a free product for everyone to use.

Adding a Data Source

First, we need to add our data source (in this case my site’s Google Analytics account) to the Data Studio.

Choose the Data Source menu from the Dashboard

Choose the Data Source menu from the Dashboard

Once you click on the menu, you would be directed to a screen listing all the data sources that you have added to your account.

Note, by default Google keeps some data sources in your account, so that one can practice on the product before moving on to your own data sources.

List of Data Sources

List of Data Sources

As all Google products, you can see the clear use of Material Design in this interface. Use the blue floating action button at the bottom right of your screen to add your own custom data source.

Connecting GA as Data Source

Connecting GA as Data Source

As the screenshot above shows, that most of the Google products can easily be integrated to this product. What’s more you can even use a MySQL database or a Google Spreadsheet (Excel ahoy!).

So, I could do most of my number crunching in existing styles, and use this tool only as a slick presentation layer.

After I press connect, this GA property of my site is now added to Data Studio as a source of data.

The minute you choose the right property, you would see all the dimensions and metrics that Google Analytics has. This is a pretty exhaustive list and you can import most of these into Data Studio.

GA Fields Imported as Dimensions and Metrics

GA Fields Imported as Dimensions and Metrics

Now that the important fields are linked (do check the respective fields you want to pull), we can go on to using a report template.

List of my Data Sources

List of my Data Sources

The screenshot shows the recently added data source. Great! We are all set to creating awesome reports!

Using Report Templates

We would be using the Acme Marketing template that’s there in the account. It broadly shows basic user level data in one simple report.

Keep in mind that Data Studio reports can span across multiple pages, but for this guide we are sticking to a one-pager.

Go back to your dashboard and choose the Acme Report template.

Acme Data Studio Template

Acme Data Studio Template

Click on the Use Template button, and now this is the most important point when it comes to using Data Studio report templates, choose your own data source.

Selecting the right Data Source

Selecting the right Data Source

Something for beginners to keep in mind again, is that if you choose the wrong data source (for e.g. of the default ones provided), then the report would be generated, however the data won’t be yours!

If in case, you have done this, it’s easy to change the data source after you have created the report.

Let’s move on to customizing the report

 

Customizing the Report

Customizing the Report

What I did was choose the Acme logo, and change it to the Big Fat Geek logo! A small change in the header color, and I have a branded look for the template.

This is what the finished report now looks like –

Finished Report

Finished Report

Using Data Studio

The cool part of Data Studio now shines through. What I have is a report which talks to data in real time. So I can change my data range, and my report updates!

This report can now be shared with my team or my reporting manager or clients without worrying about giving access to all the dimensions and metrics.

Data Studio Working Report

Data Studio Working Report

That’s all for today folks! It’s your turn to go and try out this tool and churn out spectacular looking reports.

The referral spam bots are now from Saint Petersburg

I had written in the past about discovering the Samara Oblast bots. For those of you who are unaware, just quickly check in your Google Analytics, in the Audience reports section the Location report.

If you are receiving a bunch of traffic from Russia, then it’s most likely spammy traffic. This traffic will never convert and will always be a small set of users, however with a decently large number of sessions.

Continue reading