Best advices for growth hacking

growth hacking curve

At SunnyReports, we are like any other bootstrapped start-up : we are two founders with a lot of people giving us their best advice and some of their time. I would like to take this opportunity to thank our wives, our friends and also all those people we barely know.

We soon found out (as you most surely already did) that one of the most difficult challenge of our start-up adventure is to promote our amazing product. We already have users, subscribers, but we need more, actually a lot more: we need to go growth hacking.

Growth hacking

A growth hacker is a person whose true north is growth. Everything they do is scrutinized by its potential impact on scalable growth. Is positioning important? Only if a case can be made that it is important for driving sustainable growth.
Source: Sean Ellis’ blog

There is so much content (articles, posts, videos) for growth hacking and marketing that you could spend your whole days on it doing nothing else while you have a lot of other things to do. Efficiency is the way to success. Don’t forget: execution matters. Read More →

The way to count conversions changed in Adwords

adwords conversions count change

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 →

Geo Performance Report with AWQL

Geo Performance map

AWQL is a powerful language to make queries through the Adwords API to retrieve and manage data. It’s an efficient way to search and understand your data by a way you can’t find in Google Adwords.

I will give an example of what I did some days ago for one of my customer on the geo performance report table.

Geo performance in Adwords

Geo performance is one of the thousand of data to analyse in Adwords. These informations can be valuable for your client about his target. You can start actions on a specific target area, for example to make an event or to send flyers.

But the way Adwords give the geolocation information is not very easy to use. You have to go in the Read More →

Visualize your AWQL queries in seconds for free

AWQL.me logo AWQL

We are really happy and proud to release AWQL.me, the first free tool to visualize the results of your AWQL queries in one click.

What’s the point ?

AWQL – AdWords Query Language – is the powerful query language used by Google Adwords. It’s an SQL-like language which allows to perform queries on most common Adwords API services. You can also use it for Adwords reporting too.

Even if AWQL is inspired by SQL, it doesn’t allow all the SQL tips like join and group. The language is really interesting to be able to search in your Adwords data.

A query example: Read More →

Why Adwords reports is Key for me and my clients

Adwords reporting overview

Being a freelance Adwords manager, I have experienced that Customer Reporting is the key point. Optimizing my clients’ campaigns is my job. But what does optimization mean? Does it mean 10% growth every month; fewer clicks and more conversions; lower the CPC (Cost Per Click); increase the CTR?

My clients don’t know my daily job

My clients hire an Adwords manager thinking that doing so, they optimize their budget. But being no expert in Search Engine Marketing, PPC ads and Adwords, they have no idea of the daily activities I perform for them.

I spend most of my time sitting at my desk in front of a couple of monitors displaying data tables with $ and %, adjusting one bet here, adding ten keywords there, splitting Adwords group, etc. Does that sound familiar?

My clients only know on a monthly basis whether or not they are making more revenue with fewer budgets. They are not informed that thanks to my hard work their revenue stays stable while the market is getting more and more competitive or is decreasing.

Thanks to better reporting

Better reporting provides my clients with Read More →