This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm not sure about modifying the resource quotas to "TRUE", but one workaround I figured out was wrapping the Google Analytics tool up as a macro and running smaller sets of dates through it. So rather than using the past 30 days all at once, run it one week at a time. All you need to do is to have two control parameters in the macro - one that updates the startDatePicker value and one that updates the endDatePicker value.
This should help you with your problem but I'm definitely interested to know if anyone else has another solution!
I used this method recently for a smaller site that didn't have the sampling issues on the monthly level, but the concept is still the same. It was also helpful because I was able to pull more metrics than you can currently select in the tool and join them on their respective dimensions - date and landing page path or date, channel grouping, and campaign. .
I had to strip out my Google Analytics credentials in order to share it here, but you can enter your offline credentials in the supporting macro to apply to your own use case. This one pulls daily Google Analytics data one month at a time. You could modify this workflow to feed in a week start and week end instead if you are still running into sampling issues.
Macro opened up:
Supporting Macro within macro opened up (Blue circle to the right of the first formula in previous picture):
Is this an error you are getting from a formula tool?
If you are feeding in your dates from an Excel file, use a select tool to check to see if they are coming in as V_WString or Date. If they are coming in as V_WString, you can use the DateTime tool under the "Parse" tab up top to get them converted to date format.