Forums Forums White Hat SEO PPC Can I get feedback on a PPC Data Studio Report template?

  • PPC

    Can I get feedback on a PPC Data Studio Report template?

    Posted by seohelper on March 3, 2020 at 5:52 pm

    Would anyone who uses Google Data Studio for either agency or freelance reporting like to give me some feedback on a template I built? I’ve developed a passion for data visualization and started creating some templates in Data Studio.

    I’d like to get some outside feedback.

    What do you guys think?

    PPC Report Template: https://drive.google.com/file/d/1eRdyUYubaHmx9-KEMdcHtP1BDOVqoobh/view?usp=sharing

    jarimbi2 replied 4 years ago 1 Member · 9 Replies
  • 9 Replies
  • aLeakyAbstraction

    Guest
    March 3, 2020 at 7:11 pm

    Says we need permission to view the report. Might want to change the sharing settings.

  • esheen

    Guest
    March 3, 2020 at 8:30 pm

    I’ll try and give some constructive feedback, although, I use Data Studio as an online dashboard tool only, not for PDFs – so I haven’t actually tried to pull off what you’re doing.

    I would consider how easy it is to read the data in print format. One of the great things about Data Studio is the sheer number of ways you can visualise the data. In PDFs I would say you need gridlines on graphs, clear axis and in some cases perhaps data labels for the important metrics.

    Everything seems very big on the pages, I would say you have plenty of room to shrink down some elements and get more data on your pages.

    How is this going to be digested? Are people really going to print this or is it for screens? If it’s the latter, opt for landscape orientation. You’ll have much more flexibility to get creative with your visualisations in landscape.

    Hope this was of some use!

    Here’s our latest template, hopefully some inspiration in here: [https://datastudio.google.com/u/0/reporting/1cL_ZQrN1iyTcUOqIs-9KdguUxanvv9Xh/page/4ppN/](https://datastudio.google.com/u/0/reporting/1cL_ZQrN1iyTcUOqIs-9KdguUxanvv9Xh/page/4ppN/)

  • Denver-PPC

    Guest
    March 3, 2020 at 9:10 pm

    Just my two cents here but it is a lot to digest. Of the 100 or so advertisers we work with, 0 will get passed your paid traffic overview. I think reporting has to fit your audience. So if this is intended to go to a digital marketing manager who wants to be in the weeds, so to speak, then this might work. Directors, VPs, and company owners are too busy to care about the specific ad group performance. Now, all that being said, I like it when the widgets show improvements with green and underperformance with red. Right now it’s just white. Some agencies might like that though because who likes to “highlight” bad things. Data points on graphs are helpful but sometimes can create a huge mess. It will take some refinement but I am sure you will get there. Best of luck!

  • smallbizppc

    Guest
    March 3, 2020 at 9:20 pm

    I appreciate the analysis and evidence in the report, but most clients wont read all of that – they’re only fussed about the improvements in:

    – conversions

    – clicks

    – spend / av. cost per conversion

    – impressions

    – av. cost per click

    – short summary of work completed in the month

    Speaking from experience here. It’s much easier to digest if it’s on a page or two.

  • scatteR634

    Guest
    March 3, 2020 at 10:29 pm

    I would simplify this report, there’s a lot of extra information and depending on the client, they won’t make use of it.

    Main thing I also see is that you’re not reporting on Cost Per Conversion, which is an extremely crucial metric to prove your value.

    I 2nd the other folks here saying they only use the dashboard for live reporting, as I do too.

    I have a 3 graphs with accompanied widgets that each go into these 3 categories 1. (Spend / CPM / Impressions), 2. (Clicks, CPC, CTR) and 3. (Conversions, Cost / Conversion, Conv Rate, and if ecomm Revenue / ROAS).

    Then below those graphs I have a table breaking down performance at a campaign level with all of the necessary metrics (some clients want to see certain metrics so it varies).

  • cool_cory

    Guest
    March 4, 2020 at 3:13 am

    Can you share this template for us to mess around with?

  • rhinestoneginez

    Guest
    March 4, 2020 at 5:25 am

    Great work! A couple suggestions:

    – I would use the new terminology, Google Ads, instead of AdWords. If you do want to keep it with AdWords, make sure to make the W uppercase on the front page.
    – I found your definition of clicks a little confusing. Maybe something more like, “the number of clicks on your ad leading to your website”. Also, your definition looks to be specifically for search ads, but AdWords supports display and YouTube as well.
    – The definition of conversion rate doesn’t look right. Yours looks more like the definition of a conversion, not the rate.
    – Typically I see marketers focus on cost, conversions, and cost per conversion. I don’t see rate used as much when only looking at a handful of metrics.
    – I don’t think your bounce rate definition is accurate. I think it’s if they immediately leave the page, not just access one page. A google search should confirm though.
    – I like the line charts you’ve included. An idea could be to use a pie chart to see how your top KPIs compare as a whole for the different campaigns. That way the reader can easily eyeball what campaign is spending/converting more.

    Solid job! I’m sure marketers will really enjoy it.

  • Viper2014

    Guest
    March 4, 2020 at 11:03 am

    It looks amazing. I don’t know how you did it but kudos.

  • jarimbi2

    Guest
    March 4, 2020 at 4:31 pm

    Can’t view the report. Did you remove the sharing?