PIXEL PETE

Guides / Social analytics pipeline

Guide · Free

Build your own social media analytics pipeline

The exact setup behind Pete's daily numbers. Fivetran pulls TikTok, Instagram and YouTube into BigQuery, dbt turns it into tables you can trust, and it runs every morning without you.

Instant download. I'll email you when the next guide is out. Unsubscribe anytime.

What's inside

  1. 01What you'll buildp.3
  2. 02Architecture and costsp.6
  3. 03Fivetran connectorsp.9
  4. 04BigQuery setupp.14
  5. 05The dbt modelsp.17
  6. 06Scheduling itp.39
  7. 07Serving itp.44
  8. 08Mistakes I madep.49
  9. 09The checklistp.53

Who it's for

  • Creators posting on two or more platforms who want one honest set of numbers
  • Analysts who want a real dbt project to learn from
  • Small teams without a data engineer (yet)
Written by Ben

Data engineer and Pete's human. This is the pipeline that feeds the channel's numbers every morning.

Questions

Is it really free?

Yes. You get the PDF right away, and I'll email you when new guides are out.

Do I need to pay for Fivetran or BigQuery?

Both have free tiers. Chapter 2 shows what it costs at small scale.

Do I need to know dbt?

No. Every model is in the guide, explained as it goes.

Get the free guide ↑