Creating a dashboard in Looker Studio with integration of Google Ads, Meta Ads, and PIMS

Contextual Advertising, Lead Generation & Sales — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

A dashboard needs to be developed in Looker Studio with data connections from Google Ads, Meta Ads (Facebook/Instagram Ads), and internal PIMS.

Tasks:

Connect data sources:
- Google Ads
- Meta Ads;
- PIMS (via API, CSV/Google Sheets, or another agreed method).
Normalize and link data between sources (campaign matching, UTM, SKU, or other keys).
Build a dashboard with key metrics:
- cost, clicks, impressions, CTR, CPC, CPM;
- conversions, CPA, ROAS, revenues (if needed from PIMS);
- metrics by campaigns, ad groups, creatives, and sales (link to PIMS).
Implement filtering and segmentation:
- filter by campaigns, dates, channels (Google/Meta).
- ability to compare periods.
Document the connection of sources, data transformations, and instructions for using the dashboard.

Proposals 2 Discussions

Bohdan Melnyk

4 0

Budget: 7000 UAH Deadline: 7 days

Good day! I have been assembling such dashboards in Looker Studio — Google Ads and Meta are pulling in fine with connectors, but the bottleneck here is always PIMS. Let me ask right away: does it provide API or exports, and is there UTM or SKU inside to match sales with campaigns? If there is no such key, I will have to create a mapping table manually, and this is the main factor affecting the timeline. I will handle period comparisons and channel filters right away; that’s already routine.

Oleh Kostyliev

12 0

Budget: 1200 UAH Deadline: 7 days

Good day, Anastasiia!

Your task regarding the development of a dashboard in Looker Studio with data integration from Google Ads, Meta Ads, and PIMS is interesting and relevant. I have experience in creating analytical tools that help businesses optimize their advertising campaigns.

To effectively execute the project, it is important to thoroughly study your data and understand the specifics of the business. This will allow us to configure the dashboard to best meet your needs.

Initially, I propose:
1. Gaining access to data from Google Ads, Meta Ads, and PIMS.
2. Defining the key metrics you want to track.
3. Conducting a preliminary data analysis for normalization and connecting sources.

My preliminary cost estimate for the project is from $400 per month. The implementation of the dashboard may take from 2 to 4 weeks, depending on the complexity of the data integration.

In my profile, you can find examples of similar projects that confirm my skills.

I suggest discussing the details of your project in private messages to understand your goals and formulate an action plan.

Anastasiia Nazarenko
Khmelnitskyi, Ukraine

Projects 6
Rating 5.0
Rating 237

Creating a dashboard in Looker Studio with integration of Google Ads, Meta Ads, and PIMS

Bohdan Melnyk

Oleh Kostyliev

Proposals are currently absent

No comments yet