Google Ads Connector Doesn't Match Google Dashboard Numbers

[trevorsherpr]

Hello,

I have connected my Google Ads to Power BI using the built in connector and have got Adwords campaign costs. Happy Days!

But, the numbers coming into Power BI don't agree to the numbers in Google Ads dashboard.

For yesterday the connector is saying £418 and the dashboard is saying £303.19 the exact same campaign.

I suspected that it could be a currency conversion things where the connector is giving me dollars. But $418 equals £346.

So it doesn't seem like that is the problem.

Any ideas chaps?

Trev

[Adel]

yes Power bi google ads's native connector default to us dollars and also messes up with the date also and it follows how they use it in the us.
Have you tried using a third-party connector? might be a solution

[Adel]

there is this tool called windsor.ai which lets you preview your data before sending to power bi as shown below

https://windsor.ai/connect-google-ads-to-power-bi/

[amitchandak]

@trevorsherpr , Can you check if the complete data is loaded. Check the number of rows in data view.

Also open and check power query for any errors

[trevorsherpr]

The query that i chose in the connector only gives me 1 line per day per campaign. So it's not possible to see the breakdown any deeper.

I also watched the traffic using Fiddler and there were no errors.

Any idea if the Google connector defaults to US dollards?

Trev