nCAC Google Ads Bidding Strategy based on LTV

Your Google Ads account might be pausing your most profitable products right now — and the algorithm thinks it’s doing you a favor.

Lots of Google Ads managers live and die by immediate, dashboard-reported ROAS. If a campaign spends $50 in ad spend to generate a $35 initial order, the default reaction is predictable: raise the ROAS target, restrict the budget, or pause the campaign entirely. On paper, it looks like an unacceptable cash burn.

Evaluating every product strictly on immediate return assumes that all e-commerce purchases behave the same way. In reality, product catalogs often contain items with completely different buying behaviors and customer types, impacting long-term business success in very different ways.

Using a client in the medical and physio supplies industry as an example, looking directly into store order data revealed two distinct buying behaviors:

1. High-AOV Retail Items (Immediate Payback): Products like mobility aids, wheelchairs, or treatment tables. A customer buys once, spends $300 to $1,000+, and rarely purchases again. Standard Target ROAS bidding works well here because the entire profit margin is captured on the first transaction.

2. Low-AOV Consumables (Sample-to-Scale): Products like dry needling needles or clinical wipes. In B2B or specialized niches, practitioners rarely commit to a major bulk contract with an unfamiliar supplier on day one. Instead, they place a small $25 to $40 “test purchase” to evaluate product quality, shipping speed, and customer service.

If we evaluate those test purchases through the lens of traditional first-touch ROAS, they look like complete failures. But that modest initial order often transforms into an ongoing, recurring replenishment stream. By letting Google Ads automatically optimize away from these low-AOV initial orders, we are cutting off our highest-margin customer acquisition engine.

To capture this hidden revenue without risking cash flow, we need a bidding strategy built around backend customer value rather than initial checkout totals — using Customer Lifetime Value bidding and LTV-based nCAC (new Customer Acquisition Cost) as a target CPA.

Here is how to audit your store data, find these gateway products, and structure your campaigns to scale them profitably.

Step 1: Locating Hidden Gateway Products

Before we create or adjust campaigns in Google Ads, we must uncover which products look small on day one (first sale), but quietly drive high customer lifetime value (LTV).

To do this, we need to pull an export directly from your e-commerce platform (like WooCommerce or Shopify) rather than relying strictly on Google Analytics or Google Ads reports.

Your order history should cover at least 12 to 24 months. A shorter timeframe won’t give repeat purchases enough room to mature.

We need the following core columns: Order Date, Order ID, Status, Customer ID/Email, Customer Type (New vs Returning), Product(s), Items Sold, and Net Sales.

Before analyzing the data, we need to clean up three potential traps:

1. Removing voided orders: Filter out any orders marked as Cancelled, Refunded, or Failed.

2. Handling multi-item noise: Standard WooCommerce exports, for example, lump all items in an order into a single cell. Because test purchases are typically small, single-item buys, filter for first purchases where Items Sold = 1, or create a helper category column using a SEARCH formula to group specific product keywords (e.g., grouping all variations of a product together).

3. Isolating unique customers: Using Email or Customer ID to track repeat orders is essential, as customer names can create false duplicates.

Order Analysis in Google Sheets or MS Excel

To measure true backend value per product, add two calculated helper columns to your raw data sheet:

Building the Gateway Pivot Table

Now let’s create a Pivot Table from the cleaned raw data tab and configure it as follows:

Rows: Product / Category

Filters: Set Is First Order = 1 (This restricts evaluation strictly to customer entry points)

Values:

First Purchases: Count of Order IDs

Avg 1st Order Value: Average of Net Sales

Median 1st Order Value: Median of Net Sales (Protects against wholesale outliers)

Avg n-Year LTV: Average of Customer Total Net Sales

LTV / 1st Order Ratio: Calculated Field using:

=SUM('Customer Total Net Sales') / SUM('Net Sales')

Interpreting the Data

Once assembled, the data will clearly reveal the contrast between standard catalog items and genuine gateway products.

Below are the actual numbers from analyzing the client’s store across two years of order data:

Notice the dramatic disparity between “Other Products” (the baseline catch-all category) and “Dry Needling”:

On Day 1, a standard catalog product looks far superior. It brings in an average initial basket of $67.38 vs. $39.58 coming from Dry Needling purchases.

Over 24 months, however, the standard product barely grows, topping out at an LTV ratio of 1.16x.

Dry Needling expands by 3.29x, taking a modest $39.58 first purchase and scaling it into $130.39 in lifetime revenue.

If we evaluated Google Ads performance purely on initial checkout value, we would naturally push spend toward “Other Products” and throttle “Dry Needling”.

In reality, the Dry Needling category is acquiring customers who are nearly 3x more valuable over time.

Step 2: Isolating 90-Day Repeat Purchase Patterns

Once we identify gateway products, let’s look at the payback velocity.

Payback velocity tells us how quickly repeat purchases occur within the first 30 to 90 days.

Setting Up the Re-Order Formulas

To track re-order timing in the raw order data sheet, add four additional helper columns alongside the existing Is First Order and Customer Total Net Sales columns:

Updating the Pivot Table

Let’s add three new metrics to pivot table values section:

1. Repeat Purchase Rate: Is Repeat Customer set to Average, formatted as %.

2. Avg Days to 2nd Order: Days to 2nd Order set to Average, formatted as whole number.

3. 90-Day Re-order Rate: Re-ordered in 90 Days set to Average, formatted as %.

Analyzing Payback Velocity

Adding these metrics turns long-term LTV projections into concrete cash flow data:

Key Strategic Takeaways:

• The 90-day cash multiplier: Look at the 90-Day Re-order Rate. For “Other Products,” only 7.85% of customers buy again within 90 days. For Dry Needling, 31.03% of buyers place a second order within 90 days — nearly 4x the speed of standard products.

• Re-order schedules vs non-repeaters: While Avg Days to 2nd Order shows that restocking happens every 60–100 days, the overwhelming majority (86%) of “Other Products” buyers never purchase a second time.

• De-risking acquisition: For gateway products, a massive percentage of new buyers re-order in under 65 days. The second purchase covers the initial acquisition cost within the first quarter, making every order from month 3 to month 24 compounding profit. Now that we have isolated payback velocity, we can establish exact mathematical boundaries for ad spend.

Step 3: Forecasting Allowable nCAC

Once we establish that gateway products have rapid payback velocity, the next step is calculating the Allowable New Customer Acquisition Cost (nCAC). This metric sets a realistic ceiling for your Google Ads acquisition cost instead of relying on arbitrary ROAS targets handed down by management (e.g., “We need a blanket 300% ROAS across all campaigns”).

Setting a uniform ROAS target across a diverse catalog mathematically guarantees that you will underbid on high-LTV gateway products.

The ROAS Bidding vs. The nCAC Model

Let’s look at what happens when we apply a traditional 300% Target ROAS to a gateway product like Dry Needling vs. evaluating it through an LTV-driven model:

The Common Day-1 ROAS Calculation

• Average 1st Order Value: $39.58

• Target ROAS: 300%

• Maximum Allowable Ad Spend per Order: $39.58 / 3.0 = $13.19

In competitive auction environments, trying to acquire a brand-new customer for a $13.19 acquisition cost is nearly impossible. The campaign will starve for impressions, fail to win top-of-page placements, or simply get paused for “underperforming.”

Calculating True Allowable nCAC

Instead of forcing a single-session ROAS target, we calculate allowable nCAC based on gross margin dollars captured within the acceptable payback window (e.g., 90 days).

Here is the core formula:

Allowable nCAC = (Expected Customer Revenue in Payback Window x Gross Margin %) - Target Net Profit per Acquisition

Assuming the business operates on a 50% gross margin across consumable products and wants to evaluate customer acquisition within a 90-day window:

Day-1 Gross Profit:

First order value ($39.58) x Gross margin (50%) = $19.79 Day-1 gross profit

Expected 90-Day Revenue:

According to my client’s data, on average, 31.03% of Dry Needling buyers place a second order within 90 days.

Where does the $90 average re-order size come from? When we look into the actual order logs for repeat purchases, practitioners aren’t buying single $25–$40 sample boxes anymore. Having verified product quality and shipping reliability, clinics restock in bulk with multi-packs, resulting in an average re-order basket size of $90 (which also accounts for almost the entire $90.81 difference between the initial $39.58 purchase and the $130.39 2-year LTV).

With that data in hand, the expected additional 90-day backend revenue per acquired customer is:

Re-order rate (31.03%) x Avg. Re-order size ($90) = $27.93 Expected backend revenue

Total expected 90-day customer value = $39.58 (1st order) + $27.93 (expected re-order) = $67.51

Expected 90-Day Gross Profit:

Expected 90-day customer value ($67.51) x Gross margin (50%) = $33.76 Gross margin generated

Calculating Allowable nCAC (Target CPA):

Notice the subtraction of Target Net Profit per Acquisition in our formula:

• Breakeven nCAC ($33.76): If your goal is to maximize customer acquisition speed and break even on gross margin within 90 days ($0 target profit), your maximum bid ceiling is $33.76.
• Profitable nCAC ($23.76): If you require a buffer of, say, $10 net profit per acquired customer within the first 90 days, your target acquisition cost is $23.76 ($33.76 − $10.00).

By shifting the benchmark from immediate Day-1 ROAS to an allowable nCAC of $23.76 (profitable) or $33.76 (breakeven), we give Google Ads smart bidding dramatically more room to win competitive auctions.

Step 4: Targeting High-LTV Buyers with Non-tROAS Campaigns

Now that we have identified the gateway products, calculated their 90-day payback velocity, and established a realistic allowable nCAC, we must translate these insights into Google Ads account structure.

If we leave gateway SKUs mixed into standard Performance Max or Shopping campaigns, Google’s automated bidding will naturally divert budget away from them toward high-AOV retail products. To scale gateway items safely, we must isolate them.

The Dual-Engine Campaign Architecture

To balance immediate liquidity with long-term compounding profit, we structure the account into two distinct campaign engines:

• Engine 1: The Cash Flow Engine (Standard Catalog): Targets high-AOV, one-time purchase items. Bidding remains strictly anchored to a (high) Target ROAS to ensure initial transactions generate immediate net cash flow.

• Engine 2: The LTV Growth Engine (Gateway Categories): Houses isolated gateway categories. Bidding relies on Target CPA (Target nCAC) derived from the 90-day allowable acquisition cost calculation rather than a restrictive first-click ROAS metric.

Segmenting Products via Custom Labels

To pull gateway products out of standard campaigns without disrupting product feeds, create feed rules (in Google Merchant Center or your feed management tool) based on product titles or categories to assign custom labels to these gateway items.

In Google Ads, we then exclude these labels from general Shopping and Performance Max campaigns and add them as product targets in dedicated LTV Acquisition campaigns.

Cash Flow Guardrails & Scaling Rules

To ensure aggressive customer acquisition never strains company liquidity, it’s important to establish strict account guardrails:

1. Budget Cap Allocation: Maintain the 20% to 30% budget allocation to protect working capital while scaling high-value acquisition.

2. Monthly Payback Audits: Every 30 days, re-run your orders export. Verify that the 90-day repeat purchase rate for gateway categories stays consistent.

3. Dynamic Bidding Adjustments: If the 90-day re-order rate increases, raise allowable tCPA to capture more market share. If the 90-day re-order rate drops, lower tCPA closer to Day-1 breakeven margin ($19.79) until repeat velocity recovers.

By moving away from uniform ROAS targets and deploying this LTV-based nCAC strategy, you can turn Google Ads Shopping and Performance Max campaigns from a transactional sales channel into a predictable, long-term customer acquisition engine.