Insights – Campaign Budget Dashboard

Load data

Campaign name contains

From

To

Uses Reporting data sources per platform. YouTube Views and Video plays at 100% come from the same server merge as Google Reporting (SQLite imports by ad/day). After uploading a public-views CSV there, use the same date range here and click Load totals comparison. For Meta, Facebook vs Instagram follows the Platform column in Reporting (not Boosted/Dark). 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–6 + Other / N/A — Reporting episode column and name parsing per platform.

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 6 when parseable; everything else (including N/A or episode 7+) goes 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–6 when parseable; 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.

Reddit

Totals from mirrored Reddit 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.