Because each system counts a different thing and none of them knows about the others. Below are four situations that come up at the first meeting, once we put your reports side by side.
The sum of revenue from the ad platforms is often higher than the store's revenue. Not because anyone is lying, but because each platform counts in its own way and knows nothing about the rest.
A campaign looks profitable until returns are subtracted. In some categories that is the difference between profit and loss, and it only shows up a few weeks later, once the returns are back in the warehouse.
The margin is in the ERP or a spreadsheet, the campaign result is in the ad platform. Putting the two together is done by hand once a quarter, which is why decisions get made without it.
Every month someone gathers numbers from several systems into a spreadsheet and loses working days on it. The work is repetitive, so it can be automated, and yet it keeps coming back.
We do not start with the database but with an audit of the sources: we check whether the data you want to join can be joined at all. Then come building the warehouse, the reports and the maintenance that keeps them refreshing on their own.
2-3 weeks
What you have in which system, at what quality and with what delay. This is also where we agree the definition of an order and of margin, because without it the rest makes no sense.
4-6 weeks
A cloud account in your company's name, automatic data pulls from the sources, models joining sales with costs and returns. We pull ads and sales data with full history, while Analytics data starts from the day we connect the export, because Google does not hand over its history.
2-4 weeks
The main report plus views per channel. On top of that, team training, because a report nobody can read changes no decision.
ongoing
Sources change, APIs stop working, new channels arrive. Maintenance is mainly making sure the data keeps flowing and adding further views.
An e-commerce data warehouse starts to pay for itself when the first report contradicts a number from the ad platform, and that can be a few months after the contract is signed. Until then all you have to go on is what others say about JustIdea. Below are three profiles where clients write about us.
weighted average of 224 reviews across three platforms. Clients gave them, and each site below links to the profile with the full text of every review.
Read the reviewsA warehouse is worth as much as the data flowing into it, and most of your ad spend and part of your sales run through these three systems.
Google Ads and Analytics are the biggest sources of cost and traffic data in most warehouses. The status confirms we run Google campaigns every day, so when the panel and the warehouse disagree, we can explain it, not just show it.
Meta data is the most troublesome source in the whole warehouse: campaign results keep changing retroactively for several days after the event. We run Meta campaigns every day, so we know when a number in the warehouse has actually settled.
Marketplace sales most often stay outside the profit account, because the data sits in a separate panel. We pull it into the same warehouse as your own store, so you see margin from Allegro and from the store in one report.
Implementation starts from €1,230 net, and maintenance is a monthly subscription we quote together with it. Further sources, and data that first needs to be put in order, we quote after the audit. You pay the cloud cost separately and directly to Google, and how much depends on your data volume and query load.
What you have, at what quality and whether it can be joined into one profit account.
A warehouse in your BigQuery account, automatic data pulls and the main report, which is Profit Analytics.
Keeping the data flowing, fixes after API changes and adding new views.
The call is led by a new business specialist. When we get into the details of an account, the specialist for that channel joins in. We reply within one business day.
Before the meeting we review your website, your visibility and what your campaigns show from the outside. We will not open with “so, what does your company do?”.
The reply comes from the same new business specialist who will run the call. No qualification form and no call from an unknown number.
We go through your numbers and your questions. If it turns out we are not the right fit, we will tell you straight away.
