Get up to speed on Digital Marketing with our 2018 spreadsheets recap.

November is coming, time to have a look back at 2018. SEM has changed and the recent weeks have shown that the biggest platforms had plans for 2019 and further.

Through the development of our SEM expertise here at Green T digital, we thought necessary to share a few of our tools to help you improve your own strategies. Let us know if it has helped you and which other tools could be helpful too.

 

Automate your Google Ads budget management.

One of our first spreadsheets was focused on automating your Google Ads budget management. Managing your Google Ads budget can be, indeed, a difficult task if you only do it through Google Ads web version.

Find out how to create your Google Ads budget management: Link to blog article

Link to the spreadsheet: Access to the shared tool

 

Channels and attribution.

With a similar objective, we shared a tool helping you automate your channel reporting. However, not being exhaustive enough, we enhanced that spreadsheet with additional tools to allow you to create more advanced analysis.

Find out how to automate your monthly budget management: Link to blog article

Find out how to add additional layers thanks to attribution: Link to blog article

Link to the spreadsheet: Access to the shared tool

 

Heat map, spend only when your website performs the best.

Knowing which channels perform is good, but knowing when they do so is much better. Our heat map gives you great opportunities to break down your results per channel, device, day and or hour. A template that you can naturally customize to show what matters the most for your company.

Find out how to create a heat map: Link to blog article

Link to the spreadsheet: Access to the shared tool

 

Evaluate your cost of acquisition on Google Ads

Last and not least, the last spreadsheet shared this year tried to answer an important question: What kind of CPA to expect on Google Ads? This spreadsheet had for main objectives to give you some ideas concerning the “toll” you might need to pay before getting any lead or any conversion. However, having a linear approach this spreadsheet could naturally be improved with additional layers to take into consideration the difference of CPA between all the campaign types.

Find out how to estimate your CPA: Link to blog article

Link to the spreadsheet: Access to the shared tool

 

Do not hesitate to get in touch if you have any questions,