Amazon Seller PPC Google Sheets Ad Report

$

25

Quick hire service

About this service

Summary

You will get this polished ready-to-use Amazon PPC dashboard made for Google Sheets. All you need to do is add your downloaded PPC campaign report files. Then you paste the new information onto the correct tab. Once the new data is added, you can change the dates on the dashboard to get a different range.



This dashboard is perfect for agencies and freelancers working with Amazon PPC for clients. This dashboard is simple to use and will allow you to share, snapshot, or download as a pdf to send to clients. Or if you are an Amazon seller looking for an accessible report to explain your Amazon PPC campaigns, this is ready for you!



The Google sheet comes with a How-To tab for you to reference in case you get stuck.



I will add your brand colors (up to six, no less than three) and your brand logo. After those changes are made I will share your Google Sheet with you and give you permission to edit. After you are able to access the report, I will remove my name and the report is all yours!



Please note, that some of the formulas used are only available in Google Sheets. Please do not purchase if you are planning on using this with any other spreadsheet software, It will not work.



Process

All I need to start is a logo in png format and branding hex code colors. Once I get those I can add those to the sheet and those to your new report.

Once the branding is added, I send you a PDF with he link to the secure Google Sheet report.

After you gain access to the report, you make a copy to your Google Drive by going to File > Make a copy.

Now you just download the following reports from the Amazon Seller Account:

Sponsored Products Report Report Category: Sponsored Products Report Type: Search term Time Unit: Daily

Sponsored Brands Report Report Category: Sponsored Brands Report Type: Search term Time Unit: Daily

Sponsored Display Report Report Category: Sponsored Display Report Type: Campaign Time Unit: Daily

The period is usually 3 business days after getting your branding requirements, but I try to do it sooner.



FAQs

  • Does this work with Excel?

    No, as there are formulas used in this report that are not available in Excel.

  • Can I have my colors and branding?

    Yes, there is a perfect spot ready for your logo in the top right corner. It can take up to six brand colors. I recommend at minimum 3.

  • Can I make changes or customer metrics

    Yes, but the more changes you make the more time it will take to complete the project.

  • I am an Amazon Ad agency, can I use this for my clients?

    YES! I designed this for small agencies looking for something fast and effective.

  • I am an Amazon Seller, will this sheet work for me?

    YES! I designed this for small businesses and Amazon Sellers who are looking for something fast and effective.

What's included

  • A Google Sheet template with PPC dashboard

    An easy-to-use spreadsheet where you just copy past the sponsored product, sponsored brands, and sponsored display. The report has date range filters to adjust for custom periods.

  • A PDF explaining how to access the spreadsheet.

    A PDF is sent to the secure link to your report. It also provides a link to a video walkthrough on how to use the report.


Duration

3 days

Skills and tools

Data Modelling Analyst
Business Analyst
Data Analyst
Data Analysis
Google Sheets

Industries

E-Commerce

Work with me