Post by account_disabled on Dec 20, 2023 6:25:29 GMT
For those who can work with Excel at an advanced level, it can be a great helper. And even when preparing PPC campaigns, when data from it can be imported directly into AdWords Editor, or when working with UTM parameters for Facebook. However, these things can be made easier even for people who do not understand Excel at all. Therefore, in the article you will find four templates that can be used both by absolute beginners or enemies of Excel, and by those who have no problem working in it. Excel Master Are you an Excel master? First of all, I would like to point out two things - I am not a programmer, and not all macros or all the ways templates are prepared may be perfect. However, their functionality was important to me . Testing was done on both Mac and Windows. However, if you have any ideas for improvements, I'd love to hear them in the comments.
The second thing C Level Executive List is that almost all the attached images are GIFs showing the functionality of the templates. For their full display, it is necessary to distinguish them. You can download all the templates below on Google Drive . PPC budget monitoring template Let's start from the simplest. We use this template in various variations throughout the PA department on a daily basis. This is because PPC gives an overview of how efficiently the budget for individual campaigns is used in the systems . Just fill in the available credit and the period, and the template will then show what daily budget should be set in the campaign. After each entry of the spent credit, the table will show, in addition to the remaining total and daily budget, how much the daily average spending is so far. This can inform how we work with the proposed daily budgets. Of course, it is necessary to take into account the deviation, when the systems overdraw the budget on individual days.
Sample budget Keep an eye on your budgets - click to start the animation Jack of all trades template The next template is intended especially for those who do not understand Excel at all. 3 sheets are included. You use the first one if you want to include modified loose match keywords in your campaigns . All you have to do is write the words in the free match in the first column and the modified words will immediately appear in the second column. The entire column (without the header) can then be copied and pasted into the AdWords Editor. The second sheet is intended for quick processing of, for example, the names of advertising groups into the format of two additional phrases in a visible URL ( Route 1 and Route 2 ). Simply insert the required words or phrases into the first column, and they will immediately appear in the second column without diacritics, and the spaces will be replaced by a dash . Creating a visible URL Create a visible URL quickly and easily - click to start the animation The last sheet is devoted to connecting UTM parameters behind the URL, which you will probably use mainly for Facebook campaigns. Just write the URL in the first column and then the required UTM in the table on the right. It is then automatically assigned to the address in the first column.
The second thing C Level Executive List is that almost all the attached images are GIFs showing the functionality of the templates. For their full display, it is necessary to distinguish them. You can download all the templates below on Google Drive . PPC budget monitoring template Let's start from the simplest. We use this template in various variations throughout the PA department on a daily basis. This is because PPC gives an overview of how efficiently the budget for individual campaigns is used in the systems . Just fill in the available credit and the period, and the template will then show what daily budget should be set in the campaign. After each entry of the spent credit, the table will show, in addition to the remaining total and daily budget, how much the daily average spending is so far. This can inform how we work with the proposed daily budgets. Of course, it is necessary to take into account the deviation, when the systems overdraw the budget on individual days.
Sample budget Keep an eye on your budgets - click to start the animation Jack of all trades template The next template is intended especially for those who do not understand Excel at all. 3 sheets are included. You use the first one if you want to include modified loose match keywords in your campaigns . All you have to do is write the words in the free match in the first column and the modified words will immediately appear in the second column. The entire column (without the header) can then be copied and pasted into the AdWords Editor. The second sheet is intended for quick processing of, for example, the names of advertising groups into the format of two additional phrases in a visible URL ( Route 1 and Route 2 ). Simply insert the required words or phrases into the first column, and they will immediately appear in the second column without diacritics, and the spaces will be replaced by a dash . Creating a visible URL Create a visible URL quickly and easily - click to start the animation The last sheet is devoted to connecting UTM parameters behind the URL, which you will probably use mainly for Facebook campaigns. Just write the URL in the first column and then the required UTM in the table on the right. It is then automatically assigned to the address in the first column.