Monthly Archives: November 2016

Generating slides from spreadsheet data

Posted by Wesley Chun (@wescpy), Developer Advocate, G Suite

The G Suite team recently launched the very first Google Slides API, opening up a whole new set of possibilities, including leveraging data already sitting in a spreadsheet or database, and programmatically generating slide decks or slide content based on that data. Why is this a big deal? One of the key advantages of slide decks is that they can take database or spreadsheet data and make it more presentable for human consumption. This is useful when the need arises to communicate the information reflected by that data to management or potential customers.

Walking developers through a short application demonstrating both the Sheets and Slides APIs to make this happen is the topic of today's DevByte video. The sample app starts by reading all the necessary data from the spreadsheet using the Sheets API. The Slides API takes over from there, creating new slides for the data, then populating those slides with the Sheets data.

Developers interact with Slides by sending API requests. Similar to the Google Sheets API, these requests come in the form of JSON payloads. You create an array like in the JavaScript pseudocode below featuring requests to create a cell table on a slide and import a chart from a Sheet:


var requests = [
   {"createTable": {
       "elementProperties":
           {"pageObjectId": slideID},
       "rows": 8,
       "columns": 4
   }},
   {"createSheetsChart": {
       "spreadsheetId": sheetID,
       "chartId": chartID,
       "linkingMode": "LINKED",
       "elementProperties": {
           "pageObjectId": slideID,
           "size": {
               "height": { ... },
               "width": { ... }
           },
           "transform": { ... }
       }
   }}
];
If you've got at least one request, say in a variable named requests (as above), including the Sheet's sheetID and chartID plus the presentation page's slideID. You'd then pass it to the API with just one call to the presentations().batchUpdate() command, which in Python looks like the below if SLIDES is your API service endpoint:
SLIDES.presentations().batchUpdate(presentationId=slideID,
       body=requests).execute()

Creating tables is fairly straightforward. Creating charts has some magical features, one of those being the linkingMode. A value of "LINKED" means that if the Sheet data changes (altering the chart in the Sheet), the same chart in a slide presentation can be refreshed to match the latest image, either by the API or in the Slides user interface! You can also request a plain old static image that doesn't change with the data by selecting a value of "NOT_LINKED_IMAGE" for linkingMode. More on this can be found in the documentationon creating charts, and check out the video where you'll see both those API requests in action.

For a detailed look at the complete code sample featured in the video, check out the deep dive post. We look forward to seeing the interesting integrations you build with the power of both APIs!

Updated Udacity Android course prepares students for the Associate Android Developer Certification

Posted by Jocelyn Becker, Senior Program Manager, Android Training

As one of our most popular Udacity courses, the Developing Android Apps course was recently updated to ensure developers have the resources to build high quality apps. This course, which has already helped more than half a million developers learn to build Android apps, has been through the car wash and come out sparkling clean and updated.

Google and Udacity have worked together to update the course to include the very latest changes in Android and Android Studio, including how to use the new Constraint Layout editor, and how to use Firebase Job Dispatcher. Learn best practices for building Android apps using Android 7.0 (Nougat) while keeping your apps backwards compatible in older versions, learning at your own pace in your own time.

You sent us feedback that some of the lessons were a little difficult to get through, so we've restructured the lessons and added smaller apps for you to build as you progress through the course. So not only will you build the Sunshine weather app as a complete, integrated application that spans the entire course, but you'll also create an app in each lesson to help you learn individual concepts.

Build a To Do app and add new tasks as you learn how to build a ContentProvider.

This course brings back Android experts Dan Galpin and Reto Meier from Google, and Lyla Fujiwara from Udacity, and introduces new faces from Google and Udacity.

Start learning now at https://www.udacity.com/course/ud851.

Combined package for Developing Android Apps course and Associate Android Developer Certification

This updated course teaches the skills that are tested by the Associate Android Developer certification exam. Udacity is offering a package that combines the updated Developing Android Apps course with a voucher for the Associate Android Developer certification exam. If you pass this exam, you will earn the Associate Android Developer Certification and show that you are competent and skilled in tasks that an entry-level Android developer typically performs. Enroll in Udacity's Fast Track to get prepared and take the Associate Android developer exam at: https://www.udacity.com/course/nd818.

Customize your G Suite experience with App Maker and Recommended apps

G Suite is designed to help you do your best work, whether that’s through real-time collaboration that brings your teams together or machine intelligence that speeds up everyday tasks. But we understand your company has unique needs and workflows that G Suite alone wasn’t built to address. We also know your teams rely on many third-party apps for things like CRM, support, and project management to get their job done. So today, we’re announcing two new ways to customize and extend your experience on the G Suite platform: App Maker, a new low-code developer tool for building custom enterprise applications, and the addition of seven new partners to our “Recommended for G Suite” third-party partner program.

Introducing App Maker, a new way to build powerful apps for your business.

App Maker is a low-code, application development tool that lets you quickly build and deploy custom apps tailored to your organization’s needs. Whether you’re looking for better ways to onboard new team members, staff projects, or approve employee travel requests, App Maker helps you build an app for that in days instead of months.

  • Go from idea to app, fast: App Maker makes it easy for IT or even citizen developers (including analysts and system administrators) to quickly iterate from a prototype all the way to deployed app. It offers a powerful cloud-based IDE that features built-in templates, a drag-and-drop UI, and point-and-click data modeling to accelerate your app development efforts. App Maker also embraces open, and popular standards like HTML, CSS, Javascript and Google’s material design visual framework, so developers can build apps quickly, in a development environment that leverages their existing skills and knowledge. 

1

  • Build integrated, tailor-made solutions for every need: App Maker lets you build a range of applications customized to meet the needs of your organization and connects to a wide range of data sources and APIs. This unique flexibility starts with built-in support for G Suite products as well as popular services such as Maps, Contacts, Groups and more. You can also leverage other Google Cloud services such as the Directory API and Prediction API, or third-party APIs, to create richer, more intelligent application experiences.
  • Focus on delivery, not infrastructure: App Maker is built on the same secure and trusted infrastructure as G Suite apps like Gmail, Drive and Docs. Developers can safely deploy custom apps in the cloud without worrying about servers, capacity planning, infrastructure security and monitoring that would otherwise require internal support from IT.

Over the past few months, we’ve previewed App Maker with a handful of large G Suite customers and many have already built and deployed applications to their organizations. We’re also working with the following consulting partners to help deliver solutions to our joint customers: Appsbroker, gPartner, G-Workplace, Ignite Synergy, Maven Wave, PwC, SADA Systems, and Tempus Nova.

Here are a few ways that enterprise customers and partners have used App Maker to make everyday business processes simpler and more efficient--whether it’s to track suspicious login activities, take analog claims processes and make them digital, or track office inventory orders.

If you’re interested in trying out App Maker, it’s available today through our Early Adopter Program for G Suite Business customers. Apply for the EAP here.

Announcing new apps for the ‘Recommended for G Suite’ program

While G Suite helps your teams communicate and collaborate more easily, we get that you also rely on third-party apps to manage other aspects of your business including sales, marketing, and operations. We want to make it easy for you to integrate these solutions with G Suite, and that’s why we introduced the Recommended for G Suite program last year. The program selects market leading applications, built by independent software vendors (ISVs), in a range of  categories like project management, customer support, finance and accounting.

Today, we’re adding seven new apps to the program that can help you be more productive. These apps solve critical business problems and offer deep integration and direct support with G Suite. Each app also goes through rigorous security testing and quality measures to qualify for the Recommended for G Suite program.

Our new recommended partners include:

static 2

Since we launched this program with our first eight apps last year, we’ve seen many examples of how our customers have incorporated them with G Suite to drive more value for their business. We’ve created a webinar series to show first-hand examples of this, and you can sign up here if you’re interested in attending. In addition, if you’re an ISV that’s interested in becoming a Recommended for G Suite partner, please submit your application here.

Try these new solutions today

We’re committed to helping you get the most out of your G Suite experience by fostering the best ecosystem of cloud applications and partners. App Maker enables you to build powerful apps tailored to your organizational needs, while the Recommended for G Suite program helps your teams select leading apps to grow your business. Both solutions are available today, and we encourage you to try them out.

Customize your G Suite experience with App Maker and Recommended apps

G Suite is designed to help you do your best work, whether that’s through real-time collaboration that brings your teams together or machine intelligence that speeds up everyday tasks. But we understand your company has unique needs and workflows that G Suite alone wasn’t built to address. We also know your teams rely on many third-party apps for things like CRM, support, and project management to get their job done. So today, we’re announcing two new ways to customize and extend your experience on the G Suite platform: App Maker, a new low-code developer tool for building custom enterprise applications, and the addition of seven new partners to our “Recommended for G Suite” third-party partner program.

Introducing App Maker, a new way to build powerful apps for your business.

App Maker is a low-code, application development tool that lets you quickly build and deploy custom apps tailored to your organization’s needs. Whether you’re looking for better ways to onboard new team members, staff projects, or approve employee travel requests, App Maker helps you build an app for that in days instead of months.

  • Go from idea to app, fast: App Maker makes it easy for IT or even citizen developers (including analysts and system administrators) to quickly iterate from a prototype all the way to deployed app. It offers a powerful cloud-based IDE that features built-in templates, a drag-and-drop UI, and point-and-click data modeling to accelerate your app development efforts. App Maker also embraces open, and popular standards like HTML, CSS, Javascript and Google’s material design visual framework, so developers can build apps quickly, in a development environment that leverages their existing skills and knowledge. 

1

  • Build integrated, tailor-made solutions for every need: App Maker lets you build a range of applications customized to meet the needs of your organization and connects to a wide range of data sources and APIs. This unique flexibility starts with built-in support for G Suite products as well as popular services such as Maps, Contacts, Groups and more. You can also leverage other Google Cloud services such as the Directory API and Prediction API, or third-party APIs, to create richer, more intelligent application experiences.
  • Focus on delivery, not infrastructure: App Maker is built on the same secure and trusted infrastructure as G Suite apps like Gmail, Drive and Docs. Developers can safely deploy custom apps in the cloud without worrying about servers, capacity planning, infrastructure security and monitoring that would otherwise require internal support from IT.

Over the past few months, we’ve previewed App Maker with a handful of large G Suite customers and many have already built and deployed applications to their organizations. We’re also working with the following consulting partners to help deliver solutions to our joint customers: Appsbroker, gPartner, G-Workplace, Ignite Synergy, Maven Wave, PwC, SADA Systems, and Tempus Nova.

Here are a few ways that enterprise customers and partners have used App Maker to make everyday business processes simpler and more efficient--whether it’s to track suspicious login activities, take analog claims processes and make them digital, or track office inventory orders.

If you’re interested in trying out App Maker, it’s available today through our Early Adopter Program for G Suite Business customers. Apply for the EAP here.

Announcing new apps for the ‘Recommended for G Suite’ program

While G Suite helps your teams communicate and collaborate more easily, we get that you also rely on third-party apps to manage other aspects of your business including sales, marketing, and operations. We want to make it easy for you to integrate these solutions with G Suite, and that’s why we introduced the Recommended for G Suite program last year. The program selects market leading applications, built by independent software vendors (ISVs), in a range of  categories like project management, customer support, finance and accounting.

Today, we’re adding seven new apps to the program that can help you be more productive. These apps solve critical business problems and offer deep integration and direct support with G Suite. Each app also goes through rigorous security testing and quality measures to qualify for the Recommended for G Suite program.

Our new recommended partners include:

static 2

Since we launched this program with our first eight apps last year, we’ve seen many examples of how our customers have incorporated them with G Suite to drive more value for their business. We’ve created a webinar series to show first-hand examples of this, and you can sign up here if you’re interested in attending. In addition, if you’re an ISV that’s interested in becoming a Recommended for G Suite partner, please submit your application here.

Try these new solutions today

We’re committed to helping you get the most out of your G Suite experience by fostering the best ecosystem of cloud applications and partners. App Maker enables you to build powerful apps tailored to your organizational needs, while the Recommended for G Suite program helps your teams select leading apps to grow your business. Both solutions are available today, and we encourage you to try them out.

Docker + Dataflow = happier workflows

When I first saw the Google Cloud Dataflow monitoring UI -- with its visual flow execution graph that updates as your job runs, and convenient links to the log messages -- the idea came to me. What if I could take that UI, and use it for something it was never built for? Could it be connected with open source projects aimed at promoting reproducible scientific analysis, like Common Workflow Language (CWL) or Workflow Definition Language (WDL)?
Screenshot of a Dockerflow workflow for DNA sequence analysis.

In scientific computing, it’s really common to submit jobs to a local high-performance computing (HPC) cluster. There are tools to do that in the cloud, like Elasticluster and Starcluster. They replicate the local way of doing things, which means they require a bunch of infrastructure setup and management that the university IT department would otherwise do. Even after you’re set up, you still have to ssh into the cluster to do anything. And then there are a million different choices for workflow managers, each unsatisfactory in its own special way.

By day, I’m a product manager. I hadn’t done any serious coding in a few years. But I figured it shouldn’t be that hard to create a proof-of-concept, just to show that the Apache Beam API that Dataflow implements can be used for running scientific workflows. Now, Dataflow was created for a different purpose, namely, to support scalable data-parallel processing, like transforming giant data sets, or computing summary statistics, or indexing web pages. To use Dataflow for scientific workflows would require wrapping up shell steps that launch VMs, run some code, and shuttle data back and forth from an object store. It should be easy, right?

It wasn’t so bad. Over the weekend, I downloaded the Dataflow SDK, ran the wordcount examples, and started modifying. I had a “Hello, world” proof-of-concept in a day.

To really run scientific workflows would require more, of course. Varying VM shapes, a way to pass parameters from one step to the next, graph definition, scattering and gathering, retries. So I shifted into prototyping mode.

I created a new GitHub project called Dockerflow. With Dockerflow, workflows can be defined in YAML files. They can also be written in pretty compact Java code. You can run a batch of workflows at once by providing a CSV file with one row per workflow to define the parameters.

Dataflow and Docker complement each other nicely:

  • Dataflow provides a fully managed service with a nice monitoring interface, retries,  graph optimization and other niceties.
  • Docker provides portability of the tools themselves, and there's a large library of packaged tools already available as Docker images.

While Dockerflow supports a simple YAML workflow definition, a similar approach could be taken to implement a runner for one of the open standards like CWL or WDL.

To get a sense of working with Dockerflow, here’s “Hello, World” written in YAML:

defn:
  name: HelloWorkflow
steps:
- defn:
    name: Hello
    inputParameters:
      name: message
      defaultValue: Hello, World!
    docker:
      imageName: ubuntu
      cmd: echo $message

And here’s the same example written in Java:

public class HelloWorkflow implements WorkflowDefn {
  @Override
  public Workflow createWorkflow(String[] args) throws IOException {
    Task hello =
        TaskBuilder.named("Hello").input("message", “Hello, World!”).docker(“ubuntu”).script("echo $message").build();
    return TaskBuilder.named("HelloWorkflow").steps(hello).args(args).build();
  }
}

Dockerflow is just a prototype at this stage, though it can run real workflows and includes many nice features, like dry runs, resuming failed runs from mid-workflow, and, of course, the nice UI. It uses Cloud Dataflow in a way that was never intended -- to run scientific batch workflows rather than large-scale data-parallel workloads. I wish I’d written it in Python rather than Java. The Dataflow Python SDK wasn’t quite as mature when I started.

Which is all to say, it’s been a great 20% project, and the future really depends on whether it solves a problem people have, and if others are interested in improving on it. We welcome your contributions and comments! How do you run and monitor scientific workflows today?

By Jonathan Bingham, Google Genomics and Verily Life Sciences

Customize your G Suite experience with App Maker and Recommended apps

G Suite is designed to help you do your best work, whether that’s through real-time collaboration that brings your teams together or machine intelligence that speeds up everyday tasks. But we understand your company has unique needs and workflows that G Suite alone wasn’t built to address. We also know your teams rely on many third-party apps for things like CRM, support, and project management to get their job done. So today, we’re announcing two new ways to customize and extend your experience on the G Suite platform: App Maker, a new low-code developer tool for building custom enterprise applications, and the addition of seven new partners to our “Recommended for G Suite” third-party partner program.

Introducing App Maker, a new way to build powerful apps for your business.

App Maker is a low-code, application development tool that lets you quickly build and deploy custom apps tailored to your organization’s needs. Whether you’re looking for better ways to onboard new team members, staff projects, or approve employee travel requests, App Maker helps you build an app for that in days instead of months.

  • Go from idea to app, fast: App Maker makes it easy for IT or even citizen developers (including analysts and system administrators) to quickly iterate from a prototype all the way to deployed app. It offers a powerful cloud-based IDE that features built-in templates, a drag-and-drop UI, and point-and-click data modeling to accelerate your app development efforts. App Maker also embraces open, and popular standards like HTML, CSS, Javascript and Google’s material design visual framework, so developers can build apps quickly, in a development environment that leverages their existing skills and knowledge. 

1

  • Build integrated, tailor-made solutions for every need: App Maker lets you build a range of applications customized to meet the needs of your organization and connects to a wide range of data sources and APIs. This unique flexibility starts with built-in support for G Suite products as well as popular services such as Maps, Contacts, Groups and more. You can also leverage other Google Cloud services such as the Directory API and Prediction API, or third-party APIs, to create richer, more intelligent application experiences.
  • Focus on delivery, not infrastructure: App Maker is built on the same secure and trusted infrastructure as G Suite apps like Gmail, Drive and Docs. Developers can safely deploy custom apps in the cloud without worrying about servers, capacity planning, infrastructure security and monitoring that would otherwise require internal support from IT.

Over the past few months, we’ve previewed App Maker with a handful of large G Suite customers and many have already built and deployed applications to their organizations. We’re also working with the following consulting partners to help deliver solutions to our joint customers: Appsbroker, gPartner, G-Workplace, Ignite Synergy, Maven Wave, PwC, SADA Systems, and Tempus Nova.

Here are a few ways that enterprise customers and partners have used App Maker to make everyday business processes simpler and more efficient--whether it’s to track suspicious login activities, take analog claims processes and make them digital, or track office inventory orders.

If you’re interested in trying out App Maker, it’s available today through our Early Adopter Program for G Suite Business customers. Apply for the EAP here.

Announcing new apps for the ‘Recommended for G Suite’ program

While G Suite helps your teams communicate and collaborate more easily, we get that you also rely on third-party apps to manage other aspects of your business including sales, marketing, and operations. We want to make it easy for you to integrate these solutions with G Suite, and that’s why we introduced the Recommended for G Suite program last year. The program selects market leading applications, built by independent software vendors (ISVs), in a range of  categories like project management, customer support, finance and accounting.

Today, we’re adding seven new apps to the program that can help you be more productive. These apps solve critical business problems and offer deep integration and direct support with G Suite. Each app also goes through rigorous security testing and quality measures to qualify for the Recommended for G Suite program.

Our new recommended partners include:

static 2

Since we launched this program with our first eight apps last year, we’ve seen many examples of how our customers have incorporated them with G Suite to drive more value for their business. We’ve created a webinar series to show first-hand examples of this, and you can sign up here if you’re interested in attending. In addition, if you’re an ISV that’s interested in becoming a Recommended for G Suite partner, please submit your application here.

Try these new solutions today

We’re committed to helping you get the most out of your G Suite experience by fostering the best ecosystem of cloud applications and partners. App Maker enables you to build powerful apps tailored to your organizational needs, while the Recommended for G Suite program helps your teams select leading apps to grow your business. Both solutions are available today, and we encourage you to try them out.

Source: Drive


4K live streaming: Live has never looked so good

Back in 2010, we enabled 4K video support for the very first time. Since then, millions of videos have been uploaded at that eye-popping resolution, making YouTube’s the largest library of 4K videos online. Today, we’re proud to say that we’re taking 4K video one step further with the launch of 4K live streaming for both 360-degree videos and standard videos.

Supporting this new format will let creators and partners stream incredibly high-resolution video, and let viewers enjoy the clearest picture possible when watching a live stream on 4K-supported devices. The image quality is just mind-blowing on screens that support it, and in 360 degrees … the clarity can truly transport you. If you want to experience it for yourself, make sure to check out the Game Awards tomorrow, December 1 at 9 p.m. EST / 6 p.m. PST on YouTube. The entire show will be live streamed in 4K resolution.



4K video isn’t just a little different from HD video; it’s a giant leap. It shows 8 MILLION pixels total, with an image that has four times more image definition than even 1080p video. What does this mean in real world terms? Live streams look better, show a more detailed, crisper picture, and aren’t as blurry when there’s fast action on screen. Basically, 4K makes everything better to look at. And because we support 4K at up to 60 frames per second, creators can make content that looks silky smooth, and more realistic than ever before.

For creators this means the ability to take advantage of an incredibly clear picture for recorded and now streaming video. It’s the kind of thing that can help to push their hardware (and their talent) to create the most beautiful or just plain crazy-looking images and videos possible. And with 360 4K live streams, the sky is (literally) the limit. Get ready for 360 concert and event streams that look sharper, cleaner, and brighter than ever before. If you want more information on how to stream in 4K, just check out this Help Center article.

Today’s an exciting day, and we can’t wait for everyone to experience the beauty of 4K live streams from their favorite creators.

Kurt Wilms, Senior Product Manager, recently watched “BABY PUG LIVESTREAM!

Source: YouTube Blog


Data Studio: DoubleClick Campaign Manager Connector

Google Data Studio (beta) allows users to connect, transform, visualize, and share data no matter where it lives. Today we are happy to announce that DoubleClick Campaign Manager (DCM) customers can pull their data into Data Studio dashboards instantly!


With this new connector, DCM customers no longer need to import data into spreadsheets. Users can now quickly create dashboards with over 50 DCM metrics and dimensions. These dashboards are an effective way to track and optimize campaign performance and share reports with client and agency stakeholders.

Creating a new report with DCM data
Ready to get started? The first step is to connect to your DCM network or advertiser through the Data Sources page.



Next you can create a new report from scratch or use our DCM template. With just a few clicks, the dashboard is populated with your data.

Want to learn more? Looking for a new connector in Data Studio?

To learn more about the new DCM connector, please visit our Help Center or post your questions in the Data Studio community forums.

Is there a specific data service you wish to be able to access and visualize through Data Studio? We welcome your feedback via the connector feedback form — we read all responses and use them to prioritize new connectors.

Happy reporting!

The Data Studio team

Celebrate and Vote for #TheYouTubeAd of 2016

The best YouTube ads of 2016 explored a stunning range of creativity across the board.  Viewers have been inspired, caught off guard, and moved to tears with these unbelievable ads from these top creative agencies this year. We even have a new category dedicated to brands that build for the new 6-second bumper format.

Once again, we’ve partnered with The Webby Awards to select 30 nominees based on this year’s YouTube Ads Leaderboard for the most iconic ads of 2016 -- and now you get to cast your ballot for your favorites.

We’ve selected six categories to highlight how some of the best of ads of 2016 have inspired us on a whole new level. Starting today, you can vote for:

#TheYouTubeAd That Goes Straight To The Heart
#TheYouTubeAd That's Your Guilty Pleasure
#TheYouTubeAd That Puts Stars In Your Eyes
#TheYouTubeAd That Knows No Limits
#TheYouTubeAd That Takes A Stand
#TheYouTubeAd That Says It In Six

Voting runs through December 9th - and you can help your favorites reach the top by voting for each category everyday.

Winners will be announced on December 14th.



Learn tips from Memrise to increase in-app conversions with pricing experiments

Posted by Tamzin Taylor, Partner Development Manager at Google Play, & Kristina Narusk, Head of Production at Memrise

Getting people to install your app is one thing, getting them to sign up to your paid offering is quite another. It's important to understand the complete journey your users take from installing your app to paying for something. Once you do, you can experiment on the flow to try and increase conversions. Memrise has found great success in experimenting on their language learning app to increase the number of paying users.

Four experiments Memrise use to improve conversions

Memrise makes languages fun with a number of different learning modes you can play to help increase your vocabulary in a chosen language. You can download the app for free and play some of the modes or take advantage of their premium subscription offering called 'Memrise Pro' which offers new game modes and additional features like offline learning. Memrise recently ran a number of conversion experiments with the main objective of increasing the Average Revenue Per Daily Active User (ARPDAU). These experiments tested multiple user experience and pricing experiment scenarios.

1. A/B test how messaging different user benefits can impact conversion

What they did: Memrise wanted to know what motivation and call to action would convert the most users to buy a Pro subscription from a locked game mode in the app. To do this, they ran an A/B test with two similar designs, featuring different reasons for the user to upgrade, and compared the results to their original upgrade messaging.



Screen Shot 2016-10-11 at 15.26.00.png
Screen Shot 2016-10-11 at 15.25.34.png
Test A: Focus on ‘difficult’ words with an orange background.
Test B: Focus on ‘favorite’ words with a pink background.

Results: Test A performed the best. Conversion to Pro in Test A was 28% higher than in Test B. Pro mode usage was subsequently 9.7% higher in Test A compared to Test B too.

Next steps: After seeing how test A won the experiment, Memrise applied this creative across the board. Subscribers driven by that particular mode increased as a percentage of all subscriptions in the app by 16%. Memrise plans to run additional A/B tests at others points of conversion in the app to see if they can increase the results even further. They'll also try different text for the call to actions.

2. Test whether adapting to local price points results in sustainable uplift

In 2015, Google Play launched new minimum local price levels in countries around the world. To take advantage of the new price points, Memrise tested lowering localised prices in certain markets to better match purchasing power. Prices were an average of 6 times lower during this experiment.

Results: After 30 days, Memrise saw the following changes in conversions to paid users:



??
Turkey
180%
??
Brazil
182%
??
Russia
99%
??
Mexico
115%
??
India
5.1%
??
Indonesia
152%
??
South Korea
120%
??
Thailand
70%
??
Malaysia
27%

Next steps: The change in price affected the subscription dynamics with more users taking advantage of Memrise's in-app discounted offer in most countries. The offer was for annual subscribers only and has led to a positive effect on LTV. One insight from the experiment was that Indian users prefered to have the option to subscribe in weekly or monthly increments and not just annually. Memrise is still tracking carefully to see whether the discounted subscription pricing will lead to an increase in conversions.

3. Test when and how often you offer free trials to see if that affects conversion rate

Memrise occasionally offers users, who aren't Pro subscribers, a free trial of one of the Pro game modes while cycling through the various free modes. After the free trial session, users are presented with an offer to subscribe. Memrise experimented with the offer's timing making it appear more frequently while users were cycling through normal free sessions Instead of after every 49th session, users saw the unlocked mode after every 21st session.



Screenshot_unlocked.png
Screenshot_unclocked_offer.png
An example of a free trial of a Pro mode.
After completing a free trial, users see a discounted subscription offer.

Results: Offering a free trial more frequently paid off. The conversion rate increased by 50% while all other conversion rates remained the same.

Next steps: Memrise maintained the more frequent offer cadence and has seen revenue growth as a result.

4. Test whether seasonal discounts result in more conversions Memrise launched a 'Back to School' campaign presenting all users with a discounted annual plan offer for a week in September 2016. The aim was to convert more users and generate higher value users from annual subscription plans.

Screen Shot 2016-10-11 at 16.03.14.png

Results: Memrise saw two effects from the seasonal offer. As a result of only presenting an annual period and removing weekly and monthly, 20% fewer users per day converted to Pro. However, because more people were taking an annual subscription than a shorter subscription, the average revenue per day increased by 32% justifying the change.

Next steps: Memrise plans to test different offers in the future with a combination of subscription offerings. They'll also focus offers in countries like Turkey and Mexico, where they saw the biggest increase in conversions.

Keep experimenting and take advantage of new features to improve the user experience and increase conversions

At Playtime San Francisco, we announced that introductory pricing for subscriptions would be coming soon and the feature is now live. By continually testing messaging, pricing, offers, and free trials or discounted trials, you could increase the conversions in your app and your ongoing revenue just like Memrise. Learn more about Google Play in-app billing subscriptions and get the Playbook for Developers app to stay up-to-date with features and best practices that will help you grow a successful business on Google Play.

How useful did you find this blogpost?