Introducing the Google Analytics Sample Dataset for BigQuery

Original Post: http://feedproxy.google.com/~r/blogspot/tRaA/~3/KZ-G3GD23j8/introducing-google-analytics-sample.html

The Google Analytics integration with Google BigQuery gives analysts the opportunity to glean new business insights by accessing session and hit level data and combining it with separate data sets. Organizations and developers can analyze unsampled analytics data in seconds through BigQuery, a web service that lets developers and businesses conduct interactive analysis of big data sets and tap into powerful data analytics.

To help you learn or teach practical experience with analyzing analytics data in BigQuery, we are pleased to announce the availability of a Google Analytics sample dataset. This is accessible directly through the BigQuery interface. The dataset includes data from the Google Merchandise Store, an Ecommerce site that sells Google branded merchandise. The typical Google Analytics data you would expect to see such as AdWords, Goals and Enhanced Ecommerce data can be queried. You can see the fields part of the export schema that you can query here.

Google Analytics Sample Dataset for BigQuery

When it comes to helping businesses ask advanced questions on unsampled Google Analytics data, we like to use BigQuery. Its fast and scalable for big data analytics. When providing trainings on the benefits of the Google Analytics and BigQuery integration, there is nothing like having a high quality dataset with sufficient volume to be meaningful. That’s why we are so pleased to see the public availability of a robust Google Analytics sample dataset with marketing and ecommerce data. Everyone can experience big data analytics!
– Doug Hall, Director of Analytics, Conversion Works

Self-Learning 
You can use the sample dataset to learn how granular information can be extracted from analytics data in BigQuery. We’ve created this guide to help you create queries to find answers to the following for the Google Merchandise Store:

  • What is the average number of transactions per purchaser?
  • What is the percentage of stock sold per product?
  • What is the average bounce rate per marketing channel segmented by purchasers?
  • What are the products purchased by customers who previously purchased a particular product?
  • What is the average number of user interactions before a purchase?

Education Programs

If you’re an educator trying to teach others to use BigQuery, then we encourage you to use the sample dataset as a tool. You can use it to create task based assessments and other learning materials for your students. We’ve started to do just that by integrating it into our education courses.

The Analytics Academy provides an introduction to BigQuery in their Getting Started with Google Analytics 360 course. The Data Insights course by the Google Cloud team provides an in-depth look at BigQuery with practical exercises.

Access the Dataset
You can learn more about the dataset including how to get access in this help article. If you need some help, please let us know through the Advertiser Community. Share any feature requests or ideas to make the dataset more useful. We hope the dataset gives you a practical way to learn about the benefits of analysing Google Analytics data in BigQuery.

Happy analyzing!
Posted by Deepak Aujla, Program Manager, Google Analytics Solutions

The 10 Content Marketing Plagues: How To Get On Track To Succeed

Original Post: http://feedproxy.google.com/~r/HeidiCohen/~3/N8TmTEXUDUc/

content marketing plagues

Ensure that each element of your content marketing strategy works together to avoid the 10 plagues of content marketing. This Passover inspired post provides an actionable content marketing checklist of the 10 content marketing plagues and how make your content succeed.

The post The 10 Content Marketing Plagues: How To Get On Track To Succeed appeared first on Heidi Cohen.

The Definitive Solopreneur Content Curation Guide

Original Post: http://feedproxy.google.com/~r/HeidiCohen/~3/JG0lArpEWAU/

solopreneur content curation

Are you a one person business or department trying to keep your content marketing going? Use solopreneur content curation to streamline your content creation process. You have the choice of 3 key curation formats to supply your audience with useful information. Examples included.

The post The Definitive Solopreneur Content Curation Guide appeared first on Heidi Cohen.

How to Use Continuous A/B Testing to Increase Conversions

Original Post: http://feedproxy.google.com/~r/Quicksprout/~3/A3fqDXb1CZo/

When was the last time you updated your website?

If you have to stop and think for a minute to answer that question, you may have a problem. Your website needs to be monitored and updated on a regular basis.

However, you don’t want to make changes without any rhyme or reason. That’s why you can use A/B testing as a tool to help guide your website updates.

But before you start A/B testing, you need to understand how it works. It’s not just a one-time thing. Some of you may have tried these tests in the past and seen an improvement. So why did you stop?

For those of you who have never tried A/B testing, it can be difficult to know where to start. Regardless of your situation and experience with A/B testing, I can help you.

Continuous A/B testing will make your website more efficient.

I’ll explain how you can use this strategy to improve your business and help you boost your conversion rates.

How A/B testing works

A/B testing isn’t difficult to understand. You start by creating a hypothesis about a certain element and then run a test to see if your theory was right.

To do this, you create two different versions of your website. Half of your site traffic will get sent to one version, and the other half will get directed to the variation.

Here’s a visual representation to give you a better understanding of what I’m talking about:

image3 3

Once you set up the test, you wait to see which variation has higher conversion rates. Then you draw conclusions and update your website with the version that converts the most.

What’s tricky about A/B testing is deciding how long to test things and what elements need to be tested.

Honestly, there’s not one right answer to those questions. But I’ll give you some guidance to help you run these tests efficiently.

Test your CTA buttons

When you’re trying to get higher conversions, it’s best to start with the button that gets people to convert.

Obviously, these buttons are different for each company in every industry. It depends on your goal on a specific landing page as well. Some of you may be trying to drive a sale, while others may be trying to get site visitors to opt in to their email subscription lists.

The key here is picking one element to start. You don’t want to test two theories at once. Testing multiple hypotheses doesn’t give you conclusive results because you won’t know which variation impacted the results.

That’s why you should be running tests continuously to maximize the efficiency.

Start with something subtle and easy such as the size, color, or placement of your CTA button. For example, you could hypothesize that a larger CTA button will have higher conversions.

You can also test the actual text written on your CTA button. Try testing power words against action words.

Here are some of the power words that convert the most:

image2 3

Are any of these words used in your call to action?

Here are some more statistics about the conversion success of words that prompt an action:

image1 3

Based on the numbers in these graphics, you could hypothesize that a call to action that says “Sign up for free” will have higher conversion rates than one that says “Download now.”

But there’s only one way to find out. Test it.

After you test one of these and are satisfied with the results, move on to another test. If you started with the size of your CTA button, move on to the color. After that, you can test the text or placement of the button.

Test all the CTAs this way on each page of your website.

Fewer than half of websites have a CTA button that can be spotted in less than 3 seconds. Putting so much effort into testing your CTA will definitely give you an edge over your competitors.

Evaluate your headings

After you’re satisfied with your CTA button analysis, move on to other components of your website that stand out the most.

Your headlines and subheadings definitely jump off the page, so it makes sense to test those next.

If your headlines aren’t worded properly, visitors may not even read all the content on the page. While testing the CTA may seem more important, visitors could miss out on your entire value proposition if the headers don’t keep them engaged.

In addition to conversions, you should be looking at analytics that show for how long each visitor stays on the page.

If one headline causes the average page viewing time to be significantly longer than the variation, it will definitely increase the chances that the visitors will convert.

Here’s an example of an A/B test of a website’s headline:

image8 1

As you can see, the two pages are identical, except for the headlines. The variation has different words for the main heading and subhead.

The test yielded conclusive results. Website visitors who saw version A filled out the form at a 27.76% higher rate than the ones who saw version B.

If your tests are only within 5% or so of each other, you may not be able to say that one is definitely better. To find out for sure, you can run an A/A test before your A/B test to see what your standard deviation is between the same versions of a web page.

Improve your checkout process

For those of you with an ecommerce website, you need to find ways to minimize shopping cart abandonment.

Using A/B tests on the layout of your checkout process can really help you maximize conversions. You’ll be able to tell which elements are working and which ones can be tossed away.

I’ll give you some ideas of what you can start testing.

Are you accepting coupon codes? If you have an option for visitors to input a coupon code during the checkout process, it could send them searching for a code.

But if these codes aren’t always readily available and they’re just something you offer to a disgruntled customer, it shouldn’t be a primary element of your checkout process.

Test it out to see what kind of results you get.

You could also test a guest checkout vs. login to checkout conversion rates. I’m assuming you’re offering a secure checkout, so use A/B tests to see if the size and placement of your security badges have an impact on conversions.

Test every element on the page. Something small could make a huge difference.

Here’s a great example of something subtle that iHerb used when A/B testing their checkout process:

image7 3

Take a look at the left side of the screen. They have a shipping cost calculator. All the customer has to do is input their zip code to get an estimate on their shipping costs.

But the Heavy Duty Bag promotion draws lots of attention away from the calculator.

Here’s another version of the page:

image6 3

As you can see, the image was removed and the “Calculate” button was placed much closer to the “Proceed to Checkout” CTA.

OK. So technically they changed two elements of this page, which I know I said you shouldn’t do. But this was subtle enough to be effective.

I’m a big advocate for removing clutter from your pages, so I think it was a smart decision to get rid of the image in addition to moving the placement of the calculator.

Find out which images convert

You definitely want to use images to help you improve your website. It’s just a matter of deciding what images to use and where to place them.

If you’re on the fence about a decision, or you have some images already on your website, run A/B tests to see which ones have the highest conversion rates.

For example, you could test an image of a man vs. a woman to see if they yield different results. Or you could test an image of the same model but with different facial expressions, such as smiling vs. a serious face.

Is it better to have one big image as the background for your website? Or will a white background with the image in the forefront have higher conversions?

The only way to find out for sure is to test your theory.

You should also consider the size and position of your images in relationship to other elements on your website.

Continuously run these tests to maximize your conversion rates.

For example, let’s say you find out that a photo of a man converts higher than a photo of a woman. Now you’ve got to find the most optimal position of that photo on the page, so your tests will continue.

Test different color schemes

Colors can make a huge impact on how people see your website. That’s because different colors impact us differently.

We’re programmed to associate certain colors with certain events. For example, what color does everyone wear to a funeral (at least in the West)? I’m not trying to sound grim, but that’s one of the reasons why we automatically associate the color black with death.

Test colors for every component of your website, such as the color of the text, the menu icons, and CTA buttons.

Here’s an example that tests the colors of the call to action on this website:

image5 3

The pages are identical, including the text. The only thing that’s been changed is the color. Refer back to what I said earlier about our minds automatically associating certain colors with things.

Well, we’re programmed to go on green and stop on red. So a valid hypothesis for this A/B test would be that a green CTA button will have higher conversions than the red one. You’ll have to run a test to find out if that’s true for your website.

Use A/B tests to improve your emails

Everything we’ve discussed so far is related to your website. But that’s not the only platform you use to get conversions.

A/B testing is not limited to your website. You can also test factors within your email marketing campaigns.

Here too, you can focus on your CTA, colors, images, headings, and text.

But you can test other factors as well.

For example, use A/B testing on your email subject lines. The content of your message can be the same, but see if you have a significant difference in open rates and conversions based on the subject.

Test the word count of your marketing emails.

Recent studies suggest that emails between 50 and 125 words have the highest conversion rates.

image4 3

Think outside the box when you’re running these A/B tests.

Don’t assume you’re only allowed to test elements of your website. Email campaigns are another viable option.

Revisit your early tests

A/B tests don’t just last a day or two.

Typically, you’ll want to run each test for at least a few weeks to make sure you’ve got a large enough sample size to yield conclusive results.

Let’s say you run 4 or 5 different tests on your CTA button. That alone could take 3 months. Then you test your headlines, images, colors, and checkout process.

By the time you get through all these tests, a year or two could have passed since your initial test.

Well, don’t stop now. Go back and see if your CTA is still as efficient as possible.

Conclusion

A/B testing is one of the best ways to increase your conversion rates.

But you don’t just run one test and call it a day. This process needs to be a continuous part of your marketing strategy. Always strive to make improvements to your website.

Test things like your CTA buttons, headlines, and checkout process.

You can also test visual elements such as your images and color schemes on your pages.

A/B testing isn’t just restricted to your website. You can apply this strategy to your email marketing campaigns as well.

Once you finish testing something, move on to the next element. After you’ve tested everything, start back at the beginning.

What elements of your website are you testing first to improve your conversion rates?

How to Use Continuous AB Testing to Increase Conversions

Original Post: http://feedproxy.google.com/~r/Quicksprout/~3/A3fqDXb1CZo/

When was the last time you updated your website?

If you have to stop and think for a minute to answer that question, you may have a problem. Your website needs to be monitored and updated on a regular basis.

However, you don’t want to make changes without any rhyme or reason. That’s why you can use A/B testing as a tool to help guide your website updates.

But before you start A/B testing, you need to understand how it works. It’s not just a one-time thing. Some of you may have tried these tests in the past and seen an improvement. So why did you stop?

For those of you who have never tried A/B testing, it can be difficult to know where to get started. Regardless of your situation and experience with A/B testing, I can help you out.

Continuous A/B testing will make your website more efficient.

I’ll explain how you can use this strategy to improve your business and help you boost your conversion rates.

How A/B testing works

A/B testing isn’t really that difficult of a concept to understand. You start by creating a hypothesis about a certain element and then run a test to see if your theory was right.

To do this, you create two different versions of your website. Then half of your site traffic will get sent to one version, and the other half gets directed to the variation.

Here’s a visual representation to give you a better understanding of what I’m talking about.

image3 3

Once you set up the test, you wait and see which variation has higher conversion rates. Then you draw conclusions and update your website with the version that converts the most.

What’s tricky about A/B testing is deciding how long to test things and what elements need to be tested.

Honestly, there’s not one right answer to those questions. But I’ll give you some guidance to help you run these tests efficiently.

Test your CTA buttons

When you’re trying to get higher conversions, it’s best to start with the button that gets people to convert.

Obviously, these buttons are different for each company in every industry. It depends on your goal on a specific landing page as well. Some of you may be trying to drive a sale while others may be trying to get site visitors opt-in to their email subscription list.

The key here is just picking one element to start. You don’t want to test two theories at once. Testing multiple hypotheses doesn’t give you conclusive results because you won’t know which variation impacted the results.

That’s why you should be running tests continuously to maximize the efficiency.

Start with something subtle and easy such as the size, color, or placement of your CTA button. For example, you could hypothesize that a larger CTA button will have higher conversions.

You can also test the actual text written on your CTA button. Try testing power words against action words.

Here are some of the power words that convert the most.

image2 3

Are any of these words currently used in your call-to-action?

Here are some more statistics about the conversion success of words that entice an action.

image1 3

Based on the numbers in these graphics, you could hypothesize that a call to action that says, “Sign up for free” will have higher conversion rates than one that says, “Download now.”

But there’s only one way to find out. Test it.

After you test one of these and you’re satisfied with the results, move on to another. So if you started with the size of your CTA button, then move on to the color. After that, you can test the text or placement.

Test all of the CTAs this way on each page of your website.

Less than half of websites have a CTA button that can be spotted in less than 3 seconds. So putting so much effort into testing your CTA will definitely give you an edge over your competitors.

Evaluate your headings

After you’re satisfied with your CTA button analysis, move on to other components of your website that stand out the most.

Your headlines and subheadings definitely jump off of the page at visitors, so it makes sense to test those next.

If your headlines aren’t worded properly, visitors may not even read all of the content on the page. So while testing the CTA may seem more important, visitors could miss out on your entire value proposition if the headers don’t keep them engaged.

In addition to conversions, you should be looking at analytics that shows how long each visitor stays on the page for.

If one headline causes the average page viewing time to be significantly longer than the variation, it will definitely increase the chances that the visitors will convert.

Here’s an example of an A/B test on a website’s headline.

image8 1

As you can see, the two pages are identical, except for the headlines. The variation has different words for the main heading and subhead.

The test yielded conclusive results. Website visitors who saw version A filled out the form at a 27.76% higher rate than the ones who saw version B.

If your tests are only within 5% or so if each other, you may not be able to say that one is definitely better. To find out for sure, you can run an A/A test before your A/B test to see what your standard deviation is between the same version of a web page.

Improve your checkout process

For those of you with an ecommerce website, you need to find ways to minimize shopping cart abandonment.

Using A/B tests on the layout of your checkout process can really help you maximize conversions. You’ll be able to tell which elements are working and which ones can be tossed away.

I’ll give you some ideas of what you can start testing.

Are you accepting coupon codes? If you have an option for visitors to input a coupon code during the checkout process, it could cause them to go searching for a code.

But if these codes aren’t always readily available and they’re just something you use to offer a disgruntled customer, it shouldn’t be a primary element of your checkout process.

Test it out to see what kind of results you get.

You could also test a guest checkout vs. login to checkout conversion rates. I’m assuming you’re offering a secure checkout, so use A/B tests to see if the size and placement of your security badges have an impact on conversions.

Test every element on the page. You’d be surprised at how something small could make a huge difference.

Here’s a great example of something subtle that iHerb used to when A/B testing their checkout process.

image7 3

Take a look at the left side of the screen. They have a shipping cost calculator. All the customer has to do is input their zip code and they’ll get an estimate on their shipping costs.

But the heavy-duty bag promotion draws lots of attention away from the calculator.

Here’s another version of that same page.

image6 3

As you can see, the image was removed and the “Calculate” button was placed much closer to the “Proceed to Checkout” CTA.

OK. So technically they changed two elements of this page, which I know I said you shouldn’t do. But this was subtle enough to be effective.

I’m a big advocate for removing clutter from your pages, so I think it was a smart decision to get rid of the image in addition to moving the placement of the calculator.

Find out which images convert

You definitely want to use images to help you improve your website. But it’s just a matter of what images to use and where to place them.

If you’re on the fence about a decision, or you have some images already in place on your website, run A/B tests to see which ones have the highest conversion rates.

For example, you could test an image of a man vs. an image of a woman to see if one yields different results. Or you could test an image of the same model, but with different facial expressions, such as smiling vs. a serious face.

Is it better to have one big image as the background of your website? Or will a white background with the image in the forefront have higher conversions?

The only way to find out for sure is by testing your theory.

You should also consider the size and position of your images in relationship to other elements of your website.

Continuously run these tests to maximize your conversion rates.

For example, let’s say you find out that a photo of a man converts higher than a photo of a woman. Now you’ve got to find the most optimal position of that photo on the page, so your tests will continue.

Test different color schemes

Colors can make a huge impact on how people see your website. That’s because certain colors have a psychological impact on our mind.

We’re programmed to associate certain colors with things. For example, but what color does everyone wear to a funeral? I’m not trying to sound grim, but that’s one of the reasons why we automatically associate the color black with death.

Test colors for every component of your website, such as the color of the text, the menu icons, and CTA buttons.

Here’s an example that tests the colors of the call-to-action on this website.

image5 3

The pages are identical, including the text. The only thing that’s been changed is the color. Refer back to what I said earlier about our minds automatically associating certain colors with things.

Well, we’re programmed to go on green and stop on red. So a valid hypothesis for this A/B test would be that a green CTA button will have higher conversions than the red one.

Use A/B tests to improve your emails

Everything we’ve discussed so far is based around your website. But that’s not the only platform that you use to get conversions.

A/B testing is not limited to your website. You can also test factors from your email marketing campaigns.

Test things similar to what we’ve already talked about. Focus on your CTA, colors, images, headings, and text.

But with email, you can test other factors as well.

For example, use A/B testing on your email subject lines. The content of your message can be the same, but see if you have a significant difference in open rates and conversions based on the subject.

Test the word count of your marketing emails.

Recent studies suggest that emails between 50 and 125 words have the highest conversion rates.

image4 3

So think outside of the box when you’re running these A/B tests.

Don’t assume that you’re only allowed to test elements of your website. Email campaigns are another viable option.

Revisit your early tests

A/B tests don’t just last for a day or two.

Typically, you’ll want to run each test for at least a few weeks or so to make sure that you’ve got a large enough sample size to yield conclusive results.

So let’s say you run 4 or 5 different tests on your CTA button. That alone could take 3 months. Then you move on to test your headlines, images, colors, and checkout process.

By the time you get through all of these tests, a year or two could have passed since your initial test.

Well, don’t stop now. Go back and see if your CTA is still as efficient as possible.

Conclusion

A/B testing is one of the best ways to increase your conversion rates.

But you don’t just run one test and call it a day. This process needs to be a continuous part of your marketing strategy. Always strive to make improvements to your website.

Test things like your CTA buttons, headlines, and checkout process.

You can also test visual elements such as your images and color schemes on your pages.

A/B testing isn’t just restricted to your website. You can apply this strategy to your email marketing campaigns as well.

Once you finish testing something, move on to the next element. After you’ve tested everything, start back at the beginning.

What elements of your website are you testing first to improve your conversion rates?

Google Surveys goes global

Original Post: http://feedproxy.google.com/~r/blogspot/tRaA/~3/VDQo7bbJtRo/google-surveys-goes-global-pmm.html

We’re excited to announce that you can now survey people in over 50 countries around the globe with Google Surveys.

When we first launched Google Surveys in 2012 (we called ourselves Google Consumer Surveys back then), our goal was to put quality market research in the hands of businesses of all sizes. Market research was costly and time-consuming in those days, and that made it hard for many companies to make decisions based on what their customers were actually thinking.

Google Surveys made it easy to keep your finger on the pulse of your customers with fast, reliable insights from real people. Since then, we’ve continued making improvements to the product. We also launched Surveys 360, our enterprise version, with advanced targeting, reporting, and sharing features.

And now users of both versions can reach people in more than 50 countries. Wondering if your new product line should launch in Portugal? Stop guessing and find out. Lacking competitive intel in India? Not anymore. Trying to convince your boss that your idea is better? We can help with that.

“As a global company, we’re especially excited about the targeting expansion to over 50 new countries. We’ll be using Google Surveys to run consumer research and brand awareness studies in markets that have historically been difficult for researchers to access.” 

Frank Kelly, SVP Global Marketing & Strategy, Lightspeed GMI

These new targeting choices are available starting today. Hear more from our product team in this video:

To learn more about the new country options, see our help center article.

Happy surveying!

Is Optimize set up correctly on your site? Let us double-check for you.

Original Post: http://feedproxy.google.com/~r/blogspot/tRaA/~3/59kBdoLJXSg/is-optimize-set-up-correctly-on-your-site-let-us-double-check-for-you-pmm.html

Google Optimize helps businesses determine which website experiences work best for their customers. With easy-to-use A/B testing capabilities, marketers can use Optimize to create and launch a test in minutes — and manage the entire process on their own.

A/B testing with tools like Optimize drives results. In a recent survey, 72% of marketers found A/B testing to be a highly valuable method for improving conversion rates.

But we’ve heard from businesses that while testing in Optimize is easy, setting it up could be easier. 

Good news: We’re introducing a new feature that helps make sure Optimize is set up and working the way it’s supposed to.

Let Optimize double-check your code 

With Installation Diagnostics, Optimize will automatically alert and advise you on potential issues with your Optimize code each time you create a test. At a glance, you’ll see if your Optimize setup is correct and if you’re ready to run a test.

Let’s say you create a new page on your site but forget to add the Optimize code. Later, when you are creating a test for that page, Optimize will tell you that the necessary code isn’t installed. You’ll have the opportunity to fix the issue and then launch your test. Moving forward, you can be confident that your test results won’t be disrupted by an incorrect setup.

Optimize will alert you about other issues too – including if Google Analytics code isn’t installed on a page, or if an old version of Analytics code is installed. Then you can make changes to ensure you’ll be able to measure the performance of your experiment. Learn more.

Try it yourself 

Today’s top businesses are testing their way to success. They’re valuing data over opinions. They’re constantly learning — even from failures and mistakes. And they’re using their findings to improve the customer experience.

Whether your business is big, small, or somewhere in between, you can follow their lead. Try Optimize now and get ready to gain deep insights about your customers so you can enhance their web experiences like never before.