After having added the PDF support to our Adwords reporting tool, Google Adwords Excel reports are now available in SunnyReports.
How to export to Adwords reports to Excel XLS
As usual, it’s effortless. After having made your report in some seconds, before the recipients’ fields, just tick the box:
The XLS Adwords report will be attached to the email, like this:
Impression share report is an underrated report. Be wiser than your competitors and use it to find powerful leverages to increase your Adwords campaign performances.
What is impression share report ?
Impression Share is the number of impressions your campaign received divided by the estimated number of impressions it could have received. The estimation is based on several parameters like geolocation, audience, bids, quality score, …
What is Impression share
Having a look at the picture above, you can quickly understand how useful this data is:
increase the part of your impression share => more “targeted people” see your ads.
There is four types of Search Impression Share (IS) metrics available for search campaign:
- Search impression share: this is the impressions your ads received on the Search Network divided by the estimated number of impressions they may have received,
- Search Lost IS (budget): This is the share your ads lost due to an insufficient budget. This metric is only available at the campaign level.
- Search Lost IS (rank): this is the share your ads lost due to a poor ad rank.
- Search Exact match IS: the total of impressions your ads received only for the keywords exact match relative to what they could have received.
There is also similar metrics for Display campaign: Display impression share, Display Lost IS (budget), Display Lost IS (rank).
Why using it ?
Google Analytics is going to improve his Google Adwords reporting features by adding a new feature called Treemaps. The information is coming from Google+ “Introducing Treemaps in Google Analytics for Adwords Insight“.
What is Treemaps ?
Treemaps will offer to Adwords campaign managers a better insight of the performances of their ads. The approach is not to only have look to numbers but to visually identify the trends or troubles.
It’s done by displaying hierarchical data using nested rectangles, showing positive results in green, lagging results in red. It aims to speed the decision process and to optimize better and quicker the campaigns.
It’s a really interesting improvement in the ad performances analysis. Treemaps will be available in the next weeks in Google Analytics in Acquisition > Adwords > Treemaps.
A few days ago, we released AWQL.me, a free tool to simplify the way you write an AWQL query and see the result.
We are happy to release a new feature: you can now download the results in two formats: CSV and XML.
You just have to select which format you want for the data and the file is downloaded automatically.
You can now write, check and test your AWQL queries and retrieve the Adwords data for a further exploitation in Excel for example.
Feel free to drop us a line with your feedback or to request a new feature. Have fun!
Google announced a week ago that there is a new way to count conversions in Adwords.
How it worked ?
Before these changes, there were two kinds of conversions: one per click and many per click.
- Conversions – 1-per-click
These ones count a conversion for every AdWords ad click resulting in a conversion within 30 days (the number of days you have specified for the cookie’s life).
If there is more conversion following this single click, they won’t be count. This is useful when you want to measure the conversions for unique customer acquisition.
- Conversions – many-per-click
These ones count a conversion every time a conversion is made following an Adwords click (within the number of days specified for your cookie’s life).
It counts all the conversions made after one click on an ad. It’s useful when you want to measure for example all the purchases in an e-commerce shop.
How it works now
Now, Google remove the previous conversions and Read More