{"id":948,"date":"2017-06-15T17:33:13","date_gmt":"2017-06-15T08:33:13","guid":{"rendered":"http:\/\/help.glu.jp\/en\/?p=948"},"modified":"2018-11-21T17:57:59","modified_gmt":"2018-11-21T08:57:59","slug":"tag-directives-2","status":"publish","type":"post","link":"https:\/\/help.glu.jp\/en\/tags\/tag_basics\/tag-directives-2\/","title":{"rendered":"Tag Directives"},"content":{"rendered":"

This is a list of tag directives.
\nPlease see the examples that follow.<\/p>\n

\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Directive Name<\/strong><\/td>\nFunction<\/strong><\/td>\n<\/tr>\n
TYPE<\/a><\/td>\nSpecifies tag category.<\/td>\n<\/tr>\n
EDIT<\/a><\/td>\nSpecifies edit format.<\/td>\n<\/tr>\n
CELL<\/a><\/td>\nSpecifies cell to begin output.<\/td>\n<\/tr>\n
DATA<\/a><\/td>\nSpecifies type of data.<\/td>\n<\/tr>\n
HEADER<\/a><\/td>\nSpecifies whether or not to export CSV header.<\/td>\n<\/tr>\n
START_AT<\/a><\/td>\nSpecifies start date of report data.<\/td>\n<\/tr>\n
END_AT<\/a><\/td>\nSpecifies end date of report data.<\/td>\n<\/tr>\n
GROUP<\/a><\/td>\nSpecifies\u00a0the report category.<\/td>\n<\/tr>\n
ASPECT<\/a><\/td>\nSpecifies aggregate format of data.<\/td>\n<\/tr>\n
DAILY_LEVEL<\/a><\/td>\nSpecifies time frame used for aggregation.<\/td>\n<\/tr>\n
FROM_LEVEL<\/a><\/td>\nSpecifies source of aggregation level.<\/td>\n<\/tr>\n
ANTE_FILTER<\/a><\/td>\nSpecifies media filter.<\/td>\n<\/tr>\n
SEGMENT<\/a><\/td>\nSpecifies device filter.<\/td>\n<\/tr>\n
SHOW_SEGMENT<\/a><\/td>\nSpecifies display of device types.<\/td>\n<\/tr>\n
MEDI_FILTER<\/a><\/td>\nSpecifies detailed filter.<\/td>\n<\/tr>\n
POST_FILTER<\/a><\/td>\nSpecifies metric filter.<\/td>\n<\/tr>\n
SERIES<\/a><\/td>\nFurther segments data specified in ASPECT by day, month, etc.<\/td>\n<\/tr>\n
FLAT<\/a><\/td>\nVertically aligns SERIES data.<\/td>\n<\/tr>\n
ITEMS<\/a><\/td>\nSpecifies data items to export to Excel.<\/td>\n<\/tr>\n
SORTS<\/a><\/td>\nSort data in increasing\/decreasing order.<\/td>\n<\/tr>\n
SHIFT<\/a><\/td>\nSpecifies display orientation.<\/td>\n<\/tr>\n
SUM<\/a><\/td>\nSpecifies position of Totals row.<\/td>\n<\/tr>\n
COUNT<\/a><\/td>\nSpecifies maximum rows of report data.<\/td>\n<\/tr>\n
ROUND_UP<\/a><\/td>\nCollapses data exceeding maximum number of data rows specified by COUNT into \u201cOthers\u201d row.<\/td>\n<\/tr>\n
SELECTOR<\/a><\/td>\nUsed to filter dice directly below.<\/td>\n<\/tr>\n
SHOW_ALL_ASPECT_ROWS<\/a><\/td>\nUsed to display rows of items below with no data.<\/td>\n<\/tr>\n
PAGES<\/a><\/td>\nSpecifies sheets to copy in Copy Sheet tag.<\/td>\n<\/tr>\n
OPTIONS<\/a><\/td>\nUsed for customized options.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

DIRECTIVES NOT USED IN\u00a0EXCEL REPORTS<\/h2>\n

There are a few directives listed on the report tag exported by dice that are not actually used in the reports. These directives are utilized only on the glu dashboard. Deleting the following directives from the tag will not affect the exported report.<\/p>\n

\n\n\n\n\n\n\n
Directive<\/strong><\/td>\nFunction<\/strong><\/td>\n<\/tr>\n
ATTR_SELECT<\/td>\nRepeats selected items on glu dashboard under [View > Repeat Col.]
\nSpecify items numbers to accomplish this on the tag.<\/td>\n<\/tr>\n
TRANSPOSE<\/td>\nTransposes columns and rows on glu dashboard under [View > Transpose table]
\nSpecify SHIFT=right to accomplish this on the tag.<\/td>\n<\/tr>\n
SHOW_SUM<\/td>\nIndicates “Totals Row” under View > Table on glu. On the tag, use\u00a0SUM<\/a>\u00a0to determine placement of Totals Row.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\u2191<\/a><\/div>\n

DIRECTIVE VALUES<\/h2>\n

TYPE<\/h3>\n
\n

Tag Categories.<\/p>\n\n\n\n\n\n\n
Value<\/b><\/td>\nFunction<\/strong><\/td>\n<\/tr>\n
table<\/td>\nTable format<\/td>\n<\/tr>\n
chart<\/td>\nChart format (pasted over the chart)<\/td>\n<\/tr>\n
book<\/td>\nSheet Format
\nNote: This TYPE is for copying sheets. By using\u00a0PAGES<\/a>\u3001EDIT=copy_straight OR copy_tuple<\/a>\u00a0, you can make sheet copies for number of data aspect items.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\u2191<\/a><\/div>\n

EDIT<\/h3>\n
\n

Edit Format.<\/p>\n\n\n\n\n\n\n\n\n\n
Value<\/b><\/td>\nFunction<\/b><\/td>\n<\/tr>\n
paste<\/td>\nPaste data.<\/td>\n<\/tr>\n
paste_extend<\/td>\nCopy format of first row & and paste data.<\/td>\n<\/tr>\n
insert<\/td>\nInsert rows above and paste data.<\/td>\n<\/tr>\n
insert_after<\/td>\nInsert rows below and paste data.<\/td>\n<\/tr>\n
copy_straight<\/td>\nMimics order of multiple sheets when copying sheets.<\/td>\n<\/tr>\n
copy_tuple<\/td>\nCopies sheets based\u00a0on Sheet Copy tag’s aspect.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u203b\u3000Points to note when using insert\u3001insert_after\u00a0<\/strong>
\n1. Formatting Shapes<\/strong>
\nDue to Excel specifications, tags may be unintentionally copied during report compilation. In order to avoid this, we recommend setting the tag (recognized a shape by Excel) with the following procedure.<\/p>\n