Incorrect Transactions/Revenue data in Data Studio report
I have created a report with impressions, clicks, cost, revenue and transactions for AdWords traffic data using GA as the data source.
The impressions, clicks and cost all match up perfectly but the transactions and revenue are way off.
The report uses a custom "date" dimension (using the format YYYYMMDD) to create fiscal months and it also has a filter which filters based on AdWords account & campaign names.
Is it the date format which is causing the issues? Does it need to be in a different format maybe? It just seems weird that half of the metrics are spot on but the transactions/revenue are way off.