Build a warehouse throughput dashboard from our Google Ads data
Project Deliverables & Description
We export Google Ads data to a spreadsheet every week and build warehouse throughput 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.
Looking to get started promptly. Please submit a proposal detailing your relevant past experience and expected timeline.
[!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
$1,000
fixed Rate Structure
Experience Level
Intermediate
Target expertise level requested
Project Scope
Intermediate
Target project delivery scope
Contract Identifier: 69b87793
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