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
2.3K members online now
2.3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Data Studio, Google Spreadsheets, and Comparing YoY data

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,


I am looking to compare an entire year over year performance.

 

The dimensions are:

  1. Source
  2. Medium
  3. Campaign
  4. Year

The metrics are:

  1. sessions
  2. transactions

Using a table, i am looking to display sessions by source and delta YoY.  however, i am getting a configuration error. 

 

Here's what the table properties look like - http://cloudapp.pixelgroove.com/1d1U0f0e2f0S

 

The spreadsheet data is - http://cloudapp.pixelgroove.com/35050Q0u2Q1H

 

The "date" column is formatted as http://cloudapp.pixelgroove.com/1Y3d0n1v0q1k

 

What am I doing wrong?

 

Thank you in advance,

Udi