Hey, I was originally trying the Data warehouse with a bunch of eVars
and metrics, and it can build a flat report table with some format like
this:Date, evar1, evar2, evar3, evar4, evar5, metric1, metric2, metric3.
I'm trying to folk this report with Analytics Reporting API, but found
it only support at most 3 elements as breakdowns, is there anyway I can
mimic the request with Data warehouse? Thanks a lot!
Hey sorry,Can I ask one more question here? Thanks!I'm trying to use
these "start" and "top" params for paging, but seems when I selected
multiple metrics (> 1) in the report, the non-last paging looks NOT
sorted. While the last page looks sorted. For example: (sorted by the
first metric.1. first page with (top = 3, startingWith = 0), Got
response: count: [3, 0, 1]; [3, 0, 2]; [3, 0, 4];2. second page with
(top = 3, startingWith = 3); (Last page)Got response:count: [2, 0, 3];
[2, 0, 2].
Great, thanks a lot!So to get the row count, I need to save a calculated
metric for calculating the row count, and then use that number to make
my report requests, right?Once I shard the requests into several chunk,
I can always assume the data in between each sharded requests will have
NO overlap data, right?
I'm using Analytics API directly, is there a param to set enqueueOnly ==
TRUE? Or this is set by default? I'm using the function Report.Queue()
to get the reportId, and use Report.Get(). So do this mean roughly if I
originally used 1 single request, and get the entire report after 4
mins. And now I split into 4 requests, and send them to the API queue,
suppose currently the queue only contains these 4 requests, do that mean
I can get these 4 responses in 1 min (as each request contains only 1/4
Thanks for the reply. My current API request is like
Hey,I'm trying to send multiple requests for a single report suites for
paging report with params "TOP" and "STARTINGWITH". Is that possible I
can send these paging requests in parallel? Will the API prepare the
report for this sequentially or also in parallel? I'm basically
concerned about the cardinality. As the estimated row number can be 1M,
so I plan to send multiple requests in parallel instead of sequentially,
wondering if this can speed up my downloading time in total?
Hey,I'm trying to request a hourly trended report through API request,
it'll always returned 24 * daily report rows, even some rows the metrics
count are all zero. Is there any way I can filter out with only non-zero
metric counts returned through hourly report?Thanks!