Ad and store results on one dashboard
Connect ads and stores, and ROAS fills one dashboard daily
A direct-to-consumer commerce brand running three ad platforms, its own online store and influencer collaborations set up a flow so that campaign and influencer ROAS is on one dashboard every morning, without a marketer logging into each channel and lining up numbers in Excel.
The problem
- 01
A weekly tour of every channel
A marketer logged into the Meta, Google and Naver ad managers and the store admin one by one, downloading numbers and pasting them into Excel for half a day.
- 02
Influencer results kept apart
Post links and sales codes were scattered across chat and sheets, so collaborations could not be measured the same way as ads.
- 03
Numbers a week late
Numbers lined up only once a week in Excel, so budget moved off a weak campaign a week later than it could have.
How Trackit solves it
- 1
Set the channels and the time once
The marketer sets a recurring schedule trigger for 7 a.m. daily and puts the Meta, Google and Naver ad and store order API addresses and keys into one HTTP request block each. Each influencer collaboration gets a channel performance record with its sales code and fee. That is all a person does.
- 2
The workflow pulls the numbers and calculates them one way
At that time each day, HTTP request blocks pull this month’s numbers from each channel, and a parse JSON block takes cost, clicks, conversions, revenue and order totals per sales code out of the responses. A formula block divides revenue by cost to get ROAS the same way for ad campaigns and influencers alike.
- 3
Numbers fill the records, and comparing happens on the dashboard
A create-or-update-record block finds each channel performance record by campaign ID or sales code and changes its numbers, creating a new record for a campaign it has not seen. The dashboard reads these records and shows ROAS by campaign and influencer, and cost and revenue by channel, on one screen. The marketer only has to open it in the morning.
- TriggerRecurring scheduleStarts every day at 7 a.m.
- ActionHTTP requestPulls numbers from ad and store APIs.
- ActionParse JSONTakes out cost, revenue and sales codes.
- ActionFormulaDivides revenue by cost to get ROAS.
- ResultCreate or update recordFills the numbers on channel performance records.
What changed
Before Trackit
With Trackit
More use cases
Consulting sales teamMeeting notes from recordings
Meeting recordings become text, and an agent leaves a summary and next steps.
B2B SaaSRouting leads to owners by score
An agent scores leads from web forms and the meeting scheduler, then hands each to an owner on the matching team with a call request or a first email.
B2B sales team that meets customers in personContacts from business card photos
Reads name, company, title and contact details from a card photo, registers the company and contact, and logs the meeting and follow-up.