Hello Experts,
Can you please help me figure out how to pass date with variables in GA connector.
Basically, I want to parameterize it and schedule a dataflow to run for each day sequentially for last 90 days.
Not all once but one by one ( day by day ).
To pass date parameters to the Google Analytics Macro, you need to use the Control Parameter tool and the Action tool in your workflow. The Control Parameter tool allows you to create a user-defined input that can be used to change the value of another tool. The Action tool allows you to specify how the value of the Control Parameter tool will affect the target tool.
In your case, you want to change the value of the End Date field in the Google Analytics Macro to a variable date. To do this, you can follow these steps:
To schedule your dataflow to run for each day sequentially for the last 90 days, you can use the Generate Rows tool and the Batch Macro tool in your workflow. The Generate Rows tool allows you to create a series of dates based on a start date and an end date. The Batch Macro tool allows you to run a macro multiple times, passing a different value from the input data each time.
To do this, you can follow these steps:
@Hammad_Rashid : Hey, thanks a prompt response. However, my query is more on how to pass these date parameters to GA connector.
Can you please advice.