Why openreport exists.

I build the systems that pull marketing data out of Google Ads, Meta, Instagram and TikTok, store it in a warehouse like Snowflake, BigQuery, Azure SQL or Redshift, and turn it into dashboards in Power BI or Looker. I do this for small and medium businesses.

That work has three costs. The setup takes time to build and maintain. The warehouse takes money every month, even when storage is cheap. The dashboard takes design judgment, which is the rarest of the three.

Big agencies absorb all three. Small and medium ones usually cannot. They reach for tools like Fivetran or Supermetrics to pull the data, and a dashboard tool that bills monthly on top. Sometimes the in-house team just logs into each ad platform, copies the numbers by hand, and pastes them into a PDF or a slide deck. Even when there is a dashboard, most of my clients still export it to PDF or PPT and send it on to their own clients.

AI has collapsed the hardest part of this work. Pulling clean, comparable numbers out of an ad platform used to take a week of engineering. Today it takes minutes.

openreport is for those small and medium businesses. There is no BI tool to set up, no connector to integrate, no SaaS subscription. Paste your Meta access token. The dashboard renders in your browser, fetched directly from Meta. Add your agency logo. Generate an AI summary with the model of your choice. Export the whole thing as a single self-contained HTML file and send it to your client.

The metric set, the verdict bands, and the threshold defaults all come from years of working with real digital marketing clients on real ad accounts. Calibrated, not invented.