Analyze Google Adword Performance with Zoho DB and Reports

Google Adword is the most popular online advertising avenue for most businesses. It is important to analyze the investment made and the returns achieved on any marketing campaign to measure its success and to apply necessary refinements to get the maximum for the buck invested. The same applies for Google Adword campaigns.

Unfortunately, although Google Adword has been the most popular online advertising avenue, there is a lack of powerful reporting and analysis tools to analyze the effectiveness of your Google Adword campaigns. Inbuilt reports and tools offered by Google Adword lack flexibility and the necessary features required. With Google Adword being the lifeblood of many businesses understanding the money invested, the returns realized and refinements required to effectively capitalize on this marketing investment is very critical and essential.

Analyzing Google Adword performance with Zoho DB & Reports:

Zoho DB & Reports with its powerful and easy to use reporting and analysis features could really help you in this. You could analyze your Google Adword campaign performance easily with Zoho DB & Reports and get useful insights in no time. This document explains about how you could use Zoho DB & Reports for analyzing your Google Adword Campaign Performance.

Zoho DB & Reports provides a default template, named "Google Adword Campaign Performance Analysis", for analyzing your Google Adword Campaign Performance. This template database provides insightful reports that would enable you to easily analyze your Google Adword Campaign Performance. You could also create your own reports for further analysis. A Sample Database of the same name is also available which you could use for your own Adword data for analysis.

In the following sections we will go through the step-by-step instructions on how to use the Zoho DB & Reports template for your own Google Adword Campaign analysis.

Getting Data from Google Adwords:

1. Login into your Google Adword account
2. Select the "Reports" Tab
3. Click on "Create a New Report"
4. Select Report Type as "Campaign Performance"
5. Select "Daily" for Unit of Time
6. Select the appropriate Date range
7. Select your Adword Campaigns that you would like to analyze
8. Recommended columns for selection Date, Campaign, Impressions, Clicks, CTR, Avg CPC, Avg CPM, Cost,Avg Position, Conversions, Cost / Conversion. You could also select any additional columns if required.
9. Schedule this template to run every week or month and have it emailed you.
10. Click on "Create Report"
11. Select the Generated report
12. Export Report as ".csv (for Excel)" and save it in your local folder
13. Modify the CSV data as below:
    1. Open the exported CSV file in Excel or any other text editor
    2. Delete all extra rows above the column names as well as the summary statistics rows at the bottom.
    3. Save the file

Importing and Analyzing the Adword data in Zoho DB & Reports:

1. Login into Zoho DB & Reports
2. Choose "Create Database from Template"
3. Provide Database name and description
4. Choose the Template "Google Adword Campaign Performance Analysis"
5. Uncheck "Populate with Sample Data". Choose to populate with sample data if you would like to review the features within this database with sample data before you use the same for your own Adword data analysis.
6. "Create" the database
7. Select the table "Campaign Performance"
8. Click on "Import -> Import into this table.." option
9. Choose "Add at the End" option. (You could keeping adding/appending new Adword data periodically with this same option).
10. File type is "Comma Separated Value"
11. Browse and load the Google Adword CSV data file from the "Local Drive"
12. Click "Next"
13. Verify the Date format and the default Column mapping shown under the Preview table. Column mapping should not require any modification.
14. Click "Create"

Your Adword data would get imported into the table "Campaign Performance". You could click any of the default reports created to analyze the Adword data imported.

Important points to note on using the database created:

1. Currently the template provided is done only for analyzing Google Adword Campaign analysis and not for Adword group and keyword analysis. We would be adding a template for this very soon. A sample database created with this template is also available with the same name "Google Adword Campaign Performance Analysis"
2. All the default reports with names starting with any of "EU", "US", "Others" have been created for analyzing the campaign data of a sample Mountain Bike Company. These reports would look relevant only when you populate the template database with Sample Data while creation. You could delete these reports if you do not require them.
3. You could review the default reports design or modify it by clicking "Edit Design" toolbar option in each report
4. You could create a new report to analyze your Adword data, by clicking the "New Report" option on the top left corner OR by choosing the "Campaign Performance" table and selecting the appropriate report type (Chart, Pivot, Summary, Tabular.,) listed under the "New" Menu in the toolbar.
5. The template provided "Google Adword Campaign Performance Analysis", is just to enable jumpstart in analyzing your Google Adword campaign performance. You could very well create your own database (need not be from template) for analyzing your Adword data.

If you require any assistance using Zoho DB & Reports checkout the Demo Videos. If you further need any assistance mail us at support at zohodb dot com.