Excel can help you analyze budget allocation for efficient acquisition
(You can download the Excel file format from the link above)
Please prepare the following two types phone number lookup mexico of advertising data.
Data required for analysis
: 1. Daily advertising delivery amount
2. Advertising KPIs in the same time series as 1
Supplementary information
: ・ The granularity of advertising can be freely set to ad group/campaign/media unit/all ads, but if it is lumped together too much it becomes difficult to grasp trends, so we recommend media unit
・ The data granularity is set to daily, but weekly or monthly can be used if a sufficient amount of data can be secured
・ There are various possible indicators for advertising KPIs, such as impressions, click counts, and conversion counts, but in this article we will use conversion counts for the following explanations
>>Download the document set (service documents and case studies) to learn about Ollie's
Analysis flow
We will now describe the specific work procedures, but before providing a detailed explanation, we will first explain the analysis procedures so that you can easily grasp the overall picture.
<Analysis procedure>
1. Enter advertising data into an Excel sheet and create a graph.
2. Conduct analysis based on the calculated formula.
3. Consider your company's situation and determine your advertising budget.
As you can see, there are roughly three steps to perform a simple analysis. As long as you have the data, the analysis results can be calculated in a few minutes, so I would be happy if you would give it a try after reading this article.
Now, I will explain the actual work procedure using the Excel file I introduced earlier.
1. Enter advertising data into an Excel spreadsheet and create a graph
In cells A4 to C4 of the "Analysis Creation Sheet," enter the date, delivery amount, and number of conversions in that order. (As mentioned above, the data you enter here should be the content you want to analyze, so you do not necessarily need to enter the items as shown in the reference.)
*If there is a 0 in the delivery amount column, an error will occur when setting the "Trend Curve Options" in Figure 2, so please delete the entire row for days when there was no delivery.
[Figure 1: Advertisement data description example]
