GoogleAnalyticsSource fetching only partial data

Sep 29, 2011 at 7:59 PM

Hi Tillman,

Thanks for adding custom dimensions. However, now I see another issue.

I created a package with GoogleAnalyticsSource Source and Oledb destination. I select Date, Keyword, medium, source, and custom variable dimension. For Metrics, I select New Visits, Visitors, and Visits. When I run this package for 1 month, I get about 4000 rows. I also have a Pentaho package with same setting, but that returns about 50,00 rows, which is same as what I see in the Google Analyitcs website. I am not sure whats going wrong. Please help.

Thanks,

AShish

 

Coordinator
Sep 30, 2011 at 3:12 AM

Hi Ashish,

can you check if it is a problem with the number of rows or with the query? Do you get more than 4000 rows with another query? When you change the period to 2 or 3 days, do you get the same rows in all 3 applications?
Do you use more than one custom variable dimension?

Cheers,

Tillmann