Nando's powers their customer loyalty program & reduces data integration time by 75%
Nando's leverages Hightouch to lower engineering time and deliver faster and more relevant lifecycle marketing campaigns.
Fivetran and Hightouch save Nando's 80% of time by automating ELT & data integration workflows
Nando's uses Google BigQuery as their data warehouse to power decisions around customer loyalty programs, benefitting their bottom line
Fivetran and Hightouch enable more access to data in marketing tools and more targeted campaign segmentation
Data team freed up to work on higher-value tasks
Integrating data sources delivers new insights
Pipeline: Fivetran, Serverless and Google Cloud Resources
Source: Stripe, Zendesk, SQL Server, GitHub, SFPT
Destination: Google BigQuery
Business Intelligence: Looker
Reverse ETL: Hightouch
Famous for its flame-grilled peri-peri style chicken, the Nando's takeaway chain has taken the world by storm, growing to over 1,200 outlets in 30 countries. The United Kingdom and Ireland operation runs +450 outlets across the two countries and serves 12 million customers – the goal is to continually improve and serve them even better by becoming data-driven in the UK & IRE.
The Challenge: Slow and inflexible infrastructure
Nando's built its success on providing customers with a great dining experience and wants to continue this mission by using data to better communicate with customers. Miquel Puig, Technical Lead on the Engineering team, and his team are responsible for ensuring the infrastructure can support data-driven marketing strategies, particularly around customer loyalty and the rewards program.
The problem that Puig faced was that their existing infrastructure was not meeting the demands of the business.
In addition to Puig, the data team has three analysts, two data engineers, a product manager, and a platform manager. Using an ELT approach, engineers manually worked on data pipelines and analysts made business decisions based on data at the ingestion stage. One use case was turning end-of-day data from the outlets into insights that informed loyalty and reward programs.
The Solution: Clear view of trustworthy data
The decision was taken to start from scratch, and move the business’ data from SQL server to Google Cloud Platform. BigQuery was chosen as the data warehouse at the center of a modern data stack; Fivetran was selected as the data source connector alongside Google Cloud Resources, Looker for BI, and Hightouch as the Reverse ETL and data activation solution.
The goal was to have infrastructure that provided flexibility and visibility, giving the business a transparent view of data that it knew it could trust. The team wanted to standardize and document the process, and avoid relying on a single engineer to build a pipeline in the ingestion phase while making business decisions at the same time.
Fivetran was chosen over Stitch for data integration because of its flexibility, ease of use, and speed.
Stripe and Zendesk were among the first applications to be connected for transaction and customer interaction data respectively, followed by third-party data coming in over SFTP. Tight integration with Google Cloud Platform was another Fivetran feature that was important to Nando's.
Hightouch was chosen as the Reverse ETL solution because of its clear UX, which is welcoming to both data practitioners and marketers. Hightouch sends data from the warehouse to power business tools and workflows. Hightouch had superior integrations with the Nando's marketing stack, allowing them to send a 360 view of customers to the campaign tool and ad networks like Facebook and Google Ads for personalized campaigns. The team also benefited from Hightouch’s advanced data features that handle large volumes of data, such as auto-retrying rows of data when errors or API rate limits are hit.
The Results: Granular insights for more targeted marketing
The biggest benefit from the modern data stack is seeing how the business is performing on a granular level, from the most profitable restaurants to what customers are ordering. Fivetran pulls payment data from Stripe that feeds Looker dashboards, giving the business fast access to insights on everything from deals on meals to possible incidents of fraud.
Once data is in the warehouse and modeled, Nando's uses Hightouch to send modeled data on users, such as their most recent orders and their loyalty status, to their campaign and segmentation tools. The Marketing team is then able to use that data to activate campaigns much more quickly than before, whether in reaching platinum customers with special offers during the holidays or targeting gold customers with customized emails.
As a result, Nando's was also able to update customers during the Covid lockdown. Warehouse data enabled the business to target customers by postcode and let them know when an outlet in their area was reopening.
As well as making marketing more effective, the new stack has liberated the data team from time-consuming tasks.
Integrating different data sources has enabled more sophisticated types of analysis. By correlating transaction data from the tills with platinum and gold customer purchases, the loyalty team can analyze the effectiveness of their programs and tweak them accordingly.
Ready to leverage your customer data?
Your data warehouse is your source of truth for customer data. Hightouch syncs this data to the tools that your business teams rely on.