Export review and campaign data
How do I export review and campaign data?
Synup provides CSV downloads for the all-locations Reputation table, review-request responses and delivery errors. Set the period, search and filters before exporting so the file matches the data you are reviewing. The Reviews screens do not produce a PDF; use the CSV in your own reporting template when you need a client-ready document. Sydekick can also build a separate PDF and spreadsheet report, described at the end.
Key facts
| Export | Where it lives | File | Scope |
|---|---|---|---|
| Reputation table | Reviews → All locations → Reviews Overview → Export | reviews-rollup.csv | Every location that matches the current search and filters, not only the visible page. The same 18 columns every time |
| Review-request responses | Review Invite → Responses → ⋮ Settings → Download Report | review-responses-YYYY-MM-DD.csv | Responses that match the table's filters, for the locations you can see. Capped at about 1,000 of the newest rows |
| Delivery errors | Review Invite → ⋮ Settings → Delivery Errors → Export CSV | delivery-errors.csv | Every matching row, not only the visible page |
None of the three is emailed or queued. The file downloads straight to your device, and nothing is changed in Synup.
Why this matters
Each export answers a different question. The Reputation CSV compares locations, the responses CSV contains feedback collected through review-request campaigns, and the delivery-errors CSV identifies sends that failed, bounced or reached an unsubscribed recipient.
Export the all-locations Reputation table
- Choose a client and set the location picker to All locations.
- Open Reviews, then Reviews Overview, which is headed Reputation.
- Set the period, then apply the location search and any attention, rating, health or minimum-review filters you need.
- Select Export. Synup downloads
reviews-rollup.csv.
The file always has the same 18 columns: Location, City, Rating, Reviews, %5star, %<=2star, Net sentiment, Positive, Negative, ResponseRate%, Unreplied, OldestUnrepliedDays, DaysSinceNegative, Volume/wk, Health, HealthDelta, %OfBook and LastReview. It does not follow the Columns picker, so a column you added or removed on screen makes no difference to the file, and the change figures use the period you selected. It reflects what is recorded and visible at the moment you click, and does not trigger a refresh of the reviews. See comparing locations for what each column means.
Export review-request responses
- Open Review Invite and select Responses.
- Set the response filters (date, rating, search) before downloading.
- Open the three-dot Settings menu at the top right and select Download Report.
- Synup downloads a dated
review-responses-YYYY-MM-DD.csvwith the columns Date, Name, Email, Phone, Location, Campaign, Channel, Rating and Feedback. It applies the same filters as the table and covers only the locations you can see. If the export reaches its safety cap of about 1,000 responses, Synup warns that the oldest responses are not included, so narrow the date range and export in parts.
Download Report appears only on the Responses tab.
Export delivery errors
- Open Review Invite, then open the three-dot Settings menu.
- Select Delivery Errors. The panel is headed Review campaigns / Delivery errors, with All, Failed, Bounced and Unsubscribed tabs and a search for name, email or phone.
- Set the status or search filters you need.
- Select Export CSV. Synup downloads
delivery-errors.csvwith the columns Campaign, Name, Email, Phone, Status, Reason and Time, for every matching row, not only the visible page.
What is not exportable
Review Analytics, Competitors, Topic Trends and the Review Inbox have no export. Take their figures into your own template or screenshots. The QR code for a review link is downloaded from the QR dialog; see share a review link and QR code.
A PDF or spreadsheet report from Sydekick
If you want a client-ready document rather than a CSV, Sydekick has a Reputation Performance Report. It covers every location for a client, uses Google star ratings for the current calendar year with a fixed list of competitors, and produces a branded PDF and an Excel spreadsheet, stored in Assets with a message that links to both. It is separate from the CSV files above, so it will not match them column for column. See the Reputation Performance Report.
What you'll see when it's done
- A CSV file in the browser's download location
- Portfolio metrics in
reviews-rollup.csv - Response or delivery details in the corresponding campaign export
Watch out for
- Check the scope before you export. The file reflects the client, location, period and filters you set, so an unexpectedly small report usually means the view was narrowed first.
- A spreadsheet can read text as a formula. The Reputation file does not neutralise cells that begin with =, +, - or @, so open files from untrusted sources with care.
- An export with no matching data. Export stays unavailable on the Reputation table when it has no rows, and Delivery Errors reports that there is nothing to export when its filtered result is empty.
- No PDF. There is no PDF export on the Reviews or Review Invite screens.
Questions people ask
How will I know the export is done?
The browser downloads the CSV. Synup does not queue these exports for email delivery.
Why does the responses file stop at about 1,000 rows?
That is the safety cap on the Download Report. Narrow the date range or filters and download again; the warning tells you when older rows were left out.
Review Invite shows a plan message instead of Responses. Why?
Review Invite is part of review requests, which are a paid feature and are not available during the free trial. The screens and exports above need it.