Google Cloud Platform Blog
Product updates, customer stories, and tips and tricks on Google Cloud Platform
Google Analytics Premium + BigQuery = Next-gen Digital Marketing Strategy
Tuesday, September 15, 2015
Here's a question for you: How do you focus digital marketing activities on the customers who are most likely to buy your products? Sure, there are several tools out there that can help you understand your customers better, but are limited to using their own datasets. What if you could combine data from different platforms like website analytics and customer relationship management (CRM) systems and perform statistical analysis against them to build a predictive model of likely high value customer prospects?
You may think that this sounds good in theory but hard to put into practice. That's why we recently published an
article
and
tutorial
demonstrating one way to achieve it, taking you on a step-by-step journey.
The diagram below shows what you need to know at a high level. Let's talk through the big picture in a few paragraphs.
As you can see, there are a few products and data sources mentioned in this diagram. First, there's
Google Analytics Premium
that provides actionable insights from your website data and can automatically export detailed, unsampled logs to
Google BigQuery
,
Google's fully managed, NoOps, data analytics service.
In addition to Google Analytics Premium logs, BigQuery integrates with other Google Cloud Platform services like
Google Cloud Dataflow
, and supports third party tools for importing a wide variety of business data from existing corporate databases and CRM systems.
Fast, easy and powerful analytics with BigQuery
BigQuery can import, join, and correlate every single row of
massive activity logs from different sources to extract valuable intelligence. By linking log data with your website registration forms, shopping carts, inquiry forms or any customer interactions, you can easily correlate those transactions with customer website behavior. These insights can dramatically increase the return on digital marketing investment. You can learn in this
case study
how Domino’s increased monthly revenue by 6% with Google
Analytics Premium and Google BigQuery.
Standard tools for data scientists such as
R
,
Tableau
, and the Hadoop ecosystem are also best friends of BigQuery and can be tightly integrated with each other for sophisticated data analysis beyond simple correlations and table joins. For example,
BigQuery can quickly aggregate and filter massive datasets for in-depth regression analysis with R.
In short, Google Analytics Premium + BigQuery + R provides an excellent platform for data scientists to realize a new predictive digital marketing approach.
How to Get Started
The best way to get going is to first read the
article
and then follow the step-by-step
tutorial
.
- Posted by Oyvind Roti, Solutions Architect
Free Trial
GCP Blogs
Big Data & Machine Learning
Kubernetes
GCP Japan Blog
Firebase Blog
Apigee Blog
Popular Posts
Understanding Cloud Pricing
World's largest event dataset now publicly available in BigQuery
A look inside Google’s Data Center Networks
New in Google Cloud Storage: auto-delete, regional buckets and faster uploads
Enter the Andromeda zone - Google Cloud Platform’s latest networking stack
Labels
Announcements
193
Big Data & Machine Learning
134
Compute
271
Containers & Kubernetes
92
CRE
27
Customers
107
Developer Tools & Insights
151
Events
38
Infrastructure
44
Management Tools
87
Networking
43
Open
1
Open Source
135
Partners
102
Pricing
28
Security & Identity
85
Solutions
24
Stackdriver
24
Storage & Databases
164
Weekly Roundups
20
Feed
Subscribe by email
Demonstrate your proficiency to design, build and manage solutions on Google Cloud Platform.
Learn More
Technical questions? Check us out on
Stack Overflow
.
Subscribe to
our monthly newsletter
.
Google
on
Follow @googlecloud
Follow
Follow
Follow