Setting up analytics (BigQuery + Looker Studio) for lead generation
Need an analyst to build an analytics system and dashboard for a lead generation project (USA, Home Improvement).
What needs to be done:
Connect data from Google Ads, Meta Ads, and CRM (leads)
Set up data transfer to BigQuery
Combine ads + leads for accurate CPA calculation
Implement basic data processing (deduplication, metric calculation)
Build a dashboard in Looker Studio (Spend, Leads, CPA, breakdown by source / campaign / state)
Requirements:
Experience with BigQuery
Experience with Looker Studio
Understanding of performance marketing (CPA, CR)
Experience working with API / webhook
Format: freelance, quick MVP launch
-
7 days490 USD
7 days490 USD
Hello! I am the project manager of Business Atlas. We specialize in building end-to-end analytics and automating business processes. In my experience, I have created marketing control systems for brands like Ajax and Genesis. We know how to consolidate disparate data from Google, Meta, and your CRM into one understandable report. What we will do for your project:
• Single repository: we will collect all expenses from advertising accounts and lead data from the CRM in BigQuery.
• Automatic merging: the system will automatically connect clicks with real applications so you can see the honest CPA for each state and campaign.
• Understandable dashboard: in Looker Studio, you will receive a screen with key figures (expenses, number of leads, cost per lead), without the need to log into advertising accounts each time.
• Data cleansing: we will set up duplicate filtering to ensure the analytics are clean and truthful.
Cost: $500 – $900.
What do you think about this format? Write to me privately and we will discuss the technical details of your CRM.
Similar completed project: Project Dashboard в Notion
-
7 days178 USD
10317 130 0 7 days178 USD
Good day
I have extensive experience in building analytics for performance marketing projects (Google Ads, Meta, CRM).
I have worked on similar solutions: data collection in BigQuery, combining ads + leads, calculating CPA, and building dashboards in Looker Studio.
I set up a complete turnkey pipeline.
I am ready to discuss the details.
Current freelance projects in the category Data Processing
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 5 days 3 hours back ∙ 17 proposals |
Assistant to the manager for project work in the field of science and scientific publicationsLooking for a responsible assistant to work with personal social networks, a contact database, and current projects in the field of science and scientific publications. At the first stage, the collaboration is planned for one month. The main task is to assist with basic… Information Gathering, Data Processing ∙ 5 days 19 hours back ∙ 11 proposals |
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 7 days 18 hours back ∙ 22 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 7 days 18 hours back ∙ 20 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 10 days 4 hours back ∙ 14 proposals |
Kyiv