Reports & marketplace importsBuild a client report

Help Center/Reports & marketplace imports

Build a client report

Create a styled Excel workbook for a brand, agency or creator from your Pointerly data: pick a template, choose sections and columns, write the narrative, preview and export.

draft

A client report is an Excel workbook you send to a brand, an agency or a creator: a cover, a performance summary, audience breakdowns and the data sections you choose, with your own commentary. You build it in Dashboard → Reports → Client reports. Client reports come with the Extended reports add-on.

Image placeholder — add `images/client-reports-cover.webp` under this category
Client report builder with Report details, Workbook sections and the Workbook preview

Before you start

  • The Extended reports add-on must be active on the workspace. Without it, the Client reports tab shows an Unlock button for billing managers.
  • Exporting needs the Export permission on your role.
  • The workbook only includes data your role can see.

Build the workbook

  1. Open Dashboard → Reports and click the Client reports tab.

  2. Under Report details, pick a Template:

    • Monthly performance: traffic by day, country and device, plus link results for the period.
    • Creator portfolio: media kit, link performance and traffic, which is what a brand asks for first.
    • Media kit: profile, social audience, stated rates and portfolio only. No traffic data.
    • Campaign wrap-up: delivered content, collaboration status and the traffic it produced.
    • Brand results: link performance, audience and delivered content.
    • Agency review: campaigns, collaboration pipeline and delivery status.

    The templates you get depend on whether the workspace is a creator or a brand workspace. Choosing a template resets the title, sections and filters; client, author, dates and narrative stay.

  3. Fill in the Report title, Prepared for (the client or organization; it goes on the cover), Prepared by and the Reporting dates.

  4. Optional: pick a Workbook color, and turn off Include metrics, daily activity and breakdown worksheets if you only want the data sections.

  5. Under Your narrative, write the Executive summary and the Next steps for the client.

Choose the sections

Each section of the workbook reads one report from your catalog.

  1. In Workbook sections, use Add a data source… to add a section. Reorder sections with the arrows, or Remove one.
  2. For each section, set:
    • Section title,
    • Filter conditions, written like the conditions in Advanced syntax. Leave it empty for all the records you can see,
    • Section commentary, a note shown with the section,
    • Choose and order columns: which columns appear, in which order.
  3. Optional: Include supporting worksheets, with all their columns. These can include portfolio, rates or import records.

Preview and export

  1. Click Refresh preview to see the cover, the summary and each section as the client will read them.
  2. Click Export client Excel.

If something required is missing (title, Prepared for, Prepared by, dates, or at least one data source), the export doesn't run: the page lists what's missing and moves you to the first empty field. The export always fetches fresh data, so an older preview doesn't block it.

Save a client template

Under Saved client templates, type a Template name (for example Client · monthly results) and click Save template. It keeps the template, sections, columns and filters so next month's report takes a minute.

Saved client templates are stored in this browser, up to 20. They don't follow you to another device and teammates don't see them.

Troubleshooting

  • The Client reports tab shows Unlock: the workspace doesn't have Extended reports. Ask a billing manager to enable it.
  • Export client Excel does nothing: read the line under the header; it names the missing field.
  • A section is empty: its filter conditions match nothing in the reporting dates, or your role can't see that report.
  • My saved templates are gone: they live in one browser. Clearing site data or switching browsers loses them.