Looker Studio / Metabase dashboard for ad spend reporting
Project Deliverables & Description
We export Shopify data to a spreadsheet every week and build ad spend reports by hand. I want a live dashboard with filters by date, region and product, connected directly to the data source with a daily refresh. Definitions matter here: I will share how we calculate each figure and I expect you to flag anything that looks inconsistent in the raw data.
Leadership gets numbers a week late and two people disagree about the totals.
Key Deliverables:
- Data Ingestion & Initial Processing: Importing source data, establishing processing rules, and test sample verification.
- Full Processing & Verified Delivery: Completing remaining records with clean audit trail and final reconciliation.
Requirements:
- Demonstrated experience with SQL, Data Visualization, Looker Studio, Python Pandas
- Async communication preferred with milestone check-ins.
- All company financial files stay strictly within our platform workspace.
Ready to hire as soon as we review qualified candidates. Please share your approach and availability.
[!NOTE]
Notice: Data & Business projects involving bookkeeping or financial reconciliation are administrative support only. Not certified public accounting or tax advice.
Required Skills & Technologies
Contract Parameters
Budget Setup
$800 - $1,200
fixed Rate Structure
Experience Level
Intermediate
Target expertise level requested
Project Scope
Intermediate
Target project delivery scope
Contract Identifier: cd05f82a
Professional Trust Score
Client holds verified capital secured in project escrow holds.
Client Identity Verified
Corporate background confirmed
Escrow Lock Enforcement
Secure milestone hold verified
BotDigit Arbitrated
Arbitration protection active