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