Skip to content
Random Truffle
RANDOM TRUFFLE DATA FOUNDATION

The marketing data lake
for intelligent marketing.

A marketing-specific data foundation, built in your BigQuery environment, that connects customer, sales, campaign, audience, creative and response data into a persistent marketing memory.

ARCHITECTURE / IN YOUR CLOUD
CustomerSalesCampaignProductCreativeResponse
RANDOM TRUFFLE DATA FOUNDATIONMarketing schema.
Identity. Measurement.
Campaign memory.
Built in your BigQuery environment.
+ BRAND HUBProducts · SKUs · Brand rules · Business definitions
01 / WHY IT MATTERS

AI needs something
reliable to reason over.

Connecting systems does not, on its own, create shared definitions, history or consistency. Ask the same question against four tools and you can get four totals. The foundation gives every agent the same customers, the same definition of a sale and the same record of what was tried before.

Access helps agents reach systems. A shared foundation gives them consistent context.

DefinitionsA purchase, a customer and a campaign mean the same thing for every agent.
HistoryPast audiences, creative, plans and results stay available to the next question.
LineageSource, refresh time and transformation travel with each result.
LimitsMissing data, delayed refreshes and unresolved identity stay visible.
Analytics, CRM and transactions feed Connect, Resolve and Define. The same context reaches Nexus, Aura, Prism and Radian.
02 / A MODEL BUILT FOR MARKETING

Built around how
marketing actually works.

Not a generic warehouse schema. The foundation organizes the entities marketing decisions depend on, and the relationships between them.

Customer
People, identities, behavior and eligibility.
Commerce
Transactions, products, SKUs, categories and revenue.
Marketing
Campaigns, investment, exposure and response.
Audiences
Criteria, segments, versions and destinations.
Creative
Assets, campaign context and links to products.
Measurement
Conversions, experiments, attribution and models.
Memory
Decisions, execution, results and what was learned.

A conceptual model. Which entities and modules are deployed depends on each client’s data and scope.

ONE DEFINITION, EVERY AGENT

A store records 1,000 MXN in settled gross sales and 200 MXN in refunds. Net sales are 800 MXN, and every agent uses that definition, or makes a different one explicit.

Gross sales1,000
−
Refunds200
=
Net sales800 MXN

One reporting period and currency · taxes and shipping excluded in this example.

03 / SALES AND MARKETING, CONNECTED

Connect sales
with marketing.

Analyze response by brand, SKU, category, region and customer when the data has enough granularity. Where a link is not supported, it stays unknown instead of being guessed.

  1. Campaign
  2. Exposure / response
  3. Identity, where supported
  1. Customer
  2. Transaction
  3. Product / SKU
  4. Revenue
Connect campaign performance with customer and product outcomes where the data supports the relationship.

Not every exposure can be matched to every sale. Coverage and unmatched records are reported with the result.

04 / IDENTITY RESOLUTION

One person, where the evidence supports it.

Records are linked when there is a supported, permitted correspondence between them, such as a shared customer ID. A record without that evidence remains a separate record.

Unknown remains unknown.

LinkedCRM customer ↔ commerce account, through a shared ID
UnresolvedAn anonymous visit with no supported link stays separate
PermissionA withdrawn permission changes what the record can be used for
LimitsNo perfect match rate and no universal identity
CRM and commerce records share C-014. Browser B-909 remains disconnected.
05 / MEASUREMENT

Different questions.
Different methods.

The foundation keeps the inputs each method needs. Nexus recognizes which question is being asked and says what the answer can and cannot support.

DisciplineThe questionThe limit
AttributionWhat appears to contribute?Credit across observed touchpoints is not causality.
IncrementalityWhat changed because of marketing?Needs an appropriate design: a comparable control or holdout.
Marketing Mix ModelingGoogle Meridian logoMeridianHow do channels contribute over time?Depends on the data and the fit of the model. Workflows built with Google’s Meridian framework.
ExperimentationWhat did the test change?Population, control and the metric are defined before the test.
Forecasting, where availableWhat might happen next?Expressed as a range with uncertainty, never as a certainty.
How the methods differ

Attribution shares credit for conversions already observed, using rules or a data-driven model. It is useful for day-to-day optimization and says nothing about what would have happened without the advertising.

Incrementality and experiments compare a group that received the marketing with a comparable group that did not. They answer causal questions, within the population and period tested.

Marketing mix modeling relates sales to marketing activity over time from aggregate data, accounting for other factors and stated assumptions. Random Truffle runs MMM workflows with Meridian, Google’s open-source framework; results depend on the data available and on how well the model fits.

Examples on this site use illustrative, synthetic data. They are not a fitted client model.

06 / BRAND HUB

Brand Hub.
The context behind the work.

Data Foundation connects what happened. Brand Hub adds the context needed to interpret it and to produce consistent work.

  • Products
  • SKUs
  • Categories
  • Brand guidelines
  • Tone of voice
  • Visual identity
  • Approved claims
  • Taxonomies
  • Business definitions
How Brand Hub enters the work
  1. Audience + objectiveDefined with Aura from the foundation.
  2. PrismCreates the brief and the variants.
  3. Brand HubAdds the product, approved claims and brand rules.
  4. Campaign assetReturns to the system, linked to its audience and product.

Structured product data can live in the foundation. Brand Hub adds context and rules on top of it; it is not a duplicate copy.

07 / OWNERSHIP

Change tools.
Keep your marketing memory.

Agencies, media accounts, automation platforms and analytics tools change. The history of what you did and what it produced stays in your own infrastructure.

YOUR STACK TODAY
  • Agency A
  • Google Ads · Meta
  • Email platform
  • Analytics tool
Same foundation.
Same history. Same definitions.
YOUR STACK NEXT YEAR
  • Agency B
  • Google Ads · Meta · TikTok
  • Marketing automation platform
  • Analytics tool

Changing a tool still takes technical work to connect it. What you keep is the history and the definitions, not an instant migration.

Your cloud.
Your data.
Your rules.
Your history.

The marketing data lake lives in your BigQuery environment, and it stays with you if you stop working with Random Truffle.

Your cloudDeployed in your Google Cloud project, under your access policies.
Your dataRecords keep their source, owner and permitted uses.
Your rulesAccess, approvals and limits stay under your control.
Your historyCampaigns, decisions and results remain in your foundation.

Ownership of your data is separate from the licence for Random Truffle’s software and services, which follows your contract.

TECHNOLOGY

Built in BigQuery,
on Google Cloud.

The foundation is deployed in your BigQuery environment. Agent workflows use Gemini models where your deployment is configured for them. Other clouds and warehouses can be connected as sources; they are not equivalent deployment targets.

See how your tools connect →

Questions worth asking.

Does this replace our warehouse or CRM?

No. The foundation is built in BigQuery and connects the context those systems hold; your systems of record keep doing their job. Other warehouses can feed it as sources.

Who owns the data?

You do. The marketing data lake is built in your BigQuery environment and stays there if you stop working with Random Truffle. The licence for our software and services is a separate matter, defined in your contract.

Does identity resolution make attribution causal?

No. Linking eligible records improves the observable journey. It does not establish what would have happened without the advertising. A causal question needs an appropriate comparison or experiment.

Is this a CDP?

Not a generic one. It is a marketing-specific data lake: customers, sales, campaigns, audiences, creative and response, with the business definitions and history that connect them.

What can I explore on this site?

This page describes the architecture. The agent conversations use example data to show identity, audience rules, model assumptions and a decision record.

Explore all solutions →

Start with a better question.

Ask how a business definition, an audience or a model would travel through the foundation.

Explore with Nexus →