5X - One Pagers

5X - Bring your own Google BigQuery

Setup Guide: Google Ads to Azure Data Lake Storage on 5X Platform

Multi-region support for the 5X Platform

5X Platform: Comprehensive DORA Compliance Assessment and Roadmap

Embedding 5X BI Dashboards

5X - Setting Up GitHub Merge-Triggered Workflows Using 5X Webhooks

Embedding 5X BI Dashboards

Explore

Setup Guide: Google Ads to Azure Data Lake Storage on 5X Platform

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:

Storage accounts

Service principals

Azure Active Directory applications

Containers

Detailed Setup Instructions

Create Storage Account

Follow Microsoft's official guide to create a storage account:

Create a storage account to use with Azure Data Lake Storage Gen2⁠

⁠

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

Click "+ Container"

In the New container pane:

Enter a unique container name

Select appropriate public access level

Click "Create"

Set Up Service Principal

Navigate to Microsoft Entra ID (formerly Azure Active Directory)

Go to "App registrations" → "New registration"

Enter application name

Select "Accounts in this organizational directory only"

Record the following after registration:

Application (client) ID

Directory (tenant) ID

Create Client Secret:

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

Assign Container Roles:

Go to container's "Access Control (IAM)"

Click "Add" → "Add role assignments"

Select "Storage Blob Data Contributor" role

Add the service principal as member

Complete assignment

Required Information for 5X Platform Configuration

Storage Configuration:

Storage Account Name

Container Name

Prefix Path (optional)

Data processing location

Authentication:

Tenant ID

Client ID

Secret Value

Operational Settings:

Time zone preference

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:

Google Ads customer ID

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

Click "+ Add Connector"

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

Select sync mode:

Sync All Accounts

Sync Specific Accounts

Sync Specific Manager Accounts

Support and Resources

Technical Support

5X Platform Support: support@5x.co

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.