Write a short paragraph on what this article is about. If applicable, what's the opinion or point we want to make in this article?
How to create a Google Ads report in PostHog using the data warehouse. Get data from Google Ads manager, get it into the data warehouse in PostHog, and write insights that query it.
Where will it be published?
select any that apply
[ ] Blog
[ ] Founders Hub
[ ] Newsletter
[ ] Product engineers Hub
[x] Tutorials
[ ] Other (please specify)
Why type of article is this?
select any that apply
[ ] High intent (i.e. comparisons and similar)
[ ] Brand / opinionated (how we work and why, etc.)
We haven’t set up an managed source yet, so we need to manage ourself. This does require manual upload, but you could set up an ETL tool to do this for you.
We’ll use S3 but R2, Google Cloud Storage, and Snowflake would all work too.
Summary
How to create a Google Ads report in PostHog using the data warehouse. Get data from Google Ads manager, get it into the data warehouse in PostHog, and write insights that query it.
Where will it be published?
Why type of article is this?
Who is the primary audience?
What (if any) keywords are we targeting?
Google ads report
Headline options
How to set up a Google Ads report
Will it need custom art?
Outline (optional)