The Ad Extensions report is a fast and easy way to check the number of ads and ad extensions in each ad group.
What does it do?
The Ad Extensions template report pulls data about all expanded text ads, and selected ad extensions, for all active campaigns and ad groups. This quick and easy report should be utilized on all accounts as a way of monitoring how many ads and ad extensions there are in each ad group, in addition to checking the performance of the ad groups.
What does the output look like?
The output is clean and color-coded showing you performance, number of expanded text ads, quality score information, ad ctr, ad headlines, and the ad extensions you select with impressions in the last 30 days (or whatever time duration you select).
Some of the columns have conditional formatting ready to go. For example, the Ad Information # of Exp. Text Ads column will show red if you have less than 2 ads per ad group. In the Quality Score section, the columns have a gradient from green (highest) to white (middle) to red (lowest). And, in the Ad Extensions (with impressions in last 30 days) columns, the cell will show red if the number is below the conditions you set while creating the report.
Step by step guide to setup Ad Extensions reports
Step 1: Select Ad Extensions template
From the Reports overview screen in PPC Robot, click on “+ Create A New Report” and then select the Ad Extensions template.
Step 2: Report Parameters
Select and arrange any metrics that you wish to see in your report, and you can also remove any of the default metrics. In addition to all the standard Google Ads API metrics, you can also utilize some of our custom metrics. A few important things to keep in mind:
The Ad Extensions template report utilizes data at the ad group level.
Only enabled campaigns, ad groups, and ads will be shown.
Data reflected in this report is from Google Search only and does not include Search Partners.
To add a metric to the report, simply click on the search field and start typing the name of the metric. Then click “+ Add To Report”.
Or, if you aren’t sure what you are looking for by name, you can click on “Show All” and see a list of all available metrics by category with descriptions. Once you have found the right metric, simply click and drag it to the list on the left.
You can also click and drag to rearrange the metrics in the left column. This is the order that the metrics will appear in your report.
Step 3: Set duration
From the drop-down menu select the duration of time for how far back the data will go. You can select all of the standard durations (i.e. All Time, Today, Yesterday, This Week, This Month, etc.), and you can also utilize our custom date range where you specify how many days or weeks you would like the data to go back.
Please keep in mind, if a metric has a specific duration specified in it’s name or description, then the duration you select will have no effect on that metric.
You can use this to your advantage by selecting a date range that is not covered in the metric and including the default metric along with the other date range metrics to see how the data has changed over time.
For example, you can set the duration to 90 days and include the metrics CPA, CPA 30 days, CPA 7 days, CPA yesterday and in your report you will have 4 CPA columns right next to each other with data from the last 90 days, 30 days, 7 days, and yesterday for easy comparison.
Step 4: Ad Extension Selection
Tick the box to select the extensions that should be utilized in the account. Also, put the minimum number of each extension that you want in each ad group, this will allow the conditional formatting to better reflect when an ad group does not have the right amount of extensions.
It is important to note that the report will only show ad extensions which have had impressions for the selected duration, which is Last 30 Days by default. You change this by selecting the necessary time period in the dropdown box.
Step 5: Download/upload parameters (optional)
If you would like to save and share your Ad Extensions setup, or if you would like to use someone else’s, you can easily download and upload the parameters using the options at the bottom of the report.
Step 6: Name report
Once you have your Ad Extensions report setup how you like it, click "Next" in the bottom right-hand corner to go to the Output Settings and Account Selection screen. Here you can add a report name that will help you to identify your Ad Extensions reports in the Reports Browser screen. PPC Robot automatically adds the name of the account to the beginning of each report name, so you can simply name this report “Ad Extensions” and the final output name will be “Account: Ad Extensions”. If you select multiple accounts for this report then you can rename each report individually in the reports overview screen.
Step 7: Select output type
There are two options for output, Google Sheets and Microsoft Excel (XLSX) stored in Google Drive.
Both of these options will create a file in your Google Drive (in the folder called PPC Robot which is automatically created by PPC Robot).
With Google Sheets you will be able to simply click on the report name in the Reports Overview screen and be taken to the online spreadsheet. With the Excel file, once you click on the report name, the report will download to your default local downloads folder on your computer.
The benefit of Google Sheets output is that it is saved online, it is easy to update, and it is easy to share with others. Also, any filtering, formatting, or additional columns added after the last column in the report will be saved even after updating the report.
The benefit of Excel output is that there is no limit to how many cells the report may contain. Google Sheets has a limit of 400,000 cells, a maximum of 256 columns, only 40,000 cells containing formulas, and other limitations.
If possible, we recommend using the Google Sheets output for ease of viewing, sharing, and updating.
Step 8: Set update frequency
You can select from Monthly, Weekly, Daily, and Hourly for the automatic update frequency of your report. We recommend that you select daily and an early hour so that your report is up-to-date when you arrive at the office in the morning.
And, if you utilize the email notifications, we recommend that you set those to arrive in the morning after your reports have run.
Step 9: Select Accounts
One of the great aspects of PPC Robot is the ability to apply your report to any and all of your accounts, and you can do this a number of ways. You can simply "Select All" to create the report for all of your accounts, or you can click on the account names individually, or you can search by account name or label by beginning to type them in the search box.
You can always come back later and add more accounts to the same report.
Step 10: Save and run report
The final step is to click “Save” which will take you back to the reports overview screen. Then you can find the report using the search filter, and click on the play button to run the report for the first time.