Welcome to the Referential Blog!
As a team of consultants embedded in dozens of unique customer advocacy programs at any given moment, Referential is constantly exploring, implementing, and improving on strategies and best practices.
Join us as we discuss the latest tips, tricks, and techniques in customer advocacy and customer marketing.
See a topic you’d like to learn about in greater detail? Contact us! We’d love to start a conversation.
Looking for something specific?
Metrics to Help With Budget Justification
One of the most meaningful and powerful bi-annual metrics that we have in our portfolio, Client Lifetime Total Revenue and Longevity (CLTR-L) was developed to evaluate the dollar value of a client relationship over the length of the contract, and the longevity of the relationship. This metric enables us to quantifiably contrast the average value of active advocates against the average value of non-advocates. From this, we can help our clients demonstrate the tangible business impact that active advocates are making on just their part of the overall revenue.
VLOOKUPS: A Guide to Consolidating Data Across Spreadsheets
VLOOKUP can seem intimidating as it is a more complex Excel function, but this tutorial will walk you through the steps and explain common pitfalls when using the VLOOKUP function.
How to Create a Pivot Table in Excel
Pivot tables are one of Excel's most powerful Microsoft tools. A pivot table allows you to extract the significant data and trends from a large, detailed data set. When analyzing your customer advocacy program data, pivot tables can be excellent tools for efficiently gathering insights on your customer advocates and advocacy assets.
Jennifer Doyon, a Principal at Referential, shares insights from her 15 years in customer advocacy. In this Q&A, she discusses the key considerations when selecting a Reference Management System (RMS) or Customer Advocacy Platform (CAP), and how Referential helps clients justify their advocacy program budgets, optimize platform performance, and implement best practices.