How to Add a Client Report in Clientish (Google Sheets, Looker Studio, Google Analytics or Any Link)

5 min read

Paste a share link, pick the client, and set up Google Sheets, Looker Studio and Google Analytics reports the way each one works best.

In Clientish, you add a report by pasting its share link, naming it and choosing which client sees it. The link is checked as you paste it, so you know before saving whether it will open inside the portal or in a new tab.

Applies to: every plan (Solo, Starter, Growth, Pro and Enterprise)
Who can do it: team members whose role has the Edit Clients permission

Before You Begin

  • In the tool the report comes from, set sharing so anyone with the link can view it. A private link shows the client a sign-in page instead of the report.
  • The link must start with https:// and be reachable from the internet.

How to Add a Report for One Client

  1. Open Client reports

    Go to Settings → Client reports (under Communication) and click Add report. From a client’s own page, the Reports panel offers the same button with that client already chosen. On an order page, + Add → Report opens it for that order.

  2. Pick the source and paste the link

    Under From, click the tool the report comes from, or Any link, and paste the share link into Link. A pasted link from a known tool selects it automatically. A green line says the report can be shown inside the portal; a yellow one says it will open in a new tab.

    Add a report form with a Looker Studio embed link under Any link, the check that it can be shown inside the portal, the name, Who sees it and Tell the client
  3. Name it

    Type the Name the client sees, up to 80 characters, and pick an Icon for the client’s list.

  4. Choose who sees it

    Under Who sees it, pick One client and choose the client, or All my clients, or Clients with an order for… and pick the services. With One client, the optional Order field ties the report to one of that client’s orders; leave it on All orders to keep it for the client as a whole.

  5. Tell the client and save

    Leave Tell the client checked to send a “New report” notification in the portal and an email, then click Add report.

How to Share a Google Sheet as a Client Report

  1. Share the sheet

    In Google Sheets, click Share, set General access to “Anyone with the link”, and copy the link.

  2. Add it in Clientish

    Click Add report, choose Google Sheets and paste the link. The client sees a read-only preview of the sheet inside the portal, so nobody can edit it from there.

How to Share a Looker Studio Report With a Client

  1. Make the report viewable by link

    In Looker Studio, open the report, click Share, set Link settings to Unlisted and click Save. Under Resource → Manage added data sources, set each data source’s credentials to Owner’s, so clients don’t need a Google account with access to your data.

  2. Turn on embedding

    Open File → Embed report and turn on Enable embedding. Without it, the report can only open in a new tab.

  3. Add it as a Looker Studio report

    In Clientish, click Add report, choose Looker Studio under From and paste the report link. A normal /reporting/ link is turned into the /embed/reporting/ address for you, and the report opens inside the portal.

How to Add a Google Analytics Report for a Client

Copy the report address from Google Analytics and add it with Google Analytics as the source; the client opens it in a new tab.

  1. Copy the report address

    In Google Analytics, open the report for the client’s website and copy the address from the address bar.

  2. Add it as a Google Analytics report

    In Clientish, click Add report, choose Google Analytics under From and paste the address. A yellow line says the report opens in a new tab, and Open in a new tab instead of inside the portal is checked for you.

    Add a report form with Google Analytics chosen, a Google Analytics report link and a yellow note that the report opens in a new tab
  3. Make sure the client has access

    The client must be signed in to a Google account that can see that Google Analytics property. If they don’t own it, add their Google account in Google Analytics under Admin → Property access management.

How to Add One Report for Several Clients

Click Add for several clients on the Client reports page. Give the report one name, choose all your active clients or the clients of chosen services, then paste each client’s own link on the next step. Clients left without a link are skipped, and up to 200 can be added at once.

How to Edit, Hide or Remove a Client Report

Open the menu at the end of a report’s row in Client reports:

  • Edit changes the link, name, icon or who sees it.
  • Hide from client takes it out of the portal for now; Show to client brings it back.
  • Move up and Move down set the order clients see.
  • Delete removes it from the portal. The report itself stays in the tool it came from. Deleting an order also deletes the reports added on it.

Adding a Report: Common Problems

The link is refused⌄
It must be an https link to a public website. Links to a local address or with a password in them can’t be used.
It says the report opens in a new tab⌄
That site blocks being shown inside other sites. Look for the tool’s embed or publish link; if there is none, the client opens it in a new tab.
The client sees a sign-in page⌄
The report is still private in its own tool. Change its sharing to anyone with the link, then ask the client to open it again.
A Google Analytics report says the client has no access⌄
Google Analytics reports have no public link. Give the client’s Google account access to the property in Google Analytics, or share a Looker Studio report built on the same data.

Related