INTL
Freelancer
어려움
외주
원격 가능
looker studio Dashboard
예산
$1,500~$3,000 USD
예상 기간
1~2개월
난이도
어려움
기술 스택
Shopify
GA4
Looker Studio
Google Ads
Meta Ads
Snapchat Ads
Adjust
BigQuery
Google Tag Manager (GTM)
Google Sheets
Data Integration
Data Analysis
AI 분석 요약
Shopify, Google Ads, Meta Ads, Snapchat Ads, Adjust, GA4 등 여러 데이터 소스를 통합하여 Looker Studio 대시보드를 구축하는 프로젝트입니다. GA4 트래킹 및 데이터 연동을 정확히 구현하고, 판매 성과 및 광고 캠페인 효과를 분석하는 대시보드를 개발할 역량이 필요합니다.
프로젝트 원문 설명
I’m merging every key data source—Shopify, Google Ads, Meta Ads, Snapchat Ads, Adjust (for the mobile app) and our existing GA4 property—into a single reporting flow and need the whole setup built and validated.
The work breaks down into two parts.
1. Tracking & data plumbing
• Map all Shopify e-commerce events to GA4, making sure purchase value, discounts and refunds reconcile 1:1 with the store’s back-end.
• Link Google Ads, Meta Ads and Snapchat Ads to GA4, using their respective Conversion APIs where possible so we keep signal loss to a minimum.
• Feed Adjust post-install events into GA4, aligning naming conventions so web and app funnels read as one journey.
• Test every event and audience, then document the validation results so I can reference them later.
2. Looker Studio build-out
The dashboard must surface two core report groups:
• Sales Performance – revenue, AOV, ROAS, margin by product, channel and geography.
• Ad Campaign Effectiveness – spend, CPC/CPM, impressions, assisted conversions and attribution windows for each campaign, ad set and creative.
Give me filter controls for date, channel and device type, plus a single-click export to Google Sheets. Speed matters; visualisations should load in under five seconds for the last 90-day view.
Acceptance criteria
• Data in Looker Studio matches Shopify and ad-platform totals within 2 %.
• GA4 debug view shows no duplicate or missing events.
• All reports refresh automatically without manual intervention.
• A short Loom walkthrough (≤10 min) explains the architecture and how to extend the dashboard.
Please outline your estimated timeline and the main tools you’ll rely on (e.g., GTM server-side, BigQuery, Supermetrics, native connectors).
The work breaks down into two parts.
1. Tracking & data plumbing
• Map all Shopify e-commerce events to GA4, making sure purchase value, discounts and refunds reconcile 1:1 with the store’s back-end.
• Link Google Ads, Meta Ads and Snapchat Ads to GA4, using their respective Conversion APIs where possible so we keep signal loss to a minimum.
• Feed Adjust post-install events into GA4, aligning naming conventions so web and app funnels read as one journey.
• Test every event and audience, then document the validation results so I can reference them later.
2. Looker Studio build-out
The dashboard must surface two core report groups:
• Sales Performance – revenue, AOV, ROAS, margin by product, channel and geography.
• Ad Campaign Effectiveness – spend, CPC/CPM, impressions, assisted conversions and attribution windows for each campaign, ad set and creative.
Give me filter controls for date, channel and device type, plus a single-click export to Google Sheets. Speed matters; visualisations should load in under five seconds for the last 90-day view.
Acceptance criteria
• Data in Looker Studio matches Shopify and ad-platform totals within 2 %.
• GA4 debug view shows no duplicate or missing events.
• All reports refresh automatically without manual intervention.
• A short Loom walkthrough (≤10 min) explains the architecture and how to extend the dashboard.
Please outline your estimated timeline and the main tools you’ll rely on (e.g., GTM server-side, BigQuery, Supermetrics, native connectors).
Freelancer에서 원본 확인
원본 보기