Adsense and BigQuery

[Evgeny P]

I used https://bigquery.cloud.google.com/ 

query 

SELECT

    clicks,

    individual_ad_impressions,

    matched_ad_requests,

    clicks/individual_ad_impressions CTR,

    earnings/clicks CPC,

    earnings/individual_ad_impressions*1000 CPM,

    earnings,

    ad_unit_name,

    ad_unit_id,

    country_code

FROM

[google.com:adsense-reports:Reports.DailyAdUnitReport]

WHERE date = '2014-01-24'

ORDER BY

earnings DESC

Why I got 

Query Failed

Error: Unexpected. Please try again.

Job ID: job_U3BhovD3W_i8UR7NDpDyY_gCkT4

What's wrong with it?

Thank you!

[Sérgio Gomes (AdSense API Team)]

Replying privately to the thread for account details.

Cheers,

Sérgio

---

Sérgio Gomes

Developer Relations

Google UK Limited

Registered Office: Belgrave House, 76 Buckingham Palace Road, London SW1W 9TQ

Registered in England Number: 3977902