AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2K members online now
2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Percentage Error

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I am trying to setup a new Scorecard.

 

However, looks like percentage change has incorrect values.

 

My settings:

Data Source: Adwords

Metric: Conversions

 

Date range: Last week (Starts Monday) - I want to compare W15 -10th April to 16th April vs W15 - 11th April to 17th April

Compare to Previous Year

 

In this case, my current value is 142

The percentage difference shows 16.39%

However, the previous period is 113

 

If I calculate, the actual % increase is 25.66%

 

My question: When we choose, compare to previous period, does it compare to exact dates or weeks?

 

If it compares to dates, is it possible to compare to weeks?

Percentage Error

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

I believe it compares exact dates (4/10-4/16 this year vs the same dates last year), not corrected for day of the week.

Percentage Error

Participant ✭ ✭ ☆
# 3
Participant ✭ ✭ ☆

I believe there's an ISO week dimension - I think that this is the week number of the year, so that might be what you need. But definitely double check that that's in fact it as I'm not 100%.