Back

SQL QUERIES

A collection of SQL queries Calculating KPIs and answering questions.

A/B Testing for new landing page vs the current home page from google search ads campaign "nonbrand"

Conversion rate increase 0.88% per session for lander-1

Code on Github

A/B Testing full conversion funnel from each of the two pages to orders. For new landing page vs the current home page from google search ads campaign "nonbrand"

Code on Github

Bounce rate for each of the two pages. For new landing page vs the current home page from google search ads campaign "nonbrand"

Code on Github

Conversion rate for sessions from google search capaign "nonbrand" sessions and orders ?

Code on Github

monthly trends for all sessions from google search and number of orders orders

Code on Github

monthly trends for sessions from google search campaign "nonbrand" by month and device type

Code on Github

Made with Carrd