View from Seed

FEBRUARY 27, 2019

As the former Head of Product at Blue Apron where I also built and led our Analytics & Data Science team (I know enough SQL to be dangerous), I have an intuitive sense for the “when” and “what” of this role. Analytics is about designing, reporting, and leveraging operating metrics to aid strategic and functional decision-making.

Analytics 149

Analytics Hiring SQL Forecast 149

Austin Startup

FEBRUARY 1, 2018

Product managers have the exciting responsibility of establishing the goals, roadmap and tracking metrics of their product (among many other duties), and also the less-glamorous but equally-important task of taking care of all the blocking and tackling required?—?from there is much value in learning SQL and either Python or R.

Management 85

Management Product Technical Review Software Review 85

The Startup Magazine

FEBRUARY 24, 2019

In most cases, entrepreneurs hope to grow revenue by substantial margins so as to achieve this. SaaS business models differ from all others in that they get revenues over an extended period of time. For as long as customers are happy, they stay and keep the revenue stream going. Loopholes in Conventional Approaches.

SQL 97

SQL Metrics Business Model Revenue 97

ConversionXL

AUGUST 5, 2020

In this article, I explain how to import costs from all advertising platforms into Google Analytics and how to set up performance metrics such as ROAS, Cost of Sale, and more. Next, in the settings, select the dimensions and metrics as shown in the screenshot. Add ad performance metrics to the report.

Analytics 113

Analytics Metrics Campaign Advertising 113

ConversionXL

SEPTEMBER 25, 2018

stands for: Discover : Which metrics and KPIs should you track? Let’s start with Discover: defining the list of metrics and KPIs that you should track. Discover: Which metrics and KPIs should you track? Before we start using tools or writing code, we need to know which metrics to track and why we want to track them.

Retention 107

Retention Metrics Analytics Channel 107

ConversionXL

FEBRUARY 18, 2020

Alternatively, you can build a custom table for ongoing reports for which you want to see unsampled data, or you can use the Google BigQuery integration to build the report you need with an SQL request. Custom dimension and metrics. With Google Analytics 360, you can have 200 custom dimensions and 200 custom metrics.

Analytics 90

Analytics SQL Metrics Campaign 90

Occam's Razor

JULY 15, 2014

It also handy explanations of the metrics, with key context where necessary. These will sound like: Metric x is down because of our inability to take advantage of trend y and hence I recommend we do z. It provides a brief snapshot of the entire business. From 3rd grader attendance to new artworks on view to expenses to (hurray!)

Analytics 160

Analytics Metrics Web Ohio 160

Occam's Razor

JANUARY 7, 2014

If the company has the revenues or size, it is important to hire for both roles to ensure the ROA will be positive. They are generic mash-ups that tailor to almost no one's needs, and more often than not contain awful things like nine not-really-thought out metrics for one dimension in a report. Total revenue. App Installs.

Analytics 142

Analytics Web Metrics DC 142

ConversionXL

DECEMBER 13, 2018

Custom dimensions and metrics. GA360 allows users to roll up reporting from multiple properties efficiently with capabilities not available in the free version—deduplicating users, stitching sessions, inheriting custom dimensions and metrics, etc. You’ll get more complete data, but how will you drive more revenue with it?

Analytics 126

Analytics Cloud Audience Campaign 126

ConversionXL

DECEMBER 2, 2020

Other metrics to monitor. In addition to the funnel stages described above, we also monitor some additional metrics. As a SaaS product, it’s crucial for us to monitor the monthly revenue streams (MRR). MRR, the number of canceled subscriptions, churn rate, and ARPU (Average Monthly Revenue Per User) from ProfitWell.

Churn Rate 78

Churn Rate Analytics Retention SQL 78

ConversionXL

SEPTEMBER 30, 2020

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. An accurately trained model on thousands of customer journeys can predict the probability to buy in the next 7 days (as well as revenue) effectively.

Artificial Inteligence 93

Artificial Inteligence Channel eCommerce Mobile 93

ConversionXL

AUGUST 13, 2019

SaaS sales and marketing teams can get overwhelmed by metrics. But without any metrics, it’s impossible to track growth. If growth is the best way to get out alive, marketing metrics do little unless they correlate with sales. But only 400 software companies have made it to the $500M revenue mark.

Metrics 117

Metrics SQL Retention Churn Rate 117

ConversionXL

MAY 27, 2022

The responsibilities from this DGM role at SaaS company Datto show how embedded demand gen managers are in marketing: • “Build strong, integrated marketing programs using a mix of content marketing, digital marketing, email marketing, and webinars to drive new business opportunities and revenue.

Demand 95

Demand Management B2B Campaign 95

ConversionXL

OCTOBER 15, 2019

You need to prove that your online marketing campaigns drive offline revenue. Using SQL queries, the Ile de Beaute team combined all data collected in BigQuery into a single table. Does everyone understand the metrics in the same way? Modern purchasing behavior may include: Pure online. Finding and buying products online.

Analytics 85

Analytics Cloud Advertising Metrics 85

ConversionXL

OCTOBER 4, 2018

the number of purchases or revenue that will occur in the future. 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. which segment, test, or personalization a user is most likely to respond to. customer churn. Outside vendors.

Analytics 131

Analytics Algorithm Artificial Inteligence Campaign 131

ConversionXL

JANUARY 24, 2017

Everyone has railed against these practices ( including us , many times), but it still seems that much of the industry is focused on short term metrics and surface level changes. Trends include: big data tools, data manipulation (SQL and alternatives), languages like Python, and deeper analyses (e.g., How do you do that?

Conversion 48

Conversion Technical Review Artificial Inteligence Analytics 48

ConversionXL

MAY 13, 2020

After a few hours playing around with SQL , I was already able to deliver insights I never could have with aggregated Google Analytics reports. Further, as you’re now using your own data, you can remove revenue from cancelled transactions or returns. Since that day, I’ve been exploring how raw data can be a web analyst’s best friend.

Analytics 85

Analytics Aggregator SQL Cloud 85

ConversionXL

JUNE 19, 2019

Occurs when your business achieves $100k+ in revenue monthly. Set targets: metrics to tackle the overarching goal for your product lifecycle. We need a metric or KPI that shows how good we are at increasing the likelihood that someone will convert in the future. Ben Labay: “How to Add Millions in Revenue with Voice of Customer”.

Agile 90

Agile Analytics Algorithm Software Review 90