getaero-io/gtm-eng-skills / skills/deepline-ads-audiences
deepline-ads-audiences
VerifiedUse this skill when building, enriching, auditing, or uploading B2B paid ads audiences to Google Customer Match, Meta/Facebook Custom Audiences, or LinkedIn Matched Audiences. Triggers on phrases like '/deepline-ads-audience', '/deepline-ads-audiences', 'upload this audience', 'create custom audiences', 'personal email hashes', 'increase Facebook match rate', 'Google ads audience', 'Meta audience', 'FB audience', or any workflow that turns CRM/customer/contact data into paid ads upload lists. Skip for outbound prospecting sequences, cold email, or pure campaign copywriting.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 37.6 KB |
| plays/audit-no-double-hash.play.ts | script | 3.1 KB |
| plays/build-contactout-hash-pool.play.ts | script | 9.7 KB |
| plays/build-hash-only-audience.play.ts | script | 7.0 KB |
| plays/enrich-audience-waterfall.play.ts | script | 16.7 KB |
| plays/evaluate-leadmagic-personal-email.play.ts | script | 3.7 KB |
| plays/evaluate-personal-email-provider.play.ts | script | 13.8 KB |
| plays/report-google-coverage-lift.play.ts | script | 8.6 KB |
| plays/shared/audience-hash.ts | script | 10.8 KB |
| plays/upload-facebook-google-hash-only-audience.play.ts | script | 5.4 KB |
| plays/upload-google-hash-only-audience.play.ts | script | 3.3 KB |
| recipes/enrich-and-upload-facebook-google.md | markdown | 6.9 KB |
| recipes/max-coverage-audience.md | markdown | 11.3 KB |
| recipes/sample-abm-segment-example.md | markdown | 4.9 KB |
| shared/audience-basics.md | markdown | 4.5 KB |
| shared/contactout-hash-pool.md | markdown | 7.9 KB |
| shared/meta-connection.md | markdown | 3.7 KB |
| shared/upload-failure-modes.md | markdown | 9.3 KB |
| skill-metadata.json | config | 3.3 KB |
plays/build-hash-only-audience.play.ts
View on GitHubimport deepline from 'deepline';
import {
auditHashRows,
emailHashes,
normalizeSha256,
phoneHashes,
} from './shared/audience-hash';
type AudienceInputRow = {
source_row?: string;
person_id?: string;
work_email?: string;
email?: string;
personal_email?: string;
personal_emails?: string;
email_sha256?: string;
personal_email_sha256?: string;
hashed_personal_email_sha256?: string;
personal_email_hashes_sha256?: string;
email_hashes_sha256?: string;
aviato_hash?: string;
limadata_hash?: string;
phone?: string;
mobile_phone?: string;
personal_phone?: string;
first_name?: string;
last_name?: string;
company?: string;
company_name?: string;
domain?: string;
company_domain?: string;
linkedin_url?: string;
person_linkedin_url?: string;
};
type HashOnlyRow = {
email_sha256: string;
source_row?: string;
provider_used: string;
identifier_type: 'work_email' | 'provider_hash' | 'personal_email';
};
/**
* Google hashes "+<digits>", Meta hashes "<digits>": the same phone needs a
* different digest per platform, so phone rows carry one column for each.
*/
type PhoneHashRow = {
phone_google_sha256: string;
phone_meta_sha256: string;
source_row?: string;
provider_used: string;
};
function firstHash(
row: AudienceInputRow,
): { hash: string; provider: string } | null {
const candidates: Array<[string, unknown]> = [
['email_sha256', row.email_sha256],
['personal_email_sha256', row.personal_email_sha256],
['hashed_personal_email_sha256', row.hashed_personal_email_sha256],
['aviato_hash', row.aviato_hash],
['limadata_hash', row.limadata_hash],
];
for (const [provider, value] of candidates) {
const hash = normalizeSha256(value);
if (hash) return { hash, provider };
}
return null;
}
function splitMultiValue(value: unknown): string[] {
if (Array.isArray(value)) return value.flatMap(splitMultiValue);
if (typeof value !== 'string') return [];
const trimmed = value.trim();
if (!trimmed) return [];
try {
const parsed = JSON.parse(trimmed) as unknown;
if (Array.isArray(parsed)) return parsed.flatMap(splitMultiValue);
} catch {
// Not JSON; fall through to delimiter split.
}
return trimmed
.split(/[;,|\n]/)
.map((item) => item.trim())
.filter(Boolean);
}
function allProviderHashes(row: AudienceInputRow): Array<{
hash: string;
provider: string;
}> {
const scalar = firstHash(row);
const output = scalar ? [scalar] : [];
const multiCandidates: Array<[string, unknown]> = [
['personal_email_hashes_sha256', row.personal_email_hashes_sha256],
['email_hashes_sha256', row.email_hashes_sha256],
];
for (const [provider, value] of multiCandidates) {
for (const item of splitMultiValue(value)) {
const hash = normalizeSha256(item);
if (hash) output.push({ hash, provider });
}
}
const seen = new Set<string>();
return output.filter(({ hash }) => {
if (seen.has(hash)) return false;
seen.add(hash);
return true;
});
}
/**
* Every hash a raw personal email needs: the Google canonical form (Gmail dots
* and +tags removed) plus the literal form when it differs, so one file matches
* on both Google and Meta.
*/
function personalEmailHashes(row: AudienceInputRow): string[] {
const output = [
row.personal_email,
...splitMultiValue(row.personal_emails),
].flatMap((value) => emailHashes(value));
return [...new Set(output)];
}
function phoneRows(row: AudienceInputRow, rowId: string): PhoneHashRow[] {
const candidates: Array<[string, unknown]> = [
['mobile_phone', row.mobile_phone],
['personal_phone', row.personal_phone],
['phone', row.phone],
];
const output: PhoneHashRow[] = [];
for (const [provider, value] of candidates) {
const hashes = phoneHashes(value);
if (!hashes) continue;
output.push({
phone_google_sha256: hashes.google,
phone_meta_sha256: hashes.meta,
source_row: rowId,
provider_used: provider,
});
}
return output;
}
function sourceRow(row: AudienceInputRow, index: number): string {
return String(row.source_row || row.person_id || index);
}
function dedupe(rows: HashOnlyRow[]): HashOnlyRow[] {
const seen = new Set<string>();
const output: HashOnlyRow[] = [];
for (const row of rows) {
if (seen.has(row.email_sha256)) continue;
seen.add(row.email_sha256);
output.push(row);
}
return output;
}
export const config = {
name: 'ads-audience-build-hash-only',
description:
'Build a validated hash-only paid-ads upload file from contact rows, normalizing and hashing identifiers exactly once.',
};
export default async function (input: { file: string }) {
const dataset = await deepline.csv<AudienceInputRow>(input.file);
const rows = await dataset.materialize();
const baseline: HashOnlyRow[] = [];
const enriched: HashOnlyRow[] = [];
const phones: PhoneHashRow[] = [];
rows.forEach((row, index) => {
const rowId = sourceRow(row, index);
for (const hash of emailHashes(row.work_email || row.email)) {
baseline.push({
email_sha256: hash,
source_row: rowId,
provider_used: 'work_email',
identifier_type: 'work_email',
});
enriched.push({
email_sha256: hash,
source_row: rowId,
provider_used: 'work_email',
identifier_type: 'work_email',
});
}
phones.push(...phoneRows(row, rowId));
for (const providerHash of allProviderHashes(row)) {
enriched.push({
email_sha256: providerHash.hash,
source_row: rowId,
provider_used: providerHash.provider,
identifier_type: 'provider_hash',
});
}
for (const hash of personalEmailHashes(row)) {
enriched.push({
email_sha256: hash,
source_row: rowId,
provider_used: 'personal_email',
identifier_type: 'personal_email',
});
}
});
const baselineRows = dedupe(baseline);
const enrichedRows = dedupe(enriched);
const baselineAudit = auditHashRows(baselineRows);
const enrichedAudit = auditHashRows(enrichedRows);
const baselineDataset = await deepline
.dataset('baseline_hash_only_audience', baselineRows)
.run({ description: 'Baseline work-email hash-only audience rows.' });
const enrichedDataset = await deepline
.dataset('enriched_hash_only_audience', enrichedRows)
.run({ description: 'Enriched hash-only audience rows.' });
const seenPhones = new Set<string>();
const phoneRowsDeduped = phones.filter((row) => {
if (seenPhones.has(row.phone_google_sha256)) return false;
seenPhones.add(row.phone_google_sha256);
return true;
});
const phoneDataset = await deepline
.dataset('phone_hash_rows', phoneRowsDeduped)
.run({
description:
'Phone digests, one column per platform (Google: +digits, Meta: digits).',
});
return {
baseline_rows: baselineDataset,
enriched_rows: enrichedDataset,
phone_rows: phoneDataset,
phone_hashes: phoneRowsDeduped.length,
baseline_audit: baselineAudit,
enriched_audit: enrichedAudit,
unique_hash_lift: enrichedAudit.outputRows - baselineAudit.outputRows,
};
}
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |