HighTechDerma — marketing & commercial

—: — spent on sponsored ads for — clicks · — field visits and — orders · — distributor orders worth —.

Sponsoring

—. Campaigns count in the month they start. Amounts are in $, as entered in the sheet. CPC = spend ÷ clicks; CTR = clicks ÷ impressions.

Budget spent—
Impressions—
Clicks—
CPC—
CTR—
Campaigns—

By platform

Spend, impressions, clicks and cost per click per platform, for the period.

PlatformCampaignsSpend ImpressionsClicksCPCCTR

Campaigns

Every campaign in the period and platform picked. Click a header to sort.

CampaignPlatformStartEnd SpendImpr.Clicks CPCCTRStatus

UGC creators

The UGC sheet has no dates yet, so these figures are the current roster and do not change with the period. Spend is the sum of negotiated budgets (MAD).

Active creators—
Active accounts—
Instagram / TikTok— / —
UGC spend (negotiated)—
Prospects (no status)—

Active creators

Accounts marked “Actif” in the sheet.

CreatorPlatform Negotiated (MAD)Last contactLink

Daily reports — field visits

—. From the visit forms the sales reps fill in (Visites terrain – Dermocare). Outstanding = sales − collected.

Visits—
Orders—
Sales—
Collected—
Outstanding—
Visit → order—

Visits per day

Each bar is a day's visits; the darker part is visits that ended in an order.

VisitsOrders

Daily report summary

One row per day and sales rep.

DateSales repCities VisitsNew prospectsOrders SalesCollectedTo follow up Manager absentNot interested

Visit details

Every visit in the period, with its result.

DateSales repClientTypeCity ResultAmountCollectedPotentialObjections

Distributor orders & payment status

—. Totals are HT (MAD). An order with no payment status in the sheet counts as unpaid / not recorded.

Orders—
Total HT—
Paid—
Partial—
Unpaid / not recorded—
Paid share—

Orders by month and payment status

All months; the period picked is highlighted.

PaidPartialUnpaid / not recorded

By distributor

What each distributor ordered in the period and what is still open.

DistributorOrdersTotal HT PaidPartialUnpaidStatusLast order