Two Klaviyo accounts, three markets
The US sits in account X9FTJP. Germany and France share account
UY3ZYE. There is no separate account per market, so DE and FR are told apart by
campaign name rather than by login.
Revenue is reported in each market's own currency and never added together. A combined
figure across USD and EUR would not reconcile against anything in Klaviyo.
Campaigns must carry their market in the name
Reporting reads the market from the campaign name. Use US, DE or
FR as a separate word, as in DE_BLOW.DRY_Launch. Germany and France
are also recognised.
A campaign with no marker is left out rather than counted against the wrong market,
and appears in the _unresolved tab of the sheet. If a campaign is missing here,
that tab is the first place to look.
Promotional or educational is set by hand
Klaviyo has no field for this, so the split is kept in the
campaign_classification tab of the sheet. Add a row per campaign with either
Promotional or Educational. It can be changed at any time and the
dashboard picks it up on the next refresh.
Klaviyo and Google Analytics are not the same count
Almost every figure here is Klaviyo's. The exceptions are the two columns marked
Google Analytics on the campaigns table, which show how long people stayed on the
site and how many were new to it.
The two systems count differently. Google Analytics only sees someone who clicked
through to the site; Klaviyo also credits people who opened the email and bought later
without clicking. The columns sit side by side for convenience, but they answer different
questions and will never reconcile.
Where these numbers come from
An automation reads both Klaviyo accounts once a night and writes to a Google Sheet.
This page is rebuilt from that sheet, so it shows the position as of the last refresh
rather than live figures. The date at the top of the page is the one to trust.
If something looks wrong, check the refresh note at the foot of this page first. A
failed run leaves yesterday's numbers in place rather than emptying the page.