Help Center/Reports & marketplace imports
Match report rows to your links
How imported Amazon, eBay and Walmart rows attach to your links by product, how a link's earnings and conversions are dated, how several links for one product share them, and how to fill the gaps.
After a marketplace import, Pointerly attributes report rows to existing links when product identifiers match (Amazon ASIN, eBay item ID, Walmart SKU). Reconciliation closes the gap between “Amazon says we earned this” and “this Pointerly link shows the conversion.”
Outcome
Imported rows show With link where a matching link exists; remaining gaps are filled by creating links or running Sync link stats.
Before you start
- At least one successful marketplace import for the tag.
- Links created with the same affiliate tag (and matching product IDs) where possible.
- Permission to view tag reports; optional create-link permission for bulk create from ASINs.
Steps
1. Open the tag report
- Go to Dashboard → Affiliate Tags.
- Open the tag ⋯ → View reports (route:
/dashboard/reports/tag/{tagPublicId}). - Confirm the page title shows the tag name and tag value.
2. Filter to unmatched product rows
- Set the date range to the imported period.
- Optional: filter by a specific Import batch.
- Set Show to Without link to list commission rows that have a product ID but no Pointerly link.
- Use search (product or ASIN) and category filters to focus the list.
3. Create or attach links for gaps
- For Amazon rows, use Create link (or bulk create) from an ASIN on the report page when offered—Pointerly creates a link on that tag pointing at the product.
- For products you already promote, open Links, confirm the link uses this tag and the same ASIN / item ID / SKU.
- Prefer creating missing links from the report so attribution stays on the correct tag.
4. Sync link stats from reports
- Go to Dashboard → Settings → Reports.
- Under Link stats from reports, click Sync link stats.
- Sync runs in the background; watch notifications for completion.
- Reopen a link’s detail view and confirm conversions / earnings updated.
Matching rules (high level):
| Store | Match key |
|---|---|
| Amazon | ASIN |
| eBay | Item ID |
| Walmart | SKU / product id from Impact export |
5. Verify reconciled totals
- Return to the tag report.
- Set Show to With link and confirm important ASINs appear.
- Compare summary revenue / ad fees to the partner dashboard for the same period (allow for timezone and pending vs shipped differences).
- Optional: Export CSV or XLSX from the tag report for offline checks.
How imported earnings reach a link's stats
After an import (and after Sync link stats), each link's Earnings and Conversions on its detail page come from the dated rows of your Amazon reports:
- Earnings are counted on the day the item shipped (Fee Earnings, date shipped).
- Conversions are counted on the day the item was ordered (Fee Orders, order date).
So a link's Last 7 days or Last 30 days shows only what Amazon reported for those days, and All time shows the total. If you import the same month twice, Pointerly keeps one copy per day: totals don't double.
eBay and Walmart imports don't give links a per-day series yet: their totals show on the link under All time, not in shorter ranges.
Several links for the same product
You can keep more than one link for the same Amazon product and tag, for example one for a reel and one for your bio. Amazon reports commissions per product, not per link, so Pointerly splits that product's earnings and conversions between those links by their share of clicks (evenly when none has clicks). The link page shows Other links for this product and the share credited to this link. It's an estimate, not an Amazon figure.
Tips
- Import first, then sync—sync only uses data already imported for the team.
- Rows without a product ID cannot attach to a link; treat them as tag-level only.
- Period-aggregate Linked-Product imports may stamp a whole month on one date—use the Import filter and expect limited day-by-day charts for those batches.
- Exclude noisy categories (e.g. Unknown) from the report filters if they distort totals.
Troubleshooting
| Symptom | Likely cause | What to try |
|---|---|---|
| Everything shows Without link | Links on a different tag or missing ASINs | Create links on this tag or fix product URLs |
| Sync finished but link stats unchanged | No overlapping product IDs | Confirm ASIN/SKU on both link and report row |
| Totals disagree with Amazon | Pending orders, returns, or date filter | Align period; compare shipped vs ordered sheets |
| Duplicate revenue after re-import | Visual only—rows were skipped | Check toast for “duplicates skipped” |