Open source alternative to Semrush and Ahrefs
TypeScript backlink-analysisgoogle-search-console-mcpkeyword-researchmcpseoseo-agentseo-auditseo-automationseo-skillsseo-toolssite-audit
import { Sparkles } from "lucide-react";
import { Badge } from "@/client/components/ui/badge";
import { exportRows } from "@/client/lib/exportRows";
import { captureClientEvent } from "@/client/lib/posthog";
import { formatLocationLabel } from "@/shared/keyword-locations";
import type {
RankTrackingDeviceResult,
RankTrackingRow,
} from "@/types/schemas/rank-tracking";
const FEATURE_SHORT_LABELS: Record<string, string> = {
featured_snippet: "FS",
people_also_ask: "PAA",
ai_overview: "AI",
local_pack: "Local",
knowledge_panel: "KP",
video: "Video",
images: "Img",
shopping: "Shop",
top_stories: "News",
};
const FEATURE_TOOLTIPS: Record<string, string> = {
featured_snippet:
"Featured Snippet — highlighted answer box at top of results",
people_also_ask: "People Also Ask — expandable related questions",
ai_overview: "AI Overview — AI-generated summary at top of search",
local_pack: "Local Pack — map with local business listings",
knowledge_panel: "Knowledge Panel — info box about an entity",
video: "Video — video results shown in the SERP",
images: "Images — image results shown in the SERP",
shopping: "Shopping — product listings with prices",
top_stories: "Top Stories — news articles carousel",
};
export function SerpFeatureTags({ features }: { features: string[] }) {
const notable = features.filter((f) => f in FEATURE_SHORT_LABELS);
if (notable.length === 0) return null;
return (
<div className="flex gap-1 flex-wrap">
{notable.map((f) => (
<Badge
key={f}
variant="secondary"
size="sm"
className="cursor-help"
title={FEATURE_TOOLTIPS[f] ?? f}
>
{f === "ai_overview" && <Sparkles />}
{FEATURE_SHORT_LABELS[f]}
</Badge>
))}
</div>
);
}
export function DeviceRankCell({
result,
}: {
result: RankTrackingDeviceResult;
}) {
const { position, previousPosition } = result;
// Nothing at all
if (position === null && previousPosition === null) {
return <span className="text-muted-foreground">-</span>;
}
// Was ranking, now lost
if (position === null && previousPosition !== null) {
return (
<span className="inline-flex items-center gap-1.5">
<span className="w-6 text-right font-mono text-xs text-muted-foreground">
{previousPosition}
</span>
<span className="text-muted-foreground/60">→</span>
<span className="font-mono rounded px-1.5 py-0.5 text-xs font-semibold bg-destructive/15 text-destructive">
lost
</span>
</span>
);
}
// First check — no previous data
if (previousPosition === null) {
return <span className="font-mono">{position}</span>;
}
// Both exist — show old → new with colored badge
const change = previousPosition - position!;
let badgeClass = "bg-muted text-foreground";
if (change > 0) badgeClass = "bg-success/20 text-success";
if (change < 0) badgeClass = "bg-warning/20 text-warning";
return (
<span className="inline-flex items-center gap-1.5">
<span className="w-6 text-right font-mono text-xs text-muted-foreground">
{previousPosition}
</span>
<span className="text-muted-foreground/60">→</span>
<span
className={`font-mono rounded px-1.5 py-0.5 text-xs font-semibold ${badgeClass}`}
>
{position}
</span>
</span>
);
}
export function DeviceUrlCell({
result,
domain,
}: {
result: RankTrackingDeviceResult;
domain: string;
}) {
if (!result.rankingUrl) {
return <span className="text-xs text-muted-foreground">-</span>;
}
return (
<a
href={toFullUrl(result.rankingUrl, domain)}
target="_blank"
rel="noopener noreferrer"
className="block truncate text-xs hover:underline"
title={result.rankingUrl}
>
{toPath(result.rankingUrl)}
</a>
);
}
const compactFormatter = new Intl.NumberFormat("en-US", {
notation: "compact",
maximumFractionDigits: 1,
});
export function VolumeCell({ value }: { value: number | null }) {
if (value == null) return <span className="text-muted-foreground">-</span>;
return (
<span className="font-mono text-sm">{compactFormatter.format(value)}</span>
);
}
export function CpcCell({ value }: { value: number | null }) {
if (value == null) return <span className="text-muted-foreground">-</span>;
return <span className="font-mono text-sm">${value.toFixed(2)}</span>;
}
/** Numeric change for CSV export — numbers bypass the CSV formula-injection sanitizer */
export function csvChange(
current: number | null,
previous: number | null,
): number | string {
if (previous === null) return current !== null ? "new" : "";
if (current === null) return "lost";
return previous - current;
}
function buildRankTrackingExport(
sorted: RankTrackingRow[],
showDesktop: boolean,
showMobile: boolean,
locationName?: string | null,
): { headers: string[]; rows: (string | number)[][] } {
const headers = [
"Keyword",
// Exports lack the table's tooltip, so name the city inline.
locationName
? `Local volume (${formatLocationLabel(locationName, 2)})`
: "Volume",
"KD",
"CPC",
...(showDesktop
? [
"Desktop Position",
"Desktop Change",
"Desktop URL",
"Desktop SERP Features",
]
: []),
...(showMobile
? [
"Mobile Position",
"Mobile Change",
"Mobile URL",
"Mobile SERP Features",
]
: []),
];
// Emit empty cells (not "Not ranking" strings) so Sheets infers a numeric
// column type and the user can sort by position.
const rows = sorted.map((row) => [
row.keyword,
row.searchVolume ?? "",
row.keywordDifficulty ?? "",
row.cpc ?? "",
...(showDesktop
? [
row.desktop.position ?? "",
csvChange(row.desktop.position, row.desktop.previousPosition),
row.desktop.rankingUrl ?? "",
row.desktop.serpFeatures.join(", "),
]
: []),
...(showMobile
? [
row.mobile.position ?? "",
csvChange(row.mobile.position, row.mobile.previousPosition),
row.mobile.rankingUrl ?? "",
row.mobile.serpFeatures.join(", "),
]
: []),
]);
return { headers, rows };
}
export function exportRankTracking(args: {
format: "csv" | "sheets";
rows: RankTrackingRow[];
showDesktop: boolean;
showMobile: boolean;
domain: string;
locationName?: string | null;
scope?: "selection";
}) {
const { format, scope } = args;
const { headers, rows } = buildRankTrackingExport(
args.rows,
args.showDesktop,
args.showMobile,
args.locationName,
);
// CSV file download keeps cents-formatted CPC for human readability;
// clipboard/Sheets export uses raw numbers (see buildRankTrackingExport).
const exportedRows =
format === "csv"
? rows.map((row) =>
row.map((cell, idx) =>
idx === 3 && typeof cell === "number" ? cell.toFixed(2) : cell,
),
)
: rows;
void exportRows({
format,
feature: "rank_tracking",
headers,
rows: exportedRows,
filename: `rank-tracking-${args.domain}${scope ? "-selected" : ""}`,
scope,
});
if (format === "csv" && rows.length > 0) {
captureClientEvent("rank_tracking:export_csv", scope ? { scope } : {});
}
}
function toPath(url: string): string {
try {
return new URL(url).pathname;
} catch {
return url;
}
}
function toFullUrl(url: string, domain: string): string {
if (url.startsWith("http")) return url;
return `https://${domain}${url}`;
}