FW PublishingClient reporting

Every Monday · about 3 minutes

Weekly Sprout Social export

One person downloads Sprout Social's Post Performance report each Monday and emails it in. That file is how social results get into client reports at reporting.fwpops.com.

sprout@in.fwpops.com Accepts the CSV from approved senders only.

Check your file before sending

Drop the CSV here and it's checked against what the importer expects: the right report, the right columns, the right dates, every profile, untouched by Excel. The file stays on your computer; nothing is uploaded.

Why this matters

Our Sprout plan has no API and can't schedule exports, so a person has to send the file. Once it arrives it's read automatically, and any client report that covers those dates picks up the posts on our profiles that featured the client.

We export the Last 28 Days every week, not just the last 7. Posts keep collecting reach and clicks for weeks after they go up, so each export refreshes recent posts with their newer numbers. Overlap is expected; the newest file wins.

Before you start (one time)

Every Monday: the steps

  1. Open the report. Use your bookmark, or in Sprout click Reports in the left rail, then Post Performance under Cross-Network. The page title reads "Post Performance" and the table header says "Published Posts".
  2. Check the profiles. In the filter bar under the title, Sources should show every network icon (X, Facebook, Instagram, LinkedIn and the rest). If someone narrowed it, click Clear All at the right end of the filter bar.
  3. Set the dates to Last 28 Days. Click the date button at the top right (it shows a range like 10/2/2026 – 10/29/2026).
    • Pick Last 28 Days from the presets (the list is Last 7 Days, Last Week, Last 28 Days, Last Month). There is no "Last 30 days".
    • The range ends yesterday. The button should now show it, and the post count above the table should change.
  4. Wait for the table to finish loading. The summary row (post count and totals) updates when it's done.
  5. Download the CSV. Click the Share button (the square with an arrow, next to the star at the top right), then Download CSV.
    • Not Download PDF, and not Send PDF.
    • A box titled Export Published Post Data opens. In the profile list, make sure every profile is ticked. The festival profiles (Music City Food & Wine, Crafty Bastards and the rest) and YouTube can start unticked.
    • Leave All Metrics selected, then click Export CSV.
    • The file lands in your Downloads folder, named like Post Performance (Nashville Scene) October 2, 2026 - October 29, 2026.csv. Keep that name; the date range in it is read automatically.
  6. Email it. In a new email to sprout@in.fwpops.com:
    • Subject: Sprout export – week of <Monday's date>, e.g. Sprout export – week of Oct 26, 2026
    • Attach the CSV exactly as downloaded. Don't rename, open or edit it. Excel can quietly change dates and numbers if you save it.
    • The body can be empty. Send.

That's it. The file is picked up automatically.

More than one Sprout group? The report covers one Sprout group at a time (the name shows in the file name, e.g. (Nashville Scene)). If the Nashville Post, Nfocus or Williamson Scene profiles live in another group, switch to that group and repeat steps 1–6: one email per group.

Did it work?

Every file is checked before anything is imported. If it passes, there's no email: it's in. If it fails (wrong report, Excel damage, missing metrics, no attachment), nothing is imported and the reporting team gets an email saying what's wrong. Client reports keep using the last good data until a fixed file arrives.

What you seeWhyWhat to do
Email bounces backAddress mistypedCheck it's exactly sprout@in.fwpops.com and resend
The team got a “Sprout import failed” emailThe file didn't pass the checksRead the reason in the email, export again from Sprout, check it above, resend
No bounce, but Mike says nothing arrivedYour address isn't on the allowed list yetAsk Mike to add your work address, then resend
Sprout shows far fewer posts than usualA filter is narrowing it (one profile, one post type)Click Clear All in the filter bar, re-set the dates, download again
Download CSV is greyed out or missingTable still loading, or your login lacks report accessWait for the totals row; if it stays missing, ask a Sprout admin for Reports access
File is over 25 MBRange far longer than 28 daysRe-export just the Last 28 Days
You missed a MondayIt happensSend it whenever you're back; the 28-day window covers the gap, up to 3 missed weeks

Don'ts

Quick reference

StepDo this
1Sprout → Reports → Post Performance
2Sources = all profiles (Clear All if not)
3Dates = Last 28 Days
4Wait for the totals row to load
5Share → Download CSV → tick every profile, All Metrics → Export CSV
6Optional: drop it in Check your file above
7Email the CSV, unedited, to sprout@in.fwpops.com, subject Sprout export – week of <date>

When: every Monday morning. Time: about 3 minutes.