We are looking for someone who can work w/ us on pulling in specific data sets from Google Analytics into another website page w/ a login portal using the Google Analytics API. The final report we create will be up to 3 to 4 pages and we want to make it print friendly w/ options to add comments before or after data tables are embedded into this other website. A year over year comparison and monthly comparison option would also be nice
We will help you with look and feel of the page layout of data, and we actually have a few examples of what we would like to achieve for Phase I. Phase II would be an option to invite others to login to there own portal w/ the ability to add comments for us to review. w/ a message center for client A, B, and C.
Some of the things we will need from this person(s) or agency who builds out the layout.
Ability to add multiple Goal Conversion columns into one field. Think of 'tiered" leads
1.) A.) Tier One leads: Add all phone call leads + lead form submission into a tier 1 Field. Example : Add phone calls + lead forms= The total number is the total posted in one field on layout.
B.) Tier Two Leads: Add all Map page conversions + Contact Page conversions into a tier 2 field.
2.) Have the ability to pull in what the Cost per Action and conversion rates for multiple PPC ad groups related to the above.
3.) Have the ability to pull in the top 10, 20 or 25 search queries (keywords that created the conversions above from the PPC Channel.
4.) Display the Top 5 , 10, 20 or 25 PPC ad groups for the above.
5.) Page Two or Three of the report will pull in an account overview. A clean top channels report w/ similar data to report as above for Organic, Direct, Referral and Social Media based on tiered conversions.
6.) An SEO Overview Page.
A.) Ability to pull in Top Search term rankings month over month (default is current month) This may be something that comes in from Google Webmaster tools account.
B.) Ability to pull in a report or two from SEM Rush to see Organic Search Trending data
C.) Ability to add in our own comments above or below box. This applies for all reports.
Here is a possible sitemap for the above fields:
Page 1: Cover Sheet w/ ability to add logo
Page 2: PPC Overview ( adding our specifications above)
Page 3: SEO Overview ( same as above
Page 4: Next Steps sheet option.
We love using a program called Report Garden or ReportGarden.com. It has a great look and feel or very clean reports. Our problem is we want to get away from monthly cost fees and the tiered reporting is currently not possible as far as I know in Google Analytics? Or is it? Adding two goals together, etc
We would like to see examples of other projects or reporting you've worked on and a review or two if do-able, but not a deal breaker. Also, we will share one of the reports we currently use which will be sent to people who request to see it.