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.
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.
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
-
Open Dashboard → Reports and click the Client reports tab.
-
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.
-
Fill in the Report title, Prepared for (the client or organization; it goes on the cover), Prepared by and the Reporting dates.
-
Optional: pick a Workbook color, and turn off Include metrics, daily activity and breakdown worksheets if you only want the data sections.
-
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.
- In Workbook sections, use Add a data source… to add a section. Reorder sections with the arrows, or Remove one.
- 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.
- Optional: Include supporting worksheets, with all their columns. These can include portfolio, rates or import records.
Preview and export
- Click Refresh preview to see the cover, the summary and each section as the client will read them.
- 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.