Automated Google Sheets Marketing Dashboard
Summary
Freelancer Client is hiring: Automated Google Sheets Marketing Dashboard.
Location: Remote
I need a single Google Sheets file that automatically pulls fresh data from my social channels, ad accounts and SEO sources, then turns those numbers into clean, at-a-glance insights for my own use.
Connect Google Analytics / Search Console for SEO metrics (sessions, clicks, impressions, avg. position, conversions).
Connect Google Ads and Facebook/Meta Ads for spend, clicks, CPC, CPA, ROAS and any other core campaign KPIs you recommend.
Pull organic social metrics—followers, reach, engagement—from Facebook, Instagram and Twitter if you can access their APIs; if one of them is impossible, suggest an alternative workaround.
Consolidate everything on a main “Overview” tab with clear visual cues (scorecards, sparklines, traffic-light indicators). Underlying raw-data tabs should stay hidden but editable.
Skills: PHP, Internet Marketing, Google Adwords, Google Analytics, Google Sheets, API Integration, Google Ads, Facebook Ads
Budget: $600–$1500 USD
Source: Freelancer Client via Remote / Online. Apply on the source website.
Original
I need a single Google Sheets file that automatically pulls fresh data from my social channels, ad accounts and SEO sources, then turns those numbers into clean, at-a-glance insights for my own use.
Scope
• Connect Google Analytics / Search Console for SEO metrics (sessions, clicks, impressions, avg. position, conversions).
• Connect Google Ads and Facebook/Meta Ads for spend, clicks, CPC, CPA, ROAS and any other core campaign KPIs you recommend.
• Pull organic social metrics—followers, reach, engagement—from Facebook, Instagram and Twitter if you can access their APIs; if one of them is impossible, suggest an alternative workaround.
• Consolidate everything on a main “Overview” tab with clear visual cues (scorecards, sparklines, traffic-light indicators). Underlying raw-data tabs should stay hidden but editable.
Automation
– Refresh on a schedule (hourly or daily is fine) using either App Script or a connector like Supermetrics, API Connector, or your preferred method—as long as I don’t need to click anything manually.
– Alerts: optional but welcomed. If spend or CPC crosses set thresholds, email or slack notification would be ideal.
Deliverables
1. Google Sheets file with connected data sources and live metrics.
2. All custom App Script or connector settings documented in a short read-me tab.
3. Quick Loom walkthrough (1–2 min) so I can tweak ranges or date windows later.
Acceptance Criteria
• On opening the sheet, data auto-refreshes without add-on prompts.
• KPI cells match the same-day numbers I see in native platforms (within typical API delay).
• No premium add-ons beyond free-tier limits unless I approve.
I’m building this for personal tracking, so usability and zero maintenance are top priorities. If you’ve built something similar, share a link or screenshots so I can see your style.
Location & Details
Apply on source →About this listing
This remote opportunity was imported from Freelancer and is shown here for discovery. To apply, follow the link to the original posting.