This is a list of tag directives.
Please see the examples that follow.

DIRECTIVES NOT USED IN EXCEL REPORTS

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.

DIRECTIVE VALUES

TYPE

EDIT

※　Points to note when using insert、insert_after 
1. Formatting Shapes
Due 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.

• Select the tag.
• Right click, select “Format Shape”.
• Click “Size and Properties”.
• Open “Properties”.
• Select “Don’t move or size with cells”.

2.Tag Compilation Order
When compiling multiple tags within one sheet, compilation will begin with the bottom-most tag.
To make sure rows insert in the right order, start by placing tags belonging to the lowest rows at the very bottom, and work upwards.

※ This can be easily done with Excel’s Selection Pane. Please see Showing/Hiding Tags.

■ Using EDIT
paste、insert
Paste overwrites rows lying directly beneath the tag.
Insert inserts new rows according to the number of data items. Use insert when you have pre-entered items (such as totals rows) or placed other tags in rows below the tag.

insert_after
Inserts rows downwards according to number of data items.
Useful when outputting stats totals with SUM functions or shifting cell addresses downwards.

copy_straight & copy_tuple
These EDITS are for making sheet copies.
Use along with PAGES and TYPE=book to make a sheet copy for each item.

CELL

Examples

DATA

Ex.

HEADER

Examples

START_AT / END_AT

※Cases where you specify “from” will represent a day relative to the reference date.

The Reference Date is the day that serves as a reference at the time of compilation.
For manual compilation, the reference date will be the same as the date designated on the left under the Report tab “Period”.
For the auto-generated report, you can specify the Reference Date per Report Condition.

Example

Value	Function
START_AT=from,day,0,0 END_AT=from,day,0,0	Fetch data of Reference Date.
START_AT=from,day,29,0 END_AT=from,day,0,0	Fetch data of past 30 days from Reference Date.
START_AT=from,month,0,1 END_AT=from,month,0,-1	Fetch data from 1st to last day of month of Reference Date.
START_AT=from,month_last,0,34 END_AT=from,month,0,-1	Fetch data of past 34 days from end of month of Reference Date.
START_AT=from,year,0,1 END_AT=from,year,0,-1	Fetch data of January to December of year of Reference Date.
START_AT=at,20xx-01-16 END_AT=at,20xx-02-15	Determine period directly
START_AT=at,${CELL_VALUE=’Sheet Name’!A5} END_AT=at,${CELL_VALUE=’Sheet Name’!A6}	Refer to cell value. ※1 May be on separate sheet.

Note: To reference the value of a cell where you have fetched the reference date via a tag, place the tag fetching the reference date as the bottom-most tag to ensure it executes first. Please see Tag Summary＞ 5. Showing/Hiding Tags when adjusting the compilation order of tags.

GROUP

ASPECT

DAILY_LEVEL

FROM_LEVEL

ANTE_FILTER

SEGMENT

Specifies aggregation method for device segmentation.

Variables
C: PC
T: Tablet
M: Smartphone
O: Other feature phones, game consoles, etc.

SHOW_SEGMENT

Specify the display format of device types when segmenting Aspect by device.
※ SHOW_SEGMENT may be used in conjunction with SEGMENT.
※ Device is the only segmentable item.

To export tags from the glu UI to display device types:

1. Select a dice for reporting.
2. Open Report tab.
3. Open Data.
4. Select Campaign as (example) Aspect.
5. Under Segment select a Device(s).
6. Open View.
7. Under Segment select First column segmented by aspect.
8. Click Export.
9. Select Report Tag.

MEDI_FILTER

Report Filtering Conditions

With MEDI_FILTER you can filter pre-aggregated data even more flexibly.
You can define conditions for filtering by device. In addition, you can specify custom conditions or filter according to media structure (campaign, ad group, keyword, etc.)

■　Defined Conditions
Conditions for filtering by device.
※　SEGMENT specification is necessary for device filtering.

To specify custom values in addition to device filtering, separate the two with “&” such as below.
MEDI_FILTER=report_medi_filter_segment_device:ctm&report_medi_filter_custom:"CP.name='Campaign1'"

■ Specifying Conditions for Custom Filtering

You can filter by account ID, campaign name, exact match or broad match conditions, etc.

Points to Heed

1. When using LIKE, use the following 2 characters as a wildcard.
   

   %	Random character string over 0 characters
   _	Random 1 character

2. For filtered items including symbols, insert ¥¥ before the object name to recognize it as a character string.
   

   %	percent
   _	underscore
   “	quotation mark
   ‘	single quotation mark

   Ex. 1）Filter campaign names ending in “100%”
   Add a “¥¥” before “%” part of campaign name
   MEDI_FILTER=report_medi_filter_custom:"CP.name LIKE '%100¥¥%'"

Example Conditions
Examples of possible medi_filter custom conditions

• • Filter by campaign name
    MEDI_FILTER=report_medi_filter_custom:"CP.name='Campaign1'"
  • Filter all items except for particular campaign name
    MEDI_FILTER=report_medi_filter_custom:"CP.name!='Campaign1'"
  • Filter campaign names beginning with “Remarketing”
    MEDI_FILTER=report_medi_filter_custom:"CP.name LIKE'Remarketing%'"
  • Filter campaign names ending with”/RM”
    MEDI_FILTER=report_medi_filter_custom:"CP.name LIKE'%/RM'"
  • Filter campaign names containing “CT”
    MEDI_FILTER=report_medi_filter_custom:"CP.name LIKE'%CT%'"
  • Filter multiple campaign names
    MEDI_FILTER=report_medi_filter_custom:"(CP.name='Tokyo' OR CP.name='Singapore')"
  • Filter campaign names containing “CT” or “RM”
    MEDI_FILTER=report_medi_filter_custom:"(CP.name LIKE'%CT%' OR CP.nameLIKE'%RM%')"
  • Filter all campaign names except those containing “CT” or “RM”
    MEDI_FILTER=report_medi_filter_custom:"(CP.name NOT LIKE'%CT%' AND CP.name NOT LIKE '%RM%')"
  • Filter ad group names starting with “DOCOMO”
    MEDI_FILTER=report_medi_filter_custom:"AG.name LIKE'DOCOMO%'"
  • Filter all keywords containing “Tokyo”
    MEDI_FILTER=report_medi_filter_custom:"CR.name LIKE'%Tokyo%'"
  • Filter all ad names beginning with “Responsive”
    MEDI_FILTER=report_medi_filter_custom:"AD.ad_type LIKE 'Responsive%'"
  • Filter all ads names not containing “TEXT”
    MEDI_FILTER=report_medi_filter_custom:"AD.ad_type NOT LIKE '%TEXT%'"
  • Filter image sizes containing “300”
    MEDI_FILTER=report_medi_filter_custom:"AD.image_size LIKE'%300%'"
  • Filter image sizes of 300×250
    MEDI_FILTER=report_medi_filter_custom:"AD.image_size='300x250'"
  • Filter by keyword match type
    MEDI_FILTER=report_medi_filter_custom:"CR.match_type='EXACT'"

   

  Keyword Match Type	Function
  EXACT	Exact match
  BROAD	Broad match, Broad match modifier
  PHRASE	Phrase match

  Filter by Google AdWords campaign types

  • Filter by Video campaigns
    MEDI_FILTER=report_medi_filter_custom:"CP.campaign_type IN ('VIDEO')"
  • Filter by Shopping Campaigns as well as Campaign names beginning with “Spring SALE”
    MEDI_FILTER=report_medi_filter_custom:"CP.campaign_type IN ('Shopping') AND CP.name LIKE 'Spring SALE%'"
  • Filter Universal App Campaigns ※ Specify as a CP.sub_type
    MEDI_FILTER=report_medi_filter_custom:"CP.sub_type IN ('Universal App Campaign')"

   

  Campaign Type	Details
  Search	Search network campaign
  Display	Display network campaign
  Shopping	Shopping campaign
  Video	Video campaign
  Universal App Campaign	Universal App campaign ※ Specify as a CP.sub_type

• Filter Facebook Ads and Instagram platforms
  MEDI_FILTER=report_medi_filter_custom:"RR.network_id = '16777282'"

  Platform Number	Platform
  66	FACEBOOK
  16777282	INSTAGRAM
  98	AUDIENCE_NETWORK
  194	MESSENGER
  65536	UNKNOWN

■　Values that can be used in Custom Conditions
・Metric and Attribute Examples

・Media/Tool Identifiers

※ Please contact our Support Team about all other conditions.

POST_FILTER

Report Filtering Conditions.

Applies to post-aggregated data.

■　Defined Conditions

■　Conditions for Custom Filtering
Please refer to the following as examples for possible filtering conditions.

Filtering impressions of 1000 or greater

POST_FILTER=report_post_filter_custom:"SUM(report_imps)>1000"

■　Values Used for Custom Filtering

※Above conditions may be added or modified in dice type settings.

SERIES

Segment data aggregated by ASPECT even further by week, month, etc.

Ex.

Campaigns Per Day

FLAT

Vertically align the table created in SERIES.

Ex. Specify FLAT=1

ITEMS

Specifies item numbers of data items to be exported in the report.

Outputting several items

Separate item numbers with commas.
Ex. ITEMS=1,2,3,7,8,9

Skipping columns

Data will not output to columns denoted with zeros. Use “0” to skip columns where you have set up Excel Functions.
Ex. ITEMS=1,2,3,7,0,8,9

New line

Insert “b” instead of an item number to start a new line from that column.
Ex. ITEMS=1,2,3,7,b,8,9

Special Case: Exporting Images to Ad Reports

Insert “=IMG(number)” to output an ad image..
In the “number” section, fill in the item number of the ad title.
Ex.
ITEMS=　=IMG(17),1,2,3
ITEMS=1,2,3,=IMG(15)

Special Case: Joint usage with SERIES

・Use “=top()” to extract the first value appearing in the repetitive sequence in SERIES.
Format:=top(1st ITEMS number * 2nd ITEMS number of same item – 1st ITEMS number)
Please confirm ITEMS numbers on the tag you are using.
Ex. ITEMS=1,2,3,=top(8*100),9

Usage: When you want to output account attributes (such as account IDs) to the Account Daily Report.

Ex. When outputting the daily report with SERIES without FLAT=1, accounts with impartial data, such as Account B and C below without impressions on 2/1, will also be included. You can dynamically output the account IDs for these accounts, even for dates with impartial report data.
Only Account A’s ID will output when denoting Account IDs for 2/1. There is also the possibility of dates with no stats for any account.
Using “=top()” can clear these sort of issues. It will automatically adopt the account ID of the first day with stats for any particular account.

SORTS

Sorts the data order.

Specify the column numbers (from the CSV file) of the data items you wish to sort.

Increasing & Decreasing Order

Add a minus sign to sort in decreasing order.

Sorting Multiple Items

To specify multiple items separate with a comma. When the previous column contains the same stat multiple times, you can sort based on stats in latter columns.
Ex. Sort Conversions, Clicks, and Impressions in decreasing order.

How to Verify Sort Numbers

From the Report tab, download the Report Tag or CSV file under “Export”.

• CSV file
  Specify column numbers.
  
• Report Tag
  Specify Item numbers.
  

SHIFT

Specifies display orientation.

Ex.
Without SHIFT

With SHIFT=right

SUM

COUNT

Specifies maximum rows of report data.

Ex. Total of 15 rows with count unspecified (Shows all rows).

Ex. Total of 15 rows with COUNT=5 (Shows 5 rows).

ROUND_UP

Bundle remaining rows from COUNT into “Others” row.

SELECTOR

Specifies dice directly below.

・Dice Type,Attribute Name==’Value’
Note: May denote Comparison Expression with “=”.
“!=” (except for)、”>”、”<“、”>=”、”<=”

・Specifying Multiple Dice
OR →　||
AND →　&&

Ex.
SELECTOR=client,name==’YSS_PC’

SHOW_ALL_ASPECT_ROWS

PAGES

OPTIONS