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.

Selected prospect-export cells, with domain names redacted.Open full size

Read excerpt as text
DomainSourceURL Type
[Domain redacted]keywords,competitorswiki
[Domain redacted]keywordsgeneral
[Domain redacted]keywordsgeneral
[Domain redacted]keywordsgeneral

Actual prospect-export excerpt, reflowed. Domains redacted; rows are research prospects, not acquired links.

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.

First four sales records from the assessment workbook, with original headers.Open full size

Read excerpt as text
DateProductQuantity Sold
2023-01-01Classic Chicken Bone Broth86
2023-01-01Classic Beef Bone Broth48
2023-01-01Turmeric Ginger Bone Broth65
2023-01-01Mushroom Chicken Bone Broth98

Actual workbook cells, reflowed; assessment data, not client-performance evidence.

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.

Selected creator-assessment cells with names replaced by visible redaction labels.Open full size

Read excerpt as text
NamePlatforms UsedContent NicheConversion Type
[Name redacted]IG, TikTok, FBBeautyDirect Sales
[Name redacted]TikTok, YouTube, XTech ReviewsAwareness
[Name redacted]TikTok, IG, FBFitness/LifestyleDirect Sales

Actual assessment cells, reflowed; creator names redacted. Audience and financial estimates are not republished.

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 Popl title-tag review excerpt.Open full size

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.