Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Report Builder Query Design in Excel

Avatar

Avatar
Give Back 3
Level 9
MichaelWon
Level 9

Likes

446 likes

Total Posts

91 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 5
Ignite 3
Give Back
Ignite 1
View profile

Avatar
Give Back 3
Level 9
MichaelWon
Level 9

Likes

446 likes

Total Posts

91 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 5
Ignite 3
Give Back
Ignite 1
View profile
MichaelWon
Level 9

18-04-2018

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.

4 Comments

Avatar

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile
jen_lasser
Moderator

19-04-2018

Hi Michael - are you suggesting something like SQL capabilities in a cell that RB could interpret? Let me know!

Avatar

Avatar
Give Back 3
Level 9
MichaelWon
Level 9

Likes

446 likes

Total Posts

91 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 5
Ignite 3
Give Back
Ignite 1
View profile

Avatar
Give Back 3
Level 9
MichaelWon
Level 9

Likes

446 likes

Total Posts

91 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Ignite 5
Ignite 3
Give Back
Ignite 1
View profile
MichaelWon
Level 9

19-04-2018

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

Avatar

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile

Avatar
Validate 1
Moderator
jen_lasser
Moderator

Likes

119 likes

Total Posts

317 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Give Back 25
Ignite 3
Ignite 1
Give Back 5
View profile
jen_lasser
Moderator

19-04-2018

Ah ha, that makes sense. Thanks for clarifying! We will take this into consideration.

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

360 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

360 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived