Prepared for Manchester United
Overview
This comprehensive guide outlines the complete process for setting up data ingestion from Google Ads to Azure Data Lake Storage (ADLS) using the 5X platform. This setup will enable Manchester United to efficiently move advertising data into their data lake while maintaining security and data governance standards.
Azure Data Lake Storage Setup
Prerequisites
Azure account with Administrator permissions ADLS Gen2 account with Administrator permissions Permissions to create and manage: Azure Active Directory applications Detailed Setup Instructions
Create Storage Account
Log in to the Azure portal Follow Microsoft's official guide to create a storage account: Critical Configuration Notes:
During storage account creation, ensure you: Select "Enable hierarchical namespace" checkbox in the Advanced tab Configure appropriate performance tier and redundancy options Set up appropriate network access controls Firewall Configuration: If you have a firewall enabled:
3.217.202.216
3.211.173.46
174.129.146.62
Create ADLS Container
Navigate to your newly created storage account Go to "Containers" in the navigation menu In the New container pane: Enter a unique container name Select appropriate public access level
Set Up Service Principal
Register Application in Microsoft Entra ID: Navigate to Microsoft Entra ID (formerly Azure Active Directory) Go to "App registrations" → "New registration" Select "Accounts in this organizational directory only" Record the following after registration: In the registered application, go to "Certificates & secrets" Click "+ New client secret" Add description and select expiry period Important: Save the generated secret value immediately Go to container's "Access Control (IAM)" Click "Add" → "Add role assignments" Select "Storage Blob Data Contributor" role Add the service principal as member
Required Information for 5X Platform Configuration
DST adjustment preference Table format (Delta Lake recommended) Snapshot retention period Once the above details and credentials are shared with 5X, the platform support team will assist with setting up the Azure Data Lake Storage destination on the 5X platform.
Google Ads Setup Steps
Google Ads Account Preparation
Log into Google Ads account Locate and note your Google Ads customer ID Ensure appropriate access levels are configured Required Information
Gather the following details:
Account access credentials List of accounts to be synced (if using specific account sync mode) 5X Platform Integration
Google Ads Connector Setup
Navigate to Ingestion in 5X platform Search and select "Google Ads" Configure connector settings: Enter destination schema name (e.g., "google_ads") Input Google Ads customer ID Complete Google OAuth authorization Sync Specific Manager Accounts Support and Resources
Technical Support
5X Platform Support: support@5x.co Dedicated Account Manager: akshay@5x.co Documentation
5X Platform Documentation: Next Steps
Complete Azure environment setup Configure Google Ads access Set up 5X platform integration Note: This setup enables secure and efficient data transfer from Google Ads to your Azure Data Lake Storage through the 5X platform. All configurations align with security best practices and data governance requirements.
