Digital Media Marketing Guides

Google Data Studio Web Analytics

Google Data Studio: New Amazing Version of [Data to Decision]


oogle Data Studio

Google Data Studio will be available to everyone! I am amazed to hear that Google Analytics team have finally released the news officially about it. There will still be the robust Data Studio 360 for enterprises, but a standard version will be available to everyone to create beautiful and insightful visualizations.

Our vision for Google Data Studio is to enable customers to access, visualize, and share all their data, regardless of where that data resides. Today we are adding support for the popular Google Cloud SQL and MySQL databases. This is the beginning of making your first party data available through Data Studio.” said Google Analytics team on 23rd, August 16

This is great news to all data professionals and enthusiasts, as there aren’t any first class data platforms that can be used to access, transform, visualize, collaborate and share data at scale and for free!

In this article I will discuss how Data Studio relates to other Google Analytics products (specifically the Google Analytics 360 Suite) and then I will go on to show how to use Data Studio (DS). There are a few areas I will focus on: how to access / transform / manage your data and how to visualize / collaborate / share it. (I know, it’s a lot to focus on, but stay with me!)

Data Studio and the Google Analytics platform
You probably heard about the Google Analytics 360 Suite, a platform that will help you evaluate the full customer journey and drive results. The Suite is comprised of 6 products, as schematized below.

oogle Analytics 360 Suite

Here is the mission of each of the Suite products:

  • Tag Manager 360 – Data Collection: Get more data and less hassle with powerful APIs and partnerships.
  • Analytics 360 – Digital Analytics: Gain new insight with a total view of the customer experience.
  • Attribution 360 – Marketing Analytics: Discover the true value of all your marketing channels.
  • Optimize 360 – Testing and Personalization: Test and deliver more personal experiences on your site.
  • Audience Center 360 – Audience Analytics: Match the right people with the right message.
  • Data Studio 360 – Data Analysis and Visualization (cherry on top!): Build beautiful and shareable reports, with all your data in one place.

If you are using the free products, you will have access to the current versions of Google Analytics, Tag Manager, and the new Data Studio!

While the first 5 products are about collecting, analyzing and acting on the data, DS is about letting the data speak, uncovering insights through visual exploration. It is a great tool to craft data story that can resonate with all its consumers.

Google Data Studio Overview

Let’s start with what you can do on Data Studio. I like the diagram below, from my colleague Nick Mihailovski, Lead Product Manager for Data Studio. I think it summarizes well a common analysis workflow and the tool capabilities.

ata Analysis workflow

Connect – The first thing you have to do when working with data is making sure you have it! Once you do, check whether any preparation is required (e.g. calculated fields, different formatting, cleaning up) in order to make the data useful.

Visualize – Once the data is ready to go, you will open your canvas and start connecting the dots, beautifying the charts and making sure they tell an insightful story. The cool thing is that now you can collaborate and work across cities or continents in the same way that you already do with Google Docs, Sheets and Slides. Analysts of the world, unite!

Share – And since you are having so much fun and finding so many insights, why not share it with your colleagues? I am sure they will appreciate! Even though we are making sharing simpler, a click of a button, remember that data is a serious business, make sure you think through before you share.

Now that you know what you can do with Data Studio, let’s do it, login at You will see something similar to the following page.

ata Studio interface

The interface is pretty straightforward. You can choose an account (if you have multiple) in the top right corner; and you can see all, shared, or trashed reports (default page) and Data Sources. Easy peasy.

Let’s dive in and look at some cool stuff available through DS. I will start with Data Sources, the interface used to connect your data. Following that, I will discuss the Reports interface, where you will let the artist and businessperson in you go wild

Data Sources: Access, Transform, and Manage

Now to the data… click on Data Sources in the left “sidebar” (see screenshot above). Maybe you will already have some Data Sources in there, maybe you won’t. In any case, you will see a “+” sign in the bottom-right corner of your page, click on that to create a new Data Source.

The first choice you have to make is where you are getting the data from: Google Analytics, BigQuery, Sheets, etc. Once you click on one of them, choose among the accounts you have access to and click the “Connect” button. You will get to a screen similar to the following.

ata Sources

  1. Create a calculated field: you can use this to create new metrics based on a formula that transforms one or more existing metrics. There are dozens of operators available, here is a reference list.
  2. Field type: choose the formatting and the type of your metric. Here are the top level types, each has a bunch of options: Numeric, Text, Date & Time, Boolean, Geo.
  3. Field aggregation: choose the aggregation that should be used for your metric. For example, if your metric is a ratio such as Conversion Rate, you should use Average, if it is an absolute value such as sessions, you should use Sum.
  4. Create a report: let the fun begin!

Before we dive into the Reports, I would like to focus a moment on the beauty of how Data Sources work. It is not just the fact that you can bring data from other systems that count, it is also how you can use them. One of DS capabilities I like the most is the fact that you can use Data Sources in three different levels:


  • Report level: The highest level component in the Data Studio inheritance chain. By attaching a Data Source to a Report you will be able to use it across all pages; it is possible to have multiple Sources attached to a Report, but you will choose one as the default, in case a Data Source is not set in the Page or Chart level.
  • Page level: A component of a Report. By setting a Data Source to a Page, you can make it the default to that specific page, even if another Data Source is set as the default in the Report level.
  • Chart level: A graphical representation of data within a Page, the lowest level component in the inheritance chain. The flexibility to set Data Sources to specific Charts has a great advantage when building dashboards for multiple websites, countries, business units or departments.

Now it is time to wear your oldest Marvel (DC is OK too) T-Shirt and roll your sleeves. Let’s discuss some visualization capabilities and best practices to start filling your canvas.

Reports: Visualize and Collaborate

After you create a Data Source, you will be given the option to create a Report right from there (see #4 in the screenshot above). But more often than not you will log in to your Data Studio account and create a Report right from the overview page. You will find the “+” on the bottom-right corner, click on it.

The best way to start understanding the Reports interface is by reviewing the excellent map published in the Data Studio Help Center (you will find yourself having this Help Center for breakfast, lunch and dinner, it is an awesome resource!) The descriptions following the chart are a simplified version from the link above.

eports interface

  1. Click on one of the chart tools to draw a chart in your report. 
  2. Configure data, settings and styles for any selected component.
  3. Click to switch between edit and view mode.
  4. Click to share this report.
  5. Add text to your report.
  6. Add an image to your report.
  7. Draw a shape in your report.
  8. Add a date range control to your report or a filter control.
  9. Undo and Redo.
  10. Mouseover to see data status and click to update the cache.
  11. Switch between Report pages, organize / add / remove pages from the report.
  12. Back to Homepage.
  13. Click to change the Report name.
  14. Shows who is viewing or editing the report.
  15. Click to manage your Google profile.
  16. Click to send us feedback (do it!)

Wow, that’s a lot of fun, and we barely started! And before we dive into best practices, I would like to reinforce #15 above. Once you create a Report you can share it with your colleagues to harness the collective knowledge of your company. This is a really big thing!

Below is an example where I am collaborating with my colleagues Tahir and Lizzie on a Report (they are really skilled data analysts!) As you can see, I am editing the top line chart while Lizzie (pink) is editing the donut chart and Tahir (turquoise) is editing the map. The cool thing is that you can actually see all changes in real time.

ata collaboration

Reports Best Practices

Since there are so many options available, and so many options within those options, I can’t possibly go over everything; so I will discuss some best practices I believe are critical to any Report. Data Visualization is an extremely rich world, I will not discuss fonts, colors, shapes, and charts in depth; since so many smart people already wrote about that, I am taking it as a given!

“In many ways, visualization is like cooking. You are the chef, and datasets, geometry, and color are your ingredients. A skilled chef, who knows the process of how to prepare and combine ingredients and plate the cooked food, is likely to prepare a delicious meal. A less skilled cook, who heads to the local freezer section to see what microwave dinners look good, might nuke a less savory meal. Of course, some microwave dinners taste good, but there are a lot that taste bad.”

Nathan Yau, Data Points: Visualization That Means Something

I am going to use the Page below as an example to 5 Best Practices I find can be used in a majority of Reports, but YMMV.

eports best practices

1. Filter controls give power to the users

Filter controls are like coffee with chocolate, they will drive your users forward and offer a rich analysis experience. If you choose the right filters and design them well, analysis will be easier and more effective; there is nothing more frustrating than doing an analysis and being limited by the lack of filters.

“So how should I design my filters?” Said no one ever. But I am glad you asked now!

I always invest some time in understanding the “foundational” dimensions of the Report and each Page separately. Ideally, you would want to have a set of constant filters across all your pages, so that the user can feel more comfortable when looking through the data, but this is not always possible… at least try to keep the same look and feel and some of the same filters. In the screenshot above, I used the same set of 5 filters across multiple Pages (see also #2 below).

In terms of design, I like the “Expandable” option, IMHO it looks nicer, but for short lists it might be useful to have the standard filter. Here is a great video describing this feature in detail.

2. Headers and page dividers are great for organization and consistency

To reinforce the point above on having a consistent experience across pages, I think a header can be very effective on a multi-Page Report. Not only it brings a consistent experience to users, it also informs them what data is available in a specific Page quickly. The header doesn’t need to be too complex, maybe a full-width strip with light background (as above). It can also include important messages to users, links to other resources or even a date picker (if you run out of space).

Edward Tufte termed the importance of consistency in design as “economy of perception results“:

“(…) once viewers decode and comprehend the design for one slice of data, they have familiar access to data in all the other slices. As our eye moves from one image to the next, this constancy of design allows viewers to focus on changes in information rather than changes in graphical composition. A steady canvas makes for a clearer picture.”

Edward Tufte, Envisioning Information

Page dividers can also be highly effectively to separate between different types of content. For example, if you are showing data for 4 different business units in a Page, you might consider having page dividers to make the separation clear. But again, make sure they are consistent across pages.

3. Chart diversity makes the report more engaging

When it comes to the charts themselves, diversity is a very positive factor; a Report containing only tables or only bar charts is a bit boring to look at for too long. Having different chart types makes the analysis more interesting. Of course you should still use line charts for trends, bar charts for group comparison, and tables where the value is important, but try to include some diversity in each Report… even if it means using a Pie Chart!

The Chart Chooser is a good resource on how to choose the type of visualization you need for your data.

4. Color styling helps guiding the eyes

Do not overuse color! Nothing states that more succinctly than Tufte’s Data-Ink Ratio:

“A large share of ink on a graphic should present data-information, the ink changing as the data change. Data-ink is the non-erasable core of a graphic, the non-redundant ink arranged in response to variation in the numbers represented.”

Edward Tufte, The Visual Display of Quantitative Information

In the example above, I used color to indicate which charts are most important and show the most interesting insights, making the top half of the chart colorful and the bottom half in shades of grey. I think this helps directing the eye. I also used only 2 colors which is usually not enough, but personally I find more than 5 colors hard to read.

5. The Report purpose informs the design

In addition to the above, it is important to remember that the purpose of the visualizations is incredibly important during the conception and creation of your Reports. You must think about the purpose as a whole: what are your users looking for and how to convey it in the best possible way? Stephen Few summarizes this very clearly:

“When you use tables and charts to discover the message in the data, you are performing analysis. When you use them to track information about operational performance, such as the speed or quality of manufacturing, you are engaged in monitoring. When you use them to prepare for the future, such as in budgeting, you are planning. When you use them to pass on to others a message about a business, however, your purpose is communication, no matter what the content. All of these are important uses of tables and graphs, but the process that you engage in and the design principles that you follow differ for each.”

Stephen Few, Show Me the Numbers: Designing Tables and Graphs to Enlighten

Sharing is caring: in moderation!

As you will probably notice, Data Studio uses the Google Drive sharing model, which you are hopefully acquainted with. It is important to notice that when you share a Report or Data Source with a person, the access will be given unrelated to whether the person has access to the data in Google Analytics, Sheets, BigQuery, etc. This means that it is extremely important to make sure that the data can be shared with the person.

Sharing data is great, but only when the right people have the right access to the right data.

Let’s look at an example.

ata sharing

In the sharing settings above, you will notice that three people have access to the report in question. I am the owner, Tahir can edit and Lizzie can view the Report. You will also notice in the first checkbox at the end of the settings that even though Tahir can edit, he will not be able to add new people to it. Also note that I can disable the options to download, print, and copy for commenters and viewers (in this case Lizzie).

Closing Thoughts


I have been playing with Data Studio for a while now, and as you can see I am pretty excited about it. I think this is a great opportunity to bring the Analytics community one step higher, improving the data reporting and visualization standards. Through Data Studio we will be able to broaden the horizons of our community, bringing more and more people into the data world. If you got this far, I am guessing you are quite excited about the Data Studio and the industry in general.



Read More
SEO Guide

How to Get Backlinks With Guestrographics?


shutterstock_405754042 copy

What’s the clandestine to acquiring the authority links? This question probably has given much worry to the new day’s business owners, but the question is easy to answer. With reference to other people who are capable of generating backlinks for adjusting everything that they wished to publish.

The question remains a mystery as how they do it? Are they well-familiar with the link building secrets that you event don’t know or what else? In fact, it’s true that they know the entire secret books of link building.

Link building might occur in the back of scenes, but most of us don’t even know how to acquire backlinks easily and effortlessly.

What helps people to consider linking to other websites?

You may come across thousands of emails having link requests. Right! I can make you believe that there is a simple yet effective link building formula available that works really well every time you use. That is the mixture of great content; targeted outreach and added value are the most significant ingredients to link buildings. Creation of great content with having eyeballs on targeted outreach are pretty straightforward that help publishing great stuff and allow them to appear in front of the appropriate people.

This is what most of us do. May people start sending numbers of e-mail contents to mass with a hope that someday someone will respond to their links to generate backlinks.

A mini case study on link building with the instrument Guestographics:

If you want to know all about adding value, then Guestographic has the ability to explain it. So, what’s it? Many of us may ask this question. So, for them, Guestographic is an extremely capable link building technique that makes use of your infographic contents and find ways to spread them in a new way. Instead of publishing infographics on the sites and pledging to people for sharing them, you can prepare them attractively and publish them on their sites. To depict how well it works, allow me to present you the outcomes after making use of the technique with my on page SEO infographic.

First of all, here is the immense increment in referring the domains pointing towards the page:

Referring Domains      







With this, the organic page ranking per search traffic of my site increases to 175.59% that can be compared to my previous month information.

organic traffic google analytics

The result shows how my page bounces in between 2nd and 3rd spots for every keyword search, on page SEO:

google search results first page

In short, it perfectly works. Doesn’t it?

5 smartest steps to get backlinks using Guestographics:

The methods couldn’t be much easier than using Guestographics. Here are the five steps to acquire backlinks for the site using Guestographics.

  1. Publish an infographic effectively on your site
  2. Figure out other sites that consider your infographic topic
  3. Portray them what’s your infographic
  4. Give them only exceptional contents
  5. Acquire your contextual and appropriate backlinks

Let me give you the exact brief details of each step.

  1. Publication of a splendid infographic: Absolutely, there is no shortcut available here. If you wished that people will share your infographic, then it has to be satisfying the criteria of good. Whenever talking about the design, keep in mind that they are really important for the site.

a)      A newly prepared appropriate topic: You need to select the topic precisely that’s what I would like to call a freshly made relevant topic. Let me clarify. In my opinion, I have noticed that audiences were posting articles about on page SEO on a daily basis, but they revised the same advice again and again from the year 2003. This lets me know that there was actually a lot of demand of the infographic topic in the market, but no updated contents are there to meet the demands.

Another example: At the time of when new social media network has been introduced to the world, someone will quickly bangs out the infographic content to that network. But surprisingly, I have found these infographics to get always a tidal wave of social media shares, backlinks and referral traffic. Here, I am presenting one of the first Pinterest infographic content:

Pinterest Infographic

This looks not a bad design and is not exceptional either. Now, I have the link profile of that page which published it. Check it out!

referring links

You might be thinking of how would it be achievable? In that case, the creators of this infographic topic pick up a topic that has huge potential to gain tons of social media attraction.

b)     Large sized information, but not too much: You can look into an infographic such as visual blog post which will show you how better could be the content and how better it can perform being on the site. Therefore, ensure that you’re very choosy to know what to include and what not to include.


Neil Patel is the person famed as the publisher of 75 infographics suggests that infographic topics should not have more than seven to ten informative points. This is not a lot and that’s the whole point. The infographic topics should not exceeds 50bits of data as it will be hard to digest. But it’s also an absolute truth that tightly-focused infographic content will cover up most of the important information that gives easy-to-remember option. In simple words, they can get shared and linked with ease. In the site site, you can easily find out the infographic data/information that has already covered up your topic:

visualy search

And, categorized by the number of views or favorites


And, now see if there are any other infographic ideas that you can find helpful to use:


infographic results

It is obvious to cite the infographics that you utilize in the sources region of your infographic content. You can also get the same exact thing via using Pinterest:

pinterest search

c)      Logical layout: In the graphic design section, there is a huge difference exists in between layouts and designs. And, I have witnessed a lot of site facing downfall though they are great infographics as they give more emphasis on the design section. Here, I am presenting the difference between design and layout.

Layout is what you find useful in organizing and publishing information in the wireframe whereas design will give how the information can look like.

Ensure that the layout should have the best content, ample of empty space and organized option to make the info represented as story.

  1. Simple link prospective yet effective one: Since you have your infographic distributed on your site, it’s an ideal opportunity to discover your connection targets. With my infographic, I was searching for locales that had effectively distributed substance about on page SEO. To discover them, I just hunt Google down things like “on page SEO”, “on page SEO tips and whatever else that Google Suggest concocted:

google search

Another best example could be: If you wish to promote a site with gluten-free cooking, then you should start the search with gluten-free baking or gluten-free recipes etc. It’s easy, right!

  1. Show your infographic to them: When I found a site in the outcomes that looked encouraging, I sent them this email (yes, this is an authentic email that I conveyed).

Outreach Email

Reasons why this script works perfectly in my case:

  • It’s personalized which is available only with their name and site name
  • It’s short in length carrying a total of 90words
  • It’s soft sell which liable to ask only if they show interest to see the infographic
  1. Make bribe your prospects with the help of free contents: It is the section where things get extremely intriguing. At the point when a great many people pitch an infographic, they get on their knees and ask. Bear in mind: when you are doing e-mail outreach, you have to make increasing the value of that particular site.

What’s more?

With the Guestographic method, you are letting forth them a free ‘mini-guest post to oblige the infographic. In this way you are giving value 3times:

  • Visualizing them an amazing and good working infographic on a particular topic on their personal interest
  • Allowing them to share the content with their targeted audience is also an interesting topic
  • Offering them free contents to harmonize the infographic

Here’s the email that I have sent to my audiences and gain numbers of reply on my first message:

Response to an Email

Whenever they reclaim my support, I just say Sure. I just get my stuffs and note down an effective yet top-rated 250 to 300 words introduction and published them on their site.

  1. Acquire the contextual links: You probably have had heard that GOOGLE is devaluing the backlinks those are coming straight from infographics. But if you give a look into the interview, then you’ll find that they were talking about the embed links.

infographic embed link

These links come into view repeatedly when someone will try to embed infographic content to their operating websites. These are the same links of semi-automatic types that GOOGLE even doesn’t like it. What’s good in Guestographic is that you can have the privilege to obtain backlinks surrounded by only appropriate contents and not an embed link that buried down at the bottom of the page.

Here, I am presenting an example of a contextual link out of a Guestographic:

contextual link

The contextual link present is much more capable of handling things and powerful enough compared to the embed links.






Read More
SEO Guide

17 SEO Myths You Should Leave Behind in 2016


23 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19  20 21

Read More

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

Read More