How To Embed Google Data Studio Reports in WordPress

How To Embed Google Data Studio Reports in WordPress

We use Google Data Studio to create dashboard reports for many of our clients. Our clients are similar to most other businesses in that they’re busy. We can’t send them a link to their reports in Data Studio one time and expect them to routinely visit it. That’s why we automate weekly emails (Monday mornings at 8:00 AM) containing a screenshot of their dashboard. This weekly email helps keep Zeffective at the top of their mind. Of course, it also makes it easy to view the KPIs associated with their online advertising campaigns on Google AdWords, Facebook Ads and the like. Dashboard reports aren’t optimized for viewing on mobile devices, though, which is why we embed each client’s Data Studio report on a password-protected page on Zeffective’s website. Here’s how to create such a page in WordPress:

  1. Open a report in Google Data Studio
  2. Click the share icon in the top right corner
  3. You have several options for sharing. For this tutorial, we’ll be embedding the report in a password-protected post in WordPress so you can choose “Anyone with the link” can view option. Or, choose one of the other share options.
  4. Click the embed icon in the top right corner
  5. Enable embedding
  6. Make sure “Embed code” is selected. If you want to embed the report via Google Sites, you’d select “Embed URL” instead.
  7. You can adjust the width and height. This is a waste of time until you actually see how it displays on your website. For now, leave it at the default dimensions and then you can tinker with the width and height settings as you see fit.
  8. Click COPY TO CLIPBOARD
  9. Navigate to your WordPress website and create a new post. Give it an apt name like “Client Name: Online Ads Dashboard”, for example.
  10. In the editor window, click the “Text” tab. Paste the embed code on your clipboard into the editor window.
  11. In the right sidebar, click to edit the Visibility settings. Select “Password protected” and add your password. Click OK. Click Publish.
  12. Preview the post to verify the password protection as well as how the report appears.
  13. If you want to adjust the width and height of the report for optimal viewing on your website, return to Google Data Studio and click the embed icon again. Change either the width or the height—when one changes, the other automatically changes to keep it in proportion. Then, simply copy the embed code and paste it over your old code in WordPress. Remember: in WordPress, change the editor from Visual to Text before pasting the embed code.
REMEMBER

Remember: in WordPress, change the editor from Visual to Text before pasting the embed code.

A Google Data Studio report embedded into a WordPress site.

Suscribe to our Blog

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *