Remove Campaign Remove CRM Remove SQL Remove X-functional
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

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
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. After all, most questions we answer are pretty basic: Which campaigns bring more conversions? Do more and more people use Feature X? For regular use, aggregated data is usually enough.

Gaming 85
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. . After digging further, you may discover an advertising campaign where marketing promotes these products in-store and increases demand. How do you evaluate performance and make decisions on future campaigns?

article thumbnail

Predictive Analytics in 2018: What’s Possible, Who’s Doing It, and How

ConversionXL

which marketing campaigns, channels, touches, behaviors, and demographics are contributing to a business outcome, a form of “machine learning–based attribution.”. The other half have a mix of data sources, which inevitably include an offshore SQL database (or ten) managed by an external vendor whom no one can track down.

Sports 131
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? Ryan Bonnici: And then I got this really interesting opportunity to move over to the US with HubSpot and lead global marketing, global digital, global PR, global brand campaigns, and social and all that fun stuff.

article thumbnail

The Playbook To Re-Igniting Growth with Predictable Revenue Co-Founder and CEO Aaron Ross (Video + Transcript)

SaaStr

If you’re one or if you work for one, I need to decide, “Hey, we’re getting X from if channels, partners, inbound … ” Of course, inbound is such a group stuff, partners, inbound, outbound. Just measure SQLs. It is harder because you have to have consistent definitions on what is an SQL.

Growth 78