Research and reporting: inspect the work behind the summary
This collection brings together research deliverables and assessment work. It supports the main SEO studies without presenting every spreadsheet or review sheet as another client engagement. The emphasis is on how information is organized, what can be checked and what the data cannot establish.
Link prospecting
Scope: research deliverable within the Klimastål engagement. Anchor: link-prospecting.
The source export contains 2,011 unique domains with example URLs, discovery-source labels, website types and tool-provided scores. Rechecking the CSV confirms 1,740 competitor-only records, 255 keyword-only records and 16 assigned to both sources. The two supplied copies are identical and count as one database.
Actual prospect-export excerpt, reflowed. Domains redacted; rows are research prospects, not acquired links.
Open full sizeRead excerpt as text
Domain Source URL Type [Domain redacted] keywords,competitors wiki [Domain redacted] keywords general [Domain redacted] keywords general [Domain redacted] keywords general
Real export cells, reflowed; domains redacted. The table describes opportunities for review, not links acquired.
The distinction between discovery and qualification matters here. A competitor-derived domain can be irrelevant to the business; a high score does not establish an appropriate editorial opportunity. The database therefore supports a next-stage review rather than proving the quality of every row.
A useful extension would record topical relevance, country/language suitability, the specific opportunity, review decision and any eventual outreach or placement status. Those fields are a proposed operational improvement; they are not represented as already completed research. No contacted-publisher count, earned-link total or ranking gain is claimed.
Sales and inventory reporting
Scope: spreadsheet assessment. Anchor: sales-reporting-assessment.
The workbook combines weekly product-sales records, monthly reporting, promotion information and answers to business questions. It is shown as an analytical exercise, not a live client's financial performance.
Actual workbook cells, reflowed; assessment data, not client-performance evidence.
Open full sizeRead excerpt as text
Date Product Quantity Sold 2023-01-01 Classic Chicken Bone Broth 86 2023-01-01 Classic Beef Bone Broth 48 2023-01-01 Turmeric Ginger Bone Broth 65 2023-01-01 Mushroom Chicken Bone Broth 98
Actual values from the weekly reporting sheet, reflowed. Assessment data.
For this portfolio revision, I recalculated the January–June 2023 totals directly from the 104 dated product records in the weekly sheet. This is a new validation of the supplied workbook, not a newly delivered client result.
| Product | Units in the supplied January–June records |
|---|---|
| Classic Chicken Bone Broth | 700 |
| Turmeric Ginger Bone Broth | 698 |
| Classic Beef Bone Broth | 610 |
| Mushroom Chicken Bone Broth | 598 |
The calculation supports the ordering stated in the assessment answers. It does not establish profitability, demand outside the sample or an optimal reorder quantity. Those questions would require additional inputs such as margin, stock availability, lead time and service-level assumptions.
This is where I would strengthen the analysis: separate observed sales from hypotheses about why they occurred. Promotion timing and stockouts might explain a pattern, but they need to be tested against the appropriate records. An inventory recommendation should show its assumptions instead of presenting a single replenishment number without context.
Influencer research
Scope: assessment project. Anchor: influencer-research-assessment.
The creator-comparison workbook organizes platform, niche, audience and campaign-fit information. The excerpt deliberately excludes financial estimates and audience statistics and redacts creator names. Its purpose is to show the research structure rather than publish unverified claims about individuals.
Actual assessment cells, reflowed; creator names redacted. Audience and financial estimates are not republished.
Open full sizeRead excerpt as text
Name Platforms Used Content Niche Conversion Type [Name redacted] IG, TikTok, FB Beauty Direct Sales [Name redacted] TikTok, YouTube, X Tech Reviews Awareness [Name redacted] TikTok, IG, FB Fitness/Lifestyle Direct Sales
Actual selected assessment cells, reflowed. Names are redacted; the remaining entries are exercise inputs, not independently verified current profiles.
A useful selection framework asks what each creator contributes to the campaign objective. The best fit for awareness may differ from the best fit for a product demonstration. The next improvement would be a transparent scoring rubric: the criterion, the evidence behind it and the weight assigned. That would make disagreements about the shortlist reviewable. No real partnership, outreach or campaign outcome is claimed.
Popl on-page review
Scope: independent review exercise. Anchor: popl-on-page-review.
Original review-sheet excerpt. This is historical diagnostic opinion, not a claim of commissioned work or measured ranking impact.
The review considers how title and description copy describe the offering and its use cases. It proposes alternative wording, but the original document also contains assertions that need refinement. A more keyword-heavy title is not automatically a better title, and a generic character target alone does not prove a description needs changing.
In a follow-up I would compare the intended audience, actual page offer and search-query evidence before choosing a title. I would also replace the source’s “LSI keywords” wording with a plain requirement: cover the subject accurately and answer the reader’s relevant questions. This commentary is an editorial assessment of the sample, not a claim that Popl adopted the recommendations.
For work that connects research to a live website record, read the Klimastål case study. Return to Work.

