Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Report Builder Query Design in Excel

Avatar

Level 9

4/18/18

It would be great if we could design our query in excel and have the plugin check the design for errors to create blocks.  Creating report blocks would become much faster.  Given the recent enhancements to wizard i would anticipate this to be a difficult task.  Let me know.

5 Comments

Avatar

Level 9

4/19/18

Hi Jenn...

I am not sure if you are referring to writing actual SQL queries or something else - but I guess it would be similar.  See below for an example input to initiate a report block.  You could either VBA it, or just have it in cells (i think cells would be better for the audience).

  

FieldValue
Report Suitemy.report.suite
SegmentAll Visits
Date From:1/1/2018
Date To:1/5/2018
GranularityDay
ReportLast Touch Channel
Report Items10
DimensionDevice Type
Dimension Items10
MetricsVisits, Conversion Rate

Insert Location

Offline

worksheet!B11

true