Supermetrics Drive Plugin Vs Supermetrics Functions

[Mark Brady]

Hello,

I've only just noticed Supermetrics Functions exists. I've been having a play and it does a job I've previously worked around with the Google drive plugin adapting the 'SupermetricsQueries' tab to use CHAR(34) to pass an ' (Apostrophe) in filters. For example this GA filter...

="[{"&CHAR(34)&"field"&CHAR(34)&":"&CHAR(34)&"PagePath"&CHAR(34)&","&CHAR(34)&"operator"&CHAR(34)&":"&CHAR(34)&"=@"&CHAR(34)&","&CHAR(34)&"value"&CHAR(34)&":"&CHAR(34)&'Campaign Details'!B3&"-"&'Campaign Details'!B4&"-1.html"&CHAR(34)&","&CHAR(34)&"combineToPrev"&CHAR(34)&":"&CHAR(34)&";"&CHAR(34)&"}]"

This means I can use a single template that changes when the campaign details are entered.

This is quite long winded and resolved in Supermetrics Functions, but having issues doing any deep filtering. Could you answer the following about Supermetrics Functions...

1. On YouTube tab 'insightTrafficSourceDetail / insightPlaybackLocationDetail' doesn't work.
   
2. How often does the sheet refresh with new data?
   
3. Is this the better option to use for lots of data or is the Drive plugin better option?
   
4. Any other advantages / disadvantages compared to the Drive plugin?
   

I did check the advantages on the site, but wanted to be 100% clear on my best option.

Thanks

[Mikael Thuneberg]

 

1. On YouTube tab 'insightTrafficSourceDetail / insightPlaybackLocationDetail' doesn't work.
   

Can you provide details of the query and error please? It's quite limited which metrics and dimensions are compatible with these, you should try with video views only.

1. How often does the sheet refresh with new data?
   

In Excel, if Excel's calculation setting is automatic, they refresh whenever you open the file, or any of the parameters change. If calculation is set to manual, you can refresh with F9.

In Google Drive, they refresh when any of the parameters change.

1. Is this the better option to use for lots of data or is the Drive plugin better option?
   

In Google Drive, using the add-on is better, as Google restricts the time custom functions can run, so they may not always be able to complete within these limits.

1. Any other advantages / disadvantages compared to the Drive plugin?
   

No user interface of course, can't schedule emails, no access to the "Simple connectors" listed in the add-on sidebar on the Data source tab.

I did check the advantages on the site, but wanted to be 100% clear on my best option.

Thanks

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

Hugo Boss | Alex Thomson #SkyWalk

Samsung | History of Innovation

Heineken | Brings Rugby rival fans together

:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

REDPILL

The Black & White Building

74 Rivington Street

London

EC2A 3AY

This e-mail and any attachments may contain privileged or confidential information. If you have received it in error, please delete it from your system. Do not use, copy or disclose the information in any way nor act in reliance on it and notify the sender immediately. Further communication will signify your consent to this. Opinions, conclusions and other information in this message that do not relate to the official business of the sender's company shall be understood as neither given nor endorsed by it.

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at https://groups.google.com/group/automateanalytics.
To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/98a8e1b8-15d6-4d08-a578-8429d0470010%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Mark Brady]

Thanks. Very useful. Here's what I had entered in answer to your reply 1. (with the VideoID entered correctly in format that is pulled e.g. hKMHyNsHJyg_CHUC1l5F9msJUZa1pomvsyooZZ)

Video ID	VideoID
Metrics	views
Start date	11/3/2015
End date	4/26/2016
Dimensions	Date
Pivot dimensions
Filters	insightTrafficSourceDetail==facebook.com
Advanced segment
Sort
Settings
Max results	1000
Max categories	10
	Error: 400 invalid Invalid value () given in field parameters.filters.

[Mark Brady]

Even putting in insightTrafficSourceDetail in Pivot dimensions doesn't work, yet insightTrafficSourceType does.

[Mikael Thuneberg]

Ok, the query should now work but it's extremely heavy, you should split by month, not date, to make it run better.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/4609893b-5e1e-4438-92b9-83b6575a731a%40googlegroups.com.