Connect Microsoft Ads to Amazon Redshift — Bing Advertising Data Warehouse

Log into the Supermetrics Hub, create a new data transfer, select Microsoft Ads as your source and Amazon Redshift as the destination. Authorize your Microsoft Ads account, provide your Redshift cluster endpoint and credentials, choose your target schema and table naming conventions, select the fields you need, set a schedule, and start the transfer. Supermetrics loads data using optimized S3 COPY commands — the same high-throughput path AWS recommends for bulk ingestion — so no custom ETL pipelines, AWS Glue jobs, or staging buckets are required.

Supermetrics is SOC 2 Type II certified and GDPR compliant. All Microsoft Ads credentials are encrypted at rest and in transit using TLS 1.2+. Data flows directly from the Microsoft Ads API to your Redshift cluster — Supermetrics never stores your marketing data on its own servers. On the AWS side, your VPC isolation keeps the cluster off the public internet, IAM policies restrict which roles can access the data, and S3 server-side encryption protects any intermediate staging objects. You retain full control of your security perimeter.

Absolutely — cross-source analysis is where Redshift shines in the AWS ecosystem. Once Microsoft Ads data lands in your cluster, you can JOIN it with any other table in the same schema. Need to enrich it with raw event logs or clickstream data sitting in S3? Redshift Spectrum lets you query those external files directly without loading them, so your cluster stays lean while your analysis spans petabytes. Supermetrics supports 170+ data sources that all land in the same Redshift schema, and you can optimize JOIN performance further with DISTKEY and SORTKEY settings on frequently queried columns.

All standard Microsoft Ads reporting fields are available, including Impressions, Clicks, Spend, Conversions, Revenue, CPA, and many more. You select exactly which metrics and dimensions to transfer during setup, and you can add or remove fields at any time without losing historical data already loaded into Redshift. Because Redshift uses columnar storage, queries that scan only a few selected metrics out of a wide table are extremely fast — the engine skips unneeded columns at the disk level, reducing I/O and keeping your analytics snappy.

Data freshness depends on your transfer schedule. Supermetrics supports hourly, daily, or weekly transfers into Redshift. Most teams schedule daily transfers so yesterday's final numbers are ready each morning. Incremental loading means only new and changed records are written via optimized S3 COPY commands, keeping cluster load minimal. If you define a SORTKEY on your date column, Redshift can skip entire disk blocks during time-range queries, making your morning dashboards in QuickSight or Tableau load in seconds.

Yes. Both Microsoft Search (Bing) and Audience Network data are available in your Redshift tables.

Yes. Load both sources into the same schema and JOIN on campaign name or keyword to compare CPC, CPA, and conversion rates side by side.