article thumbnail

Google BigQuery: A Tutorial for Marketers

ConversionXL

dashboards in Google Data Studio (or any other visualization tool, for the price of that tool). Alternatives include Amazon Redshift , Snowflake , Microsoft Azure SQL Data Warehouse , Apache Hive , etc. You can then say that userID X, who came on January 11 from Google Ads, brought us $500,000 in revenue.

SQL 84
article thumbnail

Acquire New Users by Adding Growth Hacking to your Marketing Strategy

ConversionXL

Analytical capability: Possessing Excel or SQL skills to extract data and gather insights on experiments to make better decisions. Cross-functional strategic thinking: Being able to come up with new ideas, understand the customer journey, identify opportunities, and work effectively with other stakeholders.

Growth 113
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

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? A pricing table for BigQuery usage. If you’re savvy enough, you can also create your own endpoint using cloud functions or log analysis.

Gaming 85
article thumbnail

What Does the Future Hold for Conversion Optimization?

ConversionXL

More and more, people are using experimentation as a way to optimise not just sales – but also pricing, functionality, and product. Trends include: big data tools, data manipulation (SQL and alternatives), languages like Python, and deeper analyses (e.g., Conversion is expanding beyond just the core user experience.

article thumbnail

A Quick Primer on B2B Conversion Optimization

ConversionXL

It’s often a higher purchase price (or at least a more complex sale). So while many usability heuristics remain the same in B2B website design and functionality , much of what goes into lead gen, sales, and analysis is different. So the process in B2B looks a bit like this (simplified): Visitor → MQL → SQL → customer.

B2B 110
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. Highly leveraged sales compensation plans are mostly seen in transactional sales, where the volume is extremely high at low prices. 40,000/150 = $267/SQL. Or rather $250/SQL.

SQL 103
article thumbnail

SaaStr Podcasts for the Week with G2 and Gorgias — September 27, 2019

SaaStr

What are the core differences when comparing marketing functions at the likes of Salesforce to smaller companies like G2? I do have to ask, you said there about your process in terms of the conversion from SQL to MQL and how you thought about that. Because marketing is the revenue function. How did it change his mindset?