How to Optimize Advertising Without Implementing CRM

[ashammi228]

Content
Why do we need end-to-end analytics and what tools does it include?
What to do for a micro-business that can't afford a CRM
How We Linked CoMagic and Google Spreadsheets
Setting up order data transfer from CoMagic to Google Speadsheets
Transferring the "sale" tag from Spreadsheets to CoMagic
What to do if a client wants to track the effectiveness of telegram brazil amateur advertising before sales, but does not enter transactions into CRM? Because he simply does not have one. We at the SILVERSITE agency found a way out of this situation using CoMagic and Google tables. We share this exciting instruction.


But first, a little preamble…

Why do we need end-to-end analytics and what tools does it include?
Do you know how much money you spend on each completed transaction? Of course you do! To do this, you just need to divide the amount of advertising costs by the number of sales. However, this approach will not show which advertising channels and ads bring in the most sales.

Sometimes it happens that the efficiency of one group of channels is almost 10 times higher than another. That is, you spend a very large part of the advertising budget in vain. As in the famous phrase of John Wanamaker: "I know that half of my advertising budget is wasted, I just don't know which one."

It is possible to analyze and understand the effectiveness of advertising sources only in one case: if at the time of sale it is known from which advertising source/channel the buyer came. If more sales are required, and it is not possible to increase the advertising budget, you can turn off ineffective channels and redistribute the budget to those that bring the maximum number of requests from clients.

Here's what an end-to-end analytics report might look like:


This report shows that the return on the Google Network and Yandex.Search channels is significantly worse than others. This means that you can work on setting up these channels to achieve better returns, or completely abandon these sources and redistribute advertising money to others.

How to get such a report? After all, in essence, we are talking about linking each completed transaction with a transition to the site from the advertising platform (channel, ad, etc.) that led to this transaction.

The ideal solution would be to build a full-fledged end-to-end analytics , which requires all the tracking tools, and first of all, CRM. Experienced entrepreneurs know that CRM is the most important tool for customer support, which records their entire life cycle.

However, practice shows that implementing CRM for most small and micro business market participants is a difficult decision, and for beginners it is also not obvious. The reason is not even the cost of the license, but the overall cost of implementation. Installing CRM always means restructuring many business processes in the company, and not every business owner will easily decide on such a step.

Don't waste your advertising budget
The call tracking and end-to-end analytics service will show the effectiveness of each source in terms of “from click to sale”.