cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Warunyak Frequent Visitor
Frequent Visitor

How to Accessing Google Adwords Campaign Via Power BI

8 REPLIES 8
Moderator v-qiuyu-msft
Moderator

Re: How to Accessing Google Adwords Campaign Via Power BI

Hi @Warunyak,

 

The screenshot shows dimensions and metrics for the Adwords, you can select one dimension and one metric to show data, eg:  

 

q4.PNG

 

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Warunyak Frequent Visitor
Frequent Visitor

Re: How to Accessing Google Adwords Campaign Via Power BI

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.

2018-08-15_10-17-21.png

Moderator v-qiuyu-msft
Moderator

Re: How to Accessing Google Adwords Campaign Via 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. 

 

q2.PNGq3.PNG

 

In Power BI desktop, when you connect to Google Anaylytics, you can select the Cost as below: 

 

q4.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Warunyak Frequent Visitor
Frequent Visitor

Re: How to Accessing Google Adwords Campaign Via Power BI

Thank you. I don't see date.

Moderator v-qiuyu-msft
Moderator

Re: How to Accessing Google Adwords Campaign Via Power BI

Hi @Warunyak,

 

You can find date in Time feature: https://developers.google.com/analytics/devguides/reporting/core/dimsmets#cats=time

 

q9.PNG

 

q0.PNG

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Warunyak Frequent Visitor
Frequent Visitor

Re: How to Accessing Google Adwords Campaign Via Power BI

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.

mwoolgar Frequent Visitor
Frequent Visitor

Re: How to Accessing Google Adwords Campaign Via Power BI

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

Anonymous
Not applicable

Re: How to Accessing Google Adwords Campaign Via 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!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)