Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Pls. help suggestions method for get data Google Adwords.
Hi @Warunyak Since there’s no built-in connector for Google Ads to PBI anymore, you will 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
Hi @Warunyak,
The screenshot shows dimensions and metrics for the Adwords, you can select one dimension and one metric to show data, eg:
You can go through this article to know the meaning of dimensions and metrics: https://developers.google.com/analytics/devguides/reporting/core/dimsmets#cats=adwords
Best Regards,
Qiuyun Yu
Thank you for reply. I was try. I want to below column. Persent I'm using Google Studio for export to excel but I want to get data by connector google analytic on Power BI.
Hi @Warunyak,
In Google Studio explorer, you can click on the metric or dimension to find which feature is the metric or dimension belong to, then select corresponding metric or dimension in Power BI desktop. For example, you can click on Cost metric, then it will show the Cost is belong to the Adwords.
In Power BI desktop, when you connect to Google Anaylytics, you can select the Cost as below:
Best Regards,
Qiuyun Yu
Thank you. I don't see date.
Hi Warunyak
I looked at getting data out of GA but it just didn't have all the KPIs I required. I got arount the problem by creating Ads Scripts in Google Ads which then expored the data into Google Sheets. From there I was able to directly bring the data into Power Bi. I scheduled the script to run every 60 days so now I have up to date information at the touch of a button.
You can read my article here: http://www.mileswoolgar.com/blog/google-ads-to-power-bi-for-free/
I hope you find this useful.
Miles
Hi, i was trying to look at your solution that you wrote about in your blog although this now (several years later) redirects to a job leads website. Beware as unfortunately this is no longer helpful. Surprised there is still no connector to get all of Adwords Metrics (Google analytics doesn't bring in all metrics such as 'conversions') into Power bi.
Dear,
do you know where I should find the Conversion Rate in Google Adwords of Power Bi?
Hope to hear from you!!
Thanks!
Hi @Warunyak,
You can find date in Time feature: https://developers.google.com/analytics/devguides/reporting/core/dimsmets#cats=time
Best Regards,
Qiuyun Yu
Thank you for help. I have error some records about column cost. DataFormat.Error: We received unexpected data for a column of type 'Currency'.
How to solve error format currency?
{Cube.AddAndExpandDimensionColumn, "ga:adwordsCampaignID", {"ga:adwordsCampaignID"}, {"Google Ads Campaign ID"}},
{Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
{Cube.AddAndExpandDimensionColumn, "ga:day", {"ga:day"}, {"Day of the month"}},
{Cube.AddAndExpandDimensionColumn, "ga:dayOfWeek", {"ga:dayOfWeek"}, {"Day of Week"}},
{Cube.AddAndExpandDimensionColumn, "ga:dayOfWeekName", {"ga:dayOfWeekName"}, {"Day of Week Name"}},
{Cube.AddAndExpandDimensionColumn, "ga:week", {"ga:week"}, {"Week of the Year"}},
{Cube.AddAndExpandDimensionColumn, "ga:year", {"ga:year"}, {"Year"}},
{Cube.AddMeasureColumn, "Cost", "ga:adCost"}
})
Thank you.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |