Close

Request a Demo

How To: Blend Data from Salesforce, Google Analytics, and Marketo with the Universal Semantic Layer

Our first webinar of 2021, co-hosted by Cat Origitano of FiveTran, a trusted AtScale technological partner, covered one the the most trending topics in the Marketing and Sales space today – “How do I blend incoming data from my MarTech application toolkit to optimize my sales and marketing channel ROI?”. In this blog post, I’ll touch on the top challenges and roadblocks, while highlighting the key webinar takeaways.

Cat started off by talking about the evolution of MarTech technology in recent years. While there were few options offering limited coverage a decade ago, there are over 8000 marketing and sales SaaS apps available in the market today. This means that data streams are multiplying in any modern organization, creating numerous data analysis bottlenecks and roadblocks. 

For this webinar, the AtScale team and I were excited to engage our participants with live poll questions about their MarTech operations. Here are the results. 

  • Participants are currently using between 3 and 10 SaaS MarTech apps
  • The majority of responders push all their data into a data warehouse
  • Relying on IT teams and data engineers is common practice

Blending Data: The Challenges

The MarTech scene is evolving fast and most modern organizations are using at least a handful of SaaS applications. But these sales and marketing applications are also generating siloed data sets that need to integrate into the organization’s data warehouse/s. This manual process creates a wide range of operational and technical problems.

Here are the top three challenges that I covered extensively in the webinar. 

1. Overdependence on IT and Data Teams

Marketers and sales executives need to connect with operation teams and IT often in order to modify, manipulate, and tweak their data . This is simply because they usually don’t have the technical knowhow to model new datasets, load and format data, or link data from different data silos. These interactions are time consuming and prone to human error. 

Below is an example of an email request that was made by a marketer wishing to update some marketing channel attribution rules.

HOW TO: BLEND DATA FROM SALESFORCE, GOOGLE ANALYTICS, AND MARKETO WITH THE UNIVERSAL SEMANTIC LAYER

This process can take hours or even days to complete and is obviously not efficient and error prone.

2. Security and Governance Issues

Multiple stakeholders need to connect to data warehouses directly using Tableau, Excel, Power BI (or similar BI tools). Data warehouse engineers and CISOs find it hard to manage policies, roles, and permissions for such a large variety of tools. This creates data security risks and introduces multiple blind spots for data governance. Monitoring access patterns and stakeholder activity creates immense operational pressure on the IT and security teams while exposing the business to unacceptable risks.  

3. Accuracy Problems and Data Inconsistencies

Raw data is not for the faint of heart. A list of database tables and views can be daunting to the average business analyst. Without business friendly terms and metadata, the business analyst must become a data engineer who can join the right tables and aggregate the right columns to get what they need. This “on-the-fly” data wrangling often results in inconsistent data and redundant work across the spectrum of BI tools, reports and dashboards. 

HOW TO: BLEND DATA FROM SALESFORCE, GOOGLE ANALYTICS, AND MARKETO WITH THE UNIVERSAL SEMANTIC LAYER

Even if you manage to overcome the technical difficulties involved in moving the data, modeling it and merging it, you may still need to deal with format inconsistencies across your SaaS applications.

Takeaways:

  • Creating consistency and trust in the analytics is difficult
  • Every analyst needs to connect directly to the data warehouse
  • Every analyst needs to have advance data engineering skills 
  • Every analyst may model the data differently
  • Duplication and unnecessary work is likely

The Universal Semantic Layer and Conformed Dimensions

The Universal Semantic Layer is a unified business representation of your corporate data and business data. It eliminates the need to perform “Excel Gymnastics” and data wrangling while allowing your business analysts to blend data across your SaaS data silos like  Salesforce, Google Analytics, and Marketo.

In our demo, I showed how AtScale, with the help of DBT (Data Build Tool) and FiveTran,  eliminated most of the manual work mentioned above. I demonstrated how FiveTran automated and orchestrated the data extraction process and loaded our data into the BigQuery staging tables. 

HOW TO: BLEND DATA FROM SALESFORCE, GOOGLE ANALYTICS, AND MARKETO WITH THE UNIVERSAL SEMANTIC LAYER

After we loaded data into BigQuery, I showed how we can use DBT to create a marketing channel “Conformed Dimension” that allowed us to join data across Google Analytics, Marketo and Salesforce..

“Conformed Dimensions are a Rosetta Stone for analytics; the driving force behind AtScale’s next-gen data virtualization solution. ” – Dave Mariani.

We combined the power of a semantic data model, conformed dimensions and intelligent data virtualization to generate “analytics ready” data without the operational and technical roadblocks that many organizations struggle with.

Takeaways:

  • “One Source of Truth” – All analysts speak the same language
  • Analysts don’t need know where the data is or how it’s stored
  • Analysts can query a common,  “Universal Semantic Layer” with business friendly terms 
  • The data is modeled once and covers multiple use-cases
  • Collaboration improves significantly
FIND OUT MORE IN OUR ON-DEMAND WEBINAR

How to Understand Your Sales Channel ROI by Blending Your SaaS Data

More Articles

How Slickdeals is Accelerating Data Driven Decisions at Scale

In our most recent webinar, Greg Mabrito of Slickdeals and Dave Mariani of AtScale shared how the Slickdeals team delivers analysis-ready data from its Snowflake Data Warehouse running on Amazon Web Services to support business-critical decisions. Couldn’t attend the webinar? In this blog post, we share a brief recap of what you missed! Slickdeals is a leading  social shopping platform that is dedicated to the sharing, rating, and reviewing deals and coupons. They help their users build a community of savvy shoppers who help each other find the best deals on the products that they love. With over 12 million…

Read More

How a Semantic Layer Can Help You Blend Your SaaS Data to Optimize Sales & Marketing Channel ROI

Data is everywhere. With dozens of SaaS sales,  marketing, and other business applications in use today, companies are witnessing an exponential rise in the volume of data they can access, leverage, and exploit. The same applies to information streams and data lakes. Only blending your SaaS data seamlessly can help you gain actionable insights and achieve sustainable business growth. Let’s take a closer look.   More and more, companies are finding it harder to gather and process data collected by their SaaS sales and marketing applications. Things only get complicated when on-prem and external data sources or tables are added…

Read More