article thumbnail

Google BigQuery: A Tutorial for Marketers

ConversionXL

Alternatives include Amazon Redshift , Snowflake , Microsoft Azure SQL Data Warehouse , Apache Hive , etc. The solution is to give every lead and every purchase a userID (like an encrypted email), to pull CRM and Google Analytics data into your BigQuery data warehouse, and then—with a simple SQL query—join the two tables.

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. Image source. ConvertKit.

Growth 113
Insiders

Sign Up for our Newsletter

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

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

Sales Pipeline Radio, Episode 248: Q & A with Kelley Hippler @forrester

Heinz Marketing

But it’s also a great way to then go back to your business partners and get that partnership and buy-in when you can quantify, “Hey, we’re spending X amount of time building decks, how can we do some things to lighten the sales load?” We are very excited about the Forrester Decisions launch.

Pipeline 126
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? Experimentation launch. cross-functional teams) or working practices (e.g., Education program launch. How is the data accessed?

article thumbnail

How Machine Learning Can Finally Solve “(direct)/(none)”

ConversionXL

After the iPhone launched in 2007 to mass adoption, analytics were never the same. A good example is the launch of ITP 2.1 Train your model: I share sample SQL code in my prior article that covers, for example, how to train a model on users’ probability to buy in the next seven days. Fully predictive approach.

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? And then right about the time HubSpot was launching into APAC they brought me on board as their first marketer. Because marketing is the revenue function. Marketing is the customer service function, etc.