Marketing Analytics | Tourism

Transat gains 360-degree view of customers for targeted marketing with Google Cloud

Transat, a leading integrated international tourism company specializing in leisure travel, needed a more thorough understanding of its customer data to accurately and efficiently target its marketing campaign efforts.

Transat
Customer
    

Customer

Industry

Tourism

Location

Montreal, Canada

Solution

Marketing Analytics, Cloud Infrastructure

Technology

Google Cloud, BigQuery

    

Overview

Transat, a leading integrated international tourism company specializing in leisure travel, needed a more thorough understanding of its customer data to accurately and efficiently target its marketing campaign efforts.

With limited capacity and an internal IT team with no Google Cloud expertise, they knew they needed a partner to help manage configuration and integrations between existing infrastructure.

css-transat
    

What we did

Pythian completed a small-scope proof of concept (POC) for Transat that proved replicating data from their Microsoft SQL Server to Google BigQuery was achievable. During the POC, approximately 10 percent of their total data landscape was replicated successfully to BigQuery using a simple data ingestion pipeline.

Pythian also installed and configured Enterprise Data Platform (EDP) QuickStart for Google Cloud to integrate, clean, and organize Transat’s data into Google BigQuery and quickly make datasets available for marketing analytics reporting. Pythian also built a pipeline using Google Cloud Build to manage organizational policies, folder structure, audit log configuration, and access at the organization and folder level.

    

Technologies used

  • Google BigQuery
  • Google Cloud Composer
  • Google Cloud Storage
  • Cloud Functions
  • Cloud SQL
  • Google Cloud Build
  • Dataflow
  • DataProc
        

Key Outcomes

Transat’s use of Pythian’s EDP QuickStart for Google Cloud allowed for the integration of data from different sources, showing quick value and allowing them to further expand and scale into a full EDP without data loss or slowdown.

  • Transat’s marketing team is benefiting from highly accurate targeting and marketing campaigns, increasing efficiency and reducing costs.
  • BigQuery is now up-to-date, providing a 360-degree view of customer data for targeted campaigns.
  • Transat’s IT team can now ensure identity sync and federation configuration between Azure Active Directory and Google user accounts, resulting in identity management remediation.
“What used to take us hours takes about 30 seconds. We can also replicate what Pythian did to help us leverage our data and build more sophisticated models.”
Jeannot Aneas

Manager, Marketing Data Analytics, Transat

"We’re now able to integrate data from different sources and centralize it in BigQuery to gain a 360-degree view of our customers. It’s helping our IT team better serve Transat’s marketing team—and that’s been a big win for us."
Aura Lucia Perez

Director, Solution, Transat

Explore our Google Cloud Marketing Analytics Services

No matter your business, no matter the challenge: Pythian’s solutions drive results.
Related resources

Discover what our marketing analytics services can do

Learn more about what Pythian's marketing analytics services can do for your business. Check out our resources below:

Data-enabled retail: Stand Out For Good leverages BigQuery to improve marketing and customer experience
Google

Data-enabled retail: Stand Out For Good leverages BigQuery to improve marketing and customer experience

Aug 25, 2023 9:38:27 AM 1 min read
Canadian clothing retailer accelerates data insights with Enterprise Data Platform QuickStart for Google Cloud
SAP ECC

Canadian clothing retailer accelerates data insights with Enterprise Data Platform QuickStart for Google Cloud

Jun 23, 2022 12:00:00 AM 1 min read
Accelerate Marketing Insights on Google Cloud with Pythian
Google BigQuery

Accelerate Marketing Insights on Google Cloud with Pythian

May 27, 2024 8:38:35 AM 3 min read
Follow us
Love Your Data
Pythian Logo

© 2024 All rights reserved.