Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Google adwords cost product groups

Hi All,

 

We would like to know the Google Adwords Costs per product. The Google Ads: Ad Group is not specific enough. Is this possible to retreive?

 

I search for similar issues but the only one close was this one from 2018 --> https://community.powerbi.com/t5/Desktop/Product-groups-by-cost-of-Google-Analytics/td-p/568535

 

Hope you can help me...Thanks!

 

RHBIP_0-1638906816674.png

 

2 REPLIES 2
QueryWhiz
Post Patron
Post Patron

Hi @Anonymous I know this reply is very late. Since there’s no built-in connector for Google Ads to PBI anymore, you would have to look for another way. As a workaround, maybe you can use a 3rd party connector, it can save you a lot of time compared to the other options. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Google Ads connector in the data sources list:

 

GOOGLE-ADS-1.jpg

 

After that, just grant access to your Google Ads account using your credentials, then on preview and destination page you will see a preview of your Gads fields:

 

GOOGLE-ADS-2.jpg

 

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

 

SELECT_DESTINATION_NEW.png

V-lianl-msft
Community Support
Community Support

Hi @Anonymous ,

 

When using dimensions in a data request, be aware of the following constraints:

  • You can supply a maximum of 7 dimensions in any query.
  • You can not send a query composed only of dimensions: you must combine any requested dimensions with at least one metric.
  • Only certain dimensions can be queried in the same query. Use the valid combination tool in the Dimensions and Metrics Reference to see which dimensions can be used together.

When requesting metrics, keep in mind:

  • Any request must supply at least one metric; a request cannot consist only of dimensions.
  • You can supply a maximum of 10 metrics for any query.
  • Most combinations of metrics from multiple categories can be used together, provided no dimensions are specified.
  • A metric can be used in combination with other dimensions or metrics, but only where valid combinations apply for that metric. See the Dimensions and Metrics Reference for details.


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.