/* ========================================= ARTICLE LAYOUT ========================================= */ .blog-post-content { width: 100%; min-width: 0; grid-template-columns: 230px minmax(0, 1fr) 74px; } .blog-post-content > * { min-width: 0; } /* ========================================= RICH TEXT VARIABLES AND BASE ========================================= */ .catchr-blog-post-rich-text { --cbrt-ink: #1c1642; --cbrt-ink-2: #302b4a; --cbrt-muted: #706b82; --cbrt-purple: #7d41f5; --cbrt-purple-dark: #5724bd; --cbrt-purple-soft: #eee6ff; --cbrt-mint: #00d7ad; --cbrt-mint-soft: #dffff7; --cbrt-yellow: #ffc84a; --cbrt-wash: #f8f6fc; --cbrt-line: #ded9eb; width: 100%; min-width: 0; max-width: 100%; color: var(--cbrt-ink-2); font-family: "Poppins", sans-serif; font-size: 17px; font-weight: 400; line-height: 1.82; overflow-wrap: break-word; } .catchr-blog-post-rich-text, .catchr-blog-post-rich-text * { box-sizing: border-box; } .catchr-blog-post-rich-text > :first-child { margin-top: 0; } .catchr-blog-post-rich-text > :last-child { margin-bottom: 0; } /* ========================================= PARAGRAPHS ========================================= */ .catchr-blog-post-rich-text p { margin: 0 0 26px; color: var(--cbrt-ink-2); font-size: 1em; font-weight: 400; line-height: 1.82; } .catchr-blog-post-rich-text > p:first-child { color: var(--cbrt-ink); font-size: 22px; line-height: 1.6; letter-spacing: -0.015em; } /* ========================================= HEADINGS ========================================= */ .catchr-blog-post-rich-text h1, .catchr-blog-post-rich-text h2, .catchr-blog-post-rich-text h3, .catchr-blog-post-rich-text h4, .catchr-blog-post-rich-text h5, .catchr-blog-post-rich-text h6 { color: var(--cbrt-ink); font-family: "Poppins", sans-serif; font-weight: 600; letter-spacing: -0.035em; line-height: 1.15; } .catchr-blog-post-rich-text h1 { margin: 0 0 28px; font-size: clamp(42px, 6vw, 68px); letter-spacing: -0.05em; line-height: 1.02; } .catchr-blog-post-rich-text h2 { margin: 76px 0 24px; font-size: clamp(34px, 4vw, 48px); scroll-margin-top: 110px; } .catchr-blog-post-rich-text h3 { margin: 48px 0 17px; font-size: 26px; scroll-margin-top: 110px; } .catchr-blog-post-rich-text h4 { margin: 38px 0 14px; font-size: 21px; letter-spacing: -0.025em; } .catchr-blog-post-rich-text h5, .catchr-blog-post-rich-text h6 { margin: 32px 0 12px; font-size: 16px; letter-spacing: 0; } .catchr-blog-post-rich-text h6 { font-family: "DM Mono", monospace; font-size: 11px; font-weight: 500; letter-spacing: 0.03em; text-transform: uppercase; } .catchr-blog-post-rich-text h2 + p, .catchr-blog-post-rich-text h3 + p, .catchr-blog-post-rich-text h4 + p { margin-top: 0; } /* ========================================= TEXT FORMATTING ========================================= */ .catchr-blog-post-rich-text strong, .catchr-blog-post-rich-text b { color: var(--cbrt-ink); font-weight: 600; } .catchr-blog-post-rich-text em, .catchr-blog-post-rich-text i { font-style: italic; } .catchr-blog-post-rich-text small { color: var(--cbrt-muted); font-size: 0.82em; } .catchr-blog-post-rich-text mark { padding: 0.08em 0.22em; background: #fff1a8; color: var(--cbrt-ink); } .catchr-blog-post-rich-text del { color: var(--cbrt-muted); } /* ========================================= LINKS ========================================= */ .catchr-blog-post-rich-text a { color: var(--cbrt-purple-dark); font-weight: 500; overflow-wrap: anywhere; text-decoration-line: underline; text-decoration-color: var(--cbrt-mint); text-decoration-thickness: 3px; text-underline-offset: 3px; transition: color 160ms ease, background-color 160ms ease; } .catchr-blog-post-rich-text a:hover { background: var(--cbrt-mint-soft); color: var(--cbrt-ink); } .catchr-blog-post-rich-text a:focus-visible { outline: 3px solid rgba(125, 65, 245, 0.32); outline-offset: 3px; } /* ========================================= LISTS ========================================= */ .catchr-blog-post-rich-text ul, .catchr-blog-post-rich-text ol { margin: 0 0 30px; padding: 0; } .catchr-blog-post-rich-text ul { overflow: visible; list-style: none; } .catchr-blog-post-rich-text ol { overflow: visible; padding-left: 30px; } .catchr-blog-post-rich-text li { position: relative; margin: 0; padding-left: 28px; color: var(--cbrt-ink-2); line-height: 1.72; } .catchr-blog-post-rich-text li + li { margin-top: 12px; } .catchr-blog-post-rich-text ul > li::before { position: absolute; top: 0.72em; left: 2px; width: 8px; height: 8px; background: var(--cbrt-purple); box-shadow: 4px 4px 0 var(--cbrt-mint-soft); content: ""; } .catchr-blog-post-rich-text ol > li { padding-left: 8px; } .catchr-blog-post-rich-text ol > li::marker { color: var(--cbrt-purple-dark); font-family: "DM Mono", monospace; font-size: 0.85em; font-weight: 500; } .catchr-blog-post-rich-text li ul, .catchr-blog-post-rich-text li ol { margin: 12px 0 4px; } .catchr-blog-post-rich-text ul ul > li::before { width: 7px; height: 2px; background: var(--cbrt-mint); box-shadow: none; } /* ========================================= BLOCKQUOTES ========================================= */ .catchr-blog-post-rich-text blockquote { margin: 42px 0; padding: 4px 0 4px 30px; border: 0; border-left: 6px solid var(--cbrt-yellow); color: var(--cbrt-ink); font-size: 24px; font-style: normal; letter-spacing: -0.02em; line-height: 1.5; } .catchr-blog-post-rich-text blockquote p { margin: 0; color: inherit; font-size: inherit; font-weight: inherit; line-height: inherit; } .catchr-blog-post-rich-text blockquote cite { display: block; margin-top: 14px; color: var(--cbrt-muted); font-family: "DM Mono", monospace; font-size: 10px; font-style: normal; font-weight: 400; letter-spacing: 0.03em; text-transform: uppercase; } /* ========================================= DIVIDERS ========================================= */ .catchr-blog-post-rich-text hr { width: 100%; height: 1px; margin: 58px 0; border: 0; background: var(--cbrt-line); } /* ========================================= IMAGES AND FIGURES ========================================= */ .catchr-blog-post-rich-text img { display: block; width: auto; max-width: 100%; height: auto; border: 1px solid var(--cbrt-ink); } .catchr-blog-post-rich-text figure, .catchr-blog-post-rich-text .w-richtext-figure-type-image, .catchr-blog-post-rich-text .w-richtext-figure-type-video { width: auto; max-width: none; margin: 46px -44px; } .catchr-blog-post-rich-text figure > div, .catchr-blog-post-rich-text .w-richtext-figure-type-image > div, .catchr-blog-post-rich-text .w-richtext-figure-type-video > div { width: 100%; } .catchr-blog-post-rich-text figure img, .catchr-blog-post-rich-text .w-richtext-figure-type-image img { width: 100%; box-shadow: 8px 8px 0 var(--cbrt-ink); } .catchr-blog-post-rich-text figcaption, .catchr-blog-post-rich-text .w-richtext-figure-type-image figcaption, .catchr-blog-post-rich-text .w-richtext-figure-type-video figcaption { margin-top: 16px; color: var(--cbrt-muted); font-family: "DM Mono", monospace; font-size: 9px; font-style: normal; line-height: 1.5; text-align: center; text-transform: uppercase; } /* ========================================= VIDEOS ========================================= */ .catchr-blog-post-rich-text iframe { display: block; width: 100%; max-width: 100%; border: 1px solid var(--cbrt-ink); } .catchr-blog-post-rich-text .w-video { overflow: hidden; border: 1px solid var(--cbrt-ink); box-shadow: 8px 8px 0 var(--cbrt-ink); } /* ========================================= RESPONSIVE TABLES ========================================= */ .catchr-blog-post-rich-text .table-wrapper, .catchr-blog-post-rich-text .w-embed:has(> table) { display: block; width: 100%; min-width: 0; max-width: 100%; margin: 38px 0; overflow-x: auto; overflow-y: hidden; border: 1px solid var(--cbrt-ink); overscroll-behavior-inline: contain; scrollbar-color: var(--cbrt-purple) var(--cbrt-purple-soft); scrollbar-width: thin; -webkit-overflow-scrolling: touch; } .catchr-blog-post-rich-text .table-wrapper::-webkit-scrollbar, .catchr-blog-post-rich-text .w-embed:has(> table)::-webkit-scrollbar { height: 8px; } .catchr-blog-post-rich-text .table-wrapper::-webkit-scrollbar-track, .catchr-blog-post-rich-text .w-embed:has(> table)::-webkit-scrollbar-track { background: var(--cbrt-purple-soft); } .catchr-blog-post-rich-text .table-wrapper::-webkit-scrollbar-thumb, .catchr-blog-post-rich-text .w-embed:has(> table)::-webkit-scrollbar-thumb { border: 2px solid var(--cbrt-purple-soft); border-radius: 999px; background: var(--cbrt-purple); } .catchr-blog-post-rich-text table { width: 100%; min-width: 600px; margin: 38px 0; border: 1px solid var(--cbrt-ink); border-collapse: collapse; color: var(--cbrt-ink-2); font-size: 14px; line-height: 1.55; table-layout: auto; } .catchr-blog-post-rich-text .table-wrapper > table, .catchr-blog-post-rich-text .w-embed:has(> table) > table { width: max-content; min-width: 100%; margin: 0; border: 0; table-layout: auto; } .catchr-blog-post-rich-text th, .catchr-blog-post-rich-text td { padding: 15px 16px; border-right: 1px solid var(--cbrt-line); border-bottom: 1px solid var(--cbrt-line); text-align: left; vertical-align: top; } .catchr-blog-post-rich-text th:last-child, .catchr-blog-post-rich-text td:last-child { border-right: 0; } .catchr-blog-post-rich-text tr:last-child td { border-bottom: 0; } .catchr-blog-post-rich-text th { background: var(--cbrt-ink); color: #fff; font-family: "DM Mono", monospace; font-size: 9px; font-weight: 500; letter-spacing: 0.02em; text-transform: uppercase; } .catchr-blog-post-rich-text tbody tr:nth-child(even) { background: var(--cbrt-wash); } /* ========================================= CODE ========================================= */ .catchr-blog-post-rich-text code { padding: 0.16em 0.36em; background: var(--cbrt-purple-soft); color: var(--cbrt-purple-dark); font-family: "DM Mono", monospace; font-size: 0.84em; } .catchr-blog-post-rich-text pre { width: 100%; max-width: 100%; margin: 38px 0; overflow-x: auto; padding: 24px; border: 1px solid var(--cbrt-ink); background: var(--cbrt-ink); color: #fff; font-family: "DM Mono", monospace; font-size: 13px; line-height: 1.7; tab-size: 2; -webkit-overflow-scrolling: touch; } .catchr-blog-post-rich-text pre code { padding: 0; background: transparent; color: inherit; font-size: inherit; } /* ========================================= OPTIONAL CALLOUT ========================================= */ .catchr-blog-post-rich-text .article-callout { position: relative; margin: 42px 0; padding: 28px 30px 28px 72px; border: 1px solid var(--cbrt-ink); background: var(--cbrt-mint-soft); box-shadow: 7px 7px 0 var(--cbrt-ink); } .catchr-blog-post-rich-text .article-callout::before { position: absolute; top: 30px; left: 27px; width: 18px; height: 18px; border: 3px solid var(--cbrt-purple); border-radius: 50%; content: ""; } .catchr-blog-post-rich-text .article-callout::after { position: absolute; top: 50px; left: 34px; width: 10px; height: 3px; background: var(--cbrt-purple); content: ""; } .catchr-blog-post-rich-text .article-callout strong { display: block; margin-bottom: 5px; } .catchr-blog-post-rich-text .article-callout p { margin: 0; font-size: 15px; line-height: 1.65; } /* ========================================= TEXT SELECTION ========================================= */ .catchr-blog-post-rich-text ::selection { background: var(--cbrt-mint); color: var(--cbrt-ink); } /* ========================================= TABLET ========================================= */ @media (max-width: 991px) { .blog-post-content { grid-template-columns: minmax(0, 1fr); } .blog-post-content > * { width: 100%; min-width: 0; max-width: 100%; } .catchr-blog-post-rich-text { width: 100%; min-width: 0; max-width: 100%; } } /* ========================================= MOBILE LANDSCAPE ========================================= */ @media (max-width: 767px) { .catchr-blog-post-rich-text { font-size: 16px; line-height: 1.76; } .catchr-blog-post-rich-text > p:first-child { font-size: 19px; line-height: 1.62; } .catchr-blog-post-rich-text h2 { margin-top: 58px; font-size: 34px; } .catchr-blog-post-rich-text h3 { margin-top: 40px; font-size: 24px; } .catchr-blog-post-rich-text blockquote { padding-left: 20px; font-size: 20px; } .catchr-blog-post-rich-text figure, .catchr-blog-post-rich-text .w-richtext-figure-type-image, .catchr-blog-post-rich-text .w-richtext-figure-type-video { max-width: 100%; margin-right: 0; margin-left: 0; } .catchr-blog-post-rich-text .table-wrapper, .catchr-blog-post-rich-text .w-embed:has(> table) { width: 100%; max-width: 100%; margin-top: 32px; margin-bottom: 32px; } .catchr-blog-post-rich-text th, .catchr-blog-post-rich-text td { min-width: 150px; padding: 13px 14px; } /* Première colonne sticky */ .catchr-blog-post-rich-text th:first-child, .catchr-blog-post-rich-text td:first-child { position: sticky; z-index: 1; left: 0; min-width: 170px; box-shadow: 1px 0 0 var(--cbrt-line); } .catchr-blog-post-rich-text th:first-child { z-index: 2; background: var(--cbrt-ink); } .catchr-blog-post-rich-text td:first-child { background: #fff; } .catchr-blog-post-rich-text tbody tr:nth-child(even) td:first-child { background: var(--cbrt-wash); } } /* ========================================= MOBILE PORTRAIT ========================================= */ @media (max-width: 479px) { .catchr-blog-post-rich-text h2 { font-size: 31px; } .catchr-blog-post-rich-text h3 { font-size: 22px; } .catchr-blog-post-rich-text li { padding-left: 24px; } .catchr-blog-post-rich-text .article-callout { padding: 60px 20px 22px; } .catchr-blog-post-rich-text .article-callout::before { top: 21px; left: 21px; } .catchr-blog-post-rich-text .article-callout::after { top: 41px; left: 28px; } .catchr-blog-post-rich-text pre { padding: 18px; font-size: 12px; } } /* ========================================= REDUCED MOTION ========================================= */ @media (prefers-reduced-motion: reduce) { .catchr-blog-post-rich-text a { transition: none; } }

Home > Destinations > Amazon Redshift > Youtube Analytics

Connect Youtube Analytics to Amazon Redshift

Connect Youtube Analytics to Amazon Redshift and export selected accounts, metrics, and dimensions to your Amazon Redshift project.

Configure the historical window, destination table, and recurring schedule without maintaining a Youtube Analytics API pipeline.

Used by the world's leading companies

Export Youtube Analytics data to Amazon Redshift

Catchr handles extraction, normalization, and loading automatically.

Centralize

Centralize Youtube Analytics data in Amazon Redshift

Bring all your Youtube Analytics data into your warehouse and make it available for analytics, machine learning, and internal applications.

Data freshness

Keep your Amazon Redshift tables up to date

Automatically sync new data from Youtube Analytics so every dashboard, model, and report works with fresh information.

Analysis

Keep your Amazon Redshift tables up to date

Join marketing, finance, CRM, and product data inside the same warehouse.

Youtube Analytics metrics and dimensions available in Amazon Redshift

Access 36 metrics and 180 dimensions from Youtube Analytics connectors including Views, Estimated Minutes Watched, Average View Duration, Subscribers Gained, Estimated Revenue, Date, Country, Device Type, Insight Traffic Source Type, Subscribed Status and many more...

36

Metrics availables

180

Dimensions availables

Connect Youtube Analytics to Amazon Redshift in minutes

Move your data from Youtube Analytics to Amazon Redshift with a simple setup. Once connected, Catchr handles the ingestion automatically so your warehouse stays up to date without manual work.

Step one

Connect your Youtube Analytics account

Authenticate your Youtube Analytics account securely in Catchr. No custom scripts, API maintenance, or engineering work required.

Client A · Connected sources
5 sources ready
Youtube Analytics 3 advertising accounts Connected
Google Ads 2 advertising accounts Connected
Google Analytics 4 1 web property Connected
HubSpot 1 CRM portal Connected
Step two

Choose the Amazon Redshift destination

Enter the Redshift host, database, and credentials that Catchr should use. The connection is checked before the destination is saved.

Destination / Amazon Redshift Required fields
Host Required
reporting-cluster.abc123.eu-west-1.redshift.amazonaws.com
Username Required
catchr_loader
Password Required
••••••••••••
Database Required
marketing_warehouse
Step three

Keep your Amazon Redshift tables updated

Choose the fields, initial history, partition field, and recurring schedule for the job. Catchr refreshes the configured import window in your Amazon Redshift table.

Export job / Amazon Redshift Example
Schema Destination
marketing_raw
Table Per job
facebook_ads_daily
Recurring schedule Choose a cadence
Every 6 hours
Daily · 06:00
Weekly · Mon
First sync scheduledSelected fields · configured history
06:00 UTC

Review 30-day Youtube Analytics organic content performance in SQL.

This example summarizes impressions, reach, engagements, and engagement rate by post.

Youtube Analytics.sql
BigQuery SQL
30-day window
SELECT
  post_id,
  SUM(impressions) AS impressions,
  SUM(reach) AS reach,
  SUM(engagements) AS engagements,
  SAFE_DIVIDE(
    SUM(engagements),
    SUM(impressions)
  ) AS engagement_rate
FROM `your_project.marketing_raw.youtube_analytics_content_daily`
WHERE date >= DATE_SUB(
  CURRENT_DATE(),
  INTERVAL 30 DAY
)
GROUP BY post_id
ORDER BY engagements DESC;
Illustrative SQL — adapt it to the fields and schema selected in your export. Standard SQL

Connect more table to your Youtube Analytics data

Open the dedicated route for each platform. Its field catalog, reporting grain, historical constraints, and warehouse use cases should be specific to that source.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Before you connect your first source.

Plain answers for marketers evaluating MCP and Catchr.

What does MCP stand for

MCP stands for Model Context Protocol. It is an open standard that lets AI applications connect to external data sources and tools through a common interface.

What is an MCP server?

An MCP server makes selected data or capabilities available to an MCP-compatible application. Catchr MCP acts as the bridge between your AI assistant and the marketing platforms connected to Catchr.

How is MCP different from an API?

An API exposes ways for software to exchange data or perform actions. MCP provides a standard designed for AI applications to discover and use those capabilities. Catchr handles the source APIs and exposes useful marketing-data capabilities through MCP.

Do I need to code to use Catchr MCP?

No. Connect your sources in Catchr, add the remote MCP server URL to a supported AI assistant, and complete authorization through the interface.

Does Catchr MCP work with ChatGPT and Claude?

Yes. Catchr provides dedicated setup guides for both. Custom MCP support can depend on your AI plan, your region, and your workspace administrator settings, so check the relevant guide before setup.

What can I ask about my marketing data?

You can request performance summaries, period comparisons, campaign and account breakdowns, anomaly investigations, and client-ready recaps. Precise prompts should include the account, date range, metrics, comparison, and desired output format.

Which data sources are available?

Catchr supports more than 100 platforms across advertising, analytics, CRM, ecommerce, email, SEO, and social. Explore the connector directory to confirm a specific source.

Still have a question ? 

Our teams is always here to responds to any question you could have about our data connector.