Looker Studio Expert — Build Premium Reusable Marketing Agency Reporting System
Worldwide
I run Enlightened Media, a digital marketing agency, and we're migrating our client reporting from Acquisio to Google Looker Studio. I'm looking for an expert Looker Studio designer/developer to finish and build a premium, highly reusable client reporting system. I need someone who is strong in both dashboard/UI design and the technical side of Looker Studio. I do not want a generic/default-looking Looker dashboard. We need 3 master reporting templates: 1. Paid Media / Lead Generation Google Ads core reporting with optional Microsoft Ads, Meta Ads and Google Local Services Ads modules. This includes executive reporting, campaign performance, detailed daily Search trends, call tracking, keywords and search terms. 2. E-commerce Paid Media Revenue/ROAS-focused reporting including campaign, Shopping/product, search and daily performance reporting, with optional Microsoft/Meta modules. 3. SEO GA4 + Google Search Console + rankings/visibility + landing pages + organic conversions + monthly SEO work completed. Scalability is extremely important. We manage a large number of clients. I want to build these masters once so we can duplicate a report, replace the client's data sources, change the client name, remove any unused channel pages and have a finished report with minimal additional work. Data sources include Google Ads, GA4, Search Console, Google Sheets/API data, and potentially Supermetrics for Microsoft Ads, Meta and other sources. We already have Marchex call-tracking data flowing via API into Google Sheets. I will provide: A detailed PDF showing exactly what data/pages/metrics are required A polished visual report/mockup showing the design quality and direction we want Existing Acquisio reports showing the reporting depth and daily charts our clients currently receive Enlightened Media branding/logo Our partially built Looker Studio report Access to representative data sources/accounts The goal is not to simply copy Acquisio or the visual mockup pixel-for-pixel. I want the reporting depth and familiarity of Acquisio combined with a substantially cleaner, more premium, modern agency reporting experience. I want you to use your own UI/dashboard expertise to improve the design where appropriate. Reports also need to look excellent when viewed online and when automatically delivered/exported as monthly PDFs. Before hiring, please send me 2–4 examples of the best client-facing marketing dashboards you personally designed in Looker Studio. I'm specifically interested in polished agency/Google Ads dashboards — not generic business-intelligence examples. Please also tell me: Your experience with Google Ads reporting Experience with Meta Ads, Microsoft Ads and LSA Experience with GA4 and Search Console Experience with Supermetrics/other connectors Experience using Google Sheets/API data in Looker Experience with calculated fields, blending and reusable templates How you would architect this so new client deployment is fast Your fixed-price estimate Estimated timeline I would like the first milestone to be only two finished pages from the Paid Media master: Executive Summary Search Performance & Daily Trends I want to approve the visual design and reporting system on those two pages before the design is propagated across all remaining pages/templates. If those two pages are excellent, we will proceed with the entire system.
- Less than 30 hrs/weekHourly
- < 1 monthDuration
- ExpertExperience Level
$25.00
-
$47.00
Hourly- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Last viewed by client:yesterday
- Interviewing:12
- Invites sent:0
- Unanswered invites:0
About the client
- United States10:10 PM
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by