Question

**Reporting Performance To Clients* What do you think "world-class" agency reporting should look like? Who here has a reporting system they're really proud of? This is a weak-link for us and we're looking to upgrade our process & system ASAP. We're either looking for a SAAS, or a killer google sheet equivalent. Thanks!  

Answer 1

Google datastudio with supermetrics no doubt!  

Answer 2

Google Data Studio, Use supermetrics as connector. That's what I'm currently exploring and looks the goods

Comments

This is the combo we use, seems to be the best solution so far, but unfortunately far from perfect. Main issues are performance when combining data on Data Studio (going via Google Sheets might solve this) and random connector crashes, which are always solved but cause problems when you need to have numbers now, not tomorrow. Still seems to be the best there is (without importing cost and other extra data to Google Analytics as well and then performing reports on that)

Answer 3

I worked with the #1 Facebook ad agency in Hollywood & we would simply create weekly reports of the top numbers they wanted and export from Facebook to a google sheet, and then have weekly & monthly reports all in 1 file for the clients.  

Answer 4

Now I use a dashboard that clients can log into anytime and see their stats in real time in laymens terms.  

Comments

What's the dashboard now?  

Answer 5

Wouldn’t it really depend what they they wanted and metrics they need to be able to make strategic decisions? One person’s world class could be another persons definition of garbage

Answer 6

amazing and simple. The 2 things I love
https://dashthis.com/

Answer 7

I've been loving databox. com

Comments

@inescutcheon DM'ing you

Answer 8

I think Google Sheets is world class. I focus my resources on keeping things as simple as possible like creating a report that's easy to read with their main KPIs only. I haven't had any pushback so far and our biggest client made $100m during 2019.  

Comments

@goebel agreed gsheets make life easy and free. Tried airtable but each client added the costs go up and up.  

Answer 9

Google data studio is about the best you can get before going enterprise, I can show you some of the stuff we for our agency do if you want to do a brief call, pm me. All the rest of the saas tools are to rigid for agency usage

Answer 10

We have been using Swydo for about a year. It’s very flexible and offers a lot of features. My only complaint is that it seems to break every few months requiring a week or more of support before it is fixed and works properly again. This is a big deal as I think as far as purpose built tools for, Swydo is among the best. but it needs to work flawlessly for the price.  

Answer 11

Coda dashboard custom built for each client. Includes embedded google data studio dashboard, timeline of every test ran with results, testing queue for new planned tests, creative ideation backlog (to post and prioritize new creative ideas). Weekly written reports log summarizing results / tests ran / next steps / etc. Everything linked to a shared slack channel where results summaries are posted and client can have any questions answered by the team. Happy to walk anyone through our setup if you’re interested.  

Comments

@rooks oh wow. That sounds awesome.  

---

@stegall548 happy to walk you through it. It’s been a game changer

---

@rooks would love a tour. I’ll send a dm tomorrow and tee up a time.  

---

@rooks/activity" class="qa-user-link">rooks hey @rooks/activity" class="qa-user-link">rooks sounds really impressive, wondering if we can talk about this too?  

---

@rooks dming

---

@lean73 sure thing, happy to chat. Just reach out.  

---

Likewise, really interested in this :) I will shoot you a pm!  

---

@rooks I really want to see this  

Answer 12

We use Data Studio + Supermetrics for dashboards, and a more curated google presentation for monthly / quarterly / specific campaign reports which gets sent as a PDF (usually for c-levels)

Answer 13

Best I've worked with was Rakuten Marketing (now part of Adobe) attribution (so attribution model was flexible per client) combined with raw data from various channels (incl Facebook ads, programmatic display, PPC etc) pulled together and visualised through Tableau. This was an in-house built system an independent agency I used to work at designed. Was seriously impressive.  

Answer 14

Google data studio for sure

Answer 15

I found a couple online recently Metricool, Oviond and Shoppr. ai

Answer 16

Custom google data studio + supermetrics

Answer 17

For a full service agency I like Tapclicks, some prebuilt templates, customization, ability to add multiple ad platforms. Support is pretty good. Can have dashboards and automation of reports.  

Answer 18

Google Data Studio works great for us. Completely customizable and programmable, etc. Love the cost too.  

Answer 19

We create reporting engines and data pipelines at siavak. com using Google Marketing and Cloud Platforms (Data Studio for reporting and data viz, G Sheet and BigQuery for data transformation, merging data sources etc. ) we’re also a Supermetrics channel partner. We don’t have bandwidth to do it for you at the moment, but I’d be happy to help you figure out the best option depending on your reporting requirements.  

Answer 20

I created some beautiful Google Data dashboards fed by Supermetrics. I've also used ReportGarden as well which is very simple and easy to use.