Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Batch Macro with Google Analytics

Owlpet
7 - Meteor

Hi all,

 

I have multiple Web properties in GA and I want to create a batch macro to run through all the available web properties and extract the users and dates

 

Below is my configuration:

 

Owlpet_0-1609967720410.png

 

 

Column property_id is what I'm trying to update.

Owlpet_2-1609967175854.png

 

Owlpet_3-1609967194091.png

 

However, it returns a duplicate instead.

 

Owlpet_4-1609967338273.png

Any guidance would be greatly appreciated.

 

Thanks,

Peter

 

 

 

4 REPLIES 4
FlorianC
Alteryx
Alteryx

Hi @Owlpet,

 

Have you tried to execute the Google Analytics query separately for each property to have a set of expected results? Could it be that the same values are being returned for both of them?

Florian Carrier
Strategic Solution Consultant
Alteryx
Owlpet
7 - Meteor

Hi @FlorianC,

 

Thanks for replying!

 

The two web properties with two different user numbers. Please see below:

Owlpet_0-1610039577232.png

 

I thought about listing all the available web properties in separate GA connectors but after 5, they start to time-out and there are about over 10 properties.

 

Any other ideas?

 

Thanks,

Peter

Owlpet
7 - Meteor

Finally figured it out.

 

You will need to:

1. add a second Control Parameter and connect to Google Analytics

2. select the profile list.

3. Tick - replace a specific string

4. Save

 

 

FlorianC
Alteryx
Alteryx

Well done @Owlpet!

 

I had not anticipated that the properties were tied to different profiles.

Florian Carrier
Strategic Solution Consultant
Alteryx
Labels