Insights – Campaign Budget Dashboard

Load data

Campaign name contains

From

To

Uses Reporting data sources per platform. Reddit loads from Reddit API Reporting (same dates and campaign filter). TikTok uses mirrored CSV from Reporting/Budget. YouTube Views and Video plays at 100% come from the same server merge as Google Reporting. Episode tables use the Reporting Episode column (Episodes 1–12). Missing metrics are shown as N/A.

All platforms (side-by-side)

Dimensional tables below sum Meta (Facebook + Instagram), YouTube (all objectives), TikTok, and Reddit for each slice.

Load totals to compare platforms side-by-side.

Hero vs Podcast (all platforms)

Combined type_of_episode (Hero / Podcast / Trailer) across Meta, YouTube, TikTok, and Reddit.

Load totals comparison to populate this table.

Targeting (all platforms)

Interest / Pixel / Lookalike buckets — same rules as per-platform Insights.

Load totals comparison to populate this table.

Region (all platforms)

Listed region codes only — same list as Meta Insights.

Load totals comparison to populate this table.

By episode (all platforms)

Episodes 1–12 + Other / N/A — Reporting Episode column (same as each Reporting tab).

Load totals comparison to populate this table.

View

Facebook & Instagram

All Meta Reporting rows where platform is Facebook or Instagram — totals shown as two rows; splits below aggregate both placements.

Totals

Facebook and Instagram side by side for this load.

Load totals comparison to populate this table.

Hero vs Podcast

Combined Meta rows, split on Type of episode (type_of_episode).

Load totals comparison to populate this table.

Targeting

Combined rows, split on Targeting (targeting).

Load totals comparison to populate this table.

Region

Combined rows, split on Location (location). Only CA, IL, CO, MN, MO, TX, OH, AUS, IN.

Load totals comparison to populate this table.

By episode

Combined rows, grouped by Episode (episode).

Load totals comparison to populate this table.

Facebook

Meta Reporting rows where platform is Facebook (same rules as the Reporting tab).

Totals

Rollup for all Facebook rows in this load.

Load totals comparison to populate this table.

Hero vs Podcast

Split on Type of episode (type_of_episode): Hero vs Podcast. Rows that are neither are excluded.

Load totals comparison to populate this table.

Targeting

Split on Reporting Targeting (targeting): interest (InterestBased), pixel retargeting (PixelBasedRetargeting), lookalikes (LookalikeAudiences). Parsed from ad names; rows with any other value are excluded.

Load totals comparison to populate this table.

Region

Split on Reporting Location (location): region codes from ad names. Only CA, IL, CO, MN, MO, TX, OH, AUS, IN; other regions are excluded.

Load totals comparison to populate this table.

By episode

Grouped by Reporting Episode (episode): Episode 1–Episode 12; unparseable rows go to Other / N/A.

Load totals comparison to populate this table.

Instagram

Meta Reporting rows where platform is Instagram.

Totals

Rollup for all Instagram rows in this load.

Load totals comparison to populate this table.

Hero vs Podcast

Split on Type of episode (type_of_episode): Hero vs Podcast. Rows that are neither are excluded.

Load totals comparison to populate this table.

Targeting

Split on Reporting Targeting (targeting): interest, pixel retargeting, lookalikes. Parsed from ad names; rows with any other value are excluded.

Load totals comparison to populate this table.

Region

Split on Reporting Location (location). Only CA, IL, CO, MN, MO, TX, OH, AUS, IN; other regions are excluded.

Load totals comparison to populate this table.

By episode

Grouped by Reporting Episode (episode): Episodes 1–12; otherwise Other / N/A.

Load totals comparison to populate this table.

Google Ads — YouTube

Rows from Google Ads reporting where objective matches each campaign type. Dimensional splits use the same Reporting columns as Meta (type_of_episode, targeting, location, episode).

Objective

Load totals comparison to populate this table.

Hero vs Podcast

Includes Trailer where type_of_episode is Trailer. Filtered by Objective pills above.

Load totals comparison to populate this table.

Targeting

InterestBased, PixelBasedRetargeting, LookalikeAudiences from ad names.

Load totals comparison to populate this table.

Region

Region codes from ad names (same list as Meta Insights).

Load totals comparison to populate this table.

By episode

Grouped by Reporting episode (Google ad-name rules).

Load totals comparison to populate this table.

TikTok

Totals from mirrored TikTok CSV data (same source as Reporting / Budget). Dimensions are parsed from adName using the same token rules as Meta where possible.

Load totals comparison to populate this table.

Hero vs Podcast

Hero / Podcast / Trailer from creative tokens in ad names.

Load totals comparison to populate this table.

Targeting

Interest, pixel, lookalike tokens in ad names.

Load totals comparison to populate this table.

Region

Region codes in ad names (listed regions only).

Load totals comparison to populate this table.

By episode

EP / Episode tokens in ad names.

Load totals comparison to populate this table.