article thumbnail

Google BigQuery: A Tutorial for Marketers

ConversionXL

Alternatives include Amazon Redshift , Snowflake , Microsoft Azure SQL Data Warehouse , Apache Hive , etc. While Google Analytics makes it possible to add CRM, back-office, or call-tracking data (via the API or Measurement Protocol), it’s still a suboptimal solution to consolidate your data. BigQuery isn’t the only game in town.

SQL 84
article thumbnail

Raw Data & Google Analytics: A Game Changer

ConversionXL

After a few hours playing around with SQL , I was already able to deliver insights I never could have with aggregated Google Analytics reports. Do more and more people use Feature X? As long as you can export your CRM data with a unique lead ID (e.g., You’ll learn about sending data to BigQuery using Cloud Functions.

Gaming 85
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Sales Pipeline Radio, Episode 116: Q&A with Samuel Sunderaraj @@V_samuelSun

Heinz Marketing

I think your customer base grows by two X it seems like every month these days. This is when Salesforce came to the market and started being the kind of up and running SaaS CRM play. So gone are the days of feature functionality, obviously have a great product to sell, but more important, it’s getting to know the buyer, right?

article thumbnail

How to Build Effective Sales Compensation Plans for Any Customer Facing Role

Sales Hacker

Here’s a simple example to begin with that covers the SDR, AE and Customer Success Manager (CSM) functions: Table 1. 3) Business-Case Target Setting (Recommended): The sales acquisition team that sells a CRM platform uses one SDR ($80k), one Jr. 40,000/150 = $267/SQL. Or rather $250/SQL. Experienced/Top Performer.

SQL 102
article thumbnail

The B2B Marketer’s Quick Start Guide: Data Visualization

Heinz Marketing

You might look at the platforms below and be thinking “there’s some missing” or “why isn’t X included?”, Features/functionality: Enable data agility and extract more value from your data with Domo’s flexible, scalable architecture. ”, because I had the same thought. Google Data Studio.

B2B 115
article thumbnail

Behavior-Based Attribution Using Google BigQuery ML

ConversionXL

Because with out-of-the-box tools, you’re limited by their functionality, data transformations, models, and heuristics. and conversions; Collect data from the CRM about final orders/lead statuses; Stitch everything together by session to understand the cost of each session; Apply attribution models to understand the value of each session.

SQL 91
article thumbnail

How to Nail Your First 90 Days as a CX Director

ConversionXL

During this stage, you want to meet the people doing the main activities in each function, not the managers. . Do you need SQL skills to pull reports, or are there dashboards? Does that map to a sale in the backend/accounting/CRM system? cross-functional teams) or working practices (e.g., How is the data accessed?