We are a small Australian company and we are having some difficulty in reading the amount of data that is available from Adwords and Analytics and want to try and simplify this by introducing a reporting tool to work within Microsoft Excel.
Essentially we want to be able to better determine where our best online revenue is coming from (e.g. which Google ads are working best, which email campaigns etc). Whilst we can look at the data in each of these sites it does not give us sufficient information about our ROI or whether one source is actually improving, or decreasing, over time.
We have looked at a couple of available tools such as GA Data Grabber and FasterMetrics (as we use Macs, although with a VMWare emulator) but simply do not have the time, or expertise, to source the best tool and to develop it.
We are therefore looking for a freelancer who has had exposure in this area to recommend a tool and to develop the reporting capability so that we can obtain better visibility of what is working and what is not. Having settled on the most appropriate tool and its capabilities, I would expect that the next phase is to produce some basic reports indicating: Source, Cost, Revenue, ROI, Changes over time. From there we would look at what additional reports could be made available and this would then be negotiated with the freelancer.
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
GAP certified. What I do: SEM - Search Engine Marketing (Adwords, Facebook, Bing) CRO - Conversion Rate Optimization * Google Analytics skills * Google Website Optimiser skills Also check my profile on Linkedin: http://pt.linkedin.com/in/manuelmoreira/
? 4+ years Work experience with MS-EXCEL and VBA. ? Having experience in MSBI & SQL Server projects with extensive usage of ETL & Reporting tools like SSIS, SSRS and SSAS ? Pragmatic Self motivated and a good team player. ? Quick learner with the ability to grasp new technologies and software. ? Sound knowledge in .NET framework, ADO.NET, RDBMS ? Developing Web applications using C#.NET, ASP.NET, ADO.NET. ? Knowledge in Development of .NET Projects. ? Created SQL Server Integration Service (SSIS) packages to export and import data from various source systems to SQL Server. ? Having Experience MS-Excel with VLookup, Pivot Table, and HLookup.
o Developing reports as per Team Decision Makings. o Develop hypothesis and structure analysis to analyze strategic business issues o Collect data from structured data sources (e.g., IMS) and unstructured sources (e.g., internet, reports) o Analyze quantitative data to develop second/third order insights o Develop ppt/word reports for sharing with decision makers and other stakeholders o Work Experience in MS-Excel with VLookup, Pivot Tables. o Preparing Region wise, Division wise, Town wise, and Zone wise Sales Reports. o Preparing L&T and NP Analysis. o Preparing Metros wise, Org Mas ter and Aion Reports. o Working Knowledge in ORG IMS, C-marc and SAP Software. o Updating Daily-Wise & Monthly wise All Reports. ? Having 4 years of experience in MSBI & SQL Server with extensive usage of ETL & Reporting tools like SSIS, SSRS, SSAS ? Having 2 years of experience in MSBI & SQL Server projects with extensive usage of ETL & Reporting tools like SSIS, SSRS and SSAS ? Have worked in multiple projects as BI Developer in Designing ETL Packages and reports in development and implementation stages of the Project according to client requirements. ? Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, FTP Task and Data Flow Task in Designing packages. ? Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, multicast, Derived column, Union All, Merge Join, and OLEDB Command to load data into SQL Server destination. ? Maintaining the Log and Audit information in the SQL tables. ? Creating the reports as per client's requirements in the form of table, matrix, and list. ? Extensive knowledge on SQL Server 2000, 2005. ? Having knowledge in creating data sources and data source views and dimensions in SSAS. ? Having knowledge in creating cube and modifying measures and attributes, creating hierarchies and relationships in dimensions. ? Process the facts dimensions and implemented aggregation on granularity basis. ? Having basic knowledge in creating calculations, KPIs, Partitions and translations, MDX. ? Good communication, inter-personnel skills and good team player. ? Self motivated individual with strong analytical and problem solving abilities, Proactive, Dedicated, enjoy learning new technologies and willing to take on extra responsibilities to get work done.
worked with SMDesign Studio - Los Angeles Ciplex - Los Angeles Blueprint - Chicago Sistem Aktiva Kont - Serbia
kandy, Sri Lanka
Honest...Clever...Fast...Reliable... I am here to help you with your all administrative needs!! Self-Motivated, qualified professionally with vast experience in Data Entry, Data Management, Data Analyzing Web Research and PDF conversion. Seeking a job where acquired experience and MS-Office Skills can be utilized properly. I am very confident and assure honest and 100% accurate and precise output. ~ Proficiency over MS Excel, MS Word, MS Power Point ~ Look forward to build a long term relationship work with client ~ Excellent analytical, organizing, interpersonal and communication skills
As a Google AdWords campaign manager i bring business to my clients through online campaigns which target segmented traffic tailored to clients Products and Services. What i could do for your business: -Consultation and Setup -Account Creation -Goal Analysis -Campaign Setup -Conversion Tracking -Call Tracking Setup - if needed -Competitive Analysis Auctions Report -Campaign Optimization -Keyword Research & Bid Management -A/B Ad Copy Testing -Conversion Tracking -Ongoing Strategy Development -Quality Score Analysis --Display Network -Text Ads -Image Ads -Video Ads(must be provided by client) -Placement Sites Targeting -Site Exclusion & Optimization -Demographic Bidding (if and where available) -Mobile Ad Campaigns if needed -Mobile Campaign Setup -Mobile Device Targeting -Re-marketing Campaign -Audience management -Landing Page Consultation -Analysis & Monitoring ... I also offer On-Site SEO consultation on how to get the most out of paying for Traffic for Free when hired.
***Freelancer's Preferred Worker*** Hello, I would like to introduce Cure Technologies and its services. Cure Technologies is an offshore development company having 8+ years of experience and providing services in following areas: - Web Applications Development - Windows Applications Development - Mobile Applications Development We have expertise in a wide range of technologies including: - DOTNET - C# - SQL SERVER - WinForms - WPF - WCF - PHP(custom & framework) - MySQL - CMS - WordPress - Joomla, Drupal - eCommerce(Magento, - Volusion - WooCommerce - Prestashop - OpenCart - Shopify) - PhoneGap - Android - iOS We have always completed our assignments on time with customer satisfaction based purely upon quality standards.
Greetings. I work on Google AdWords PPC Campaigns, Bing Ads, SEO, Internet Marketing, Market Research, Project Management and Affiliate Marketing. I can set up an online PPC marketing campaign or SEO for your website, whichever applicable as per project requirements. I am working as a team and have some staff to help me where required in specialized areas like web design. Website suggestions and Project Report included in every applicable project. 24 hours support & free revisions within 1st week after project delivery. Just send me a message right here so that i can get back to you ASAP Thanks & Best Wishes
Hello. My name is Alex and I'm a certified Adwords professional and former Google Employee. I'm living in between Italy and Portugal. I've worked at Google as an Account Manager of SMB advertisers for the Portuguese and Italian market. I've got my Adwords certification and formation directly from Google. I'm also Analytics-certified. I have 5 years of experience and Top rated Manager account on Wordstream and 99% success rate guarantees you that there's no time or money wasting with my skills. Because there are so many projects posted here, I rarely bid nowadays. If you are seeing my profile and you're interested in my services, contact me for more details. You can also invite me to your project but only if you are serious about it. Time is a very precious thing! Thanks. Alex