Supermetrics Data Studio Connectors

Data Studio Connectors: 4 Easy Steps to More Insightful Analytics

Data visualization matters – a lot.

By some estimates, 65% of people are visual learners and process information best by seeing it. To a certain degree, however, we may all be visual learners when it comes to complex data because a well-designed visual can condense lots of numbers into a more readily apparent outcome or trend. Not surprisingly, when it comes to business, data visualization is a critical tool. Timely, transparent analytics in graphic, bite-sized formats can help managers understand their companies better, identify potential customers, and hone in on effective growth strategies.

If you’re a digital marketer, chances are you work with data all the time. But, in reality, your clients may not. Even with mounds of fascinating metrics available in their marketing reports, managers often come back to us and ask, “OK…now what?” The problem is compounded by the fact that marketing data is everywhere – different platforms, different formats, different reporting options, different reference points.

In April of this year, I wrote about Google Data Studio, a tool that pulls data from the Google ecosystem and can be used to populate configurable, visual dashboards. It’s become an absolute mainstay in our client reporting toolkit allowing us to give performance snapshots across a broad range of digital marketing metrics. However, beyond the data you can mine from Google, there are many other important performance metrics to consider – social media ad engagement, email campaign click-through rates, video views – to name a few. Now, with Data Studio Connectors, you can pull all types of data into your Data Studio (DS) dashboard from platforms that are outside Google.

marketing analytics

I decided to take Data Studio Connectors for a spin. These Connectors were launched by Supermetrics on September 7, 2017. Now there is no need to first pull all the marketing data into Google Sheets and then into Google Data Studio – you can use the Connectors to pull the data directly. I set myself a challenge – I wanted to layer some social media metrics onto a client report we had already created in Data Studio that included Google Analytics and Google AdWords data.

It worked! My new, improved dashboard report consolidated, streamlined, and visually standardized social media metrics into our current Data Studio report. 

Here’s a step by step:

Supermetrics Data Studio Connectors

Step 1: Pick a Data Studio Connector

Go to the Data Studio Connectors homepage, scroll through the available Connectors and choose which one you would like. I picked Facebook Insights and clicked the Try now button. On the next screen in the top left where it says Untitled Data Source, I named my Connector data source (Agency Tip: Put your client name in there too, so you know which client) and then click Authorize.

connect outside data source for Data Studio Connectors

Step 2: Connect your outside data source

I was prompted to choose a Google account, and I did. Once the Community Connector was authorized, I then had to Authorize Facebook Insights, my chosen Connector. I followed a prompt allowing Supermetrics to authenticate and connect to my Facebook Insights, and to be on the safe side, I decided to ensure I was both logged into my Facebook account and had the correct client Facebook business page opened in a tab too.

DS Connectors Facebook Insights

Step 3: Choose the correct Facebook page

This step is mission critical if you’re a digital marketer as you’ll no doubt manage and be an admin to many client Facebook pages. You are given the option to see all the pages you manage and then you choose the page you want. Once you choose the Facebook page from the drop-down list and CONNECT, the Data Connector will pull data specific to that page.

choosing the data source in Data Studio Connectors

On the next page which shows all of your data sources, you can edit them (I didn’t) and CREATE REPORT. You’ll notice the portal looks pretty familiar now as you are in Data Studio.

ADD TO REPORT the data source that is being pulled into your Data Studio portal via the Connector.

Supermetrics Data Source for Clients
Supermetrics Data Source for Clients

 

Step 4: Build Out Your Google Data Studio Report

In the final report building stage, there’s good news, bad news and then some more good news.

The first bit of good news is that all of your data is now being pulled in by the chosen DS Connector and is accessible in a list of metrics. The bad news is that there are a lot of metrics – I counted 123 in total for the Facebook Insights Connector.

If you don’t correctly align the:

  • Data Source
  • Dimension
  • Metric

you will not get meaningful metrics in the dashboard. When you have to choose from People Clicking Your Content, Content Clicks, Post Unique Link Clicks, or Post Other Clicks, it can be a challenge. I toggled back and forth to the Facebook portal to confirm I was choosing the exact metric I wanted and built out the report. If you’ve never built a Data Studio report, read about how to build one in our blog, Google Data Studio: 3 Easy Steps to Your Website Analytics.

The additional piece of good news is Supermetrics is in the process of developing a Facebook Insights Template for Data Studio. The metrics will be pre-selected and split by correct dimension thereby simplifying a currently complex process.

All in all, I thought the Supermetrics DS Connector I used to build Facebook Insights data into our Google Data Studio report was excellent. Prompts guide you through the authorization process and once the outside data source of choice is connected, you can utilize the powerful drag and drop report building functionality and customization capability of Data Studio. And although it’s fun to build reports, in the end, it comes down to data visualization.

If, as marketers, we can present data-driven insights to our clients in a holistic, transparent way, they will run better, more profitable businesses.

 

Google Data Studio for website analytics

Google Data Studio: 3 Easy Steps To Your Website Analytics

Have you ever wondered what percentage of your website visitors are returning, how long they stay on your website or what pages they look at while they are there? Google Analytics (GA) tracks a multitude of statistics like these, yet according to BuiltWith, only 7.8 percent of the 370 million websites on the Internet use Google Analytics. Given what Google Analytics can do, the percentage is shockingly low, but understandable too. Although GA has long provided a treasure trove of information about a website and its traffic, for business owners, it’s not been an intuitive interface to tackle. Now, there’s the incredibly user-friendly Google Data Studio.

Google Data Studio, still in beta, is a new tool that pulls data from your Google ecosystem, Google Analytics or AdWords as examples, into visual dashboards. We took a spin with Google Data Studio to see if we could put together a quick, informative, visual report pulling key information from website data in GA. It was a breeze.

Now you can create a remarkable, easy to understand snapshot of your website traffic using Google Data Studio. You’ll quickly see the value of the data as you grow your business and marketing efforts. You’ll need to connect Google Analytics to your website first, and then you’re ready to begin.  

Step 1: Sign up for Google Data Studio

Go to Google Data Studio and signup for free using your Google account. Use the same Google account linked to your website Google Analytics because Google Data Studio does not replace GA, but rather provides more user-friendly dashboards for viewing the data. Once you login to Data Studio, you will see a dashboard, and there are several pre-built templates which are set up to help you visualize data from many different sources including Google Analytics. You can completely customize and create your own report, but we grabbed the Google Analytics template for Acme Marketing – [Sample] Acme Marketing Website – as a starting point.

Google Data Studio sample AdWords report

Step 2. Select your data source for the Google Data Studio report

When you click on the Acme Marketing Google Analytics template, a turquoise and gray sample report pops up. In the top right of the screen, there is an icon which gives you the option to “Make a copy of this report.” Copy it and you will see a pop-up screen “Create new report.”

Connect data source in Google Data Studio

The Acme Marketing report uses sample data. To populate your report with your own website data, you will need to connect the Google Analytics data for your website.

In the pop-up window, look to the right where it says New Data Source, then:

  • Click on [Sample] Google Analytics Data
  • Click the blue CREATE NEW DATA SOURCE
  • In the left sidebar menu entitled Connectors, choose Google Analytics
  • Pick the relevant Account, (website) Property and View
  • Click the CONNECT button in the top right-hand corner
  • Click the ADD TO REPORT button in the top right-hand corner
  • Under the New Data Source section, your website Property is now listed, so you can CREATE REPORT

You’re connected!

Only 7.8 percent of the 370 million websites on the Internet use Google Analytics. – BuiltWith

Step 3. Customize the Google Data Studio report layout, theme, and elements

  • First things first – name your report in the top left of the screen near the Data Studio icon by typing over the words Copy of [Sample] Acme Marketing Website
  • Pick your date range by clicking the calendar dates in the top right of the report and select date range in the right sidebar
  • Click and delete sample elements such as the Acme Marketing logo on the top left and the note centered at the top, “SAMPLE REPORT – MAKE A COPY TO EDIT.”
  • Add your own graphic or text elements. Here are two examples. Add a logo by clicking the image icon in the top menu (a square with a mountain) and drag out a square or rectangular space with your cursor. Click Select a file in the right sidebar under DATA and choose your logo from your computer files. The logo will be sized and put in the outlined space. To add text, click the text icon in the top menu (a box with a “T”), draw out a square or rectangle with the cursor and type in your text. Customize your Text Properties in the right sidebar.

If you want to add more data views, you can either delete and replace what is in the sample report, or:

  • Add a blank page to the report with the “+Add a page” option on the top left of the menu.
  • Add custom elements

Here’s another quick example:

  1. Choose the Table icon on the top menu
  2. Drag out a rectangular or square shape with your cursor
  3. Immediately the table is populated with default source data, so in the right sidebar menu, click the green Source button under Dimensions
  4. Choose whichever data dimension you want to see
  5. Need a shorter table? Drag the lower border up and fewer entries will show.
  6. Prefer a different visualization? Repeat these steps choosing a different option besides Table or change your data source.

You can continue to add pages or visual dashboards that are useful to you. All of the elements of the report can be stylized to match your brand colors by clicking on them and using the STYLE options in the right sidebar. Your report is automatically saved because you are in the Google cloud ecosystem. Plus, all of the features you are used to with Google Docs such as sharing and download as PDF are either available or coming soon.

The best part? Once you create the report you want, you can change the date range each month and refresh the report for an updated view.

We’re loving the new Google Data Studio as an intuitive, interactive interface to view essential Google Analytics data for a website. Give it a try and tell us your thoughts in the comments!

CMS

6 Tips for Choosing the Right Content Management System For Your Startup

Every business strategy, from marketing to manufacturing, is spun around improving customer satisfaction. This truism is no news to us, but the notable fact is that it applies to even our business website and content. Why? Because if you wish to build a customer-centric company, your website – the face of your company, should reflect the same.

You need a strong content management system (CMS) which makes it possible for your website to adapt to and evolve with your customers’ ever-changing tastes and preferences. Especially if you are a startup, you have to make sure that you are picking the right CMS for your company since, for most startups, the major conversion point from a lead to a customer is the website.

A content management system can indeed help you effectively create and manage your digital content, and it can provide an interface for all your employees to collaborate within; some of the most famous ones include WordPress and Joomla (see more). The type of content management system you choose for your company can make or break your whole marketing setup, which makes it absolutely crucial to select the right CMS.

Here are a few basic questions you need to ask yourself to ensure that you pick the right content management system:

1. Can you edit the content easily?

Before investing in a tool, it is paramount that you find out how easy the CMS is to work with, especially for content editing. Check to see if you can easily insert images, update texts, upload documents etc. It is also important to check if it’s easy to add new web pages. Why? Your website needs to change with the demands, requirements, and trends, and the CMS should make that easy for you. Ask your web partner to give you a thorough demo of the CMS so that you can get firsthand experience before investing in it and thereby make an informed choice to purchase.

Here’s the takeaway: Make sure that the CMS is very intuitive and friendly to use for both the tech and non-tech employees.

SEO-friendly CMS

2. Is it SEO-friendly?

One of the most important points to remember is don’t choose a CMS which can negatively impact your efforts to search-optimize your content.

Here are some things you must keep in mind:

  • The CMS must allow you to add unique titles and labels for your post, tailored to suit the content of the page and also SEO optimized.
  • The URLs the CMS generates for your web pages should be neat and simple, instead of www.abc.com/page189$XZ2–that’s not good for your SEO.
  • Your platform must be able to integrate with other SEO optimization tools.

3. Did you check to see how secure the platform is?

Hire a web designer or a tech expert to analyze the potential security issues and see if your CMS can address them or can accommodate tools that can address them. For example, if someone hacks your website, what actions will the CMS company take? To clarify the security issues, you should also take the time to read the online reviews about your CMS company, get in touch with previous users and get a first-hand opinion if possible.

For example, if the existing users tell you that they are having to constantly upgrade their system with security code patches, that’s not a very good sign and you probably should consider a different CMS company.

CMS licensing fees

4. Does the CMS require any licensing fees?

There might be some costs you are neglecting, and for a startup, that might not bode well.

For some CMS platforms, a one-time fee or a licensing fee may be required to use the product unconditionally, which in many cases is reasonable. But for some platforms, you might incur additional charges whenever you want to update or upgrade, and you must keep such costs in mind before picking out a platform. In some cases, even adding additional plugins and extensions might cost you. Make sure you know how much cost the CMS platform might incur now and in the future too.

5. Will the CMS work with your server or technical configurations?

Not all website hosters are compatible with all content management systems. You must make sure that your CMS will work perfectly with your IT configurations. If you are not adept at doing so, hire a freelancer to help you check whether the CMS is compatible with your web server, because obviously you shouldn’t end up spending your dollars on a tool that might not even work for you.

In many cases, your IT configurations block out a number of websites, especially those that seem like personal blogs.  Check to see these limitations first. For example, some IT departments block-out the majority of the WordPress blogs and in such cases, you won’t be able to access the platform using your office IT configurations. Not good!

tracking web analytics with your CMS

6. Can the CMS accommodate web analytics?

If you are running a business, you need metrics to measure your progress. That makes it extremely important to ensure that your CMS will accommodate the tracking and measuring of your performance. You must check to see if it can integrate with analytics tools like Google Webmaster and Google Analytics.

To measure your lead generation and lead activity and understand how you are doing and what changes you might need to implement, your CMS must also be able to integrate with lead generation tools.

Final Thoughts

Here’s the takeaway. Selecting the right content management system requires two things:

  • List your needs, requirements and business goals
  • Strip down the CMS feature by feature and review each one to understand how well it fits with the above list

About Niraj Ranjan Rout

Niraj is the CEO and Founder of Hiver, an app that turns Gmail into a powerful customer support and collaboration tool. Read more about Hiver in Business Insider, Inc., Hubspot, and Lifehack.

Follow Niraj on Twitter @nirajr

5 Essential Elements to a Knockout Content Management Strategy

The digital nature of marketing today allows for the distribution of content at breathtaking speeds. Advertisers target ads based on a population’s demographic profile including a consumer’s age, geographic location or areas of interest. In fact, the power and precision made possible by electronic marketing has made a content management strategy even more critical to a business’ success.

Simply put, content management is the process of creating, editing, posting and managing digital content. Whether you create your own or hire an outside company to develop and execute it for you, here are 5 essential elements to a knockout content management strategy.

1. Define your Target Demographic

A traditional marketing campaign might include print media, internet marketing, networking events, or television ads. Today, over 80% of small business owners also incorporate social media in their marketing strategy. A quick look at social media provides an excellent example of why it is imperative to define the target demographic, because social media networks are not all created equal, at least as far as user demographics are concerned.

Social media networks are not all created equal, at least as far as user demographics are concerned.

The Pew Research Center compiles comprehensive statistics on social media user demographics broken down by characteristics such as age, race, income, and education. In the Social Media Update 2013, their researchers confirmed that Facebook remains the most popular social media network by far, and along with Instagram, has the highest levels of user engagement. So, for example, if you own a retail business, these two social networks are great choices for engaging the client base and encouraging them to post how they are enjoying or using your product. Facebook and Instagram would also be ideal platforms to run a contest and do a product give-away. Another example is that women are four times more likely to use Pinterest than men, so perhaps Pinterest would be a good choice for a business with highly visual, eye-catching products geared towards women. And older consumers like LinkedIn, which after Facebook, has the highest percentage of users in the 30 to 49 and 50 to 64 age brackets. So, if your service or product targets C-level employees or managers, LinkedIn might be the right social network choice.

2. Understand Media Consumption Patterns

One aspect of content management strategy that is often overlooked is what device the target audience is actually using to access social media, a general marketing campaign, an e-commerce site, or an app for the business. Eighty percent of mobile device users have the Android operating system, and Android users tend to have lower incomes and slightly lower rates of engagement than iPhone users. iPhone owners have a higher level of device engagement, make purchases more often with their mobile device, have higher incomes, but are much less widespread than Android users. So in developing a content management strategy, a business must determine if the income and location of the target audience is conducive to owning iPhones or Android devices, and also whether the marketing strategy needs breadth, depth or both to work. For an interesting article on this subject, read the Business Insider comparison published in April, “These Maps Show That Android Is For People With Less Money,” and to analyze a target area specifically, try Mapbox which shows geographic mobile device usage based on Tweets.

3. Identify Meaningful Goals

To ensure it is on the mark, a content marketing strategy should have meaningful goals that are established upfront and agreed by all parties. If the goal can’t be defined, then the outcome can’t be measured either. Examples of tangible goals are increasing subscribers or readership of an electronic newsletter as well as engagement with those clients when the newsletter is released. Another objective might be to convert engagement or ad clicks into an actionable response by the client, such as a call for a consultation. A company blogger might try to get the blog syndicated for more recognition and a wider audience. For some businesses, the management team may want to see Facebook likes and Twitter followers increasing every week. Another measurable goal might be the number of customers posting product pictures on Instagram or Pinterest and sharing their personal stories related to the products.

A great content management strategy must have meaningful goals defined for every platform and metrics which quantify the base case before the campaign is even launched. After the marketing effort begins, data points should be compared to the base case on a regular basis.

Social Media Metrics

 4. Measure Return on Investment (ROI)

A content management strategy must also include a basis for measuring both the financial impact and reach of the campaign. Metrics like organic subscriber growth versus paid subscriber growth, blog comments from readers, click-throughs and page likes are measurable indications of reach, but quantifiable financial impacts are a must too.

Levels of engagement for a content management strategy must be viewed in the context of campaign spend to see if the strategy has a bona fide ROI. You can easily analyze the basic data. For example, add a promotional code to a new social media ad to see how many people actually redeem it. Compare how many dollars were spent running the campaign to the number of coupons redeemed and you have a measure of the actual dollar spend, per new customer. Vary content blocks in a newsletter and monitor click-throughs. If click-throughs rise, dollars spent on creating the campaign relative to click-throughs will tell you the actual dollar spend, per click-through. If Page Likes and the number of Followers increases after a campaign, the company could be seeing increasing brand awareness and reach. Another great example of a measurable ROI is to link a product discount to a Pin on Pinterest. Monitor the number of click-throughs to your e-commerce store from the Pin and whether the coupon is redeemed.

5. Use Tracking Tools

To confirm the effectiveness of content marketing initiatives, choose a suite of tracking tools and monitor the metrics. For campaigns that link back to a company website, Google Analytics can provide extensive information on website engagement including whether visitors clicked through an ad, if they are new or returning, what pages were visited, how long they were on the page, and what keywords they typed in to find the site. Similarly, Facebook campaigns have a detailed Ads Manager dashboard which will show the number of users who saw an ad, Page Likes, website clicks and even the average price paid for the click on the ad. The Facebook Insights dashboard also provides an excellent visual summary of Page Likes, Post Reach and Engagement. For electronic newsletters that contain a multitude of clickable components, the post distribution statistics will detail opens, unique click-throughs for the individual parts, social media shares and open rates. All of these tracking tools will provide tangible measures of campaign effectiveness and a basis for tweaking a content management strategy. If you have engaged a content management firm to manage your strategy for you, many of these statistics can be exported to Excel, so ensure you receive monthly reports for review.

Would you like a more targeted, measurable and effective content management strategy? Resourceful Business can help define your user demographic and their consumption patterns and then put a knockout content management strategy in place to reach them. Contact us for a free consultation.